units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 985, MNG_AGENCY = 494 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Southgate Recreation and Park District · 1 ✖
DES_TP 1
- - · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11270 | 11270 | 11269 | {"type": "MultiPolygon", "coordinates": [[[[-121.30369, 38.49136], [-121.29786, 38.49132], [-121.29784, 38.4889], [-121.30251, 38.48891], [-121.30252, 38.48894], [-121.30366, 38.48894], [-121.30369, 38.49136]]], [[[-121.31605, 38.46467], [-121.31569, 38.46467], [-121.31545, 38.46469], [-121.3152, 38.46475], [-121.31494, 38.46485], [-121.31489, 38.46486], [-121.31484, 38.46483], [-121.31425, 38.46426], [-121.31403, 38.46409], [-121.31363, 38.46387], [-121.31323, 38.46373], [-121.31249, 38.46355], [-121.31219, 38.4635], [-121.31084, 38.46343], [-121.31049, 38.46339], [-121.31015, 38.46331], [-121.30949, 38.46309], [-121.30919, 38.46302], [-121.3088, 38.463], [-121.30845, 38.46303], [-121.30718, 38.46329], [-121.30693, 38.46336], [-121.30664, 38.46347], [-121.30619, 38.46369], [-121.30545, 38.46417], [-121.30525, 38.46431], [-121.30504, 38.46452], [-121.30483, 38.46481], [-121.3041, 38.4663], [-121.30334, 38.4671], [-121.30043, 38.4671], [-121.30069, 38.4669], [-121.30202, 38.46628], [-121.30248, 38.466], [-121.30291, 38.46547], [-121.30293, 38.46503], [-121.30287, 38.4641], [-121.30299, 38.46363], [-121.30301, 38.46338], [-121.30352, 38.46257], [-121.30434, 38.46231], [-121.30737, 38.46216], [-121.30796, 38.46155], [-121.30874, 38.46128], [-121.30949, 38.46142], [-121.3106, 38.46198], [-121.31097, 38.46201], [-121.31413, 38.46142], [-121.31529, 38.46197], [-121.31604, 38.46216], [-121.31605, 38.46467]]]]} | Open Access 1 | 21745 | SOUTHGATE RECREATION/PARK DISTRICT | 25690 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 105.753 | SOUTHGATE RECREATION/PARK DISTRICT | None 985 |
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]);