units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACRES = "1.298"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1043 | 1043 | 1042 | {"type": "Polygon", "coordinates": [[[-121.86197, 37.28707], [-121.86132, 37.28748], [-121.86081, 37.28697], [-121.86146, 37.28657], [-121.86197, 37.28707]]]} | Open Access 1 | 38008 | Vieira Park | 27092 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 1.298 | Vieira Park | 0 | Local Park 2 | 4 | |
5662 | 5662 | 5661 | {"type": "Polygon", "coordinates": [[[-121.43833, 38.45244], [-121.43643, 38.45242], [-121.43642, 38.45213], [-121.43738, 38.45213], [-121.43772, 38.45216], [-121.43826, 38.45217], [-121.4383, 38.45218], [-121.43832, 38.45221], [-121.43833, 38.45244]]]} | Open Access 1 | 21253 | John Reith Park | 20465 | 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 | 1.298 | John Reith Park | 0 | Local Park 2 | 4 | |
12479 | 12479 | 12478 | {"type": "Polygon", "coordinates": [[[-122.68917, 38.31984], [-122.68871, 38.32012], [-122.68862, 38.31988], [-122.6885, 38.31969], [-122.68833, 38.31976], [-122.68822, 38.31988], [-122.68821, 38.31994], [-122.68813, 38.31992], [-122.68814, 38.31986], [-122.68808, 38.31967], [-122.68771, 38.31971], [-122.68776, 38.31955], [-122.68787, 38.31946], [-122.68798, 38.31932], [-122.68799, 38.31915], [-122.68789, 38.31873], [-122.68799, 38.31873], [-122.68873, 38.31983], [-122.68917, 38.31984]]]} | Open Access 1 | 28202 | Lydia Court Mini-park | 21602 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 1.298 | Lydia Court Mini-park | None 1088 | |||
14769 | 14769 | 14768 | {"type": "Polygon", "coordinates": [[[-116.97617, 32.63948], [-116.97614, 32.6399], [-116.97612, 32.64006], [-116.9761, 32.64008], [-116.97549, 32.64002], [-116.97527, 32.63998], [-116.97525, 32.63995], [-116.97541, 32.63942], [-116.97545, 32.6394], [-116.97578, 32.63945], [-116.97615, 32.63945], [-116.97617, 32.63948]]]} | Restricted Access 2 | 45177 | Countryside Park | 33357 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 1.298 | Countryside Park | 0 | Private Recreation or Education 65 | 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]);