units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_LEV = 3, DES_TP = 2, MNG_AG_TYP = 3 and PARK_URL = "http://ocparks.com/parks/peters/"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16338 | 16338 | 16337 | {"type": "Polygon", "coordinates": [[[-117.7745, 33.76321], [-117.77127, 33.76645], [-117.77115, 33.76624], [-117.77112, 33.766], [-117.77099, 33.76577], [-117.77064, 33.76565], [-117.77011, 33.76579], [-117.77004, 33.76589], [-117.76987, 33.76656], [-117.76963, 33.76663], [-117.76971, 33.7668], [-117.76925, 33.76698], [-117.76926, 33.76691], [-117.76925, 33.76684], [-117.76929, 33.76671], [-117.76916, 33.76669], [-117.76903, 33.76688], [-117.76895, 33.76704], [-117.76881, 33.76727], [-117.76819, 33.76797], [-117.76749, 33.76856], [-117.76704, 33.76865], [-117.76712, 33.76899], [-117.76711, 33.7691], [-117.76706, 33.76914], [-117.76704, 33.76921], [-117.76706, 33.76946], [-117.76705, 33.76951], [-117.767, 33.76952], [-117.76667, 33.76955], [-117.76637, 33.76962], [-117.76611, 33.76977], [-117.76544, 33.77036], [-117.7653, 33.77051], [-117.76521, 33.77069], [-117.76507, 33.7712], [-117.76501, 33.77129], [-117.76492, 33.77136], [-117.76486, 33.77144], [-117.7649, 33.77154], [-117.76477, 33.77258], [-117.76493, 33.77279], [-117.76424, 33.77349], [-117.76401, 33.77399], [-117.7639, 33.77458], [-117.76349, 33.77509], [-117.76321, 33.77561], [-117.7622, 33.77623], [-117.76212, 33.77646], [-117.76215, 33.77676], [-117.77006, 33.78227], [-117.77138, 33.78321], [-117.77082, 33.78374], [-117.7706, 33.78359], [-117.77016, 33.78338], [-117.76925, 33.78311], [-117.76828, 33.78315], [-117.7674, 33.78348], [-117.7655, 33.78459], [-117.76525, 33.78474], [-117.76497, 33.78496], [-117.76481, 33.78506], [-117.76473, 33.78513], [-117.76447, 33.78542], [-117.76435, 33.78545], [-117.76383, 33.78524], [-117.76328, 33.7851], [-117.75968, 33.78498], [-117.75943, 33.78493], [-117.75877, 33.78492], [-117.7587, 33.78485], [-117.75865, 33.78456], [-117.75862, 33.78402], [-117.75858, 33.78378], [-117.75855, 33.78339], [-117.75854, 33.78301], [-117.75855, 33.78263], [-117.75863, 33.78196], [-117.75877, 33.78129], [-117.75934, 33.77918], [-117.75943, 33.77871], [-117.75949, 33.77824], [-117.75951, 33.77778], [-117.75948, 33.77732], [-117.75938, 33.77622], [-117.75938, 33.77487], [-117.75961, 33.77355], [-117.76003, 33.7721], [-117.76117, 33.77247], [-117.76158, 33.77178], [-117.76196, 33.77159], [-117.7624, 33.77091], [-117.76229, 33.7704], [-117.76287, 33.77019], [-117.76313, 33.76976], [-117.76385, 33.76804], [-117.76334, 33.76726], [-117.76359, 33.76681], [-117.76453, 33.767], [-117.76503, 33.76638], [-117.76582, 33.76631], [-117.76688, 33.76543], [-117.76652, 33.76434], [-117.7668, 33.76423], [-117.76798, 33.76467], [-117.76825, 33.76375], [-117.76799, 33.76219], [-117.76915, 33.75982], [-117.76914, 33.75934], [-117.76998, 33.75841], [-117.77008, 33.75845], [-117.77022, 33.75835], [-117.7705, 33.75813], [-117.77075, 33.75783], [-117.77078, 33.75776], [-117.77077, 33.7577], [-117.77067, 33.75757], [-117.7706, 33.75744], [-117.77057, 33.75725], [-117.77059, 33.75713], [-117.7707, 33.75704], [-117.77077, 33.75701], [-117.77086, 33.75724], [-117.77101, 33.75755], [-117.77163, 33.7586], [-117.77173, 33.75859], [-117.77181, 33.75853], [-117.77273, 33.76013], [-117.7729, 33.76038], [-117.77325, 33.76075], [-117.77376, 33.76112], [-117.77369, 33.76118], [-117.77344, 33.76101], [-117.77232, 33.76213], [-117.77264, 33.76296], [-117.77311, 33.76307], [-117.77435, 33.7631], [-117.7745, 33.76321]]]} | Open Access 1 | 8384 | Peters Canyon Regional Park | 8102 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://ocparks.com/parks/peters/ | Orange 3 | 361.587 | Peters Canyon 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]);