superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_LEV = 3 and PARK_URL = "http://parks.lacounty.gov/wps/portal/dpr/parks/peter_f_schabarum_regional_park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 1
ACCESS_TYP 1
- Open Access · 1 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15454 | 15454 | 15453 | {"type": "Polygon", "coordinates": [[[-117.94459, 33.9753], [-117.94377, 33.98292], [-117.94094, 33.98271], [-117.94096, 33.98265], [-117.94089, 33.98262], [-117.94082, 33.9827], [-117.93444, 33.98223], [-117.9342, 33.98201], [-117.93398, 33.98185], [-117.93364, 33.98164], [-117.9322, 33.98095], [-117.93195, 33.98325], [-117.93128, 33.98988], [-117.93129, 33.98989], [-117.93184, 33.98993], [-117.93174, 33.99036], [-117.93169, 33.99074], [-117.93164, 33.99077], [-117.93132, 33.99082], [-117.93063, 33.99087], [-117.93029, 33.99086], [-117.9299, 33.99083], [-117.92988, 33.99086], [-117.9286, 33.99074], [-117.92871, 33.9897], [-117.92448, 33.98938], [-117.92439, 33.98921], [-117.92424, 33.98903], [-117.92407, 33.9889], [-117.92384, 33.98878], [-117.92351, 33.9887], [-117.92239, 33.98862], [-117.9224, 33.98851], [-117.92247, 33.98826], [-117.92255, 33.98806], [-117.92397, 33.98818], [-117.92417, 33.98746], [-117.92568, 33.98642], [-117.92475, 33.98546], [-117.92496, 33.98532], [-117.92506, 33.98521], [-117.92516, 33.98506], [-117.92562, 33.98532], [-117.92577, 33.98513], [-117.92585, 33.9849], [-117.92589, 33.98467], [-117.92584, 33.98385], [-117.92586, 33.98348], [-117.9259, 33.98319], [-117.926, 33.98276], [-117.92613, 33.98239], [-117.92618, 33.98218], [-117.92624, 33.98178], [-117.92636, 33.98063], [-117.92638, 33.98022], [-117.92635, 33.97979], [-117.92639, 33.97951], [-117.92645, 33.97936], [-117.92655, 33.9792], [-117.92667, 33.97908], [-117.92753, 33.97854], [-117.92763, 33.97755], [-117.92642, 33.97688], [-117.92522, 33.97687], [-117.92425, 33.97645], [-117.92427, 33.97571], [-117.92422, 33.97513], [-117.92386, 33.97512], [-117.92331, 33.97487], [-117.9233, 33.97476], [-117.92245, 33.97468], [-117.92207, 33.9748], [-117.9219, 33.97478], [-117.92208, 33.97404], [-117.92199, 33.97395], [-117.92204, 33.97332], [-117.92189, 33.97332], [-117.92181, 33.97364], [-117.92158, 33.974], [-117.92144, 33.97416], [-117.92109, 33.9745], [-117.91925, 33.97332], [-117.91911, 33.97215], [-117.91986, 33.97141], [-117.91893, 33.96998], [-117.91809, 33.96984], [-117.91729, 33.97016], [-117.91688, 33.96946], [-117.91593, 33.96916], [-117.91547, 33.96879], [-117.92385, 33.97074], [-117.92387, 33.97072], [-117.9239, 33.97052], [-117.92825, 33.97153], [-117.92824, 33.97175], [-117.92959, 33.97207], [-117.92961, 33.97206], [-117.92963, 33.97185], [-117.92965, 33.97185], [-117.93099, 33.97216], [-117.93305, 33.97264], [-117.93305, 33.97286], [-117.94259, 33.97506], [-117.94329, 33.975], [-117.94459, 33.9753]], [[-117.9363, 33.98086], [-117.9363, 33.98088], [-117.93677, 33.9816], [-117.93743, 33.98131], [-117.93696, 33.98057], [-117.9363, 33.98086]]]} | Open Access 1 | Peter F Schabarum Regional County Park | http://parks.lacounty.gov/wps/portal/dpr/parks/peter_f_schabarum_regional_park | 6064 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 621.902 | Peter F Schabarum Reg. County Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);