units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where DES_TP = 2, MNG_AGENCY = 604 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Cameron Park Community Services District · 7 ✖
DES_TP 1
- Local Park · 7 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3311 | 3311 | 3310 | {"type": "Polygon", "coordinates": [[[-121.00447, 38.69485], [-121.00424, 38.69495], [-121.00409, 38.6946], [-121.00391, 38.69442], [-121.0036, 38.69429], [-121.00345, 38.69439], [-121.00337, 38.69431], [-121.00353, 38.69419], [-121.00327, 38.69372], [-121.00274, 38.6933], [-121.00269, 38.693], [-121.00275, 38.69254], [-121.00265, 38.6919], [-121.0022, 38.69097], [-121.00192, 38.6906], [-121.0019, 38.69021], [-121.00147, 38.69024], [-121.00115, 38.68933], [-121.00361, 38.68935], [-121.00284, 38.6901], [-121.00321, 38.69093], [-121.00333, 38.69132], [-121.00341, 38.69159], [-121.00351, 38.6923], [-121.00395, 38.6938], [-121.00443, 38.69404], [-121.00427, 38.6946], [-121.00447, 38.69485]]]} | Open Access 1 | 29639 | Gateway Park | 19240 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 13.424 | Gateway Park | 0 | Local Park 2 | 4 | |
3346 | 3346 | 3345 | {"type": "Polygon", "coordinates": [[[-120.98121, 38.68838], [-120.9796, 38.68963], [-120.97944, 38.6898], [-120.97775, 38.68919], [-120.98018, 38.68729], [-120.98102, 38.6879], [-120.98092, 38.68806], [-120.9809, 38.68811], [-120.98121, 38.68838]]]} | Open Access 1 | 24123 | Rasmussen Park | 24190 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 9.847 | Rasmussen Park | 0 | Local Park 2 | 4 | |
4331 | 4331 | 4330 | {"type": "Polygon", "coordinates": [[[-120.97333, 38.67984], [-120.97344, 38.67985], [-120.97355, 38.67989], [-120.97363, 38.67997], [-120.97367, 38.68004], [-120.97367, 38.68086], [-120.97365, 38.68088], [-120.97361, 38.68089], [-120.97303, 38.68087], [-120.97276, 38.68084], [-120.97273, 38.68079], [-120.97279, 38.68048], [-120.9728, 38.67987], [-120.97286, 38.67984], [-120.97333, 38.67984]]]} | Open Access 1 | 45512 | Eastwood Park | 28346 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 2.155 | Eastwood Park | 0 | Local Park 2 | 4 | |
11827 | 11827 | 11826 | {"type": "Polygon", "coordinates": [[[-120.97689, 38.66644], [-120.97663, 38.66629], [-120.97415, 38.66658], [-120.9732, 38.66697], [-120.97297, 38.66712], [-120.97286, 38.6669], [-120.97405, 38.6665], [-120.97542, 38.66632], [-120.97556, 38.66598], [-120.97435, 38.66468], [-120.9748, 38.6645], [-120.97485, 38.66452], [-120.9763, 38.66567], [-120.97663, 38.66601], [-120.97682, 38.66628], [-120.97689, 38.66644]]]} | Open Access 1 | 24132 | Hacienda Park | 19590 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 4.93 | Hacienda Park | 0 | Local Park 2 | 4 | |
11828 | 11828 | 11827 | {"type": "Polygon", "coordinates": [[[-121.00637, 38.65611], [-121.00636, 38.65719], [-121.00382, 38.6572], [-121.00381, 38.65631], [-121.00418, 38.65622], [-121.00637, 38.65611]]]} | Open Access 1 | 24135 | Christa McAuliffe Park | 17223 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 6.17 | Christa McAuliffe Park | 0 | Local Park 2 | 4 | |
11829 | 11829 | 11828 | {"type": "Polygon", "coordinates": [[[-121.00711, 38.65544], [-121.00546, 38.65556], [-121.00537, 38.65489], [-121.0066, 38.65449], [-121.00711, 38.65544]]]} | Open Access 1 | 24136 | Dave West Park | 17937 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 2.985 | Dave West Park | 0 | Local Park 2 | 4 | |
14985 | 14985 | 14984 | {"type": "Polygon", "coordinates": [[[-120.97926, 38.68508], [-120.97912, 38.68513], [-120.97897, 38.68516], [-120.97813, 38.68517], [-120.97813, 38.68492], [-120.97806, 38.68492], [-120.97796, 38.68484], [-120.97754, 38.68479], [-120.97738, 38.6848], [-120.97726, 38.6845], [-120.97699, 38.68426], [-120.97654, 38.68405], [-120.97598, 38.68382], [-120.97568, 38.68381], [-120.97569, 38.68295], [-120.97575, 38.68292], [-120.97606, 38.68291], [-120.97631, 38.68288], [-120.97652, 38.6832], [-120.97729, 38.684], [-120.97865, 38.68477], [-120.97926, 38.68508]]]} | Open Access 1 | 45619 | Northview Park | 28447 | 2212 | Cameron Park Community Services District 615 | Special District 4 | Community Services District 19 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | El Dorado 34 | 5.218 | Northview 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]);