units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where ACCESS_TYP = 1, COUNTY = 39, DES_TP = 3 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 11 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2507 | 2507 | 2506 | {"type": "Polygon", "coordinates": [[[-121.27079, 38.14011], [-121.27066, 38.14193], [-121.26896, 38.14194], [-121.2691, 38.14025], [-121.26916, 38.1402], [-121.27042, 38.14019], [-121.27043, 38.1401], [-121.27079, 38.14011]]]} | Open Access 1 | 17545 | Lodi Softball Complex | 21399 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 7.175 | Lodi Softball Complex | 0 | Local Recreation Area 3 | 4 | |
3917 | 3917 | 3916 | {"type": "Polygon", "coordinates": [[[-121.14245, 37.7614], [-121.13919, 37.76142], [-121.13923, 37.76402], [-121.13825, 37.76402], [-121.13827, 37.76499], [-121.1359, 37.765], [-121.13596, 37.76744], [-121.13372, 37.76745], [-121.13357, 37.76127], [-121.13812, 37.76125], [-121.14244, 37.76126], [-121.14245, 37.7614]]]} | Open Access 1 | 36078 | Mistlin Sports Park | 22321 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 62.763 | Mistlin Sports Park | 0 | Local Recreation Area 3 | 4 | |
4080 | 4080 | 4079 | {"type": "Polygon", "coordinates": [[[-121.13806, 37.72898], [-121.13801, 37.72902], [-121.13798, 37.72906], [-121.13797, 37.7292], [-121.13763, 37.72921], [-121.13763, 37.72908], [-121.13769, 37.72901], [-121.13806, 37.72898]]]} | Open Access 1 | 44517 | Country Woods Tot Lot | 17706 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 0.171 | Country Woods Tot Lot | 0 | Local Recreation Area 3 | 4 | |
5482 | 5482 | 5481 | {"type": "MultiPolygon", "coordinates": [[[[-121.43492, 37.7531], [-121.43371, 37.7531], [-121.43368, 37.75309], [-121.43335, 37.75287], [-121.43327, 37.75284], [-121.43318, 37.75283], [-121.43317, 37.75056], [-121.43362, 37.75055], [-121.43362, 37.75015], [-121.43442, 37.75015], [-121.43442, 37.75042], [-121.43437, 37.75043], [-121.43437, 37.75081], [-121.43491, 37.75082], [-121.43492, 37.7531]]], [[[-121.43368, 37.75324], [-121.43318, 37.75324], [-121.43318, 37.75297], [-121.43326, 37.75299], [-121.43356, 37.7532], [-121.43368, 37.75324]]]]} | Open Access 1 | 18026 | Tracy Ball Park | 26504 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 11.077 | Tracy Ball Park | 0 | Local Recreation Area 3 | 4 | |
12600 | 12600 | 12599 | {"type": "Polygon", "coordinates": [[[-121.45925, 37.73898], [-121.45645, 37.73897], [-121.45529, 37.73893], [-121.45515, 37.7389], [-121.45501, 37.73885], [-121.454, 37.73808], [-121.45375, 37.73775], [-121.45365, 37.73739], [-121.45378, 37.73749], [-121.45466, 37.73749], [-121.45466, 37.73714], [-121.45923, 37.73713], [-121.45924, 37.73765], [-121.45925, 37.73898]]]} | Open Access 1 | 29259 | Plasencia Fields | 23770 | 1357 | Tracy, City of 396 | City 2 | City Agency 2 | http://www.ci.tracy.ca.us/?navid=52 | City 2 | 1357 | Tracy, City of 390 | City 2 | City Agency 2 | San Joaquin 39 | 21.697 | Plasencia Fields | 0 | Local Recreation Area 3 | 4 | |
13703 | 13703 | 13702 | {"type": "Polygon", "coordinates": [[[-121.2634, 38.04678], [-121.25918, 38.04681], [-121.25898, 38.04416], [-121.25901, 38.04388], [-121.2591, 38.04355], [-121.25911, 38.04302], [-121.26311, 38.04296], [-121.2634, 38.04678]]]} | Open Access 1 | 36079 | Detention Basin Soccer Complex | 18118 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 38.293 | Detention Basin Soccer Complex | 0 | Local Recreation Area 3 | 4 | |
14383 | 14383 | 14382 | {"type": "Polygon", "coordinates": [[[-121.13756, 37.74219], [-121.13694, 37.74219], [-121.1369, 37.74096], [-121.13752, 37.74097], [-121.13756, 37.74219]]]} | Open Access 1 | 44483 | Curt Pernice Skate Park | 17863 | 1277 | Ripon, City of 534 | City 2 | City Agency 2 | http://www.cityofripon.org/ | City 2 | 1277 | Ripon, City of 527 | City 2 | City Agency 2 | San Joaquin 39 | 1.841 | Curt Pernice Skate Park | 0 | Local Recreation Area 3 | 4 | |
14820 | 14820 | 14819 | {"type": "Polygon", "coordinates": [[[-121.27616, 37.81964], [-121.27616, 37.81998], [-121.27581, 37.81998], [-121.27581, 37.81963], [-121.27616, 37.81964]]]} | Open Access 1 | 47254 | Lathrop Skate Park | 30965 | 1171 | Lathrop, City of 528 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | San Joaquin 39 | 0.287 | Lathrop Skate Park | 0 | Local Recreation Area 3 | 4 | |
16259 | 16259 | 16258 | {"type": "Polygon", "coordinates": [[[-121.30121, 37.826], [-121.30039, 37.8261], [-121.29978, 37.82615], [-121.2988, 37.82617], [-121.29874, 37.82611], [-121.29874, 37.82524], [-121.29879, 37.82509], [-121.29878, 37.82501], [-121.29874, 37.82497], [-121.29934, 37.82496], [-121.29995, 37.82493], [-121.30093, 37.82482], [-121.30121, 37.826]]]} | Open Access 1 | 45099 | Lathrop Generations Center | 32370 | 1171 | Lathrop, City of 528 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | http://www.kla-ca.com/portfolio/lathrop-generations-center/ | San Joaquin 39 | 6.76 | Lathrop Generations Ctr. | 2014 | Local Recreation Area 3 | 4 |
16401 | 16401 | 16400 | {"type": "Polygon", "coordinates": [[[-121.22007, 37.79923], [-121.22006, 37.79965], [-121.21962, 37.79965], [-121.21962, 37.79923], [-121.22007, 37.79923]]]} | Open Access 1 | 24705 | Center St Tennis Courts | 17039 | 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 | 0.461 | Ctr. St Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
17039 | 17039 | 17038 | {"type": "Polygon", "coordinates": [[[-121.29458, 37.95402], [-121.29455, 37.95407], [-121.29456, 37.95412], [-121.29396, 37.95531], [-121.29388, 37.95538], [-121.29374, 37.95544], [-121.29362, 37.95545], [-121.29271, 37.9554], [-121.2927, 37.95548], [-121.2927, 37.95549], [-121.29374, 37.95554], [-121.29215, 37.95577], [-121.29166, 37.95409], [-121.29334, 37.9539], [-121.2945, 37.95393], [-121.29454, 37.95394], [-121.29458, 37.95402]]]} | Open Access 1 | 29645 | Weber Point Event Center | 27326 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 9.256 | Weber Point Event Ctr. | 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]);