units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, AGNCY_LEV = 2 and DES_TP = 834
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9683 | 9683 | 9682 | {"type": "Polygon", "coordinates": [[[-122.20614, 38.31457], [-122.20607, 38.3157], [-122.1894, 38.31588], [-122.18952, 38.3136], [-122.1897, 38.30526], [-122.18507, 38.30526], [-122.18515, 38.29837], [-122.18065, 38.29829], [-122.18076, 38.28784], [-122.18075, 38.28783], [-122.18022, 38.28841], [-122.1764, 38.27648], [-122.17639, 38.27648], [-122.17466, 38.27733], [-122.17228, 38.27276], [-122.17131, 38.2713], [-122.17033, 38.2697], [-122.1693, 38.26822], [-122.16818, 38.26618], [-122.17132, 38.26615], [-122.17405, 38.2673], [-122.17621, 38.26806], [-122.17787, 38.26825], [-122.18125, 38.25243], [-122.19329, 38.25234], [-122.19314, 38.25272], [-122.19297, 38.25544], [-122.19237, 38.25612], [-122.19237, 38.25613], [-122.19566, 38.2584], [-122.2031, 38.25944], [-122.19399, 38.2709], [-122.19304, 38.27115], [-122.18835, 38.2714], [-122.19035, 38.27574], [-122.19019, 38.2872], [-122.19947, 38.28716], [-122.19952, 38.28719], [-122.19951, 38.2872], [-122.19954, 38.28728], [-122.1995, 38.28756], [-122.19954, 38.28779], [-122.19969, 38.28801], [-122.19987, 38.28812], [-122.20004, 38.28827], [-122.20021, 38.28859], [-122.20032, 38.28872], [-122.20046, 38.28883], [-122.20082, 38.28903], [-122.20122, 38.28939], [-122.20133, 38.28951], [-122.20136, 38.28966], [-122.20138, 38.28991], [-122.20139, 38.2905], [-122.19943, 38.29049], [-122.19965, 38.2982], [-122.18994, 38.29826], [-122.18979, 38.3017], [-122.1898, 38.30171], [-122.19097, 38.3017], [-122.19902, 38.30174], [-122.20022, 38.30208], [-122.20051, 38.30238], [-122.20065, 38.30285], [-122.20072, 38.30294], [-122.20245, 38.30413], [-122.20259, 38.3051], [-122.20185, 38.30668], [-122.20117, 38.30779], [-122.20115, 38.30785], [-122.20116, 38.30817], [-122.20129, 38.30858], [-122.2015, 38.30881], [-122.20164, 38.309], [-122.2019, 38.30924], [-122.2025, 38.30949], [-122.2027, 38.30951], [-122.20289, 38.3096], [-122.20312, 38.30968], [-122.20338, 38.30972], [-122.2036, 38.30986], [-122.204, 38.3102], [-122.20454, 38.31106], [-122.20499, 38.31274], [-122.20614, 38.31457]], [[-122.1976, 38.305], [-122.1975, 38.30511], [-122.19707, 38.30535], [-122.19655, 38.30547], [-122.19592, 38.30586], [-122.19554, 38.30593], [-122.19537, 38.30627], [-122.19467, 38.30713], [-122.19392, 38.30748], [-122.19331, 38.30796], [-122.19247, 38.30854], [-122.19248, 38.30887], [-122.19233, 38.3091], [-122.19304, 38.3098], [-122.19321, 38.31017], [-122.1931, 38.31035], [-122.19278, 38.31036], [-122.19236, 38.31018], [-122.19186, 38.31001], [-122.19178, 38.31008], [-122.19184, 38.31022], [-122.19197, 38.31027], [-122.19199, 38.3105], [-122.19168, 38.31061], [-122.19141, 38.31078], [-122.19127, 38.31103], [-122.1914, 38.31132], [-122.19187, 38.31187], [-122.19211, 38.3124], [-122.19215, 38.31267], [-122.19231, 38.31283], [-122.19269, 38.31296], [-122.19309, 38.31321], [-122.19336, 38.31344], [-122.19326, 38.31395], [-122.19303, 38.31447], [-122.19271, 38.31499], [-122.19271, 38.315], [-122.19359, 38.31458], [-122.19414, 38.31428], [-122.19445, 38.31407], [-122.19461, 38.31393], [-122.19513, 38.31383], [-122.1956, 38.31404], [-122.19578, 38.31424], [-122.19619, 38.31412], [-122.19652, 38.31423], [-122.19675, 38.3146], [-122.19693, 38.31471], [-122.19717, 38.3147], [-122.1972, 38.31449], [-122.19682, 38.31398], [-122.1966, 38.31375], [-122.1966, 38.31346], [-122.19687, 38.3129], [-122.19667, 38.3129], [-122.19627, 38.31316], [-122.19566, 38.31317], [-122.19525, 38.31315], [-122.19472, 38.31293], [-122.19463, 38.31263], [-122.1948, 38.3118], [-122.19566, 38.3109], [-122.19533, 38.31033], [-122.19561, 38.30937], [-122.19629, 38.30861], [-122.19709, 38.30803], [-122.19746, 38.30695], [-122.19811, 38.30572], [-122.19813, 38.30518], [-122.19785, 38.30475], [-122.19784, 38.30475], [-122.1976, 38.305]], [[-122.19187, 38.29525], [-122.19169, 38.29521], [-122.19155, 38.29515], [-122.19135, 38.29495], [-122.19128, 38.29482], [-122.19128, 38.29474], [-122.19142, 38.29462], [-122.19144, 38.29453], [-122.1914, 38.29445], [-122.19133, 38.29438], [-122.19109, 38.29435], [-122.19096, 38.29416], [-122.19093, 38.29384], [-122.19114, 38.29353], [-122.19107, 38.29329], [-122.19094, 38.29299], [-122.1909, 38.29274], [-122.19092, 38.29262], [-122.19104, 38.29246], [-122.19112, 38.29228], [-122.19126, 38.2921], [-122.19131, 38.29193], [-122.19119, 38.2918], [-122.19105, 38.29154], [-122.19089, 38.29128], [-122.19089, 38.29107], [-122.19077, 38.29099], [-122.19072, 38.29101], [-122.19058, 38.29091], [-122.19046, 38.29056], [-122.19039, 38.29045], [-122.19002, 38.29014], [-122.18993, 38.29004], [-122.18985, 38.28979], [-122.1898, 38.28974], [-122.18976, 38.28973], [-122.18966, 38.28974], [-122.18949, 38.28972], [-122.18937, 38.28963], [-122.18932, 38.28951], [-122.18925, 38.28941], [-122.18916, 38.28937], [-122.18908, 38.28918], [-122.18896, 38.2889], [-122.18891, 38.28859], [-122.18881, 38.28836], [-122.18849, 38.28815], [-122.18837, 38.28803], [-122.18833, 38.28793], [-122.18824, 38.28789], [-122.18807, 38.28803], [-122.188, 38.28816], [-122.18804, 38.2883], [-122.18812, 38.28842], [-122.18818, 38.28883], [-122.18818, 38.2892], [-122.18809, 38.28932], [-122.1878, 38.28947], [-122.18768, 38.28946], [-122.18752, 38.28944], [-122.18705, 38.28964], [-122.18655, 38.28976], [-122.18645, 38.28981], [-122.18641, 38.28989], [-122.18648, 38.28997], [-122.18658, 38.29004], [-122.1867, 38.29021], [-122.18678, 38.29053], [-122.18685, 38.29066], [-122.18714, 38.291], [-122.18748, 38.29129], [-122.18782, 38.29186], [-122.18787, 38.292], [-122.18796, 38.29208], [-122.18803, 38.29218], [-122.18811, 38.29231], [-122.18821, 38.29253], [-122.18849, 38.29274], [-122.18853, 38.29294], [-122.18853, 38.29308], [-122.18863, 38.29329], [-122.1887, 38.29338], [-122.18872, 38.29346], [-122.18872, 38.29353], [-122.18849, 38.29365], [-122.18847, 38.29387], [-122.18864, 38.29413], [-122.18888, 38.29431], [-122.18907, 38.2945], [-122.18929, 38.29469], [-122.18948, 38.29491], [-122.18934, 38.29521], [-122.1893, 38.29542], [-122.18933, 38.29555], [-122.1893, 38.2958], [-122.18912, 38.29602], [-122.18903, 38.29625], [-122.18901, 38.29648], [-122.18904, 38.29688], [-122.1893, 38.29748], [-122.18938, 38.29755], [-122.18961, 38.29751], [-122.18971, 38.29735], [-122.18977, 38.29714], [-122.18984, 38.29702], [-122.19006, 38.29702], [-122.19031, 38.29687], [-122.19055, 38.2969], [-122.19094, 38.29711], [-122.19099, 38.2971], [-122.19101, 38.29691], [-122.19096, 38.2967], [-122.19091, 38.29658], [-122.19081, 38.29641], [-122.19076, 38.29637], [-122.19073, 38.29628], [-122.19071, 38.29609], [-122.19087, 38.29605], [-122.19099, 38.29593], [-122.19096, 38.29567], [-122.19105, 38.2956], [-122.19255, 38.29563], [-122.19255, 38.29554], [-122.19248, 38.29542], [-122.19236, 38.29531], [-122.19221, 38.29528], [-122.19208, 38.29529], [-122.19187, 38.29525]]]} | No Public Access 3 | 16322 | Vallejo Lakes | 26780 | 1365 | Vallejo, City of 531 | City 2 | City Agency 2 | http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails | City 2 | 1365 | Vallejo, City of 524 | City 2 | City Agency 2 | Solano 26 | 2325.531 | Vallejo Lakes | 0 | None 834 |
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]);