units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 1090, MNG_AG_LEV = 2 and MNG_AG_TYP = 2
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12582 | 12582 | 12581 | {"type": "Polygon", "coordinates": [[[-122.39817, 38.49063], [-122.39349, 38.49061], [-122.39329, 38.49416], [-122.38896, 38.49414], [-122.38885, 38.49057], [-122.38485, 38.49054], [-122.38486, 38.49056], [-122.385, 38.4906], [-122.38593, 38.49097], [-122.38622, 38.49115], [-122.38645, 38.49145], [-122.38643, 38.49174], [-122.38642, 38.49229], [-122.38561, 38.4925], [-122.38526, 38.49284], [-122.38477, 38.49305], [-122.38447, 38.49332], [-122.38392, 38.49411], [-122.38452, 38.49412], [-122.38418, 38.49454], [-122.38387, 38.49499], [-122.38382, 38.49523], [-122.3839, 38.49534], [-122.38423, 38.49601], [-122.38426, 38.49614], [-122.38446, 38.49674], [-122.38475, 38.49729], [-122.38508, 38.49782], [-122.38587, 38.49991], [-122.38609, 38.50018], [-122.38658, 38.50049], [-122.38738, 38.50054], [-122.38769, 38.50078], [-122.38783, 38.50099], [-122.3878, 38.50113], [-122.38782, 38.50119], [-122.38788, 38.50123], [-122.38865, 38.50227], [-122.38927, 38.50242], [-122.38984, 38.50245], [-122.39022, 38.50267], [-122.39069, 38.50347], [-122.39134, 38.50398], [-122.39197, 38.50411], [-122.39222, 38.50425], [-122.3933, 38.50458], [-122.39365, 38.50473], [-122.3943, 38.5053], [-122.39402, 38.50548], [-122.39373, 38.50545], [-122.39252, 38.50515], [-122.39219, 38.50588], [-122.39001, 38.50494], [-122.38879, 38.50423], [-122.38809, 38.50398], [-122.3877, 38.50405], [-122.38735, 38.50435], [-122.38707, 38.50457], [-122.3869, 38.50496], [-122.38659, 38.50479], [-122.38605, 38.50445], [-122.38604, 38.50426], [-122.38661, 38.50404], [-122.38686, 38.50381], [-122.38668, 38.50345], [-122.38637, 38.50304], [-122.38621, 38.50292], [-122.38514, 38.50246], [-122.38439, 38.50254], [-122.38404, 38.50252], [-122.3838, 38.50246], [-122.38367, 38.50194], [-122.38341, 38.50158], [-122.38275, 38.50137], [-122.38227, 38.50144], [-122.382, 38.50165], [-122.38133, 38.50228], [-122.38108, 38.50261], [-122.38068, 38.50275], [-122.38055, 38.50273], [-122.3804, 38.50261], [-122.38058, 38.50218], [-122.38123, 38.50133], [-122.38123, 38.50131], [-122.38063, 38.50133], [-122.37517, 38.50132], [-122.36512, 38.5081], [-122.3562, 38.50837], [-122.35386, 38.50839], [-122.35386, 38.50734], [-122.35357, 38.50656], [-122.35341, 38.50604], [-122.3535, 38.50475], [-122.35355, 38.50357], [-122.3537, 38.50281], [-122.35356, 38.50215], [-122.35268, 38.50113], [-122.34707, 38.50106], [-122.34706, 38.5009], [-122.34235, 38.50107], [-122.34246, 38.49735], [-122.34705, 38.49741], [-122.34713, 38.49374], [-122.34255, 38.49362], [-122.34252, 38.49261], [-122.34281, 38.49253], [-122.34319, 38.49226], [-122.34341, 38.49206], [-122.34359, 38.49192], [-122.34374, 38.49187], [-122.34404, 38.4918], [-122.34487, 38.49169], [-122.34541, 38.49165], [-122.34587, 38.49159], [-122.34614, 38.49154], [-122.34641, 38.49142], [-122.34664, 38.49126], [-122.34688, 38.49107], [-122.34709, 38.49082], [-122.34725, 38.49067], [-122.34739, 38.49063], [-122.34778, 38.49056], [-122.34849, 38.49048], [-122.34866, 38.49052], [-122.34905, 38.49075], [-122.34943, 38.49109], [-122.34953, 38.4912], [-122.34965, 38.49138], [-122.34984, 38.49177], [-122.34985, 38.49199], [-122.34972, 38.49268], [-122.3497, 38.4929], [-122.34967, 38.49309], [-122.34971, 38.49323], [-122.34991, 38.49354], [-122.35017, 38.49369], [-122.35018, 38.49368], [-122.34987, 38.49319], [-122.34986, 38.49301], [-122.34993, 38.49271], [-122.35003, 38.49211], [-122.35003, 38.49188], [-122.34999, 38.49168], [-122.34972, 38.49111], [-122.34955, 38.4909], [-122.34889, 38.49042], [-122.34888, 38.49025], [-122.34853, 38.49016], [-122.34775, 38.49014], [-122.34737, 38.4902], [-122.34693, 38.49041], [-122.34568, 38.49121], [-122.34513, 38.49128], [-122.34478, 38.491], [-122.34571, 38.49062], [-122.34603, 38.49032], [-122.34615, 38.49002], [-122.3465, 38.48959], [-122.34722, 38.48934], [-122.34899, 38.48903], [-122.34902, 38.48883], [-122.34915, 38.48868], [-122.34926, 38.4886], [-122.34989, 38.48841], [-122.35022, 38.48828], [-122.3506, 38.48819], [-122.35122, 38.48796], [-122.3516, 38.48785], [-122.35205, 38.48774], [-122.3529, 38.48759], [-122.35312, 38.48753], [-122.35329, 38.4874], [-122.35342, 38.48726], [-122.35351, 38.48703], [-122.35356, 38.48679], [-122.35364, 38.48656], [-122.35374, 38.48634], [-122.3538, 38.4861], [-122.3538, 38.48594], [-122.3539, 38.4858], [-122.35407, 38.48568], [-122.35435, 38.48552], [-122.35452, 38.48547], [-122.35517, 38.4852], [-122.35525, 38.48512], [-122.3553, 38.48459], [-122.35539, 38.48441], [-122.35546, 38.48421], [-122.35551, 38.48396], [-122.35555, 38.48346], [-122.35559, 38.4832], [-122.35571, 38.48301], [-122.35589, 38.48293], [-122.35648, 38.48288], [-122.35656, 38.48292], [-122.35686, 38.48317], [-122.35703, 38.48328], [-122.3573, 38.48333], [-122.35754, 38.48332], [-122.35782, 38.48323], [-122.35813, 38.48302], [-122.3587, 38.48252], [-122.35906, 38.48208], [-122.35947, 38.48167], [-122.36052, 38.4817], [-122.36082, 38.48183], [-122.36101, 38.48179], [-122.36116, 38.48178], [-122.36151, 38.4819], [-122.36166, 38.4819], [-122.36294, 38.48154], [-122.36335, 38.48162], [-122.36372, 38.48186], [-122.36444, 38.48175], [-122.36465, 38.48168], [-122.36499, 38.48146], [-122.3653, 38.48122], [-122.36562, 38.48106], [-122.36563, 38.48152], [-122.3663, 38.48119], [-122.36668, 38.48119], [-122.36817, 38.4816], [-122.36936, 38.48169], [-122.37008, 38.4816], [-122.37064, 38.48124], [-122.3709, 38.48068], [-122.37093, 38.47998], [-122.37108, 38.47975], [-122.3716, 38.47922], [-122.37163, 38.48028], [-122.37201, 38.48069], [-122.37306, 38.48094], [-122.37317, 38.4819], [-122.37282, 38.48225], [-122.37286, 38.4827], [-122.37323, 38.483], [-122.37943, 38.48583], [-122.38069, 38.48618], [-122.38092, 38.48655], [-122.38174, 38.48748], [-122.3818, 38.48776], [-122.38226, 38.48817], [-122.38299, 38.48859], [-122.38302, 38.48884], [-122.38255, 38.4892], [-122.38261, 38.48945], [-122.38351, 38.49016], [-122.38423, 38.49036], [-122.38414, 38.48696], [-122.38994, 38.48702], [-122.39667, 38.48705], [-122.39811, 38.48703], [-122.39817, 38.49063]], [[-122.36784, 38.49357], [-122.36758, 38.49291], [-122.36744, 38.49263], [-122.36752, 38.49165], [-122.36744, 38.49138], [-122.36709, 38.49094], [-122.36676, 38.49036], [-122.35629, 38.49029], [-122.35637, 38.49396], [-122.37223, 38.49404], [-122.37207, 38.49394], [-122.3714, 38.49371], [-122.36997, 38.49348], [-122.36784, 38.49357]]]} | Restricted Access 2 | 29127 | Lake Hennessey | 28933 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 1973.435 | Lake Hennessey | 0 | None 1090 |
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]);