units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, AGNCY_LEV = 4, DES_TP = 2 and MNG_AGENCY = 46
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Monterey Peninsula Regional Park District · 1 ✖
DES_TP 1
- Local Park · 1 ✖
ACCESS_TYP 1
- Restricted Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16374 | 16374 | 16373 | {"type": "MultiPolygon", "coordinates": [[[[-121.9257, 36.52343], [-121.92523, 36.52381], [-121.92497, 36.52371], [-121.92407, 36.52474], [-121.92222, 36.52622], [-121.92115, 36.52685], [-121.92031, 36.52755], [-121.91759, 36.53022], [-121.9173, 36.53057], [-121.91691, 36.53111], [-121.91584, 36.53239], [-121.91492, 36.53236], [-121.91342, 36.53291], [-121.91194, 36.53282], [-121.91058, 36.5322], [-121.90862, 36.53115], [-121.90823, 36.53118], [-121.90743, 36.53162], [-121.9072, 36.53167], [-121.90692, 36.53164], [-121.90641, 36.53152], [-121.90609, 36.53134], [-121.90577, 36.5311], [-121.90542, 36.53107], [-121.90504, 36.53109], [-121.9039, 36.53149], [-121.90319, 36.53217], [-121.90197, 36.53366], [-121.90125, 36.53415], [-121.90091, 36.5342], [-121.90052, 36.53422], [-121.8997, 36.5337], [-121.90019, 36.53589], [-121.90005, 36.53622], [-121.89922, 36.53574], [-121.89525, 36.5357], [-121.89286, 36.52585], [-121.8922, 36.52318], [-121.89325, 36.52302], [-121.89326, 36.52301], [-121.89159, 36.51509], [-121.89118, 36.51436], [-121.88929, 36.51373], [-121.88887, 36.5121], [-121.88374, 36.50894], [-121.88095, 36.50942], [-121.88013, 36.50781], [-121.87855, 36.50755], [-121.87637, 36.50689], [-121.87648, 36.50599], [-121.87545, 36.50392], [-121.87373, 36.50294], [-121.86917, 36.50113], [-121.86636, 36.49919], [-121.86436, 36.49857], [-121.86206, 36.49793], [-121.86403, 36.49741], [-121.86731, 36.49567], [-121.86835, 36.49521], [-121.86864, 36.49496], [-121.86925, 36.49457], [-121.86951, 36.49402], [-121.87014, 36.49399], [-121.87507, 36.49809], [-121.87509, 36.49811], [-121.87511, 36.4981], [-121.87511, 36.49716], [-121.86617, 36.49004], [-121.87076, 36.49], [-121.87061, 36.4795], [-121.86924, 36.47596], [-121.86171, 36.47568], [-121.86225, 36.46142], [-121.86322, 36.46103], [-121.86421, 36.4607], [-121.86435, 36.46061], [-121.86444, 36.46049], [-121.86448, 36.46032], [-121.86455, 36.4602], [-121.86467, 36.46009], [-121.86628, 36.45809], [-121.86652, 36.45761], [-121.86664, 36.45732], [-121.86675, 36.45698], [-121.86698, 36.45668], [-121.86724, 36.4564], [-121.8675, 36.45612], [-121.86779, 36.45586], [-121.86832, 36.45544], [-121.8687, 36.45528], [-121.86898, 36.45519], [-121.86932, 36.45511], [-121.86986, 36.455], [-121.87009, 36.45491], [-121.87024, 36.45482], [-121.8704, 36.45468], [-121.87053, 36.45449], [-121.87086, 36.45366], [-121.87085, 36.45359], [-121.87082, 36.45354], [-121.87065, 36.45338], [-121.87054, 36.45321], [-121.87049, 36.45265], [-121.8705, 36.45203], [-121.87041, 36.45157], [-121.87024, 36.45099], [-121.87014, 36.45083], [-121.87006, 36.4506], [-121.87001, 36.45051], [-121.86988, 36.45041], [-121.86967, 36.45035], [-121.86959, 36.45029], [-121.86942, 36.45002], [-121.86921, 36.44983], [-121.86918, 36.44977], [-121.86906, 36.44939], [-121.86899, 36.44928], [-121.86891, 36.4492], [-121.8688, 36.44912], [-121.86853, 36.44896], [-121.86844, 36.44893], [-121.86832, 36.44891], [-121.86818, 36.44892], [-121.86748, 36.44912], [-121.86735, 36.44913], [-121.86722, 36.44909], [-121.86708, 36.44898], [-121.86692, 36.44879], [-121.86657, 36.44844], [-121.86638, 36.44817], [-121.86612, 36.44787], [-121.86603, 36.44771], [-121.86595, 36.44752], [-121.86587, 36.44745], [-121.86577, 36.44742], [-121.86496, 36.44732], [-121.86475, 36.44726], [-121.86453, 36.44718], [-121.8643, 36.44716], [-121.86404, 36.44712], [-121.86371, 36.447], [-121.87126, 36.44704], [-121.87577, 36.44691], [-121.87568, 36.45055], [-121.88428, 36.45027], [-121.88429, 36.45385], [-121.87993, 36.45402], [-121.87991, 36.45763], [-121.89061, 36.45717], [-121.88968, 36.47155], [-121.8887, 36.47167], [-121.88862, 36.47525], [-121.88944, 36.47516], [-121.89811, 36.48265], [-121.89785, 36.48903], [-121.89818, 36.48899], [-121.8984, 36.48898], [-121.89861, 36.48899], [-121.89887, 36.48904], [-121.89894, 36.48907], [-121.89923, 36.48928], [-121.89945, 36.4894], [-121.89961, 36.48946], [-121.89981, 36.4896], [-121.90017, 36.48992], [-121.90021, 36.48999], [-121.90024, 36.49005], [-121.9004, 36.49024], [-121.90047, 36.49041], [-121.90055, 36.49057], [-121.9008, 36.49091], [-121.90145, 36.49158], [-121.90167, 36.49185], [-121.90191, 36.492], [-121.90208, 36.49216], [-121.90231, 36.49223], [-121.90248, 36.49234], [-121.90255, 36.49244], [-121.90268, 36.49272], [-121.90294, 36.49304], [-121.90312, 36.49346], [-121.90322, 36.49353], [-121.90336, 36.49356], [-121.90343, 36.49361], [-121.90362, 36.49432], [-121.90362, 36.49448], [-121.90359, 36.49461], [-121.90355, 36.4947], [-121.90329, 36.49511], [-121.90326, 36.49523], [-121.90318, 36.49572], [-121.90322, 36.49585], [-121.90347, 36.49622], [-121.9035, 36.4963], [-121.90351, 36.49644], [-121.90342, 36.49669], [-121.90344, 36.49674], [-121.90355, 36.49688], [-121.90358, 36.49695], [-121.90358, 36.49702], [-121.90353, 36.49709], [-121.90342, 36.49714], [-121.90336, 36.49719], [-121.90334, 36.49728], [-121.90336, 36.49736], [-121.88877, 36.49724], [-121.88872, 36.50083], [-121.88421, 36.50081], [-121.88418, 36.50438], [-121.88411, 36.50435], [-121.88411, 36.50437], [-121.88262, 36.50435], [-121.88261, 36.50436], [-121.88356, 36.50521], [-121.89572, 36.51561], [-121.89571, 36.51565], [-121.89696, 36.52231], [-121.89827, 36.52246], [-121.90048, 36.52259], [-121.9007, 36.52255], [-121.90086, 36.52241], [-121.90107, 36.52238], [-121.90144, 36.52252], [-121.90225, 36.5224], [-121.90254, 36.52231], [-121.90369, 36.52138], [-121.90463, 36.52106], [-121.90505, 36.52077], [-121.90557, 36.52055], [-121.90615, 36.52045], [-121.90659, 36.5204], [-121.9072, 36.5201], [-121.9081, 36.51972], [-121.90815, 36.51966], [-121.90829, 36.51959], [-121.90869, 36.51935], [-121.90888, 36.5191], [-121.90879, 36.51884], [-121.90904, 36.51864], [-121.91077, 36.52017], [-121.9189, 36.52179], [-121.9219, 36.51998], [-121.92296, 36.52058], [-121.9233, 36.52182], [-121.92392, 36.52161], [-121.92361, 36.52224], [-121.92218, 36.52222], [-121.9211, 36.52143], [-121.92032, 36.52301], [-121.92344, 36.52402], [-121.92413, 36.52272], [-121.9257, 36.52343]], [[-121.91582, 36.52607], [-121.91754, 36.52557], [-121.91556, 36.52406], [-121.91544, 36.52242], [-121.9108, 36.52132], [-121.90774, 36.5228], [-121.90774, 36.52281], [-121.90845, 36.52324], [-121.90613, 36.52512], [-121.91472, 36.52777], [-121.91582, 36.52607]]], [[[-121.8937, 36.54136], [-121.89234, 36.54135], [-121.89234, 36.54275], [-121.8893, 36.54218], [-121.88843, 36.5421], [-121.88782, 36.54208], [-121.88722, 36.54209], [-121.88534, 36.54226], [-121.8846, 36.54225], [-121.8836, 36.54234], [-121.88309, 36.5423], [-121.88251, 36.54221], [-121.88165, 36.542], [-121.88167, 36.53889], [-121.88193, 36.53879], [-121.88204, 36.53842], [-121.88214, 36.53836], [-121.88258, 36.53788], [-121.88294, 36.53648], [-121.88491, 36.53655], [-121.88503, 36.53507], [-121.88612, 36.53456], [-121.88697, 36.53472], [-121.88766, 36.53506], [-121.88896, 36.53486], [-121.89234, 36.53519], [-121.89205, 36.53587], [-121.89368, 36.53589], [-121.8937, 36.54136]]]]} | Restricted Access 2 | 18367 | Palo Corona Regional Park | 31678 | 2085 | Monterey Peninsula Regional Park District 47 | Special District 4 | Recreation/Parks District 4 | http://www.mprpd.org/ | Special District 4 | 2085 | Monterey Peninsula Regional Park District 46 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 4416.868 | Palo Corona 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]);