Council Properties

Southampton City Council

@ukgov.council_properties

Table List

1 table(143.67 KB)

Table 1

@ukgov.council_properties.table_1

Resource locator

143.67 KB
1589 rows
22 columns

fid FID	property_name PROPERTY NAME	street_no STREET NO	street_name STREET NAME	post_code POST CODE	easting EASTING	northing NORTHING	ownership OWNERSHIP	ownership_detail OWNERSHIP DETAIL	land_only LAND ONLY	asset_size ASSET SIZE	services_offered SERVICES OFFERED	holding_reason HOLDING REASON	required_maintenance_cost REQUIRED MAINTENANCE COST	category CATEGORY	unique_identity UNIQUE IDENTITY	uprn UPRN	mi_prinx MI PRINX	geometry GEOMETRY
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-531c	Weston Farm Estate, Substation No 2 adj Bacon Close, 043		Bacon Close	SO19 9PZ	444954	110118	Freehold - Owned by Local Authority	Lease	No	32	Commercial property - Business and employment	Investment Property		Commercial	3159	10001305979	778599	POINT (444954 110118)
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-531b	Belgrave Industrial Estate, 007	007	Belgrave Industrial Estate	SO17 3EA	443372	114741	Freehold - Owned by Local Authority	Lease	No	246	Commercial property - Business and employment	Investment Property		Commercial	321	100062513692	778600	POINT (443372 114741)
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-531a	Windermere Avenue, 172 - 176	172 - 176	Windermere Avenue	SO16 9GA	438118	114718	Freehold - Owned by Local Authority	Lease	No	68	Commercial property - Business and employment	Occupied by the local authority or providing a service in its behalf	55000	Commercial	3267	100062511078	778601	POINT (438118 114718)
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-5319	Wolseley Road, Substation		Wolseley Road	SO15 3EQ	440264	113042	Freehold - Owned by Local Authority	Lease	No	24	Commercial property - Business and employment	Investment Property		Commercial	3301	10001305988	778602	POINT (440264 113042)
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-5318	Upper Townhill Farm, Substation adj Atlantic Park View, 047		Upper Townhill Farm	SO18 3RR	445350	114937	Freehold - Owned by Local Authority	Lease	No	9	Commercial property - Business and employment	Investment Property		Commercial	3397	10024437406	778603
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-5317	Belgrave Industrial Estate, 002	002	Belgrave Industrial Estate	SO17 3EA	443350	114816	Freehold - Owned by Local Authority	Lease	No	295	Commercial property - Business and employment	Investment Property		Commercial	343	100062513654	778604	POINT (443350 114816)
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-5316	Gainsborough Close, Garage 002		Gainsborough Close	SO19 0QZ	110882	446073	Freehold - Owned by Local Authority	Lease	Yes	37	Commercial property - Business and employment	Investment Property		Commercial	3459	10090584648	778605	POINT (446073 110882)
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-5315	Gover Road, Junction Redbridge Causeway		Gover Road	SO16 9BS	437260	113804	Freehold - Owned by Local Authority	Lease	No	4	Commercial property - Business and employment	Investment Property		Commercial	4033	10001306246	778606	POINT (437260 113804)
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-5314	Sea City Museum, Substation		Havelock Road	SO14 7LY	112237	441775	Freehold - Owned by Local Authority	Occupied by Local Authority	No	26	Commercial property - Business and employment	Occupied by the local authority or providing a service in its behalf		Commercial	9667	10090584331	778607	POINT (441775 112237)
COUNCIL_PROPERTIES.fid-288ee063_19627021b22_-5313	Fairisle Road, Underground Cable		Fairisle Road	SO16 8BW	438470	115944	Freehold - Owned by Local Authority	Lease	No		Commercial property - Business and employment	Investment Property		Commercial	4055	10001306256	778608	POINT (438470 115944)


CREATE TABLE table_1 (
  "fid" VARCHAR,
  "property_name" VARCHAR,
  "street_no" VARCHAR,
  "street_name" VARCHAR,
  "post_code" VARCHAR,
  "easting" DOUBLE,
  "northing" DOUBLE,
  "ownership" VARCHAR,
  "ownership_detail" VARCHAR,
  "land_only" VARCHAR,
  "asset_size" BIGINT,
  "services_offered" VARCHAR,
  "holding_reason" VARCHAR,
  "operation_cost" DOUBLE,
  "required_maintenance_cost" DOUBLE,
  "functional_suitability" VARCHAR,
  "energy_performance" VARCHAR,
  "category" VARCHAR,
  "unique_identity" VARCHAR,
  "uprn" BIGINT,
  "mi_prinx" BIGINT,
  "geometry" VARCHAR
);