units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 3 and PARK_URL = "http://www.ocparks.com/beaches/aliso/"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9462 | 9462 | 9461 | {"type": "MultiPolygon", "coordinates": [[[[-117.74571, 33.5005], [-117.74518, 33.50106], [-117.74514, 33.50106], [-117.74485, 33.50091], [-117.74481, 33.50074], [-117.74412, 33.50007], [-117.74386, 33.49969], [-117.7435, 33.49927], [-117.74351, 33.49913], [-117.74349, 33.49904], [-117.74345, 33.49895], [-117.74339, 33.49893], [-117.7433, 33.49884], [-117.74307, 33.49878], [-117.74292, 33.49866], [-117.74284, 33.49857], [-117.7427, 33.49868], [-117.74249, 33.49863], [-117.74215, 33.49859], [-117.74161, 33.49828], [-117.7411, 33.49784], [-117.74078, 33.49745], [-117.7407, 33.49706], [-117.74067, 33.49704], [-117.74064, 33.49695], [-117.74062, 33.49684], [-117.74057, 33.49666], [-117.7405, 33.49662], [-117.7404, 33.49647], [-117.74038, 33.49641], [-117.74009, 33.49624], [-117.73991, 33.49625], [-117.73944, 33.49564], [-117.73923, 33.49529], [-117.7391, 33.4947], [-117.73927, 33.49442], [-117.73917, 33.4941], [-117.7398, 33.49355], [-117.7398, 33.4936], [-117.73988, 33.49366], [-117.73988, 33.49377], [-117.73981, 33.49388], [-117.73962, 33.49414], [-117.7396, 33.49427], [-117.73966, 33.4944], [-117.73968, 33.49451], [-117.73982, 33.49466], [-117.7399, 33.4948], [-117.73992, 33.49489], [-117.73997, 33.49495], [-117.74019, 33.4951], [-117.74024, 33.4952], [-117.74028, 33.49532], [-117.74029, 33.49544], [-117.74032, 33.49552], [-117.74047, 33.49575], [-117.7409, 33.49587], [-117.74107, 33.49585], [-117.74114, 33.49589], [-117.74121, 33.49598], [-117.74119, 33.49611], [-117.74106, 33.4963], [-117.74106, 33.49657], [-117.7411, 33.4967], [-117.74121, 33.49697], [-117.74125, 33.49703], [-117.74137, 33.4971], [-117.74167, 33.49735], [-117.742, 33.49752], [-117.74226, 33.49769], [-117.74235, 33.49778], [-117.74246, 33.4978], [-117.74252, 33.49786], [-117.7427, 33.49797], [-117.74289, 33.49803], [-117.74306, 33.49812], [-117.74318, 33.49821], [-117.74336, 33.49824], [-117.7435, 33.49806], [-117.74359, 33.49803], [-117.7437, 33.49795], [-117.74379, 33.49795], [-117.74383, 33.49803], [-117.7438, 33.49809], [-117.74365, 33.4982], [-117.74361, 33.49827], [-117.74364, 33.49831], [-117.74379, 33.49835], [-117.74393, 33.49845], [-117.7441, 33.49841], [-117.74421, 33.49843], [-117.74428, 33.49846], [-117.74424, 33.49855], [-117.74418, 33.49865], [-117.74415, 33.49879], [-117.74423, 33.49891], [-117.74425, 33.49898], [-117.74426, 33.49919], [-117.74453, 33.49948], [-117.74474, 33.49963], [-117.74503, 33.4998], [-117.74519, 33.49993], [-117.74528, 33.50003], [-117.74542, 33.5001], [-117.74547, 33.50016], [-117.74549, 33.50025], [-117.74558, 33.50032], [-117.74566, 33.50048], [-117.74571, 33.5005]]], [[[-117.74679, 33.50232], [-117.74662, 33.5025], [-117.74653, 33.50254], [-117.74643, 33.50256], [-117.74628, 33.50236], [-117.74632, 33.50231], [-117.74634, 33.50223], [-117.74628, 33.50198], [-117.74607, 33.50188], [-117.74596, 33.50173], [-117.74592, 33.50157], [-117.74593, 33.50147], [-117.74607, 33.50138], [-117.74615, 33.50145], [-117.74615, 33.50151], [-117.74641, 33.50162], [-117.74654, 33.50154], [-117.74666, 33.50154], [-117.74669, 33.50163], [-117.7467, 33.50176], [-117.74666, 33.50191], [-117.74666, 33.502], [-117.74673, 33.50211], [-117.74675, 33.50222], [-117.74679, 33.50232]]], [[[-117.75133, 33.50794], [-117.75119, 33.50797], [-117.75105, 33.50804], [-117.75095, 33.50794], [-117.75085, 33.50768], [-117.75078, 33.50756], [-117.75069, 33.50724], [-117.75045, 33.50702], [-117.75017, 33.50705], [-117.74972, 33.50692], [-117.74954, 33.50672], [-117.74923, 33.50647], [-117.74899, 33.50617], [-117.74885, 33.50594], [-117.74865, 33.50579], [-117.74834, 33.50551], [-117.748, 33.50525], [-117.74786, 33.50474], [-117.74764, 33.50458], [-117.74744, 33.50427], [-117.7473, 33.50414], [-117.74726, 33.5038], [-117.74684, 33.50356], [-117.74705, 33.50331], [-117.74744, 33.50365], [-117.74756, 33.50389], [-117.74759, 33.504], [-117.74765, 33.50406], [-117.74776, 33.50414], [-117.74796, 33.50422], [-117.74809, 33.50436], [-117.74819, 33.5045], [-117.74827, 33.50466], [-117.7483, 33.5048], [-117.74838, 33.5049], [-117.74849, 33.50493], [-117.74865, 33.5051], [-117.74887, 33.50529], [-117.74889, 33.50538], [-117.74893, 33.50548], [-117.74898, 33.50555], [-117.74906, 33.50559], [-117.74931, 33.50586], [-117.74947, 33.50598], [-117.74964, 33.50608], [-117.74984, 33.50633], [-117.74988, 33.50641], [-117.7502, 33.50658], [-117.75036, 33.50673], [-117.75045, 33.50677], [-117.75055, 33.50678], [-117.75067, 33.50673], [-117.75078, 33.50667], [-117.75093, 33.50663], [-117.75107, 33.50665], [-117.75114, 33.50673], [-117.75118, 33.50689], [-117.75117, 33.50707], [-117.75126, 33.50722], [-117.75122, 33.50729], [-117.75124, 33.5077], [-117.75133, 33.50794]]], [[[-117.75269, 33.51143], [-117.75257, 33.51156], [-117.75251, 33.51167], [-117.75246, 33.51185], [-117.75247, 33.51199], [-117.75245, 33.5121], [-117.75238, 33.51226], [-117.75219, 33.51236], [-117.75198, 33.51242], [-117.74989, 33.51241], [-117.74968, 33.51243], [-117.74962, 33.51202], [-117.74932, 33.51168], [-117.74996, 33.51147], [-117.7502, 33.51164], [-117.75062, 33.51162], [-117.75087, 33.51145], [-117.75107, 33.51119], [-117.7512, 33.51111], [-117.75127, 33.5112], [-117.75133, 33.51136], [-117.75139, 33.51142], [-117.75146, 33.51145], [-117.75159, 33.51145], [-117.75204, 33.51131], [-117.75212, 33.51127], [-117.75222, 33.51118], [-117.75225, 33.51117], [-117.75253, 33.5113], [-117.75269, 33.51143]]], [[[-117.75603, 33.51286], [-117.75547, 33.51286], [-117.75541, 33.51285], [-117.75535, 33.51276], [-117.75531, 33.51274], [-117.75524, 33.51266], [-117.75502, 33.51258], [-117.75489, 33.51238], [-117.75449, 33.51197], [-117.75426, 33.51178], [-117.754, 33.51162], [-117.75374, 33.51189], [-117.75372, 33.51187], [-117.75397, 33.5116], [-117.75351, 33.51121], [-117.7529, 33.51086], [-117.75295, 33.51076], [-117.75302, 33.5107], [-117.75302, 33.51058], [-117.75308, 33.5105], [-117.75312, 33.51038], [-117.75318, 33.51028], [-117.75327, 33.51019], [-117.75332, 33.51016], [-117.75342, 33.51017], [-117.75361, 33.51037], [-117.75379, 33.51045], [-117.75409, 33.51076], [-117.75428, 33.51091], [-117.75446, 33.51112], [-117.75493, 33.5116], [-117.75532, 33.51215], [-117.75572, 33.51257], [-117.75586, 33.51275], [-117.75603, 33.51286]]]]} | Open Access 1 | 15813 | Aliso Beach Park | 32092 | 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://www.ocparks.com/beaches/aliso/ | Orange 3 | 39.83 | Aliso Beach Park | 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]);