units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 4, DES_TP = 3 and PARK_URL = "http://www.sandiego.gov/water/recreation/reservoirs/miramar.shtml"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5819 | 5819 | 5818 | {"type": "MultiPolygon", "coordinates": [[[[-117.10849, 32.91547], [-117.10806, 32.91551], [-117.10802, 32.91565], [-117.10797, 32.91576], [-117.10783, 32.91595], [-117.10762, 32.9161], [-117.10736, 32.91622], [-117.10713, 32.91627], [-117.10512, 32.91648], [-117.10496, 32.91652], [-117.10481, 32.91661], [-117.10473, 32.91668], [-117.1041, 32.91744], [-117.10389, 32.91775], [-117.10378, 32.91801], [-117.1037, 32.91837], [-117.10364, 32.91846], [-117.10355, 32.91858], [-117.1035, 32.91867], [-117.10345, 32.91936], [-117.10341, 32.91944], [-117.10335, 32.91949], [-117.10321, 32.91956], [-117.10311, 32.91958], [-117.10304, 32.91957], [-117.10298, 32.91954], [-117.10292, 32.91949], [-117.10277, 32.91902], [-117.1023, 32.91816], [-117.10225, 32.9181], [-117.10218, 32.91804], [-117.10208, 32.918], [-117.10199, 32.91799], [-117.10187, 32.91799], [-117.10179, 32.91802], [-117.1017, 32.91807], [-117.10163, 32.91814], [-117.10158, 32.91822], [-117.10138, 32.91881], [-117.10131, 32.9189], [-117.10118, 32.91893], [-117.10094, 32.91886], [-117.10075, 32.91887], [-117.10063, 32.91893], [-117.10055, 32.91901], [-117.10051, 32.91909], [-117.10047, 32.91929], [-117.1004, 32.91936], [-117.10032, 32.91939], [-117.09997, 32.9194], [-117.09982, 32.91938], [-117.0997, 32.9193], [-117.09964, 32.9192], [-117.09933, 32.918], [-117.09926, 32.91788], [-117.09914, 32.91777], [-117.09896, 32.9177], [-117.09878, 32.9177], [-117.0986, 32.91775], [-117.09847, 32.91785], [-117.09839, 32.91797], [-117.09783, 32.91975], [-117.09779, 32.91984], [-117.09772, 32.91992], [-117.09695, 32.92055], [-117.09682, 32.92059], [-117.09658, 32.9206], [-117.09644, 32.92067], [-117.09638, 32.92078], [-117.0961, 32.9218], [-117.09601, 32.92189], [-117.09576, 32.92196], [-117.09558, 32.92198], [-117.09545, 32.92198], [-117.09536, 32.92195], [-117.09528, 32.9219], [-117.09522, 32.92182], [-117.09505, 32.92139], [-117.0949, 32.92114], [-117.09474, 32.92097], [-117.09426, 32.92056], [-117.09415, 32.9205], [-117.09407, 32.92049], [-117.09398, 32.9205], [-117.0939, 32.92052], [-117.09383, 32.92057], [-117.09326, 32.92129], [-117.09315, 32.92139], [-117.09294, 32.92151], [-117.09282, 32.92154], [-117.09267, 32.92156], [-117.0925, 32.92155], [-117.09234, 32.92151], [-117.09208, 32.92138], [-117.09199, 32.92132], [-117.0919, 32.92123], [-117.09185, 32.92114], [-117.09172, 32.92074], [-117.09169, 32.92068], [-117.09163, 32.92062], [-117.09157, 32.92059], [-117.09141, 32.92058], [-117.09119, 32.92062], [-117.09112, 32.92065], [-117.09104, 32.92073], [-117.09101, 32.92081], [-117.09121, 32.92242], [-117.09121, 32.92249], [-117.09117, 32.92259], [-117.0911, 32.92267], [-117.091, 32.92272], [-117.09059, 32.92282], [-117.09028, 32.92285], [-117.08999, 32.92282], [-117.0897, 32.92272], [-117.08943, 32.92256], [-117.08816, 32.92142], [-117.08803, 32.92133], [-117.08781, 32.92125], [-117.08748, 32.92124], [-117.08757, 32.9211], [-117.08757, 32.92108], [-117.08646, 32.92096], [-117.08584, 32.91969], [-117.08908, 32.91922], [-117.09, 32.91793], [-117.09, 32.91792], [-117.08639, 32.91741], [-117.08635, 32.91633], [-117.08863, 32.91548], [-117.09344, 32.91499], [-117.09504, 32.91442], [-117.09504, 32.91412], [-117.09581, 32.91384], [-117.0958, 32.91354], [-117.095, 32.9132], [-117.09496, 32.91147], [-117.09565, 32.91147], [-117.09794, 32.91154], [-117.09833, 32.91157], [-117.09897, 32.91169], [-117.10147, 32.91178], [-117.10322, 32.91201], [-117.10358, 32.91203], [-117.10394, 32.91203], [-117.10607, 32.91193], [-117.10628, 32.9119], [-117.10662, 32.91183], [-117.10683, 32.91181], [-117.10813, 32.91187], [-117.10846, 32.9145], [-117.10849, 32.91547]]], [[[-117.09901, 32.91148], [-117.09846, 32.91138], [-117.09813, 32.91134], [-117.09672, 32.91131], [-117.09901, 32.91131], [-117.09901, 32.91148]]], [[[-117.10128, 32.9115], [-117.0992, 32.91142], [-117.0992, 32.9113], [-117.09957, 32.91129], [-117.10128, 32.9115]]]]} | Open Access 1 | 138 | Miramar Reservoir | 10429 | 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 | http://www.sandiego.gov/water/recreation/reservoirs/miramar.shtml | San Diego 4 | 350.632 | Miramar Reservoir | 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]);