units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where COUNTY = 14, DES_TP = 2 and MNG_AGENCY = 172
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 19
MNG_AGENCY 1
- Greenfield, City of · 19 ✖
DES_TP 1
- Local Park · 19 ✖
ACCESS_TYP 1
- Open Access 19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
468 | 468 | 467 | {"type": "Polygon", "coordinates": [[[-121.23985, 36.31529], [-121.23985, 36.31529], [-121.23866, 36.31569], [-121.23912, 36.31545], [-121.23943, 36.31521], [-121.23967, 36.31506], [-121.23985, 36.31529]]]} | Open Access 1 | 1515 | Tyler Park | 26628 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.38 | Tyler Park | 0 | Local Park 2 | 4 | |
2341 | 2341 | 2340 | {"type": "Polygon", "coordinates": [[[-121.26004, 36.31152], [-121.25821, 36.31254], [-121.25576, 36.30965], [-121.25757, 36.30863], [-121.26004, 36.31152]]]} | Open Access 1 | 18443 | Patriot Park | 23513 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 19.116 | Patriot Park | 0 | Local Park 2 | 4 | |
2358 | 2358 | 2357 | {"type": "Polygon", "coordinates": [[[-121.23787, 36.32179], [-121.23747, 36.32201], [-121.23733, 36.32185], [-121.23774, 36.32162], [-121.23787, 36.32179]]]} | Open Access 1 | 17554 | Fifth Street Park | 30773 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.244 | Fifth Street Park | 0 | Local Park 2 | 4 | |
2433 | 2433 | 2432 | {"type": "Polygon", "coordinates": [[[-121.24674, 36.33072], [-121.24636, 36.33094], [-121.24588, 36.33048], [-121.2463, 36.33025], [-121.24657, 36.33041], [-121.24654, 36.33047], [-121.24655, 36.33054], [-121.2466, 36.33059], [-121.24667, 36.33063], [-121.24674, 36.33072]]]} | Open Access 1 | 17316 | Baywood Park | 15904 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.745 | Baywood Park | 0 | Local Park 2 | 4 | |
2784 | 2784 | 2783 | {"type": "Polygon", "coordinates": [[[-121.23513, 36.32734], [-121.23453, 36.32767], [-121.23445, 36.32757], [-121.23443, 36.32747], [-121.23439, 36.32741], [-121.23433, 36.32738], [-121.23426, 36.32737], [-121.23419, 36.32738], [-121.23414, 36.32741], [-121.23399, 36.32723], [-121.23469, 36.32683], [-121.23513, 36.32734]]]} | Open Access 1 | 18554 | Vintage Park | 30768 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 1.141 | Vintage Park | 0 | Local Park 2 | 4 | |
2859 | 2859 | 2858 | {"type": "Polygon", "coordinates": [[[-121.24939, 36.3241], [-121.24918, 36.32421], [-121.24905, 36.32407], [-121.24905, 36.32404], [-121.24907, 36.324], [-121.24924, 36.32392], [-121.24939, 36.3241]]]} | Open Access 1 | 18833 | Primavera Park | 24000 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.14 | Primavera Park | 0 | Local Park 2 | 4 | |
3306 | 3306 | 3305 | {"type": "Polygon", "coordinates": [[[-121.23637, 36.31806], [-121.23585, 36.31802], [-121.23546, 36.31808], [-121.23542, 36.3176], [-121.23574, 36.31756], [-121.23607, 36.31747], [-121.23615, 36.31767], [-121.23637, 36.31806]]]} | Open Access 1 | 47108 | St. Charles Park | 30775 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.968 | St. Charles Park | 0 | Local Park 2 | 4 | |
3762 | 3762 | 3761 | {"type": "Polygon", "coordinates": [[[-121.23523, 36.33374], [-121.23509, 36.33358], [-121.235, 36.33363], [-121.23489, 36.3335], [-121.23508, 36.33339], [-121.2353, 36.33364], [-121.2353, 36.33369], [-121.23523, 36.33374]]]} | Open Access 1 | 34924 | Barolo Circle Park | 30772 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.152 | Barolo Circle Park | 0 | Local Park 2 | 4 | |
4077 | 4077 | 4076 | {"type": "Polygon", "coordinates": [[[-121.2496, 36.33136], [-121.24926, 36.33155], [-121.24888, 36.3311], [-121.24922, 36.33092], [-121.2496, 36.33136]]]} | Open Access 1 | 47105 | Apricot Street Park | 30767 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.542 | Apricot Street Park | 0 | Local Park 2 | 4 | |
5720 | 5720 | 5719 | {"type": "Polygon", "coordinates": [[[-121.25117, 36.31304], [-121.25116, 36.31307], [-121.25106, 36.31311], [-121.25103, 36.3131], [-121.25093, 36.31297], [-121.25094, 36.31294], [-121.25104, 36.3129], [-121.25117, 36.31304]]]} | Open Access 1 | 47107 | Lexington Park | 30774 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.07 | Lexington Park | 0 | Local Park 2 | 4 | |
10086 | 10086 | 10085 | {"type": "Polygon", "coordinates": [[[-121.25325, 36.33079], [-121.25247, 36.33122], [-121.25122, 36.32977], [-121.25201, 36.32933], [-121.25325, 36.33079]]]} | Open Access 1 | 17510 | Jim Maggini Memorial Park | 30770 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 4.16 | Jim Maggini Memorial Park | 0 | Local Park 2 | 4 | |
10413 | 10413 | 10412 | {"type": "Polygon", "coordinates": [[[-121.25022, 36.31869], [-121.24968, 36.319], [-121.24959, 36.31888], [-121.24961, 36.31877], [-121.24958, 36.3187], [-121.24948, 36.31865], [-121.24941, 36.31865], [-121.24934, 36.31867], [-121.24932, 36.31865], [-121.25003, 36.31825], [-121.25003, 36.3183], [-121.24994, 36.31833], [-121.24989, 36.31839], [-121.24988, 36.31845], [-121.24989, 36.31849], [-121.24997, 36.31856], [-121.25013, 36.3186], [-121.25022, 36.31869]]]} | Open Access 1 | 18417 | Parkside Park | 23450 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.627 | Parkside Park | 0 | Local Park 2 | 4 | |
11231 | 11231 | 11230 | {"type": "Polygon", "coordinates": [[[-121.23861, 36.32876], [-121.23725, 36.32951], [-121.23681, 36.329], [-121.23817, 36.32823], [-121.23861, 36.32876]]]} | Open Access 1 | 48027 | Greenfield Community Park | 32512 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | https://ci.greenfield.ca.us/262/Parks | Monterey 14 | 2.576 | Greenfield Community Park | 0 | Local Park 2 | 4 |
11538 | 11538 | 11537 | {"type": "Polygon", "coordinates": [[[-121.22905, 36.3312], [-121.22856, 36.33147], [-121.22839, 36.33127], [-121.22888, 36.331], [-121.22905, 36.3312]]]} | Open Access 1 | 47109 | Traditions Park | 30776 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.353 | Traditions Park | 0 | Local Park 2 | 4 | |
12397 | 12397 | 12396 | {"type": "Polygon", "coordinates": [[[-121.23116, 36.33457], [-121.23086, 36.33474], [-121.2295, 36.33313], [-121.2298, 36.33296], [-121.23116, 36.33457]]]} | Open Access 1 | 47110 | Second Street Park | 30777 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 1.758 | Second Street Park | 0 | Local Park 2 | 4 | |
12571 | 12571 | 12570 | {"type": "Polygon", "coordinates": [[[-121.23081, 36.33315], [-121.23069, 36.33322], [-121.23061, 36.33324], [-121.23056, 36.33329], [-121.23056, 36.33334], [-121.23057, 36.33337], [-121.23068, 36.33345], [-121.23037, 36.33363], [-121.23001, 36.33322], [-121.23059, 36.33289], [-121.23081, 36.33315]]]} | Open Access 1 | 29082 | Tuscany Park | 26601 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.711 | Tuscany Park | 0 | Local Park 2 | 4 | |
12585 | 12585 | 12584 | {"type": "Polygon", "coordinates": [[[-121.23267, 36.33082], [-121.23205, 36.33118], [-121.23168, 36.33074], [-121.2323, 36.33039], [-121.23235, 36.33039], [-121.23263, 36.33072], [-121.23267, 36.33082]]]} | Open Access 1 | 29155 | Rotary Centennial Park | 30769 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 1.022 | Rotary Centennial Park | 0 | Local Park 2 | 4 | |
13050 | 13050 | 13049 | {"type": "Polygon", "coordinates": [[[-121.23739, 36.32724], [-121.23742, 36.32725], [-121.23769, 36.32756], [-121.23769, 36.32759], [-121.23755, 36.32767], [-121.23751, 36.32767], [-121.23723, 36.32735], [-121.23724, 36.32732], [-121.23739, 36.32724]]]} | Open Access 1 | 34923 | Mariposa Park | 21866 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.241 | Mariposa Park | 0 | Local Park 2 | 4 | |
14377 | 14377 | 14376 | {"type": "Polygon", "coordinates": [[[-121.23981, 36.31708], [-121.23921, 36.31754], [-121.23883, 36.3171], [-121.23934, 36.31671], [-121.23981, 36.31708]]]} | Open Access 1 | 47106 | Village Green Park | 30771 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 1.0 | Village Green 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]);