Conservation Areas

Leicester City Council

@ukgov.conservation_areas98

Table List

1 table(109.5 KB)

Table 1

@ukgov.conservation_areas98.table_1

Conservation Areas (csv)

109.5 KB
25 rows
6 columns

geo_point_2d Geo Point 2d	geo_shape Geo Shape	caref Caref	name Name	designated Designated	description Description
52.61644549300722, -1.1091255272451912	{"coordinates": [[[-1.1144977688, 52.6233649186], [-1.114614718, 52.6232190274], [-1.1147905619, 52.6229853195], [-1.1148588407, 52.6229093463], [-1.1149773047, 52.6227848561], [-1.1150600658, 52.6227094403], [-1.1153288421, 52.6224453285], [-1.1158407166, 52.6219397398], [-1.1166178391, 52.62116847…	ST	Stoneygate	Thu Sep 28 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Boundary amendments: 1989, January 2000, March 2007.
52.60378175441202, -1.1579987699580387	{"coordinates": [[[-1.1529031148, 52.6056194381], [-1.1530858587, 52.6056956088], [-1.1532178655, 52.6056247423], [-1.1533853668, 52.6055378619], [-1.1535385488, 52.6054611246], [-1.1536382048, 52.6054199547], [-1.1537703846, 52.6053779384], [-1.1539014722, 52.6053546978], [-1.1540638181, 52.6053520…	AY	Aylestone	Thu Feb 27 1975 00:00:00 GMT+0000 (Coordinated Universal Time)	Extended May 2008.
52.63569272141207, -1.1272248875048931	{"coordinates": [[[-1.1252740284, 52.6348674284], [-1.1252392761, 52.6349178615], [-1.1259514024, 52.6350161363], [-1.1259342087, 52.6350658902], [-1.1259191213, 52.6351077507], [-1.1259094416, 52.6351350014], [-1.1258668661, 52.6352541315], [-1.1258099587, 52.6354138695], [-1.12579833, 52.635447217…	SG	St. Georges	Thu May 25 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Extended July 2003 and January 2010.
52.635546726374855, -1.1372159661389512	{"coordinates": [[[-1.133326306, 52.6358238097], [-1.1332549366, 52.6358471047], [-1.1332496629, 52.6358488636], [-1.1332370356, 52.6358528157], [-1.1331842981, 52.635870405], [-1.13320225, 52.6358930051], [-1.1331888652, 52.6358982997], [-1.1332098006, 52.6359240673], [-1.1330674794, 52.6359741653]…	HS	High Street	Thu May 25 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Boundary amended 06/12/2014.
52.63226432383512, -1.1340442765613226	{"coordinates": [[[-1.1360768805, 52.6323737245], [-1.1362425406, 52.6323192995], [-1.1361642817, 52.6322285846], [-1.1361508225, 52.6322129381], [-1.1358789395, 52.6322977751], [-1.1358500066, 52.632307001], [-1.1358406942, 52.6323097192], [-1.1354890013, 52.631818954], [-1.1360730249, 52.631825999…	MS	Market Street	Thu May 25 1989 00:00:00 GMT+0000 (Coordinated Universal Time)	Boundary amended 06/12/2014.
52.648814038823296, -1.0779596213077467	{"coordinates": [[[-1.0787779085, 52.6472440076], [-1.078777202, 52.6472428338], [-1.078773004, 52.6472338137], [-1.078771655, 52.6472284107], [-1.0787709428, 52.6472275064], [-1.0787672504, 52.6472234334], [-1.0787636421, 52.6472211585], [-1.0787569781, 52.6472193092], [-1.0786587064, 52.6471866401…	OH	Old Humberstone	Tue Jan 29 1974 00:00:00 GMT+0000 (Coordinated Universal Time)	Boundary amended 3 April 2006.
52.62125290899995, -1.076027408244455	{"coordinates": [[[-1.0791067288, 52.6227180721], [-1.0791021784, 52.622714352], [-1.0790998834, 52.6227134354], [-1.0790969984, 52.6227116155], [-1.0790962865, 52.6227107112], [-1.0790956124, 52.6227080098], [-1.0790971115, 52.6227062239], [-1.0792282801, 52.6225441209], [-1.0792329085, 52.62253831…	EV	Evington Village	Thu Nov 30 1989 00:00:00 GMT+0000 (Coordinated Universal Time)
52.62046272225001, -1.1819190008176794	{"coordinates": [[[-1.1857135129, 52.6216561127], [-1.1857054284, 52.6216520128], [-1.1856360893, 52.6216079466], [-1.1855311001, 52.6215290335], [-1.1854874428, 52.6214990745], [-1.1854596775, 52.6214791111], [-1.1854189679, 52.6214478242], [-1.1853795314, 52.6214201411], [-1.1853474986, 52.6213938…	BR	Braunstone	Tue Jan 29 1974 00:00:00 GMT+0000 (Coordinated Universal Time)
52.63142154651108, -1.1552650975612613	{"coordinates": [[[[-1.1513558351, 52.633306027], [-1.1520506698, 52.633367622], [-1.1522227448, 52.6333840419], [-1.1523902367, 52.63370142], [-1.1524635037, 52.6339011974], [-1.1526711131, 52.6339008845], [-1.1526955982, 52.6339010596], [-1.1527029158, 52.6339006625], [-1.1527199874, 52.6338998858…	WD	West End	Thu Oct 02 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	Replaced Daneshill and Westcotes Drive conservation areas.Extended June 2022
52.62906454013672, -1.1201398599039007	{"coordinates": [[[-1.1155866066, 52.6265917981], [-1.115501984, 52.627037663], [-1.115554063, 52.6270404781], [-1.1155940971, 52.6270425742], [-1.115723776, 52.6270511806], [-1.1158257038, 52.6270586812], [-1.1158535585, 52.6270606864], [-1.1158790901, 52.6270631236], [-1.1158687395, 52.6271174204]…	SH	South Highfields	Thu Apr 30 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	Boundary amended March 2003.


CREATE TABLE table_1 (
  "geo_point_2d" VARCHAR,
  "geo_shape" VARCHAR,
  "caref" VARCHAR,
  "name" VARCHAR,
  "designated" TIMESTAMP,
  "description" VARCHAR
);