units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, COUNTY = 4, DES_TP = 1248 and MNG_AGENCY = 101
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14635 | 14635 | 14634 | {"type": "Polygon", "coordinates": [[[-117.10501, 33.01145], [-117.10485, 33.01158], [-117.10476, 33.01169], [-117.10473, 33.01183], [-117.10471, 33.01203], [-117.10476, 33.01243], [-117.10474, 33.01289], [-117.1046, 33.01309], [-117.1044, 33.01313], [-117.10431, 33.01325], [-117.1041, 33.01314], [-117.10388, 33.01304], [-117.10297, 33.01276], [-117.10268, 33.01265], [-117.10215, 33.01241], [-117.10125, 33.01195], [-117.09931, 33.01118], [-117.09888, 33.011], [-117.09844, 33.0108], [-117.09802, 33.01057], [-117.09748, 33.01024], [-117.09709, 33.00997], [-117.09672, 33.00969], [-117.0966, 33.00959], [-117.09698, 33.00811], [-117.1048, 33.00837], [-117.10477, 33.00869], [-117.10481, 33.00874], [-117.10454, 33.00943], [-117.10481, 33.00975], [-117.10482, 33.01], [-117.10492, 33.01018], [-117.10484, 33.01029], [-117.1048, 33.01076], [-117.1047, 33.01099], [-117.10468, 33.01115], [-117.10469, 33.01122], [-117.10471, 33.01127], [-117.10475, 33.01131], [-117.105, 33.01142], [-117.10501, 33.01145]], [[-117.10204, 33.01004], [-117.10213, 33.01005], [-117.10226, 33.01004], [-117.10237, 33.01001], [-117.10247, 33.00996], [-117.10255, 33.00989], [-117.10262, 33.0098], [-117.10265, 33.0097], [-117.10266, 33.0096], [-117.10261, 33.00944], [-117.10255, 33.00937], [-117.10247, 33.0093], [-117.10235, 33.00924], [-117.10222, 33.00922], [-117.10207, 33.00922], [-117.10198, 33.00925], [-117.10193, 33.00914], [-117.10174, 33.00924], [-117.10161, 33.00939], [-117.10154, 33.00955], [-117.10153, 33.0098], [-117.10156, 33.00992], [-117.10162, 33.01005], [-117.10168, 33.01013], [-117.10183, 33.01027], [-117.10191, 33.01037], [-117.10192, 33.01036], [-117.10204, 33.01004]]]} | Open Access 1 | 44867 | Christopher Hill Holding | 29230 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | San Diego 4 | 69.353 | Christopher Hill Holding | None 1248 |
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]);