units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "Santiago Oaks RP"
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16334 | 16334 | 16333 | {"type": "MultiPolygon", "coordinates": [[[[-117.74717, 33.82579], [-117.74627, 33.82669], [-117.74427, 33.82907], [-117.74444, 33.83039], [-117.7441, 33.83055], [-117.74415, 33.83064], [-117.7442, 33.83064], [-117.74424, 33.83067], [-117.74452, 33.8311], [-117.74457, 33.83127], [-117.74457, 33.83139], [-117.74447, 33.83255], [-117.7445, 33.83282], [-117.74458, 33.83308], [-117.74458, 33.83312], [-117.74455, 33.83314], [-117.74351, 33.83341], [-117.74329, 33.83352], [-117.74312, 33.83368], [-117.74303, 33.8338], [-117.74298, 33.83394], [-117.74295, 33.83415], [-117.743, 33.83436], [-117.74318, 33.83465], [-117.74324, 33.83481], [-117.74243, 33.83463], [-117.74217, 33.83515], [-117.74238, 33.83523], [-117.74248, 33.83535], [-117.74264, 33.8354], [-117.74275, 33.83553], [-117.74205, 33.83595], [-117.74188, 33.83603], [-117.74161, 33.83612], [-117.74116, 33.83618], [-117.74122, 33.83653], [-117.74175, 33.83719], [-117.74236, 33.83711], [-117.74241, 33.83732], [-117.74205, 33.83779], [-117.74232, 33.83842], [-117.74227, 33.83878], [-117.74152, 33.83929], [-117.74153, 33.83955], [-117.74146, 33.83956], [-117.7414, 33.8396], [-117.74105, 33.83955], [-117.74083, 33.84002], [-117.74113, 33.84035], [-117.74114, 33.84083], [-117.73934, 33.84086], [-117.74022, 33.84198], [-117.7395, 33.84354], [-117.73795, 33.84241], [-117.735, 33.84356], [-117.73411, 33.84604], [-117.73284, 33.84396], [-117.73219, 33.84389], [-117.73216, 33.84382], [-117.73149, 33.84375], [-117.73139, 33.8438], [-117.73121, 33.84426], [-117.73091, 33.84456], [-117.73055, 33.8447], [-117.73034, 33.8449], [-117.73008, 33.84529], [-117.73021, 33.8454], [-117.73055, 33.84547], [-117.73058, 33.8455], [-117.73056, 33.84572], [-117.73046, 33.84575], [-117.7304, 33.8458], [-117.73039, 33.84591], [-117.73047, 33.84628], [-117.73053, 33.8463], [-117.73054, 33.84657], [-117.72992, 33.84666], [-117.72944, 33.8469], [-117.72919, 33.8466], [-117.72901, 33.84667], [-117.72867, 33.84657], [-117.72847, 33.84659], [-117.72831, 33.84649], [-117.72905, 33.84563], [-117.74585, 33.82563], [-117.74717, 33.82579]]], [[[-117.77598, 33.82318], [-117.77582, 33.82371], [-117.77472, 33.82421], [-117.77454, 33.82424], [-117.77398, 33.82415], [-117.77361, 33.82404], [-117.7732, 33.82413], [-117.77277, 33.82435], [-117.77237, 33.82463], [-117.7723, 33.82502], [-117.77178, 33.82471], [-117.77146, 33.82482], [-117.77115, 33.82544], [-117.77123, 33.82566], [-117.77114, 33.8258], [-117.77065, 33.82607], [-117.77041, 33.82612], [-117.77033, 33.82605], [-117.77042, 33.82576], [-117.77006, 33.8254], [-117.76982, 33.82544], [-117.76938, 33.8258], [-117.76898, 33.82586], [-117.76875, 33.8261], [-117.76836, 33.82625], [-117.76819, 33.82621], [-117.76812, 33.82632], [-117.74884, 33.82389], [-117.7473, 33.82389], [-117.76518, 33.80258], [-117.76612, 33.80258], [-117.76615, 33.81262], [-117.76251, 33.81574], [-117.76359, 33.81708], [-117.76616, 33.81708], [-117.76617, 33.8173], [-117.76846, 33.81894], [-117.77094, 33.81966], [-117.77373, 33.82188], [-117.77561, 33.8231], [-117.77598, 33.82318]]], [[[-117.77188, 33.8194], [-117.77172, 33.81956], [-117.77154, 33.81969], [-117.77097, 33.8195], [-117.77065, 33.81907], [-117.76974, 33.81876], [-117.76932, 33.81882], [-117.76809, 33.81833], [-117.76714, 33.81763], [-117.76641, 33.81724], [-117.76627, 33.81707], [-117.76786, 33.81697], [-117.76852, 33.81781], [-117.7692, 33.81719], [-117.77044, 33.81765], [-117.77113, 33.81813], [-117.77159, 33.81872], [-117.77171, 33.8193], [-117.77188, 33.8194]]], [[[-117.77065, 33.82664], [-117.77065, 33.82664], [-117.77014, 33.82658], [-117.77063, 33.82624], [-117.77065, 33.82664]]], [[[-117.77717, 33.82199], [-117.77689, 33.82228], [-117.77677, 33.82233], [-117.77617, 33.82234], [-117.77599, 33.8223], [-117.77583, 33.82222], [-117.77455, 33.82131], [-117.77205, 33.81929], [-117.77208, 33.81864], [-117.77168, 33.81819], [-117.7729, 33.81775], [-117.77282, 33.81812], [-117.77504, 33.81795], [-117.77532, 33.81824], [-117.77562, 33.81874], [-117.77591, 33.81891], [-117.77543, 33.81884], [-117.77527, 33.81948], [-117.77502, 33.81959], [-117.77501, 33.81962], [-117.77512, 33.81967], [-117.77492, 33.81993], [-117.77445, 33.82004], [-117.77443, 33.82014], [-117.77486, 33.82052], [-117.7749, 33.82059], [-117.77522, 33.82049], [-117.77541, 33.82072], [-117.77565, 33.82071], [-117.77607, 33.82065], [-117.7764, 33.82053], [-117.77717, 33.82199]]], [[[-117.77631, 33.82341], [-117.77631, 33.82341], [-117.77604, 33.82354], [-117.7761, 33.82344], [-117.77609, 33.82336], [-117.77619, 33.82331], [-117.77623, 33.82331], [-117.77631, 33.82341]]]]} | Open Access 1 | 11788 | Santiago Oaks Regional Park | 8111 | 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/santiago/ | Orange 3 | 946.984 | Santiago Oaks 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]);