units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 4, MNG_AGENCY = 27 and UNIT_NAME = "Michael D Antonovich Open Space Preserve"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 2 ✖
DES_TP 1
- Local Conservation Area · 2 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6806 | 6806 | 6805 | {"type": "Polygon", "coordinates": [[[-118.55054, 34.32745], [-118.55055, 34.3311], [-118.55052, 34.33477], [-118.54506, 34.33473], [-118.54505, 34.33835], [-118.5198, 34.33815], [-118.51986, 34.33634], [-118.52863, 34.33635], [-118.53313, 34.33655], [-118.53326, 34.33624], [-118.53308, 34.33582], [-118.53343, 34.3358], [-118.53342, 34.3352], [-118.53313, 34.33487], [-118.53318, 34.33459], [-118.53314, 34.33418], [-118.53277, 34.33349], [-118.53277, 34.33329], [-118.53241, 34.33335], [-118.53229, 34.33293], [-118.53232, 34.33239], [-118.53215, 34.3317], [-118.53144, 34.33119], [-118.53107, 34.33063], [-118.53062, 34.33044], [-118.53025, 34.33008], [-118.53016, 34.32992], [-118.53014, 34.32974], [-118.53018, 34.32962], [-118.53029, 34.32946], [-118.5304, 34.32938], [-118.5306, 34.3293], [-118.53138, 34.32918], [-118.53178, 34.32877], [-118.53193, 34.32831], [-118.53176, 34.32804], [-118.53073, 34.3273], [-118.53428, 34.3273], [-118.5343, 34.33092], [-118.5366, 34.33092], [-118.53657, 34.32729], [-118.55054, 34.32745]]]} | Open Access 1 | 5330 | Michael D Antonovich Open Space Preserve | 7183 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=8 | Los Angeles 6 | 496.735 | Michael D Antonovich OSP | 0 | Local Conservation Area 4 | 2 |
15886 | 15886 | 15885 | {"type": "Polygon", "coordinates": [[[-118.54781, 34.32672], [-118.54769, 34.32707], [-118.54764, 34.3273], [-118.54762, 34.32734], [-118.54752, 34.3274], [-118.54662, 34.32741], [-118.53658, 34.32729], [-118.5366, 34.33092], [-118.53429, 34.33092], [-118.53428, 34.3273], [-118.52868, 34.3273], [-118.5287, 34.32367], [-118.52187, 34.32368], [-118.5338, 34.31469], [-118.53523, 34.31592], [-118.53552, 34.31596], [-118.5357, 34.31621], [-118.53637, 34.31667], [-118.53692, 34.31712], [-118.5374, 34.31726], [-118.5377, 34.31745], [-118.53783, 34.31759], [-118.53852, 34.31805], [-118.53881, 34.31828], [-118.53911, 34.31837], [-118.53897, 34.31933], [-118.53928, 34.31997], [-118.53977, 34.32011], [-118.53998, 34.32047], [-118.54039, 34.32068], [-118.54083, 34.32078], [-118.54115, 34.32109], [-118.54136, 34.32163], [-118.54154, 34.32182], [-118.54187, 34.3219], [-118.54245, 34.32194], [-118.54218, 34.32261], [-118.54299, 34.32292], [-118.54323, 34.32325], [-118.5438, 34.32323], [-118.54434, 34.32329], [-118.54474, 34.32341], [-118.54509, 34.32341], [-118.54537, 34.3241], [-118.5464, 34.32399], [-118.54683, 34.32417], [-118.54734, 34.32472], [-118.5473, 34.32507], [-118.54732, 34.32524], [-118.54738, 34.32536], [-118.54749, 34.32549], [-118.54753, 34.32558], [-118.54752, 34.32577], [-118.54754, 34.32582], [-118.54772, 34.32625], [-118.54781, 34.32655], [-118.54781, 34.32672]]]} | Open Access 1 | 45371 | Michael D Antonovich Open Space Preserve | 7183 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.lamountains.com/parks.asp?parkid=8 | Los Angeles 6 | 446.821 | Michael D Antonovich OSP | 0 | Local Conservation Area 4 | 2 |
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]);