units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 4 and SUID_NMA = 22813
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5967 | 5967 | 5966 | {"type": "MultiPolygon", "coordinates": [[[[-117.23655, 32.96372], [-117.23459, 32.9637], [-117.23449, 32.96333], [-117.23435, 32.96258], [-117.23431, 32.96222], [-117.23433, 32.96218], [-117.23438, 32.96217], [-117.23489, 32.96213], [-117.23496, 32.96215], [-117.23452, 32.96224], [-117.23469, 32.96262], [-117.23483, 32.96286], [-117.23499, 32.96308], [-117.23524, 32.96325], [-117.23549, 32.96336], [-117.23622, 32.9636], [-117.23655, 32.96372]]], [[[-117.24528, 32.96002], [-117.24485, 32.96019], [-117.24306, 32.96017], [-117.24306, 32.96168], [-117.23968, 32.96375], [-117.23673, 32.96372], [-117.23702, 32.96342], [-117.23677, 32.96327], [-117.23688, 32.96312], [-117.23715, 32.96306], [-117.23729, 32.96315], [-117.23735, 32.96296], [-117.23748, 32.96282], [-117.23763, 32.96269], [-117.23797, 32.96242], [-117.23818, 32.96234], [-117.23822, 32.96213], [-117.23835, 32.96199], [-117.23851, 32.96186], [-117.2387, 32.96165], [-117.23873, 32.96141], [-117.23873, 32.96119], [-117.23907, 32.96116], [-117.23932, 32.96111], [-117.2396, 32.96101], [-117.23983, 32.96088], [-117.24009, 32.96068], [-117.24116, 32.95961], [-117.24133, 32.95936], [-117.24145, 32.95907], [-117.24166, 32.9593], [-117.24203, 32.95905], [-117.24265, 32.95857], [-117.24277, 32.95851], [-117.24297, 32.95845], [-117.24317, 32.95835], [-117.24321, 32.95828], [-117.24307, 32.95812], [-117.24328, 32.95788], [-117.2433, 32.95779], [-117.24319, 32.95778], [-117.24324, 32.95767], [-117.24331, 32.95757], [-117.24361, 32.95729], [-117.2438, 32.95762], [-117.24406, 32.95779], [-117.2443, 32.95868], [-117.24478, 32.95883], [-117.24488, 32.95924], [-117.24528, 32.96002]]]]} | Open Access 1 | 541 | North City West Open Space | 22813 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 52.537 | North City West OS | 0 | Local Recreation Area 3 | 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]);