units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_NAME = 488 and DES_TP = 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10110 | 10110 | 10109 | {"type": "Polygon", "coordinates": [[[-121.30036, 38.15016], [-121.30004, 38.15016], [-121.3001, 38.15032], [-121.3002, 38.15049], [-121.30033, 38.15078], [-121.30012, 38.15079], [-121.30006, 38.15083], [-121.3, 38.15083], [-121.29976, 38.1507], [-121.29949, 38.15061], [-121.2992, 38.15044], [-121.29901, 38.1503], [-121.29893, 38.14994], [-121.29891, 38.14963], [-121.29893, 38.14947], [-121.29891, 38.1493], [-121.29888, 38.14922], [-121.29881, 38.14911], [-121.29869, 38.14903], [-121.2986, 38.14893], [-121.29827, 38.14869], [-121.29794, 38.14869], [-121.29783, 38.14865], [-121.29754, 38.14879], [-121.29754, 38.1488], [-121.29763, 38.14882], [-121.29763, 38.1489], [-121.2975, 38.14908], [-121.2973, 38.14951], [-121.29736, 38.14966], [-121.29738, 38.14975], [-121.29734, 38.14984], [-121.29739, 38.15004], [-121.29736, 38.15016], [-121.29721, 38.15028], [-121.29699, 38.1505], [-121.29678, 38.15048], [-121.29654, 38.15041], [-121.29641, 38.15034], [-121.29609, 38.15009], [-121.29608, 38.14987], [-121.29598, 38.14932], [-121.29595, 38.14917], [-121.29584, 38.14887], [-121.29605, 38.14873], [-121.29596, 38.14858], [-121.29578, 38.14846], [-121.29566, 38.14841], [-121.29555, 38.1485], [-121.29548, 38.14864], [-121.29516, 38.14863], [-121.29483, 38.14874], [-121.29459, 38.14879], [-121.29439, 38.149], [-121.29423, 38.14931], [-121.29424, 38.14957], [-121.29418, 38.14966], [-121.29399, 38.14977], [-121.29388, 38.14978], [-121.29362, 38.14971], [-121.29349, 38.14963], [-121.29345, 38.14958], [-121.29323, 38.14948], [-121.29294, 38.14938], [-121.29267, 38.14939], [-121.29234, 38.14945], [-121.2923, 38.14949], [-121.2921, 38.14954], [-121.29178, 38.14976], [-121.29148, 38.15001], [-121.29124, 38.15035], [-121.2912, 38.15046], [-121.2912, 38.15066], [-121.29123, 38.15075], [-121.29129, 38.15085], [-121.29151, 38.15105], [-121.29165, 38.15122], [-121.2918, 38.15153], [-121.29216, 38.15188], [-121.29226, 38.15204], [-121.29219, 38.1521], [-121.29212, 38.15211], [-121.29186, 38.15205], [-121.29136, 38.1518], [-121.29126, 38.15171], [-121.29087, 38.15158], [-121.29041, 38.15147], [-121.29026, 38.15145], [-121.29009, 38.15148], [-121.28994, 38.15153], [-121.28977, 38.15163], [-121.28966, 38.15202], [-121.28966, 38.15217], [-121.28973, 38.15236], [-121.28984, 38.15249], [-121.28997, 38.15257], [-121.29025, 38.15266], [-121.29031, 38.15271], [-121.29036, 38.15279], [-121.29044, 38.15287], [-121.29055, 38.15306], [-121.29064, 38.15317], [-121.2906, 38.15321], [-121.29049, 38.1532], [-121.29001, 38.15296], [-121.2899, 38.15293], [-121.28961, 38.15293], [-121.28937, 38.15296], [-121.28917, 38.15301], [-121.28901, 38.15307], [-121.28874, 38.1532], [-121.28865, 38.15327], [-121.28859, 38.15335], [-121.28847, 38.1537], [-121.28847, 38.15407], [-121.28833, 38.15438], [-121.28836, 38.15447], [-121.28849, 38.15461], [-121.28849, 38.1547], [-121.28832, 38.15491], [-121.28822, 38.15498], [-121.28806, 38.15504], [-121.2879, 38.15502], [-121.28776, 38.15499], [-121.28763, 38.1549], [-121.28756, 38.1548], [-121.28738, 38.15447], [-121.2873, 38.15437], [-121.28721, 38.15417], [-121.2869, 38.15385], [-121.28669, 38.15368], [-121.28607, 38.15338], [-121.2859, 38.15333], [-121.28576, 38.15322], [-121.28544, 38.1527], [-121.2853, 38.15232], [-121.28519, 38.15212], [-121.28502, 38.15195], [-121.285, 38.15147], [-121.28555, 38.15166], [-121.28588, 38.1517], [-121.2865, 38.15169], [-121.28714, 38.15196], [-121.28762, 38.152], [-121.2877, 38.15198], [-121.28779, 38.15191], [-121.28803, 38.15099], [-121.28812, 38.15073], [-121.28821, 38.15058], [-121.28833, 38.15046], [-121.2891, 38.14979], [-121.2893, 38.14964], [-121.28936, 38.14969], [-121.28953, 38.14954], [-121.28948, 38.14948], [-121.29004, 38.149], [-121.29011, 38.14904], [-121.29049, 38.14873], [-121.29049, 38.14872], [-121.29044, 38.14867], [-121.29063, 38.14856], [-121.2907, 38.14862], [-121.29092, 38.14854], [-121.2909, 38.14847], [-121.29142, 38.14831], [-121.29146, 38.14839], [-121.2918, 38.14828], [-121.29181, 38.14827], [-121.29178, 38.1482], [-121.29187, 38.14817], [-121.29201, 38.14815], [-121.29202, 38.14827], [-121.29229, 38.14818], [-121.29227, 38.14812], [-121.29229, 38.14755], [-121.29235, 38.14731], [-121.29248, 38.14712], [-121.29271, 38.14692], [-121.29271, 38.14575], [-121.293, 38.14575], [-121.293, 38.14615], [-121.29301, 38.14616], [-121.29304, 38.14575], [-121.29365, 38.14571], [-121.29373, 38.14569], [-121.29406, 38.14566], [-121.29463, 38.14554], [-121.29525, 38.14537], [-121.29579, 38.14527], [-121.29635, 38.14523], [-121.29695, 38.14527], [-121.29714, 38.1453], [-121.29723, 38.1453], [-121.29782, 38.14543], [-121.29798, 38.14549], [-121.29808, 38.14564], [-121.29826, 38.14582], [-121.2984, 38.14602], [-121.2985, 38.14619], [-121.29857, 38.14636], [-121.2987, 38.14713], [-121.29882, 38.14795], [-121.29889, 38.14819], [-121.29916, 38.14864], [-121.29933, 38.14887], [-121.29972, 38.14928], [-121.30036, 38.15016]]]} | Open Access 1 | 17542 | Lodi Lake Park and Nature Area | 21398 | 1180 | Lodi, City of 488 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | San Joaquin 39 | 106.776 | Lodi Lake Park and Nature Area | 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]);