units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 659, MNG_AGENCY = 32 and YR_EST = 1976
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7920 | 7920 | 7919 | {"type": "Polygon", "coordinates": [[[-121.82621, 37.22902], [-121.82609, 37.22903], [-121.82596, 37.22907], [-121.82581, 37.22918], [-121.82516, 37.22872], [-121.82423, 37.22874], [-121.824, 37.22889], [-121.82393, 37.22912], [-121.82384, 37.22914], [-121.82379, 37.22909], [-121.82302, 37.22908], [-121.82296, 37.22912], [-121.82289, 37.2291], [-121.82283, 37.22911], [-121.82278, 37.22913], [-121.82275, 37.22918], [-121.82205, 37.22899], [-121.82192, 37.22928], [-121.82184, 37.2293], [-121.8218, 37.22936], [-121.82181, 37.22943], [-121.8219, 37.22951], [-121.8219, 37.22962], [-121.82152, 37.22963], [-121.82153, 37.23028], [-121.82141, 37.23029], [-121.82132, 37.23032], [-121.82132, 37.23054], [-121.82111, 37.23048], [-121.82083, 37.23033], [-121.82063, 37.23027], [-121.82065, 37.23], [-121.82039, 37.22994], [-121.82019, 37.22983], [-121.82009, 37.22971], [-121.81999, 37.22949], [-121.81985, 37.22937], [-121.81967, 37.2293], [-121.81919, 37.22926], [-121.81908, 37.22923], [-121.81898, 37.22918], [-121.8184, 37.22859], [-121.81824, 37.22849], [-121.81803, 37.22841], [-121.81799, 37.22825], [-121.81792, 37.22813], [-121.81781, 37.22804], [-121.81768, 37.22798], [-121.81765, 37.22798], [-121.81748, 37.22821], [-121.81742, 37.22823], [-121.81738, 37.22828], [-121.81738, 37.22878], [-121.81735, 37.22895], [-121.8173, 37.22906], [-121.81721, 37.2292], [-121.81703, 37.22939], [-121.81698, 37.22942], [-121.81627, 37.22915], [-121.81639, 37.22894], [-121.81612, 37.2287], [-121.81599, 37.22855], [-121.81608, 37.22841], [-121.81615, 37.22821], [-121.81616, 37.22804], [-121.81614, 37.22792], [-121.81608, 37.22777], [-121.816, 37.22766], [-121.81586, 37.22754], [-121.81576, 37.22748], [-121.81562, 37.22744], [-121.81548, 37.22744], [-121.81535, 37.22747], [-121.81523, 37.22753], [-121.81489, 37.22788], [-121.81461, 37.22822], [-121.81432, 37.22822], [-121.81409, 37.22815], [-121.81424, 37.22795], [-121.81407, 37.22783], [-121.81395, 37.2277], [-121.8139, 37.22761], [-121.81379, 37.22735], [-121.81364, 37.22711], [-121.81345, 37.22694], [-121.81327, 37.22686], [-121.81305, 37.22685], [-121.81294, 37.22688], [-121.81282, 37.22694], [-121.81269, 37.22707], [-121.81254, 37.22738], [-121.81249, 37.22743], [-121.81241, 37.22747], [-121.81229, 37.22749], [-121.81185, 37.22747], [-121.81159, 37.22753], [-121.81159, 37.22777], [-121.81095, 37.22777], [-121.81094, 37.22749], [-121.81111, 37.22727], [-121.81114, 37.22712], [-121.81111, 37.22701], [-121.81105, 37.22692], [-121.811, 37.22688], [-121.8109, 37.22684], [-121.8108, 37.22684], [-121.8104, 37.22691], [-121.80977, 37.22689], [-121.80969, 37.22692], [-121.80965, 37.22696], [-121.80956, 37.22715], [-121.80951, 37.22719], [-121.80916, 37.2272], [-121.8089, 37.22718], [-121.80882, 37.22725], [-121.80876, 37.22723], [-121.80882, 37.22715], [-121.80863, 37.22699], [-121.80856, 37.22698], [-121.80789, 37.22745], [-121.80781, 37.22744], [-121.80772, 37.22747], [-121.80771, 37.2274], [-121.80756, 37.22737], [-121.80742, 37.22737], [-121.8069, 37.22759], [-121.8069, 37.22782], [-121.80642, 37.22782], [-121.80642, 37.22759], [-121.80635, 37.22752], [-121.80634, 37.22703], [-121.80667, 37.22672], [-121.80696, 37.22647], [-121.80765, 37.22592], [-121.80832, 37.22662], [-121.80871, 37.22656], [-121.80883, 37.2269], [-121.80912, 37.22698], [-121.80945, 37.22694], [-121.80984, 37.2267], [-121.81032, 37.22681], [-121.81081, 37.22668], [-121.81143, 37.22669], [-121.81153, 37.22701], [-121.81164, 37.22719], [-121.81182, 37.22724], [-121.81199, 37.22723], [-121.81212, 37.22723], [-121.81245, 37.22711], [-121.81289, 37.22685], [-121.81337, 37.22683], [-121.8136, 37.22697], [-121.81423, 37.22782], [-121.8146, 37.22793], [-121.81528, 37.22743], [-121.81539, 37.22739], [-121.81554, 37.22736], [-121.81569, 37.22737], [-121.81582, 37.22741], [-121.81609, 37.22759], [-121.8163, 37.22808], [-121.81639, 37.2282], [-121.81648, 37.2283], [-121.81654, 37.22834], [-121.81678, 37.22838], [-121.81682, 37.22841], [-121.81732, 37.22816], [-121.81744, 37.22785], [-121.81783, 37.22786], [-121.81806, 37.2281], [-121.81851, 37.22843], [-121.81904, 37.22851], [-121.81925, 37.22902], [-121.81954, 37.22905], [-121.82014, 37.22903], [-121.82035, 37.22959], [-121.82053, 37.22974], [-121.82099, 37.2299], [-121.82124, 37.2298], [-121.82147, 37.22942], [-121.82159, 37.22835], [-121.82162, 37.22823], [-121.82184, 37.22817], [-121.82211, 37.22826], [-121.8223, 37.22837], [-121.82261, 37.22857], [-121.82297, 37.22873], [-121.82325, 37.2288], [-121.82358, 37.22879], [-121.82377, 37.22872], [-121.82412, 37.22849], [-121.82455, 37.22833], [-121.8247, 37.22818], [-121.82496, 37.22811], [-121.82507, 37.22813], [-121.82515, 37.22845], [-121.82528, 37.22858], [-121.8255, 37.22867], [-121.82587, 37.22874], [-121.82604, 37.22875], [-121.82615, 37.22867], [-121.82621, 37.22902]]]} | Open Access 1 | 10484 | Century Oaks | 17076 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 23.07 | Century Oaks | 1976 | None 659 |
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]);