calands: units_with_maps: 4 rows where COUNTY = 4 and MNG_AG

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

4 rows where COUNTY = 4 and MNG_AG_TYP = 4

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	UNIT_ID	UNIT_NAME	SUID_NMA	AGNCY_ID	AGNCY_NAME	AGNCY_LEV	AGNCY_TYP	AGNCY_WEB	LAYER	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	PARK_URL	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
7618	7618	7617	{"type": "MultiPolygon", "coordinates": [[[[-116.58828, 32.9905], [-116.58825, 32.99071], [-116.58818, 32.9909], [-116.58801, 32.99116], [-116.5879, 32.99127], [-116.58761, 32.99148], [-116.5874, 32.99157], [-116.58719, 32.99163], [-116.5869, 32.99167], [-116.58665, 32.99166], [-116.58142, 32.99099], [-116.5814, 32.99108], [-116.58108, 32.99104], [-116.58084, 32.991], [-116.58063, 32.99093], [-116.58048, 32.99088], [-116.57988, 32.9906], [-116.57971, 32.99055], [-116.57949, 32.99055], [-116.57933, 32.99059], [-116.57914, 32.99068], [-116.57896, 32.99083], [-116.57867, 32.99102], [-116.57852, 32.99107], [-116.57837, 32.9911], [-116.57793, 32.99107], [-116.57771, 32.99101], [-116.57685, 32.99067], [-116.57675, 32.99065], [-116.57647, 32.99066], [-116.57626, 32.99071], [-116.57605, 32.99081], [-116.57587, 32.99094], [-116.57568, 32.99114], [-116.57548, 32.9913], [-116.57545, 32.99118], [-116.57544, 32.99118], [-116.57368, 32.99185], [-116.57278, 32.99241], [-116.57137, 32.99369], [-116.56793, 32.99529], [-116.56657, 32.99852], [-116.56638, 32.99902], [-116.56548, 33.00118], [-116.56333, 33.00224], [-116.56291, 33.00372], [-116.56374, 33.00577], [-116.56384, 33.00633], [-116.5638, 33.00661], [-116.56173, 33.00851], [-116.56074, 33.01059], [-116.5602, 33.01038], [-116.55982, 33.01017], [-116.55945, 33.00989], [-116.5593, 33.00975], [-116.55914, 33.00956], [-116.55893, 33.00928], [-116.55868, 33.00889], [-116.55871, 33.00846], [-116.55796, 33.00715], [-116.55889, 33.00477], [-116.55844, 33.00404], [-116.55765, 33.00348], [-116.55654, 33.0018], [-116.55354, 33.00214], [-116.5523, 33.00058], [-116.55155, 32.99892], [-116.55205, 32.99793], [-116.55211, 32.99628], [-116.55325, 32.9954], [-116.55471, 32.99537], [-116.5569, 32.99538], [-116.55636, 32.99378], [-116.55535, 32.99255], [-116.55513, 32.99154], [-116.55526, 32.99138], [-116.55652, 32.98959], [-116.55693, 32.98801], [-116.55725, 32.98657], [-116.55803, 32.98589], [-116.5583, 32.9844], [-116.56187, 32.9836], [-116.56188, 32.98227], [-116.56635, 32.98249], [-116.56636, 32.98312], [-116.56747, 32.98414], [-116.56898, 32.98471], [-116.56935, 32.98534], [-116.56921, 32.9856], [-116.56929, 32.9864], [-116.56943, 32.98702], [-116.56962, 32.98713], [-116.57098, 32.98721], [-116.57129, 32.98711], [-116.57157, 32.98694], [-116.57204, 32.98548], [-116.57271, 32.98562], [-116.57335, 32.98626], [-116.57363, 32.98619], [-116.57605, 32.98533], [-116.57692, 32.98421], [-116.57714, 32.98288], [-116.57697, 32.98202], [-116.57662, 32.98137], [-116.57615, 32.9811], [-116.57521, 32.98117], [-116.57385, 32.98191], [-116.57299, 32.98196], [-116.57165, 32.98146], [-116.57102, 32.98066], [-116.5713, 32.98014], [-116.57341, 32.98094], [-116.57566, 32.97928], [-116.57639, 32.978], [-116.57747, 32.97841], [-116.57837, 32.97822], [-116.57879, 32.97782], [-116.57898, 32.97751], [-116.58028, 32.97747], [-116.58088, 32.97794], [-116.58068, 32.97842], [-116.58069, 32.97857], [-116.58058, 32.97883], [-116.58052, 32.97945], [-116.58088, 32.97945], [-116.58105, 32.98054], [-116.58105, 32.98062], [-116.58099, 32.98084], [-116.58069, 32.98145], [-116.58065, 32.9816], [-116.58066, 32.98181], [-116.58076, 32.98207], [-116.58157, 32.98307], [-116.58165, 32.98322], [-116.582, 32.98456], [-116.58201, 32.9848], [-116.58199, 32.98488], [-116.58199, 32.98499], [-116.58201, 32.98513], [-116.58212, 32.9854], [-116.58228, 32.98559], [-116.58245, 32.98572], [-116.58261, 32.9858], [-116.58292, 32.98591], [-116.58308, 32.98605], [-116.58316, 32.98614], [-116.58325, 32.98628], [-116.5833, 32.98658], [-116.58428, 32.98766], [-116.58443, 32.98778], [-116.58457, 32.98785], [-116.58482, 32.98793], [-116.58541, 32.98797], [-116.58564, 32.98803], [-116.58576, 32.98807], [-116.58654, 32.98843], [-116.58647, 32.9885], [-116.58648, 32.98851], [-116.5866, 32.98856], [-116.58682, 32.98869], [-116.58698, 32.98883], [-116.58708, 32.98895], [-116.58734, 32.98907], [-116.58763, 32.98942], [-116.58797, 32.98965], [-116.58814, 32.98999], [-116.58819, 32.99043], [-116.58828, 32.99044], [-116.58828, 32.9905]]], [[[-116.55887, 33.00971], [-116.55857, 33.00969], [-116.55861, 33.00936], [-116.55873, 33.00954], [-116.55887, 33.00971]]], [[[-116.56489, 33.01495], [-116.56489, 33.01495], [-116.56483, 33.02105], [-116.56391, 33.0168], [-116.56255, 33.01679], [-116.5626, 33.01656], [-116.56264, 33.01612], [-116.56264, 33.01583], [-116.56262, 33.01571], [-116.56258, 33.01556], [-116.56251, 33.01542], [-116.56188, 33.01444], [-116.56175, 33.01414], [-116.56132, 33.01258], [-116.56125, 33.01223], [-116.56121, 33.01185], [-116.56121, 33.01153], [-116.56121, 33.01124], [-116.56125, 33.01102], [-116.56158, 33.01114], [-116.564, 33.01328], [-116.56489, 33.01495]]], [[[-116.58571, 32.99196], [-116.58562, 32.99276], [-116.58476, 32.99272], [-116.58486, 32.99176], [-116.58558, 32.99185], [-116.58571, 32.99196]]]]}	Open Access 1	47619	Lake Cuyamaca	20881	2046	Helix Water District 777	Special District 4	Water District 13	http://www.hwd.com	Special District 4	2058	Lake Cuyamaca Park and Recreation District 853	Special District 4	Recreation/Parks District 4	http://www.lakecuyamaca.org/	San Diego 4	1116.016	Lake Cuyamaca		None 635
11859	11859	11858	{"type": "Polygon", "coordinates": [[[-117.02375, 33.23685], [-117.02356, 33.2408], [-117.0235, 33.24085], [-117.01947, 33.24142], [-117.01954, 33.24036], [-117.01953, 33.24028], [-117.0196, 33.23816], [-117.01959, 33.23767], [-117.02055, 33.23769], [-117.02067, 33.23715], [-117.02219, 33.23726], [-117.02227, 33.23694], [-117.02375, 33.23685]]]}	Open Access 1	24307	Adams Community Park	15259	2267	Valley Center Parks and Recreation 994	Special District 4	Recreation/Parks District 4	http://www.valleycenterparks.com/	Special District 4	2267	Valley Center Parks and Recreation 957	Special District 4	Recreation/Parks District 4	http://valleycenterparks.com/adams-park.html	San Diego 4	40.858	Adams Community Park	0	Local Park 2	4
14811	14811	14810	{"type": "MultiPolygon", "coordinates": [[[[-117.02211, 33.23255], [-117.02184, 33.23287], [-117.02177, 33.233], [-117.02172, 33.23315], [-117.0217, 33.23329], [-117.02169, 33.2336], [-117.02172, 33.2337], [-117.02181, 33.23381], [-117.01978, 33.23376], [-117.01982, 33.23259], [-117.02065, 33.23255], [-117.02066, 33.23262], [-117.02211, 33.23255]]], [[[-117.02398, 33.234], [-117.02394, 33.23465], [-117.02277, 33.23459], [-117.0228, 33.23394], [-117.02398, 33.234]]]]}	Open Access 1	45230	Cole Grade Park	17488	2267	Valley Center Parks and Recreation 994	Special District 4	Recreation/Parks District 4	http://www.valleycenterparks.com/	Special District 4	2267	Valley Center Parks and Recreation 957	Special District 4	Recreation/Parks District 4	http://valleycenterparks.com/sports.html	San Diego 4	8.076	Cole Grade Park	0	Local Park 2	4
14813	14813	14812	{"type": "Polygon", "coordinates": [[[-117.0394, 33.21861], [-117.03938, 33.22118], [-117.03939, 33.22214], [-117.03705, 33.22216], [-117.03693, 33.22215], [-117.03682, 33.22181], [-117.0364, 33.22099], [-117.03616, 33.2206], [-117.03524, 33.2202], [-117.03611, 33.22021], [-117.0362, 33.22038], [-117.03783, 33.22024], [-117.03783, 33.21859], [-117.0394, 33.21861]]]}	Open Access 1	45229	Valley Center Community Park	26785	2267	Valley Center Parks and Recreation 994	Special District 4	Recreation/Parks District 4	http://www.valleycenterparks.com/	Special District 4	2267	Valley Center Parks and Recreation 957	Special District 4	Recreation/Parks District 4		San Diego 4	20.768	Valley Ctr. Community Park	0	Local Park 2	4

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]),
   FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]),
   FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]),
   FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]),
   FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);