superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Presidio Community Park" and MNG_AGENCY = 4
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8401 | 8401 | 8400 | {"type": "MultiPolygon", "coordinates": [[[[-117.18828, 32.75875], [-117.18799, 32.75907], [-117.1873, 32.75905], [-117.1873, 32.75885], [-117.18697, 32.75883], [-117.18742, 32.7583], [-117.18749, 32.75826], [-117.18828, 32.75875]]], [[[-117.19646, 32.7591], [-117.19564, 32.7601], [-117.19553, 32.76019], [-117.19539, 32.76024], [-117.19522, 32.76028], [-117.19449, 32.76021], [-117.19432, 32.76012], [-117.19424, 32.7602], [-117.19322, 32.76011], [-117.19317, 32.76004], [-117.1931, 32.76001], [-117.19303, 32.76002], [-117.19291, 32.76009], [-117.19256, 32.76003], [-117.19223, 32.75996], [-117.19, 32.75854], [-117.19068, 32.75774], [-117.19057, 32.75767], [-117.19052, 32.75771], [-117.18974, 32.75722], [-117.18976, 32.75717], [-117.18964, 32.75709], [-117.18985, 32.75684], [-117.18968, 32.75657], [-117.18929, 32.75633], [-117.18913, 32.7561], [-117.18943, 32.75593], [-117.18959, 32.75579], [-117.1904, 32.75631], [-117.19027, 32.75646], [-117.1902, 32.75644], [-117.18993, 32.75675], [-117.18994, 32.75677], [-117.19089, 32.75738], [-117.19116, 32.7571], [-117.19163, 32.75738], [-117.19234, 32.75653], [-117.19279, 32.75681], [-117.19286, 32.75683], [-117.19363, 32.75595], [-117.19361, 32.75589], [-117.19406, 32.75539], [-117.19462, 32.75629], [-117.19466, 32.75631], [-117.19466, 32.75634], [-117.19482, 32.7565], [-117.19484, 32.75655], [-117.19534, 32.7569], [-117.19536, 32.75694], [-117.19548, 32.75704], [-117.19562, 32.75728], [-117.19559, 32.75733], [-117.19572, 32.75794], [-117.19565, 32.75859], [-117.19646, 32.7591]]], [[[-117.19048, 32.759], [-117.19018, 32.759], [-117.18958, 32.759], [-117.18989, 32.75864], [-117.19048, 32.759]]], [[[-117.19474, 32.75568], [-117.19452, 32.75593], [-117.19412, 32.75531], [-117.19413, 32.75529], [-117.19474, 32.75568]]], [[[-117.195, 32.75635], [-117.1949, 32.75646], [-117.19473, 32.75629], [-117.19464, 32.75613], [-117.195, 32.75635]]], [[[-117.19773, 32.75695], [-117.19755, 32.75716], [-117.1976, 32.75721], [-117.19742, 32.75743], [-117.19769, 32.7576], [-117.19718, 32.7582], [-117.19678, 32.75797], [-117.19612, 32.75872], [-117.19591, 32.75857], [-117.19587, 32.75852], [-117.19583, 32.75843], [-117.19582, 32.75831], [-117.1959, 32.75794], [-117.19579, 32.75745], [-117.19571, 32.75724], [-117.19562, 32.7571], [-117.19548, 32.75691], [-117.19502, 32.75656], [-117.19609, 32.7553], [-117.19686, 32.75577], [-117.19639, 32.7564], [-117.19651, 32.75646], [-117.19672, 32.7562], [-117.19759, 32.75661], [-117.19746, 32.75678], [-117.19773, 32.75695]]], [[[-117.19744, 32.75901], [-117.19729, 32.75901], [-117.19712, 32.75904], [-117.19697, 32.7591], [-117.19685, 32.75917], [-117.19675, 32.7593], [-117.1966, 32.75963], [-117.19644, 32.75985], [-117.19624, 32.76004], [-117.19607, 32.76013], [-117.19599, 32.76015], [-117.19725, 32.7586], [-117.19744, 32.75901]]]]} | Open Access 1 | Presidio Community Park | https://www.sandiego.gov/park-and-recreation/parks/regional/presidio | 23991 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 62.919 | Presidio Community Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);