units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where UNIT_NAME = "Otay Valley Regional Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY
MNG_AG_TYP 3
DES_TP 2
- Local Park 3
- None 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7841 | 7841 | 7840 | {"type": "Polygon", "coordinates": [[[-116.95835, 32.58995], [-116.95155, 32.59194], [-116.94918, 32.59009], [-116.947, 32.58786], [-116.94582, 32.58582], [-116.94542, 32.58527], [-116.94808, 32.58424], [-116.94748, 32.58333], [-116.94716, 32.58293], [-116.94705, 32.58296], [-116.94672, 32.58291], [-116.94635, 32.58283], [-116.94603, 32.58271], [-116.94582, 32.58248], [-116.9458, 32.58217], [-116.94581, 32.58211], [-116.94962, 32.58217], [-116.95013, 32.5831], [-116.95155, 32.5844], [-116.95157, 32.58584], [-116.9523, 32.58586], [-116.95595, 32.58857], [-116.95639, 32.58888], [-116.95835, 32.58995]]]} | No Public Access 3 | 47716 | Otay Valley Regional Park | 31498 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | San Diego 4 | 146.674 | Otay Valley RP | None 656 | ||
7864 | 7864 | 7863 | {"type": "MultiPolygon", "coordinates": [[[[-116.92777, 32.58949], [-116.92777, 32.59228], [-116.92719, 32.59236], [-116.92709, 32.59253], [-116.92678, 32.59284], [-116.92635, 32.59308], [-116.92611, 32.59314], [-116.92622, 32.59232], [-116.92562, 32.59183], [-116.92563, 32.5918], [-116.92293, 32.5893], [-116.92211, 32.58875], [-116.92204, 32.58879], [-116.92131, 32.58828], [-116.91987, 32.58695], [-116.91737, 32.58824], [-116.91724, 32.58868], [-116.91579, 32.58965], [-116.91571, 32.59019], [-116.91743, 32.59146], [-116.92026, 32.59141], [-116.92062, 32.59165], [-116.92179, 32.59313], [-116.92285, 32.59318], [-116.92318, 32.59348], [-116.92371, 32.5935], [-116.92369, 32.59353], [-116.92526, 32.595], [-116.92514, 32.59515], [-116.92556, 32.59554], [-116.92582, 32.59535], [-116.92587, 32.59561], [-116.92593, 32.59573], [-116.92601, 32.59583], [-116.92635, 32.59609], [-116.9266, 32.5963], [-116.92681, 32.59658], [-116.92695, 32.59689], [-116.91079, 32.59702], [-116.9107, 32.59326], [-116.9129, 32.59324], [-116.91243, 32.59374], [-116.91342, 32.59443], [-116.91457, 32.59326], [-116.91516, 32.59328], [-116.91548, 32.5923], [-116.91619, 32.5921], [-116.91584, 32.59121], [-116.91508, 32.59097], [-116.91467, 32.59137], [-116.9128, 32.59139], [-116.91275, 32.58957], [-116.91061, 32.58958], [-116.91052, 32.58587], [-116.91906, 32.5858], [-116.92128, 32.5858], [-116.92129, 32.58715], [-116.92666, 32.58812], [-116.92777, 32.58949]]], [[[-116.92994, 32.59688], [-116.92778, 32.59688], [-116.92778, 32.59585], [-116.92807, 32.5955], [-116.92806, 32.59492], [-116.92993, 32.59491], [-116.92994, 32.59688]]], [[[-116.98385, 32.58252], [-116.97937, 32.58383], [-116.97937, 32.58383], [-116.97936, 32.5825], [-116.98385, 32.58252]]]]} | No Public Access 3 | 47717 | Otay Valley Regional Park | 31497 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.ovrp.org/ | San Diego 4 | 324.329 | Otay Valley RP | 0 | Local Park 2 | 4 |
16302 | 16302 | 16301 | {"type": "MultiPolygon", "coordinates": [[[[-116.91232, 32.61566], [-116.91095, 32.61568], [-116.91078, 32.61199], [-116.91216, 32.61202], [-116.91232, 32.61566]]], [[[-116.92778, 32.59728], [-116.92778, 32.60065], [-116.92354, 32.60066], [-116.92353, 32.60446], [-116.91928, 32.60446], [-116.91927, 32.59916], [-116.91929, 32.59695], [-116.92727, 32.59688], [-116.92727, 32.59728], [-116.92778, 32.59728]]], [[[-117.01006, 32.5909], [-117.01004, 32.591], [-117.01004, 32.59112], [-117.00954, 32.59112], [-117.00907, 32.59125], [-117.00888, 32.59122], [-117.00852, 32.59242], [-117.0079, 32.59229], [-117.00821, 32.59118], [-117.00749, 32.59106], [-117.00674, 32.59097], [-117.00673, 32.5933], [-117.00575, 32.59319], [-117.00519, 32.59186], [-117.00499, 32.5913], [-117.00654, 32.59136], [-117.00653, 32.59076], [-117.01006, 32.5909]]], [[[-117.00998, 32.57781], [-117.00992, 32.57971], [-117.00881, 32.57966], [-117.0088, 32.57777], [-117.00998, 32.57781]]], [[[-117.04076, 32.58623], [-117.04076, 32.58745], [-117.03739, 32.58748], [-117.03758, 32.58632], [-117.03796, 32.58675], [-117.04076, 32.58623]]], [[[-117.04924, 32.58651], [-117.04737, 32.58651], [-117.04737, 32.58542], [-117.0474, 32.58535], [-117.04789, 32.58533], [-117.04863, 32.58602], [-117.04894, 32.58578], [-117.04924, 32.58577], [-117.04924, 32.58651]]], [[[-117.05639, 32.58743], [-117.05004, 32.58738], [-117.05005, 32.58643], [-117.05174, 32.5869], [-117.05397, 32.58692], [-117.05549, 32.58712], [-117.05639, 32.58743]]], [[[-117.0608, 32.58744], [-117.06077, 32.5878], [-117.06076, 32.58781], [-117.06057, 32.58744], [-117.0608, 32.58744]]], [[[-117.06677, 32.58746], [-117.06677, 32.58881], [-117.06244, 32.5888], [-117.06243, 32.58871], [-117.06125, 32.58863], [-117.06121, 32.58857], [-117.06114, 32.58842], [-117.0611, 32.58825], [-117.06109, 32.58778], [-117.06112, 32.58761], [-117.06118, 32.58744], [-117.06677, 32.58746]]], [[[-117.07163, 32.58838], [-117.07163, 32.5884], [-117.07115, 32.5884], [-117.07115, 32.58747], [-117.07134, 32.58747], [-117.07135, 32.58748], [-117.07146, 32.58789], [-117.07163, 32.58838]]], [[[-117.08349, 32.58715], [-117.08349, 32.58795], [-117.08132, 32.58885], [-117.07725, 32.58886], [-117.07724, 32.5875], [-117.07475, 32.5875], [-117.07475, 32.58693], [-117.07542, 32.5865], [-117.07542, 32.5863], [-117.07608, 32.58629], [-117.07607, 32.5852], [-117.07476, 32.5852], [-117.07476, 32.58448], [-117.07508, 32.58448], [-117.07508, 32.58432], [-117.07576, 32.5843], [-117.07577, 32.58432], [-117.07626, 32.58432], [-117.07627, 32.58423], [-117.07709, 32.58411], [-117.07748, 32.58407], [-117.07749, 32.58404], [-117.07804, 32.58404], [-117.07806, 32.58472], [-117.07866, 32.58472], [-117.07868, 32.58632], [-117.07973, 32.58632], [-117.07973, 32.58659], [-117.07981, 32.5866], [-117.07981, 32.58717], [-117.08035, 32.58717], [-117.08073, 32.58726], [-117.08126, 32.58729], [-117.08165, 32.58722], [-117.08268, 32.58714], [-117.08349, 32.58715]]]]} | Open Access 1 | 485 | Otay Valley Regional Park | 10739 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/OVRP.html | San Diego 4 | 246.744 | Otay Valley RP | 0 | Local Park 2 | 4 |
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]);