superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 4 and PARK_NAME = "Miramar Ranch North Open Space"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14904 | 14904 | 14903 | {"type": "MultiPolygon", "coordinates": [[[[-117.0781, 32.92695], [-117.07731, 32.92666], [-117.07659, 32.92619], [-117.07652, 32.92608], [-117.07606, 32.9257], [-117.07602, 32.92534], [-117.07609, 32.92497], [-117.07633, 32.92449], [-117.0765, 32.92427], [-117.07669, 32.92407], [-117.07654, 32.92373], [-117.07613, 32.9236], [-117.07576, 32.92355], [-117.07529, 32.92339], [-117.07529, 32.92305], [-117.07685, 32.92342], [-117.07696, 32.92359], [-117.07678, 32.92412], [-117.0765, 32.92459], [-117.07643, 32.92479], [-117.0764, 32.92494], [-117.07638, 32.92511], [-117.07639, 32.92526], [-117.07646, 32.92556], [-117.07653, 32.92573], [-117.07663, 32.92589], [-117.07675, 32.92604], [-117.07689, 32.92617], [-117.07712, 32.92633], [-117.07785, 32.92674], [-117.0781, 32.92695]]], [[[-117.08412, 32.93081], [-117.08363, 32.93035], [-117.08361, 32.93029], [-117.08369, 32.92998], [-117.08322, 32.92982], [-117.08301, 32.92959], [-117.083, 32.92936], [-117.0831, 32.92914], [-117.08294, 32.92892], [-117.08223, 32.92903], [-117.08218, 32.92902], [-117.08207, 32.92896], [-117.08201, 32.92888], [-117.08185, 32.9288], [-117.08166, 32.92887], [-117.0816, 32.92893], [-117.08146, 32.92885], [-117.08099, 32.92848], [-117.08113, 32.92837], [-117.08099, 32.92812], [-117.08095, 32.92792], [-117.081, 32.92757], [-117.08097, 32.92726], [-117.08111, 32.9271], [-117.08104, 32.92697], [-117.08071, 32.92682], [-117.0804, 32.92696], [-117.08006, 32.92686], [-117.0797, 32.92692], [-117.0796, 32.92668], [-117.07953, 32.9257], [-117.07972, 32.92509], [-117.0796, 32.92497], [-117.07904, 32.92515], [-117.07848, 32.92514], [-117.07849, 32.92536], [-117.07856, 32.92561], [-117.07853, 32.92604], [-117.07837, 32.92651], [-117.07822, 32.9268], [-117.07815, 32.92674], [-117.07805, 32.92645], [-117.07789, 32.92635], [-117.07805, 32.92626], [-117.07816, 32.92612], [-117.07832, 32.92585], [-117.07835, 32.92557], [-117.07831, 32.92533], [-117.07806, 32.92495], [-117.07827, 32.92486], [-117.07824, 32.92439], [-117.07843, 32.92435], [-117.07894, 32.92421], [-117.07932, 32.92405], [-117.07952, 32.92402], [-117.07968, 32.92402], [-117.07986, 32.92408], [-117.07998, 32.92414], [-117.07999, 32.92444], [-117.08042, 32.92493], [-117.08019, 32.92552], [-117.08023, 32.92589], [-117.08074, 32.92624], [-117.08114, 32.92619], [-117.08126, 32.92625], [-117.08118, 32.92642], [-117.08154, 32.92674], [-117.08174, 32.92713], [-117.08187, 32.92722], [-117.08188, 32.92733], [-117.08171, 32.92763], [-117.08208, 32.92819], [-117.08236, 32.92839], [-117.08288, 32.92871], [-117.08337, 32.92954], [-117.08385, 32.92982], [-117.08386, 32.92999], [-117.08374, 32.93016], [-117.08412, 32.93081]]], [[[-117.08873, 32.92603], [-117.08855, 32.92614], [-117.08843, 32.92644], [-117.08826, 32.92621], [-117.08803, 32.9261], [-117.08754, 32.92615], [-117.08743, 32.92612], [-117.08667, 32.92584], [-117.08638, 32.92563], [-117.08621, 32.92541], [-117.08536, 32.92523], [-117.08506, 32.92506], [-117.08463, 32.92489], [-117.08435, 32.92454], [-117.08422, 32.92442], [-117.084, 32.92433], [-117.08295, 32.92422], [-117.08238, 32.92429], [-117.08202, 32.92442], [-117.08177, 32.92442], [-117.08177, 32.92425], [-117.08178, 32.92422], [-117.0818, 32.92421], [-117.08292, 32.92416], [-117.08351, 32.92418], [-117.08391, 32.92426], [-117.08424, 32.92435], [-117.086, 32.92502], [-117.0863, 32.92512], [-117.08687, 32.92525], [-117.0872, 32.92528], [-117.0877, 32.92529], [-117.08873, 32.92568], [-117.08857, 32.92611], [-117.08858, 32.92612], [-117.08873, 32.92603]]]]} | Open Access 1 | Miramar Ranch North Open Space | 22288 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 28.147 | Miramar Ranch North OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);