units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where AGNCY_LEV = 4, MNG_AGENCY = 322 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3932 | 3932 | 3931 | {"type": "Polygon", "coordinates": [[[-118.4757, 34.42905], [-118.47423, 34.42905], [-118.4742, 34.42839], [-118.47412, 34.42835], [-118.47409, 34.42733], [-118.47558, 34.42732], [-118.47558, 34.42796], [-118.47557, 34.42802], [-118.47558, 34.42841], [-118.47568, 34.42842], [-118.4757, 34.42905]]]} | Restricted Access 2 | 46226 | North Oaks Park | 31633 | 2389 | William S. Hart Union High School District 702 | Special District 4 | School District 14 | http://www.hartdistrict.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=413 | Los Angeles 6 | 6.399 | North Oaks Park | 0 | Local Park 2 | 4 |
10860 | 10860 | 10859 | {"type": "Polygon", "coordinates": [[[-118.55086, 34.42777], [-118.55071, 34.42814], [-118.55003, 34.42806], [-118.54982, 34.42802], [-118.54982, 34.428], [-118.54977, 34.42799], [-118.54976, 34.42802], [-118.54855, 34.42796], [-118.54655, 34.42794], [-118.54585, 34.42615], [-118.54604, 34.42614], [-118.54672, 34.42619], [-118.54707, 34.42614], [-118.54709, 34.42619], [-118.54768, 34.42609], [-118.54894, 34.42607], [-118.54869, 34.42636], [-118.55086, 34.42777]]]} | Open Access 1 | 20658 | Bridgeport Park | 16380 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 16.763 | Bridgeport Park | 0 | Local Park 2 | 4 | |
11922 | 11922 | 11921 | {"type": "Polygon", "coordinates": [[[-118.52735, 34.42936], [-118.52648, 34.4312], [-118.52377, 34.4344], [-118.52375, 34.4344], [-118.52373, 34.43438], [-118.52366, 34.4344], [-118.52366, 34.43443], [-118.52356, 34.43446], [-118.52356, 34.43443], [-118.52349, 34.43445], [-118.52292, 34.43464], [-118.52289, 34.43469], [-118.51956, 34.43606], [-118.51934, 34.43614], [-118.51921, 34.4362], [-118.51911, 34.43628], [-118.51872, 34.4365], [-118.51866, 34.43641], [-118.51824, 34.43627], [-118.51752, 34.43616], [-118.51675, 34.43564], [-118.51612, 34.43492], [-118.51601, 34.43454], [-118.51599, 34.43359], [-118.51617, 34.43263], [-118.51638, 34.43244], [-118.51689, 34.43217], [-118.51741, 34.43224], [-118.5181, 34.43224], [-118.51831, 34.43207], [-118.51831, 34.43205], [-118.51798, 34.43182], [-118.51716, 34.43158], [-118.51793, 34.43112], [-118.51839, 34.43118], [-118.51902, 34.43111], [-118.51991, 34.43113], [-118.52057, 34.43153], [-118.521, 34.43155], [-118.52124, 34.43111], [-118.52235, 34.4297], [-118.52232, 34.42936], [-118.52204, 34.42904], [-118.52188, 34.42879], [-118.52198, 34.42861], [-118.52249, 34.42859], [-118.52301, 34.42894], [-118.52339, 34.42892], [-118.52384, 34.42887], [-118.52422, 34.42833], [-118.52466, 34.42818], [-118.52512, 34.42828], [-118.5253, 34.42868], [-118.52648, 34.42868], [-118.52735, 34.42936]]]} | Open Access 1 | 24527 | Central Park | 5954 | 2340 | Castaic Lake Water Agency 1002 | Special District 4 | Water District 13 | http://clwa.org/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=409 | Los Angeles 6 | 122.849 | Central Park | 0 | Local Park 2 | 4 |
15247 | 15247 | 15246 | {"type": "MultiPolygon", "coordinates": [[[[-118.49458, 34.3588], [-118.49075, 34.36144], [-118.48897, 34.36142], [-118.4889, 34.35963], [-118.48493, 34.35958], [-118.48502, 34.35379], [-118.49356, 34.35386], [-118.49458, 34.3588]]], [[[-118.49593, 34.3615], [-118.49593, 34.3615], [-118.49243, 34.36146], [-118.49569, 34.35921], [-118.49573, 34.35941], [-118.49593, 34.3615]]], [[[-118.50276, 34.35978], [-118.50268, 34.36302], [-118.50179, 34.36301], [-118.4977, 34.36262], [-118.49766, 34.36153], [-118.49695, 34.36151], [-118.49677, 34.35971], [-118.50065, 34.35975], [-118.50113, 34.35577], [-118.50123, 34.35577], [-118.50186, 34.35977], [-118.50276, 34.35978]]], [[[-118.50605, 34.35776], [-118.5061, 34.35822], [-118.50589, 34.35954], [-118.50557, 34.36001], [-118.50551, 34.36061], [-118.50407, 34.36097], [-118.50435, 34.35233], [-118.50448, 34.35247], [-118.50466, 34.35309], [-118.50466, 34.35327], [-118.50481, 34.35353], [-118.50561, 34.35585], [-118.50562, 34.35644], [-118.50588, 34.35693], [-118.50596, 34.35778], [-118.50605, 34.35776]]]]} | Open Access 1 | 46278 | Whitney Elsmere Open Space | 29563 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 233.794 | Whitney Elsmere OS | 0 | Local Recreation Area 3 | 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]);