units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where AGNCY_NAME = 600 and MNG_AGENCY = 590
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3225 | 3225 | 3224 | {"type": "Polygon", "coordinates": [[[-118.92729, 34.39189], [-118.92663, 34.39198], [-118.92655, 34.39159], [-118.92719, 34.3914], [-118.92729, 34.39189]]]} | Open Access 1 | 48098 | Fillmore Dog Park | 32603 | 1423 | Fillmore, City of 600 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | http://www.fillmoreca.com/departments/parks-and-recreation-department/parks-and-sports-fields/two-rivers-park/dog-park | Ventura 8 | 0.753 | Fillmore Dog Park | 0 | Local Park 2 | 4 |
5489 | 5489 | 5488 | {"type": "MultiPolygon", "coordinates": [[[[-118.91332, 34.39908], [-118.90881, 34.3997], [-118.90873, 34.39929], [-118.91324, 34.39866], [-118.91332, 34.39908]]], [[[-118.91138, 34.39885], [-118.91068, 34.39894], [-118.91062, 34.39865], [-118.91106, 34.39859], [-118.91108, 34.39863], [-118.91133, 34.3986], [-118.91138, 34.39885]]], [[[-118.91263, 34.39868], [-118.91217, 34.39875], [-118.91212, 34.39849], [-118.91258, 34.39843], [-118.91263, 34.39868]]]]} | Open Access 1 | 25029 | Central Park | 17065 | 1423 | Fillmore, City of 600 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | Ventura 8 | 5.662 | Central Park | 0 | Local Park 2 | 4 | |
5491 | 5491 | 5490 | {"type": "Polygon", "coordinates": [[[-118.90873, 34.39979], [-118.90865, 34.39987], [-118.90766, 34.40001], [-118.90754, 34.39991], [-118.90614, 34.4001], [-118.90608, 34.39983], [-118.90634, 34.39979], [-118.90633, 34.3997], [-118.90855, 34.3994], [-118.90862, 34.39973], [-118.90873, 34.39979]]]} | Open Access 1 | 25031 | Main Street Park | 21694 | 1423 | Fillmore, City of 600 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | Ventura 8 | 2.606 | Main Street Park | 0 | Local Park 2 | 4 | |
5492 | 5492 | 5491 | {"type": "Polygon", "coordinates": [[[-118.93094, 34.40291], [-118.93097, 34.40316], [-118.93097, 34.4034], [-118.93094, 34.40362], [-118.93089, 34.4038], [-118.93077, 34.40408], [-118.93027, 34.40498], [-118.93023, 34.405], [-118.93016, 34.40499], [-118.9292, 34.40449], [-118.92887, 34.40283], [-118.93084, 34.40256], [-118.93091, 34.4029], [-118.93094, 34.40291]]]} | Open Access 1 | 25032 | Shiells Park | 25409 | 1423 | Fillmore, City of 600 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | Ventura 8 | 9.213 | Shiells Park | 0 | Local Park 2 | 4 | |
11399 | 11399 | 11398 | {"type": "Polygon", "coordinates": [[[-118.93135, 34.39204], [-118.93109, 34.39215], [-118.93091, 34.39217], [-118.93059, 34.39041], [-118.931, 34.39029], [-118.93135, 34.39204]]]} | Open Access 1 | 48099 | Fillmore Bike Park | 32604 | 1423 | Fillmore, City of 600 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | http://www.fillmoreca.com/departments/parks-and-recreation-department/parks-and-sports-fields/two-rivers-park | Ventura 8 | 2.006 | Fillmore Bike Park | 0 | Local Park 2 | 4 |
11429 | 11429 | 11428 | {"type": "Polygon", "coordinates": [[[-118.93143, 34.39244], [-118.92918, 34.39273], [-118.92687, 34.39306], [-118.92684, 34.39299], [-118.92663, 34.39198], [-118.92729, 34.39189], [-118.92719, 34.39141], [-118.93059, 34.39041], [-118.93091, 34.39216], [-118.93109, 34.39215], [-118.93135, 34.39204], [-118.93143, 34.39244]]]} | Open Access 1 | 48097 | Two Rivers Park | 32602 | 1423 | Fillmore, City of 600 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | http://www.fillmoreca.com/departments/parks-and-recreation-department/parks-and-sports-fields/two-rivers-park | Ventura 8 | 18.615 | Two Rivers Park | 0 | Local Park 2 | 4 |
11461 | 11461 | 11460 | {"type": "Polygon", "coordinates": [[[-118.92622, 34.40137], [-118.92584, 34.40136], [-118.92572, 34.40141], [-118.92553, 34.40166], [-118.92549, 34.40178], [-118.92542, 34.40186], [-118.9253, 34.4018], [-118.92553, 34.4015], [-118.92556, 34.40139], [-118.92547, 34.40109], [-118.92613, 34.401], [-118.92622, 34.40137]]]} | Open Access 1 | 48697 | Meadowlark Park | 33432 | 1423 | Fillmore, City of 600 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | Ventura 8 | 0.726 | Meadowlark Park | 0 | Local Park 2 | 4 | |
12269 | 12269 | 12268 | {"type": "Polygon", "coordinates": [[[-118.9277, 34.40717], [-118.92762, 34.40751], [-118.92752, 34.40771], [-118.92692, 34.40854], [-118.92688, 34.40856], [-118.92683, 34.40856], [-118.92669, 34.40853], [-118.92653, 34.40851], [-118.92642, 34.40797], [-118.92664, 34.40792], [-118.92683, 34.40784], [-118.92704, 34.40769], [-118.92716, 34.40754], [-118.92727, 34.40733], [-118.92733, 34.40712], [-118.92734, 34.40692], [-118.9273, 34.40665], [-118.92552, 34.40689], [-118.92551, 34.40687], [-118.92771, 34.40657], [-118.92778, 34.40661], [-118.9278, 34.40667], [-118.9277, 34.40717]]]} | Open Access 1 | 48753 | Delores Day Park | 33480 | 1423 | Fillmore, City of 600 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | https://www.fillmoreca.com/departments/parks-and-recreation-department/parks/delores-day-park | Ventura 8 | 2.659 | Delores Day 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]);