units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 3 and MNG_AGENCY = 559
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Consumnes Community Services District · 2 ✖
DES_TP 1
- Local Recreation Area · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14477 | 14477 | 14476 | {"type": "MultiPolygon", "coordinates": [[[[-121.38001, 38.42816], [-121.37938, 38.42865], [-121.37942, 38.42872], [-121.37937, 38.42875], [-121.37935, 38.42879], [-121.37911, 38.42882], [-121.3788, 38.42929], [-121.37901, 38.4298], [-121.37887, 38.4299], [-121.37871, 38.43006], [-121.37863, 38.43019], [-121.37857, 38.43039], [-121.37809, 38.43057], [-121.3777, 38.43082], [-121.37771, 38.43096], [-121.37765, 38.43099], [-121.37762, 38.43106], [-121.37752, 38.43105], [-121.37721, 38.43117], [-121.37673, 38.43052], [-121.37715, 38.43014], [-121.37735, 38.43014], [-121.37763, 38.43007], [-121.3778, 38.43], [-121.37802, 38.42985], [-121.37813, 38.42973], [-121.37824, 38.42951], [-121.37828, 38.42936], [-121.37826, 38.42913], [-121.37862, 38.42897], [-121.37892, 38.42875], [-121.3789, 38.42863], [-121.37898, 38.4286], [-121.37902, 38.42855], [-121.37918, 38.42859], [-121.37977, 38.42801], [-121.38001, 38.42816]]], [[[-121.38539, 38.42712], [-121.38534, 38.43073], [-121.38522, 38.43073], [-121.38522, 38.43017], [-121.3849, 38.42994], [-121.38457, 38.42966], [-121.38434, 38.4295], [-121.3842, 38.42927], [-121.38387, 38.42925], [-121.38382, 38.4291], [-121.38373, 38.42893], [-121.38362, 38.4288], [-121.38347, 38.42868], [-121.38328, 38.42857], [-121.38271, 38.42832], [-121.38256, 38.42826], [-121.38238, 38.42822], [-121.38237, 38.42792], [-121.38168, 38.42783], [-121.3815, 38.42747], [-121.38116, 38.4276], [-121.38116, 38.42771], [-121.38108, 38.42771], [-121.38102, 38.42776], [-121.38085, 38.42771], [-121.38048, 38.42788], [-121.38022, 38.42812], [-121.37995, 38.42794], [-121.3809, 38.42712], [-121.38539, 38.42712]]]]} | Open Access 1 | 47133 | Camden Park Greenbelt | 30810 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/569/Camden-Park | Sacramento 41 | 23.178 | Camden Park Greenbelt | 0 | Local Recreation Area 3 | 4 |
14480 | 14480 | 14479 | {"type": "Polygon", "coordinates": [[[-121.42687, 38.39388], [-121.42259, 38.39408], [-121.42253, 38.39406], [-121.42251, 38.39403], [-121.42245, 38.39353], [-121.4222, 38.39047], [-121.42254, 38.39046], [-121.4225, 38.38985], [-121.42686, 38.38968], [-121.42687, 38.39388]]]} | Open Access 1 | 47135 | Bartholomew Sports Park | 30812 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/584/Bartholomew-Sports-Park | Sacramento 41 | 45.36 | Bartholomew Sports Park | 0 | Local Recreation Area 3 | 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]);