units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where LABEL_NAME = "Miramar Ranch North OS" and MNG_AGENCY = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5826 | 5826 | 5825 | {"type": "Polygon", "coordinates": [[[-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.92913], [-117.08294, 32.92891], [-117.08223, 32.92903], [-117.08218, 32.92902], [-117.08207, 32.92896], [-117.08201, 32.92888], [-117.08185, 32.92879], [-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.08112, 32.9271], [-117.08105, 32.92697], [-117.08071, 32.92682], [-117.0804, 32.92696], [-117.08006, 32.92685], [-117.0797, 32.92692], [-117.0796, 32.92668], [-117.07953, 32.9257], [-117.07972, 32.92509], [-117.07959, 32.92496], [-117.07904, 32.92515], [-117.07848, 32.92513], [-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.92613], [-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.07998, 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.08373, 32.93016], [-117.08412, 32.93081]]]} | Open Access 1 | 140 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 17.39 | Miramar Ranch North OS | 0 | Local Recreation Area 3 | 4 | |
15970 | 15970 | 15969 | {"type": "Polygon", "coordinates": [[[-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.08622, 32.92541], [-117.08536, 32.92523], [-117.08506, 32.92506], [-117.08463, 32.92489], [-117.08435, 32.92453], [-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.92426], [-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.08856, 32.92612], [-117.08858, 32.92612], [-117.08873, 32.92603]]]} | Open Access 1 | 144 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 6.794 | Miramar Ranch North OS | 0 | Local Recreation Area 3 | 4 | |
16222 | 16222 | 16221 | {"type": "Polygon", "coordinates": [[[-117.0781, 32.92695], [-117.07731, 32.92666], [-117.07659, 32.92619], [-117.07652, 32.92609], [-117.07606, 32.9257], [-117.07602, 32.92534], [-117.07609, 32.92498], [-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.07677, 32.92412], [-117.0765, 32.92459], [-117.07643, 32.92479], [-117.0764, 32.92494], [-117.07638, 32.92511], [-117.07639, 32.92527], [-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.92675], [-117.0781, 32.92695]]]} | Open Access 1 | 44840 | 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 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 3.928 | Miramar Ranch North OS | 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]);