units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where DES_TP = 2 and LABEL_NAME = "Northgate Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
703 | 703 | 702 | {"type": "Polygon", "coordinates": [[[-117.45142, 34.11234], [-117.45138, 34.11239], [-117.45135, 34.11245], [-117.45104, 34.11232], [-117.45073, 34.11232], [-117.45072, 34.11111], [-117.45108, 34.11111], [-117.45109, 34.11203], [-117.45136, 34.11204], [-117.45136, 34.11228], [-117.45142, 34.11234]]]} | Open Access 1 | 3856 | Northgate Park | 22871 | 1109 | Fontana, City of 168 | City 2 | City Agency 2 | http://www.fontana.org/index.aspx?NID=551 | City 2 | 1109 | Fontana, City of 164 | City 2 | City Agency 2 | San Bernardino 22 | 1.363 | Northgate Park | 0 | Local Park 2 | 4 | |
2603 | 2603 | 2602 | {"type": "Polygon", "coordinates": [[[-121.22864, 37.8225], [-121.22678, 37.82253], [-121.22665, 37.81919], [-121.22692, 37.81918], [-121.227, 37.8192], [-121.22709, 37.8192], [-121.22738, 37.81924], [-121.22769, 37.8193], [-121.2281, 37.81944], [-121.22844, 37.8196], [-121.22864, 37.8225]]]} | Open Access 1 | 17699 | Northgate Park | 22873 | 1195 | Manteca, City of 490 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | San Joaquin 39 | 14.058 | Northgate Park | 0 | Local Park 2 | 4 | |
8390 | 8390 | 8389 | {"type": "Polygon", "coordinates": [[[-122.04305, 37.57926], [-122.04289, 37.57941], [-122.04271, 37.57954], [-122.04251, 37.57966], [-122.04229, 37.57977], [-122.04187, 37.57991], [-122.04161, 37.57996], [-122.0414, 37.57998], [-122.04111, 37.57998], [-122.04082, 37.57994], [-122.0398, 37.57971], [-122.03945, 37.57965], [-122.039, 37.57965], [-122.03876, 37.57967], [-122.03848, 37.57972], [-122.0383, 37.57961], [-122.03816, 37.57954], [-122.03811, 37.57946], [-122.03813, 37.5794], [-122.03948, 37.57759], [-122.03952, 37.57756], [-122.03958, 37.57754], [-122.03967, 37.57755], [-122.04027, 37.57785], [-122.04094, 37.57825], [-122.04305, 37.57926]]]} | Open Access 1 | 13037 | Northgate Park | 22872 | 1113 | Fremont, City of 381 | City 2 | City Agency 2 | http://www.fremont.gov/316/Parks | City 2 | 1113 | Fremont, City of 376 | City 2 | City Agency 2 | Alameda 17 | 16.014 | Northgate Park | 0 | Local Park 2 | 4 | |
10308 | 10308 | 10307 | {"type": "Polygon", "coordinates": [[[-121.65964, 36.70897], [-121.65953, 36.709], [-121.65927, 36.70942], [-121.65928, 36.70947], [-121.65919, 36.70953], [-121.65893, 36.70994], [-121.65892, 36.71003], [-121.65888, 36.71005], [-121.65865, 36.71043], [-121.65865, 36.71047], [-121.65835, 36.71041], [-121.658, 36.71039], [-121.65769, 36.71043], [-121.65735, 36.71053], [-121.65797, 36.70943], [-121.65802, 36.70926], [-121.65802, 36.70908], [-121.65818, 36.70906], [-121.65822, 36.709], [-121.65907, 36.70888], [-121.65946, 36.7088], [-121.6596, 36.70883], [-121.65964, 36.70897]]]} | Open Access 1 | 18178 | Northgate Park | 22875 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 4.861 | Northgate Park | 0 | Local Park 2 | 4 | |
11012 | 11012 | 11011 | {"type": "Polygon", "coordinates": [[[-121.49168, 38.61834], [-121.49131, 38.61829], [-121.49096, 38.61831], [-121.48973, 38.6183], [-121.48946, 38.61826], [-121.48916, 38.61813], [-121.48866, 38.61801], [-121.48843, 38.618], [-121.48843, 38.61703], [-121.48846, 38.61687], [-121.4885, 38.61676], [-121.48859, 38.61662], [-121.48887, 38.61628], [-121.4891, 38.61594], [-121.48914, 38.61592], [-121.48951, 38.61597], [-121.49132, 38.61599], [-121.49168, 38.61834]]]} | Open Access 1 | 21095 | Northgate Park | 22874 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 15.863 | Northgate 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]);