units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
37 rows where AGNCY_LEV = 2, DES_TP = 2 and MNG_AGENCY = 167 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 37
MNG_AGENCY 1
- Davis, City of · 37 ✖
DES_TP 1
- Local Park · 37 ✖
ACCESS_TYP 1
- Open Access 37
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14535 | 14535 | 14534 | {"type": "Polygon", "coordinates": [[[-121.73123, 38.54961], [-121.73123, 38.54972], [-121.73057, 38.5497], [-121.73057, 38.54959], [-121.73123, 38.54961]]]} | Open Access 1 | 47203 | N Street Mini-Park | 30908 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/40/2926?npage=3 | Yolo 33 | 0.176 | N Street Mini-Park | 0 | Local Park 2 | 4 |
10934 | 10934 | 10933 | {"type": "Polygon", "coordinates": [[[-121.7412, 38.54418], [-121.74079, 38.54425], [-121.74073, 38.54406], [-121.74114, 38.54399], [-121.7412, 38.54418]]]} | Open Access 1 | 20959 | E Street Plaza | 18332 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.202 | E Street Plaza | 0 | Local Park 2 | 4 | |
14536 | 14536 | 14535 | {"type": "Polygon", "coordinates": [[[-121.70244, 38.54454], [-121.70243, 38.54488], [-121.7019, 38.54488], [-121.70188, 38.5448], [-121.70188, 38.54471], [-121.70185, 38.54466], [-121.70208, 38.54454], [-121.70244, 38.54454]]]} | Open Access 1 | 47204 | Woodbridge Park | 30909 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/80/2926?npage=7 | Yolo 33 | 0.435 | Woodbridge Park | 0 | Local Park 2 | 4 |
17066 | 17066 | 17065 | {"type": "Polygon", "coordinates": [[[-121.75072, 38.57381], [-121.75068, 38.57385], [-121.75067, 38.57395], [-121.75049, 38.57408], [-121.75035, 38.57409], [-121.75035, 38.57399], [-121.7503, 38.57395], [-121.75016, 38.57394], [-121.75011, 38.57395], [-121.75011, 38.57366], [-121.75016, 38.57367], [-121.75028, 38.57367], [-121.75032, 38.57366], [-121.75035, 38.57362], [-121.75065, 38.57367], [-121.75065, 38.57373], [-121.75072, 38.57381]]]} | Open Access 1 | 20971 | Northstar Pocket Park | 22894 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.474 | Northstar PP | 0 | Local Park 2 | 4 | |
10920 | 10920 | 10919 | {"type": "Polygon", "coordinates": [[[-121.73627, 38.55082], [-121.73586, 38.55084], [-121.73586, 38.54976], [-121.73598, 38.55013], [-121.73622, 38.55068], [-121.73627, 38.55082]]]} | Open Access 1 | 21006 | Cedar Park | 16997 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.504 | Cedar Park | 0 | Local Park 2 | 4 | |
13788 | 13788 | 13787 | {"type": "Polygon", "coordinates": [[[-121.71597, 38.54423], [-121.71597, 38.54442], [-121.71563, 38.54442], [-121.71562, 38.54448], [-121.71527, 38.54448], [-121.71528, 38.54408], [-121.71532, 38.54404], [-121.71581, 38.54387], [-121.71586, 38.54387], [-121.7159, 38.5439], [-121.71594, 38.54398], [-121.71593, 38.54403], [-121.7159, 38.5441], [-121.7159, 38.54415], [-121.71593, 38.5442], [-121.71597, 38.54423]]]} | Open Access 1 | 36348 | Village Park | 30901 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/66/2926?npage=6 | Yolo 33 | 0.792 | Village Park | 0 | Local Park 2 | 4 |
10891 | 10891 | 10890 | {"type": "Polygon", "coordinates": [[[-121.75127, 38.54762], [-121.75021, 38.54761], [-121.75021, 38.54761], [-121.75024, 38.54751], [-121.75032, 38.54742], [-121.7507, 38.5472], [-121.75085, 38.54718], [-121.75111, 38.54725], [-121.75118, 38.5473], [-121.75124, 38.54744], [-121.75127, 38.54762]]]} | Open Access 1 | 21022 | College Park | 17507 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.816 | College Park | 0 | Local Park 2 | 4 | |
14538 | 14538 | 14537 | {"type": "Polygon", "coordinates": [[[-121.69931, 38.55911], [-121.69852, 38.55911], [-121.69853, 38.55865], [-121.6989, 38.55856], [-121.6991, 38.55855], [-121.69916, 38.55857], [-121.69919, 38.55862], [-121.69919, 38.55889], [-121.69918, 38.55896], [-121.69918, 38.55901], [-121.69924, 38.55908], [-121.69931, 38.55911]]]} | Open Access 1 | 47206 | Mace Ranch Mini Park | 30912 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | http://cityofdavis.org/Home/Components/FacilityDirectory/FacilityDirectory/38/2926?npage=3 | Yolo 33 | 0.836 | Mace Ranch MP | 0 | Local Park 2 | 4 |
439 | 439 | 438 | {"type": "Polygon", "coordinates": [[[-121.7605, 38.56573], [-121.7605, 38.56632], [-121.75984, 38.56631], [-121.75985, 38.56573], [-121.7605, 38.56573]]]} | Open Access 1 | 21013 | Hacienda Park | 19586 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 0.923 | Hacienda Park | 0 | Local Park 2 | 4 | |
8012 | 8012 | 8011 | {"type": "Polygon", "coordinates": [[[-121.71434, 38.56981], [-121.71412, 38.56993], [-121.71347, 38.56998], [-121.71348, 38.56937], [-121.71412, 38.56937], [-121.71419, 38.56958], [-121.71434, 38.56981]]]} | Open Access 1 | 20988 | Wildhorse Mini Park | 27515 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 1.015 | Wildhorse MP | 0 | Local Park 2 | 4 | |
12073 | 12073 | 12072 | {"type": "Polygon", "coordinates": [[[-121.70231, 38.54387], [-121.7023, 38.54454], [-121.70208, 38.54454], [-121.70185, 38.54466], [-121.70176, 38.5446], [-121.70167, 38.54459], [-121.70168, 38.54386], [-121.70231, 38.54387]]]} | Open Access 1 | 24838 | Putah Creek Park | 24034 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 1.08 | Putah Creek Park | 0 | Local Park 2 | 4 | |
10948 | 10948 | 10947 | {"type": "Polygon", "coordinates": [[[-121.79276, 38.55281], [-121.79186, 38.55291], [-121.7918, 38.55291], [-121.79176, 38.55286], [-121.79166, 38.55227], [-121.79266, 38.55227], [-121.79276, 38.55281]]]} | Open Access 1 | 20986 | Whaleback Park | 27447 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 1.432 | Whaleback Park | 0 | Local Park 2 | 4 | |
10943 | 10943 | 10942 | {"type": "Polygon", "coordinates": [[[-121.71025, 38.54282], [-121.70863, 38.54241], [-121.70861, 38.54232], [-121.70916, 38.54214], [-121.71012, 38.54174], [-121.71025, 38.54282]]]} | Open Access 1 | 20976 | Putah Creek Park | 24034 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 2.137 | Putah Creek Park | 0 | Local Park 2 | 4 | |
10956 | 10956 | 10955 | {"type": "Polygon", "coordinates": [[[-121.72913, 38.565], [-121.7291, 38.56585], [-121.72823, 38.56583], [-121.72798, 38.56584], [-121.72797, 38.56528], [-121.72791, 38.56495], [-121.72799, 38.56491], [-121.72856, 38.56489], [-121.72882, 38.56499], [-121.72913, 38.565]]]} | Open Access 1 | 21014 | Oak Grove Park | 22971 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 2.504 | Oak Grove Park | 0 | Local Park 2 | 4 | |
3055 | 3055 | 3054 | {"type": "Polygon", "coordinates": [[[-121.78648, 38.54919], [-121.78648, 38.55007], [-121.78525, 38.55004], [-121.78525, 38.54902], [-121.78605, 38.54902], [-121.78606, 38.54919], [-121.78648, 38.54919]]]} | Open Access 1 | 20984 | West Manor Park | 27367 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 2.883 | West Manor Park | 0 | Local Park 2 | 4 | |
10947 | 10947 | 10946 | {"type": "Polygon", "coordinates": [[[-121.73051, 38.54687], [-121.73035, 38.5469], [-121.73008, 38.54678], [-121.72995, 38.54676], [-121.72953, 38.54675], [-121.72911, 38.54675], [-121.72907, 38.54672], [-121.72877, 38.54679], [-121.72877, 38.54684], [-121.72873, 38.5469], [-121.72861, 38.54694], [-121.72851, 38.54693], [-121.72841, 38.54688], [-121.72781, 38.54701], [-121.72765, 38.54694], [-121.72759, 38.54688], [-121.72764, 38.54646], [-121.72756, 38.54626], [-121.72771, 38.54622], [-121.72773, 38.54643], [-121.7277, 38.54667], [-121.72771, 38.54683], [-121.72777, 38.5469], [-121.72784, 38.54691], [-121.72798, 38.54689], [-121.72798, 38.54681], [-121.72837, 38.54675], [-121.72845, 38.54667], [-121.72854, 38.54665], [-121.72867, 38.54667], [-121.72876, 38.54673], [-121.72905, 38.54663], [-121.72899, 38.5462], [-121.73041, 38.54597], [-121.73051, 38.54597], [-121.73051, 38.54687]]]} | Open Access 1 | 20981 | Toad Hollow Dog Park | 26379 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 3.147 | Toad Hollow Dog Park | 0 | Local Park 2 | 4 | |
10959 | 10959 | 10958 | {"type": "Polygon", "coordinates": [[[-121.76107, 38.55363], [-121.75876, 38.55359], [-121.75878, 38.55228], [-121.75911, 38.5523], [-121.75908, 38.55291], [-121.75992, 38.55317], [-121.76087, 38.55311], [-121.76107, 38.55363]]]} | Open Access 1 | 21018 | Redwood Park | 24248 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 3.333 | Redwood Park | 0 | Local Park 2 | 4 | |
10942 | 10942 | 10941 | {"type": "Polygon", "coordinates": [[[-121.76656, 38.5479], [-121.76567, 38.54789], [-121.76516, 38.54781], [-121.76502, 38.54815], [-121.76448, 38.54798], [-121.76444, 38.54796], [-121.76443, 38.54793], [-121.76461, 38.54748], [-121.76465, 38.54747], [-121.76489, 38.54747], [-121.76495, 38.54745], [-121.765, 38.54741], [-121.76503, 38.54735], [-121.76504, 38.54722], [-121.76503, 38.54718], [-121.7657, 38.54695], [-121.7657, 38.54714], [-121.76625, 38.54714], [-121.76652, 38.54765], [-121.76645, 38.54771], [-121.76644, 38.54779], [-121.76646, 38.54782], [-121.76654, 38.54786], [-121.76656, 38.5479]]]} | Open Access 1 | 20974 | Oxford Circle Park | 23280 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 3.34 | Oxford Circle Park | 0 | Local Park 2 | 4 | |
10938 | 10938 | 10937 | {"type": "Polygon", "coordinates": [[[-121.74467, 38.5606], [-121.74332, 38.56059], [-121.74294, 38.55937], [-121.74458, 38.55939], [-121.74465, 38.55962], [-121.74468, 38.55985], [-121.74467, 38.5606]]]} | Open Access 1 | 20966 | Little League Park | 21347 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 4.447 | Little League Park | 0 | Local Park 2 | 4 | |
10949 | 10949 | 10948 | {"type": "Polygon", "coordinates": [[[-121.70677, 38.54671], [-121.70675, 38.54698], [-121.7067, 38.54723], [-121.70665, 38.54741], [-121.70659, 38.54746], [-121.70654, 38.54746], [-121.70604, 38.54738], [-121.70546, 38.54733], [-121.70502, 38.54734], [-121.70456, 38.5474], [-121.70451, 38.54738], [-121.70447, 38.54734], [-121.70443, 38.54715], [-121.7044, 38.54689], [-121.70436, 38.54675], [-121.70431, 38.54665], [-121.70413, 38.54637], [-121.70448, 38.54638], [-121.70482, 38.54641], [-121.70547, 38.54642], [-121.70556, 38.5467], [-121.70677, 38.54671]]]} | Open Access 1 | 20989 | Willow Creek Park | 27576 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 4.64 | Willow Creek 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]);