units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "7.689" and MNG_AG_TYP = 13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12487 | 12487 | 12486 | {"type": "MultiPolygon", "coordinates": [[[[-122.06746, 37.06925], [-122.06729, 37.06974], [-122.06733, 37.07001], [-122.06655, 37.0699], [-122.06656, 37.06988], [-122.06672, 37.06987], [-122.06687, 37.06981], [-122.06697, 37.06971], [-122.06705, 37.06949], [-122.06727, 37.06928], [-122.06737, 37.06924], [-122.06746, 37.06925]]], [[[-122.06985, 37.08164], [-122.06977, 37.08166], [-122.06962, 37.08182], [-122.06793, 37.0818], [-122.0676, 37.08181], [-122.06763, 37.08087], [-122.06808, 37.08033], [-122.06862, 37.08042], [-122.0686, 37.08048], [-122.06862, 37.08053], [-122.06811, 37.08079], [-122.06812, 37.08081], [-122.06841, 37.08088], [-122.06821, 37.08112], [-122.06871, 37.08141], [-122.06958, 37.08162], [-122.0697, 37.08161], [-122.06985, 37.08164]]], [[[-122.10082, 37.08139], [-122.1007, 37.08166], [-122.10042, 37.08154], [-122.10029, 37.08175], [-122.10009, 37.08172], [-122.10001, 37.08168], [-122.10017, 37.08137], [-122.10045, 37.08131], [-122.10082, 37.08139]]], [[[-122.09414, 37.08858], [-122.09348, 37.08902], [-122.09292, 37.08877], [-122.09271, 37.08872], [-122.09254, 37.08896], [-122.09245, 37.08889], [-122.09234, 37.08883], [-122.09225, 37.08874], [-122.09193, 37.08861], [-122.09176, 37.08858], [-122.09139, 37.08858], [-122.09136, 37.08857], [-122.09135, 37.08849], [-122.09112, 37.08848], [-122.09112, 37.08856], [-122.0905, 37.08851], [-122.09038, 37.08849], [-122.09038, 37.08844], [-122.09042, 37.08843], [-122.09037, 37.08832], [-122.09047, 37.08832], [-122.09101, 37.0884], [-122.0913, 37.0884], [-122.09201, 37.08844], [-122.09212, 37.08827], [-122.09261, 37.08828], [-122.09374, 37.08838], [-122.09414, 37.08858]]]]} | Open Access 1 | 28261 | San Lorenzo Valley Water District | 11349 | 2277 | San Lorenzo Valley Water District 598 | Special District 4 | Water District 13 | http://www.slvwd.com/ | Special District 4 | 2277 | San Lorenzo Valley Water District 588 | Special District 4 | Water District 13 | Santa Cruz 5 | 7.689 | San Lorenzo Valley Water District | 0 | Local Other or Unknown 14 | 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]);