units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where ACCESS_TYP = 1, AGNCY_ID = 1407 and DES_TP = 2
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3343 | 3343 | 3342 | {"type": "Polygon", "coordinates": [[[-121.29859, 38.27323], [-121.29827, 38.27323], [-121.29772, 38.27303], [-121.29772, 38.27294], [-121.29763, 38.27285], [-121.29754, 38.27274], [-121.29747, 38.27261], [-121.29743, 38.27246], [-121.2974, 38.27226], [-121.29741, 38.27183], [-121.29743, 38.27174], [-121.29739, 38.27166], [-121.29733, 38.27162], [-121.29732, 38.27136], [-121.2974, 38.27136], [-121.29748, 38.27138], [-121.29759, 38.27146], [-121.29762, 38.27154], [-121.29764, 38.2719], [-121.29767, 38.27203], [-121.29772, 38.27212], [-121.29788, 38.27231], [-121.29808, 38.27243], [-121.29817, 38.27251], [-121.29823, 38.27262], [-121.29826, 38.27288], [-121.29829, 38.27297], [-121.29835, 38.27304], [-121.29841, 38.27309], [-121.29859, 38.27317], [-121.29859, 38.27323]]]} | Open Access 1 | 24095 | Canyon Creek Park | 16814 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 1.995 | Canyon Creek Park | 0 | Local Park 2 | 4 | |
4078 | 4078 | 4077 | {"type": "Polygon", "coordinates": [[[-121.30625, 38.25317], [-121.30605, 38.25321], [-121.30574, 38.25237], [-121.30594, 38.25233], [-121.30625, 38.25317]]]} | Open Access 1 | 47115 | Southern Pacific Park | 30786 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 0.434 | Southern Pacific Park | 0 | Local Park 2 | 4 | |
5236 | 5236 | 5235 | {"type": "Polygon", "coordinates": [[[-121.32596, 38.25906], [-121.32595, 38.26184], [-121.32404, 38.26185], [-121.32404, 38.26001], [-121.32402, 38.25959], [-121.32423, 38.25956], [-121.3249, 38.25955], [-121.32492, 38.25909], [-121.32596, 38.25906]]]} | Open Access 1 | 48078 | Walker Community Park | 32580 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/walker-park | Sacramento 41 | 11.723 | Walker Community Park | 2011 | Local Park 2 | 4 |
5237 | 5237 | 5236 | {"type": "Polygon", "coordinates": [[[-121.29056, 38.28984], [-121.29054, 38.29107], [-121.28929, 38.29108], [-121.2893, 38.29104], [-121.2894, 38.291], [-121.28946, 38.29093], [-121.28974, 38.28982], [-121.28981, 38.28979], [-121.29056, 38.28984]]]} | Open Access 1 | 48079 | Monterey Park | 32581 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/monterey-park | Sacramento 41 | 2.941 | Monterey Park | 0 | Local Park 2 | 4 |
5238 | 5238 | 5237 | {"type": "Polygon", "coordinates": [[[-121.29118, 38.26987], [-121.29055, 38.27022], [-121.29037, 38.27002], [-121.29023, 38.26972], [-121.28988, 38.26967], [-121.29008, 38.26883], [-121.29062, 38.26886], [-121.29067, 38.26894], [-121.29055, 38.26919], [-121.2907, 38.26947], [-121.29099, 38.26963], [-121.29118, 38.26987]]]} | Open Access 1 | 48080 | Roundstone Park | 32582 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/roundstone-park | Sacramento 41 | 2.211 | Roundstone Park | 0 | Local Park 2 | 4 |
5239 | 5239 | 5238 | {"type": "Polygon", "coordinates": [[[-121.28808, 38.28648], [-121.2873, 38.28653], [-121.28649, 38.28664], [-121.2858, 38.2868], [-121.28515, 38.287], [-121.28514, 38.28575], [-121.28761, 38.28573], [-121.28795, 38.28568], [-121.28803, 38.28612], [-121.28808, 38.28648]]]} | Open Access 1 | 48081 | McCaffery Park | 32583 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/mccaffery-park | Sacramento 41 | 6.455 | McCaffery Park | 0 | Local Park 2 | 4 |
5240 | 5240 | 5239 | {"type": "Polygon", "coordinates": [[[-121.30529, 38.25856], [-121.30529, 38.25881], [-121.30473, 38.25881], [-121.30473, 38.25856], [-121.30529, 38.25856]]]} | Open Access 1 | 48082 | Lion's Oak Park | 32584 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/lion-s-oak-park | Sacramento 41 | 0.333 | Lion's Oak Park | 0 | Local Park 2 | 4 |
11722 | 11722 | 11721 | {"type": "MultiPolygon", "coordinates": [[[[-121.3074, 38.2507], [-121.30691, 38.25081], [-121.30678, 38.25048], [-121.30727, 38.25037], [-121.3074, 38.2507]]], [[[-121.30834, 38.25155], [-121.30727, 38.25179], [-121.30695, 38.25094], [-121.30802, 38.25069], [-121.30834, 38.25155]]]]} | Open Access 1 | 24101 | Harvey Park | 19728 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 2.817 | Harvey Park | 0 | Local Park 2 | 4 | |
11797 | 11797 | 11796 | {"type": "Polygon", "coordinates": [[[-121.29204, 38.27768], [-121.29211, 38.27781], [-121.29225, 38.27822], [-121.29252, 38.27871], [-121.29252, 38.27875], [-121.29249, 38.27878], [-121.2891, 38.28007], [-121.28904, 38.28006], [-121.28901, 38.28004], [-121.28881, 38.27976], [-121.28864, 38.27957], [-121.28876, 38.27956], [-121.28886, 38.27952], [-121.28895, 38.27946], [-121.28902, 38.27938], [-121.28944, 38.27834], [-121.28978, 38.27838], [-121.28986, 38.27837], [-121.28997, 38.27832], [-121.2901, 38.27821], [-121.29016, 38.27812], [-121.29019, 38.27802], [-121.2902, 38.27744], [-121.29024, 38.27737], [-121.2903, 38.27731], [-121.29038, 38.27728], [-121.29048, 38.27726], [-121.29057, 38.27728], [-121.29065, 38.27731], [-121.29072, 38.27737], [-121.29083, 38.27761], [-121.29091, 38.27771], [-121.29102, 38.27778], [-121.29122, 38.27786], [-121.29136, 38.27788], [-121.29158, 38.27785], [-121.29204, 38.27768]]]} | Open Access 1 | 24093 | Galt Community Park | 19181 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 12.207 | Galt Community Park | 0 | Local Park 2 | 4 | |
11798 | 11798 | 11797 | {"type": "Polygon", "coordinates": [[[-121.30404, 38.27616], [-121.30399, 38.27618], [-121.30342, 38.27634], [-121.30297, 38.27653], [-121.30278, 38.27657], [-121.3027, 38.27655], [-121.30268, 38.27652], [-121.30264, 38.27633], [-121.30259, 38.27594], [-121.30258, 38.27535], [-121.30262, 38.27523], [-121.3026, 38.27516], [-121.30254, 38.27509], [-121.30256, 38.27507], [-121.30256, 38.27477], [-121.30354, 38.27477], [-121.30404, 38.27616]]]} | Open Access 1 | 24094 | Emerald Vista Park | 18620 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 4.767 | Emerald Vista Park | 0 | Local Park 2 | 4 | |
11800 | 11800 | 11799 | {"type": "Polygon", "coordinates": [[[-121.30202, 38.25468], [-121.30084, 38.25469], [-121.30084, 38.25455], [-121.30188, 38.25429], [-121.30202, 38.25468]]]} | Open Access 1 | 24097 | SMUD Park | 33379 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 0.741 | SMUD Park | 0 | Local Park 2 | 4 | |
11801 | 11801 | 11800 | {"type": "Polygon", "coordinates": [[[-121.32095, 38.25247], [-121.32095, 38.25302], [-121.32042, 38.25302], [-121.32041, 38.25335], [-121.3201, 38.25359], [-121.32011, 38.25455], [-121.31912, 38.25456], [-121.31906, 38.25453], [-121.31904, 38.25449], [-121.31904, 38.2525], [-121.32095, 38.25247]]]} | Open Access 1 | 24098 | Greer Basin Park | 19493 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 6.695 | Greer Basin Park | 0 | Local Park 2 | 4 | |
14242 | 14242 | 14241 | {"type": "Polygon", "coordinates": [[[-121.31175, 38.2403], [-121.31174, 38.24169], [-121.31079, 38.24169], [-121.31078, 38.24152], [-121.31041, 38.24152], [-121.31041, 38.24036], [-121.31043, 38.24032], [-121.31047, 38.2403], [-121.31175, 38.2403]]]} | Open Access 1 | 44133 | Meadowview Park | 22101 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 4.303 | Meadowview Park | 0 | Local Park 2 | 4 | |
14248 | 14248 | 14247 | {"type": "Polygon", "coordinates": [[[-121.2979, 38.28722], [-121.29743, 38.28722], [-121.29718, 38.28678], [-121.29688, 38.28635], [-121.29687, 38.2863], [-121.29689, 38.28627], [-121.29711, 38.28618], [-121.29749, 38.28606], [-121.29778, 38.286], [-121.29786, 38.28602], [-121.29787, 38.28605], [-121.29794, 38.28649], [-121.29791, 38.2866], [-121.29792, 38.28715], [-121.2979, 38.28722]]]} | Open Access 1 | 44147 | Lake Canyon Park | 20878 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | Sacramento 41 | 2.16 | Lake Canyon 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]);