units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, MNG_AG_TYP = 2 and UNIT_NAME = "Carmel Mountain Ranch Open Space"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16953 | 16953 | 16952 | {"type": "MultiPolygon", "coordinates": [[[[-117.07957, 32.96753], [-117.07923, 32.96784], [-117.07895, 32.96765], [-117.0777, 32.96774], [-117.07742, 32.96793], [-117.07746, 32.96862], [-117.07739, 32.96892], [-117.0773, 32.96914], [-117.07716, 32.96984], [-117.07709, 32.97059], [-117.07703, 32.97077], [-117.07462, 32.97086], [-117.07419, 32.97067], [-117.07352, 32.97074], [-117.0735, 32.97099], [-117.07273, 32.97099], [-117.07277, 32.97074], [-117.07271, 32.9706], [-117.07267, 32.97027], [-117.07288, 32.96973], [-117.07327, 32.96928], [-117.07307, 32.96899], [-117.07282, 32.96888], [-117.07285, 32.96883], [-117.07311, 32.96895], [-117.07358, 32.96864], [-117.07359, 32.96829], [-117.07355, 32.96806], [-117.07349, 32.96788], [-117.07366, 32.9677], [-117.07377, 32.96754], [-117.07392, 32.96737], [-117.07408, 32.96734], [-117.07432, 32.96716], [-117.07459, 32.96677], [-117.07472, 32.96635], [-117.07439, 32.96605], [-117.07399, 32.96607], [-117.07385, 32.96611], [-117.07365, 32.96606], [-117.07361, 32.96601], [-117.07346, 32.96596], [-117.07331, 32.96598], [-117.0727, 32.96585], [-117.07234, 32.96588], [-117.07175, 32.96616], [-117.07171, 32.96613], [-117.07131, 32.96607], [-117.07105, 32.96614], [-117.07085, 32.96613], [-117.0707, 32.96603], [-117.07038, 32.96594], [-117.07008, 32.96599], [-117.06925, 32.96588], [-117.06898, 32.9661], [-117.06889, 32.96609], [-117.06887, 32.96614], [-117.06881, 32.96613], [-117.06881, 32.96609], [-117.06856, 32.96606], [-117.06822, 32.96597], [-117.0683, 32.96549], [-117.06816, 32.96538], [-117.06772, 32.96497], [-117.06751, 32.96494], [-117.06728, 32.96502], [-117.06717, 32.96536], [-117.06712, 32.9656], [-117.06717, 32.96581], [-117.06693, 32.96616], [-117.06687, 32.96616], [-117.0669, 32.96437], [-117.07558, 32.96446], [-117.07654, 32.96449], [-117.07563, 32.96502], [-117.07556, 32.96533], [-117.07542, 32.96641], [-117.07517, 32.96727], [-117.07476, 32.9678], [-117.07471, 32.96848], [-117.07523, 32.96934], [-117.07579, 32.96957], [-117.07669, 32.9695], [-117.07705, 32.9692], [-117.07705, 32.96895], [-117.07666, 32.96838], [-117.07606, 32.96853], [-117.07599, 32.96832], [-117.07621, 32.96793], [-117.07637, 32.9675], [-117.07685, 32.96744], [-117.0772, 32.96723], [-117.07774, 32.96734], [-117.0788, 32.96748], [-117.0791, 32.96729], [-117.07957, 32.96753]]], [[[-117.06922, 32.96653], [-117.06914, 32.96696], [-117.06893, 32.96717], [-117.06883, 32.9672], [-117.0685, 32.967], [-117.06828, 32.96676], [-117.0682, 32.96676], [-117.06819, 32.96661], [-117.06843, 32.96656], [-117.06866, 32.96639], [-117.06891, 32.96634], [-117.06922, 32.96653]]], [[[-117.08254, 32.96456], [-117.08251, 32.96597], [-117.08159, 32.96649], [-117.08107, 32.96649], [-117.08013, 32.96673], [-117.08011, 32.96672], [-117.08002, 32.96656], [-117.07999, 32.96645], [-117.07998, 32.96628], [-117.07999, 32.96619], [-117.08002, 32.96619], [-117.08006, 32.96634], [-117.08014, 32.96636], [-117.08037, 32.96634], [-117.08046, 32.96621], [-117.08018, 32.96606], [-117.08001, 32.96539], [-117.08001, 32.96453], [-117.08254, 32.96456]]]]} | Open Access 1 | 7327 | Carmel Mountain Ranch Open Space | 16871 | 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 | 78.713 | Carmel Mtn. Ranch 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]);