units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 322 and UNIT_NAME = "Rivendale Ranch Open Space"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16247 | 16247 | 16246 | {"type": "MultiPolygon", "coordinates": [[[[-118.55804, 34.35646], [-118.55785, 34.3569], [-118.55733, 34.35724], [-118.55594, 34.35793], [-118.55551, 34.35847], [-118.55555, 34.35838], [-118.55554, 34.35832], [-118.55528, 34.35791], [-118.55509, 34.35733], [-118.55491, 34.35693], [-118.55577, 34.35669], [-118.55585, 34.35672], [-118.55591, 34.35679], [-118.55638, 34.35668], [-118.55665, 34.35687], [-118.55689, 34.35688], [-118.55715, 34.35686], [-118.5574, 34.3568], [-118.55764, 34.35672], [-118.55785, 34.3566], [-118.55804, 34.35646]]], [[[-118.56596, 34.35766], [-118.56596, 34.35817], [-118.56569, 34.35836], [-118.56569, 34.35838], [-118.56573, 34.35838], [-118.56554, 34.35926], [-118.56481, 34.35969], [-118.56431, 34.35969], [-118.56344, 34.35922], [-118.56284, 34.35922], [-118.56244, 34.35931], [-118.56175, 34.35931], [-118.56135, 34.35953], [-118.56135, 34.35975], [-118.56113, 34.35975], [-118.56094, 34.35939], [-118.56061, 34.35921], [-118.56018, 34.35923], [-118.56001, 34.35932], [-118.55981, 34.3595], [-118.55953, 34.3595], [-118.55921, 34.35844], [-118.55926, 34.35811], [-118.55914, 34.35804], [-118.55913, 34.35805], [-118.55912, 34.35897], [-118.55837, 34.35936], [-118.55835, 34.35987], [-118.55597, 34.35986], [-118.55561, 34.35927], [-118.55545, 34.35875], [-118.55603, 34.35801], [-118.55741, 34.35733], [-118.55796, 34.35697], [-118.55819, 34.35644], [-118.55843, 34.35616], [-118.55889, 34.35649], [-118.55894, 34.35661], [-118.55941, 34.35648], [-118.5596, 34.35645], [-118.5598, 34.35645], [-118.56002, 34.35648], [-118.5602, 34.35652], [-118.5604, 34.3566], [-118.56055, 34.35668], [-118.56066, 34.35678], [-118.56076, 34.35691], [-118.56086, 34.3571], [-118.56094, 34.35729], [-118.56098, 34.35746], [-118.561, 34.35763], [-118.56099, 34.3578], [-118.56097, 34.35803], [-118.56132, 34.35804], [-118.56169, 34.358], [-118.56196, 34.35794], [-118.56248, 34.35778], [-118.56288, 34.35771], [-118.56333, 34.35768], [-118.56388, 34.35771], [-118.56409, 34.35771], [-118.56481, 34.35757], [-118.5651, 34.35753], [-118.56525, 34.35753], [-118.56554, 34.35755], [-118.56583, 34.35761], [-118.56596, 34.35766]]]]} | Open Access 1 | 46256 | Rivendale Ranch Open Space | 29538 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 1319 | Santa Clarita, City of 322 | City 2 | City Agency 2 | Los Angeles 6 | 60.065 | Rivendale Ranch 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]);