units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2, MNG_AGENCY = 117 and PARK_URL = "http://www.ovrp.org/"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16337 | 16337 | 16336 | {"type": "MultiPolygon", "coordinates": [[[[-117.07724, 32.58886], [-117.07702, 32.58887], [-117.07702, 32.58935], [-117.07542, 32.58935], [-117.07543, 32.5875], [-117.07724, 32.5875], [-117.07724, 32.58886]]], [[[-117.07114, 32.59021], [-117.07114, 32.59039], [-117.07056, 32.5903], [-117.06945, 32.5902], [-117.07114, 32.59021]]], [[[-117.05145, 32.59104], [-117.05145, 32.59113], [-117.05034, 32.59112], [-117.05034, 32.59103], [-117.05145, 32.59104]]], [[[-117.04928, 32.58936], [-117.04829, 32.58936], [-117.04829, 32.5878], [-117.04827, 32.58738], [-117.04815, 32.58739], [-117.04815, 32.58946], [-117.04715, 32.58946], [-117.04716, 32.58898], [-117.04617, 32.58897], [-117.04617, 32.5874], [-117.04603, 32.5874], [-117.04602, 32.58897], [-117.04503, 32.58897], [-117.04502, 32.58924], [-117.04397, 32.58926], [-117.04398, 32.59108], [-117.04503, 32.59108], [-117.04503, 32.59121], [-117.04077, 32.59126], [-117.04076, 32.59112], [-117.03866, 32.59115], [-117.03865, 32.58747], [-117.045, 32.58741], [-117.045, 32.58713], [-117.04548, 32.58711], [-117.04563, 32.58708], [-117.0458, 32.58697], [-117.04595, 32.58704], [-117.04613, 32.5869], [-117.04629, 32.58682], [-117.04646, 32.5867], [-117.04663, 32.5867], [-117.0468, 32.58666], [-117.04728, 32.58664], [-117.04777, 32.58674], [-117.0479, 32.5867], [-117.04804, 32.58663], [-117.04812, 32.58678], [-117.0482, 32.58684], [-117.04838, 32.58684], [-117.04863, 32.587], [-117.04879, 32.58699], [-117.04895, 32.58703], [-117.04925, 32.58706], [-117.04928, 32.58936]]], [[[-117.03561, 32.59007], [-117.03561, 32.59118], [-117.03231, 32.59122], [-117.03231, 32.59052], [-117.03561, 32.59007]]], [[[-117.06313, 32.59241], [-117.06252, 32.59241], [-117.0625, 32.59211], [-117.06035, 32.59206], [-117.06034, 32.59104], [-117.05813, 32.59103], [-117.05813, 32.58922], [-117.05812, 32.58921], [-117.05701, 32.58922], [-117.057, 32.58915], [-117.0548, 32.58916], [-117.05481, 32.58926], [-117.05701, 32.58926], [-117.05702, 32.59201], [-117.0565, 32.59186], [-117.05648, 32.59076], [-117.05594, 32.59077], [-117.05594, 32.59166], [-117.05381, 32.59167], [-117.05381, 32.59146], [-117.05393, 32.59123], [-117.05394, 32.59116], [-117.05392, 32.5911], [-117.05386, 32.59106], [-117.05372, 32.59105], [-117.05371, 32.58741], [-117.05801, 32.58744], [-117.06057, 32.58744], [-117.06076, 32.58781], [-117.06072, 32.58785], [-117.06078, 32.58853], [-117.06074, 32.58859], [-117.06079, 32.58889], [-117.06092, 32.58917], [-117.06111, 32.58954], [-117.06126, 32.58963], [-117.06137, 32.58984], [-117.06148, 32.58981], [-117.06205, 32.59085], [-117.06195, 32.59089], [-117.062, 32.59099], [-117.06212, 32.59095], [-117.06213, 32.59096], [-117.06219, 32.59106], [-117.06242, 32.59139], [-117.06276, 32.592], [-117.06295, 32.59222], [-117.06313, 32.59241]]], [[[-117.08192, 32.59211], [-117.08125, 32.59221], [-117.0809, 32.5922], [-117.08069, 32.59211], [-117.08063, 32.59204], [-117.08053, 32.59198], [-117.0804, 32.59195], [-117.07977, 32.59191], [-117.07976, 32.59168], [-117.07762, 32.59167], [-117.07761, 32.59203], [-117.07532, 32.59205], [-117.07531, 32.5928], [-117.07527, 32.5928], [-117.07525, 32.59284], [-117.07521, 32.59287], [-117.07437, 32.59287], [-117.07432, 32.59284], [-117.07388, 32.59203], [-117.07393, 32.59203], [-117.07393, 32.59201], [-117.07345, 32.59112], [-117.08191, 32.59115], [-117.08192, 32.59211]]], [[[-117.06506, 32.59281], [-117.06465, 32.5928], [-117.06464, 32.59284], [-117.06461, 32.59284], [-117.06437, 32.59277], [-117.06388, 32.59258], [-117.06355, 32.59238], [-117.06329, 32.59214], [-117.06308, 32.59191], [-117.06295, 32.59167], [-117.0627, 32.59109], [-117.06504, 32.5911], [-117.06506, 32.59281]]], [[[-117.03003, 32.59295], [-117.02946, 32.59306], [-117.02891, 32.59321], [-117.02792, 32.59359], [-117.02792, 32.59302], [-117.02789, 32.59301], [-117.02789, 32.5935], [-117.0277, 32.59349], [-117.02748, 32.59353], [-117.02729, 32.59363], [-117.02715, 32.59375], [-117.02705, 32.59377], [-117.02698, 32.59375], [-117.02694, 32.59371], [-117.02687, 32.59352], [-117.02679, 32.59343], [-117.02667, 32.59334], [-117.02655, 32.59331], [-117.02619, 32.59326], [-117.02519, 32.59335], [-117.02471, 32.59332], [-117.02416, 32.59317], [-117.0232, 32.59297], [-117.0231, 32.59288], [-117.02301, 32.59285], [-117.02188, 32.59273], [-117.02165, 32.59269], [-117.02136, 32.59261], [-117.02018, 32.5925], [-117.01982, 32.59255], [-117.01973, 32.59259], [-117.01966, 32.59265], [-117.01963, 32.5927], [-117.01964, 32.59277], [-117.01978, 32.59293], [-117.01977, 32.59295], [-117.01912, 32.59307], [-117.0188, 32.59305], [-117.01877, 32.59311], [-117.01865, 32.59343], [-117.01727, 32.59308], [-117.01699, 32.59302], [-117.01648, 32.59296], [-117.0159, 32.59295], [-117.01561, 32.59298], [-117.01525, 32.59303], [-117.01448, 32.59321], [-117.01447, 32.59344], [-117.01416, 32.59353], [-117.01374, 32.59361], [-117.01164, 32.59384], [-117.0111, 32.59384], [-117.01087, 32.59383], [-117.01005, 32.59371], [-117.01004, 32.59355], [-117.0074, 32.59311], [-117.00674, 32.59307], [-117.00674, 32.59097], [-117.00749, 32.59106], [-117.00822, 32.59118], [-117.0079, 32.59229], [-117.00852, 32.59242], [-117.00888, 32.59122], [-117.00907, 32.59125], [-117.00954, 32.59112], [-117.01003, 32.59112], [-117.01006, 32.5909], [-117.01447, 32.59108], [-117.03002, 32.59121], [-117.03003, 32.59295]]]]} | Open Access 1 | 7396 | Otay Valley Regional Park | 2353 | 1056 | Chula Vista, City of 120 | City 2 | City Agency 2 | http://www.chulavistaca.gov/City_Services/Community_Services/Public_Works_Operations/Parks/default.asp | City 2 | 1056 | Chula Vista, City of 117 | City 2 | City Agency 2 | http://www.ovrp.org/ | San Diego 4 | 324.371 | Otay Valley RP | 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]);