units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Peter F Schabarum Reg. County Park", MNG_AGENCY = 16 and MNG_AG_TYP = 3
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16803 | 16803 | 16802 | {"type": "Polygon", "coordinates": [[[-117.94459, 33.9753], [-117.94377, 33.98292], [-117.94094, 33.98271], [-117.94097, 33.98265], [-117.94088, 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.98094], [-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.92989, 33.99083], [-117.92988, 33.99086], [-117.9286, 33.99074], [-117.92872, 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.92238, 33.98862], [-117.9224, 33.98852], [-117.92247, 33.98826], [-117.92255, 33.98806], [-117.92397, 33.98819], [-117.92417, 33.98746], [-117.92569, 33.98642], [-117.92475, 33.98546], [-117.92496, 33.98532], [-117.92505, 33.98521], [-117.92516, 33.98506], [-117.92563, 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.98023], [-117.92635, 33.97979], [-117.92639, 33.97951], [-117.92645, 33.97936], [-117.92655, 33.9792], [-117.92667, 33.97908], [-117.92754, 33.97854], [-117.92763, 33.97755], [-117.92642, 33.97688], [-117.92522, 33.97687], [-117.92425, 33.97645], [-117.92427, 33.97571], [-117.92423, 33.97513], [-117.92386, 33.97512], [-117.92331, 33.97487], [-117.92331, 33.97477], [-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.96997], [-117.91808, 33.96984], [-117.91729, 33.97016], [-117.91688, 33.96946], [-117.91593, 33.96916], [-117.91547, 33.96879], [-117.92386, 33.97074], [-117.92387, 33.97073], [-117.9239, 33.97052], [-117.92825, 33.97153], [-117.92824, 33.97175], [-117.9296, 33.97207], [-117.92961, 33.97206], [-117.92963, 33.97185], [-117.92965, 33.97185], [-117.93099, 33.97216], [-117.93305, 33.97264], [-117.93304, 33.97286], [-117.94259, 33.97506], [-117.94329, 33.975], [-117.94459, 33.9753]], [[-117.9363, 33.98086], [-117.93629, 33.98087], [-117.93677, 33.9816], [-117.93743, 33.98131], [-117.93696, 33.98056], [-117.9363, 33.98086]]]} | Open Access 1 | 6562 | Peter F Schabarum Regional County Park | 6064 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov/wps/portal/dpr/parks/peter_f_schabarum_regional_park | Los Angeles 6 | 621.792 | Peter F Schabarum Reg. County 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]);