units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2, MNG_AGENCY = 4 and UNIT_NAME = "Carmel Del Mar Neighborhood Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
169 | 169 | 168 | {"type": "Polygon", "coordinates": [[[-117.22951, 32.94051], [-117.22941, 32.94054], [-117.22942, 32.94052], [-117.22937, 32.94039], [-117.22922, 32.94033], [-117.22916, 32.94027], [-117.22905, 32.94019], [-117.22877, 32.9401], [-117.22873, 32.94012], [-117.2286, 32.94032], [-117.22857, 32.94039], [-117.22857, 32.94046], [-117.22834, 32.94055], [-117.22821, 32.94046], [-117.22795, 32.9404], [-117.2279, 32.94042], [-117.2278, 32.94057], [-117.22776, 32.94064], [-117.22775, 32.94075], [-117.22777, 32.94082], [-117.2278, 32.94086], [-117.22785, 32.94089], [-117.22783, 32.94095], [-117.22791, 32.94096], [-117.22791, 32.94093], [-117.22811, 32.94103], [-117.22831, 32.94111], [-117.22868, 32.94123], [-117.22874, 32.94117], [-117.22892, 32.9411], [-117.22892, 32.94108], [-117.22898, 32.94104], [-117.22922, 32.94106], [-117.22931, 32.94104], [-117.22937, 32.94097], [-117.2294, 32.94082], [-117.22943, 32.94081], [-117.22945, 32.94081], [-117.22946, 32.94084], [-117.2294, 32.94102], [-117.22931, 32.94117], [-117.22873, 32.94187], [-117.22785, 32.94149], [-117.22745, 32.94126], [-117.22708, 32.9413], [-117.22682, 32.9412], [-117.2262, 32.9412], [-117.22622, 32.94109], [-117.22645, 32.94086], [-117.22653, 32.9406], [-117.22645, 32.94035], [-117.22613, 32.93992], [-117.22789, 32.9393], [-117.22818, 32.93927], [-117.22838, 32.93927], [-117.22869, 32.93934], [-117.2289, 32.93945], [-117.22903, 32.93955], [-117.22914, 32.93966], [-117.22923, 32.93977], [-117.22927, 32.93985], [-117.22944, 32.94023], [-117.22951, 32.94051]]]} | Open Access 1 | 451 | Carmel Del Mar Neighborhood Park | 30150 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.077 | Carmel Del Mar Neighborhood 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]);