units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 41 and DES_TP = 1175
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13665 | 13665 | 13664 | {"type": "Polygon", "coordinates": [[[-121.51621, 38.53667], [-121.51548, 38.53708], [-121.51409, 38.53819], [-121.51411, 38.53822], [-121.51315, 38.53912], [-121.51236, 38.54029], [-121.51175, 38.54103], [-121.51167, 38.54115], [-121.51161, 38.54114], [-121.51156, 38.54127], [-121.5113, 38.54174], [-121.51126, 38.54192], [-121.51118, 38.5421], [-121.51111, 38.54232], [-121.51083, 38.54287], [-121.51059, 38.54344], [-121.51055, 38.54362], [-121.51054, 38.54384], [-121.51047, 38.54423], [-121.51048, 38.54436], [-121.51045, 38.54454], [-121.51046, 38.54484], [-121.51054, 38.54526], [-121.51054, 38.54538], [-121.5105, 38.54548], [-121.51051, 38.54555], [-121.51053, 38.54563], [-121.51059, 38.54571], [-121.51067, 38.54603], [-121.51066, 38.54613], [-121.5106, 38.54622], [-121.51073, 38.54632], [-121.51076, 38.54636], [-121.51078, 38.54648], [-121.51086, 38.54676], [-121.51088, 38.54703], [-121.51098, 38.54723], [-121.51104, 38.54753], [-121.51103, 38.54759], [-121.51095, 38.54764], [-121.51085, 38.54763], [-121.51078, 38.54757], [-121.5107, 38.54754], [-121.51048, 38.54752], [-121.51041, 38.54755], [-121.5103, 38.54764], [-121.51034, 38.54794], [-121.51041, 38.54828], [-121.5105, 38.54851], [-121.51074, 38.54849], [-121.51072, 38.54793], [-121.51114, 38.54779], [-121.51175, 38.54909], [-121.51176, 38.54917], [-121.51176, 38.54926], [-121.51177, 38.5493], [-121.51179, 38.54932], [-121.51186, 38.54931], [-121.51193, 38.54954], [-121.51201, 38.54996], [-121.51191, 38.55041], [-121.51191, 38.55056], [-121.51194, 38.55064], [-121.51201, 38.55071], [-121.51221, 38.55081], [-121.51231, 38.55089], [-121.51237, 38.55097], [-121.5124, 38.55105], [-121.51254, 38.55165], [-121.51257, 38.55203], [-121.5126, 38.55213], [-121.5127, 38.5523], [-121.51274, 38.55241], [-121.51278, 38.55279], [-121.51307, 38.55344], [-121.51323, 38.55394], [-121.51339, 38.55419], [-121.5134, 38.55431], [-121.51362, 38.55502], [-121.51369, 38.55533], [-121.5139, 38.55594], [-121.51392, 38.55606], [-121.51398, 38.55618], [-121.51408, 38.55658], [-121.51421, 38.55687], [-121.51426, 38.55714], [-121.51431, 38.55723], [-121.51438, 38.55743], [-121.51444, 38.55749], [-121.51446, 38.55756], [-121.51429, 38.55754], [-121.51428, 38.55756], [-121.51446, 38.55808], [-121.51476, 38.55866], [-121.51468, 38.55865], [-121.51467, 38.55866], [-121.51491, 38.55911], [-121.51466, 38.55917], [-121.51418, 38.55818], [-121.51385, 38.55738], [-121.51371, 38.55697], [-121.51354, 38.55635], [-121.51323, 38.55533], [-121.513, 38.55454], [-121.51268, 38.55367], [-121.51232, 38.55289], [-121.51149, 38.55139], [-121.51101, 38.55044], [-121.51065, 38.54957], [-121.51024, 38.54848], [-121.5101, 38.54796], [-121.51003, 38.54762], [-121.51001, 38.54721], [-121.51003, 38.54681], [-121.50998, 38.54643], [-121.50994, 38.54622], [-121.50987, 38.54601], [-121.50978, 38.5458], [-121.50966, 38.54558], [-121.50969, 38.54514], [-121.50971, 38.54516], [-121.50972, 38.54515], [-121.50968, 38.54493], [-121.50967, 38.5446], [-121.50972, 38.54423], [-121.50983, 38.54392], [-121.51135, 38.54107], [-121.5113, 38.54104], [-121.51147, 38.54082], [-121.5115, 38.54082], [-121.5121, 38.54011], [-121.51245, 38.53953], [-121.5128, 38.53904], [-121.51443, 38.53752], [-121.51488, 38.53719], [-121.51533, 38.53693], [-121.51587, 38.53642], [-121.51621, 38.53667]]]} | Open Access 1 | 36030 | Sacramento River Parkway Land Park Area | 24772 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 33.337 | Sacramento River Parkway Land Park Area | None 1175 |
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]);