units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 757 and MNG_AG_LEV = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 1
ACCESS_TYP 1
- Open Access · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9152 | 9152 | 9151 | {"type": "Polygon", "coordinates": [[[-121.82685, 37.39745], [-121.82424, 37.39805], [-121.82003, 37.39552], [-121.81608, 37.39627], [-121.81562, 37.39619], [-121.81562, 37.39615], [-121.81502, 37.39608], [-121.81467, 37.39602], [-121.81166, 37.39704], [-121.81219, 37.39905], [-121.81062, 37.39973], [-121.81059, 37.39974], [-121.81011, 37.39966], [-121.81005, 37.39967], [-121.8087, 37.40019], [-121.80763, 37.39844], [-121.80757, 37.39844], [-121.80283, 37.39978], [-121.80112, 37.40036], [-121.79831, 37.4024], [-121.79418, 37.40641], [-121.78972, 37.40606], [-121.78962, 37.40571], [-121.78867, 37.40542], [-121.78834, 37.40549], [-121.78804, 37.40512], [-121.78726, 37.40494], [-121.78686, 37.40469], [-121.78657, 37.40468], [-121.78595, 37.4025], [-121.78513, 37.40055], [-121.78517, 37.39729], [-121.78521, 37.39698], [-121.78532, 37.39685], [-121.78492, 37.39673], [-121.78477, 37.39615], [-121.78472, 37.39609], [-121.78424, 37.39609], [-121.78386, 37.39578], [-121.78391, 37.39562], [-121.78425, 37.39525], [-121.78401, 37.3949], [-121.78388, 37.39414], [-121.78402, 37.39371], [-121.78388, 37.39348], [-121.78347, 37.39319], [-121.78345, 37.3928], [-121.78389, 37.39245], [-121.78388, 37.39232], [-121.78387, 37.39171], [-121.78374, 37.3915], [-121.78559, 37.39101], [-121.78626, 37.39258], [-121.78877, 37.39788], [-121.78915, 37.39916], [-121.79265, 37.40064], [-121.79365, 37.39904], [-121.79415, 37.39821], [-121.79497, 37.39394], [-121.80037, 37.3915], [-121.80159, 37.39139], [-121.80345, 37.39415], [-121.80325, 37.39439], [-121.80328, 37.39444], [-121.80321, 37.39453], [-121.80322, 37.39454], [-121.80471, 37.39468], [-121.80596, 37.39492], [-121.80597, 37.39494], [-121.80605, 37.39495], [-121.80777, 37.39469], [-121.80778, 37.39447], [-121.80787, 37.39371], [-121.8078, 37.39304], [-121.80771, 37.39282], [-121.80764, 37.39282], [-121.80761, 37.39269], [-121.80761, 37.39231], [-121.80772, 37.39227], [-121.8077, 37.39212], [-121.80831, 37.39186], [-121.80848, 37.39196], [-121.80871, 37.39201], [-121.80865, 37.39234], [-121.80951, 37.39298], [-121.80954, 37.39292], [-121.80985, 37.39268], [-121.80972, 37.39233], [-121.80956, 37.39176], [-121.80955, 37.39175], [-121.80951, 37.39178], [-121.80945, 37.39162], [-121.80957, 37.39134], [-121.81049, 37.39152], [-121.81104, 37.3915], [-121.81293, 37.39206], [-121.8144, 37.39192], [-121.81502, 37.392], [-121.81538, 37.39189], [-121.8162, 37.39211], [-121.8163, 37.3921], [-121.81669, 37.39222], [-121.81684, 37.39233], [-121.81744, 37.39247], [-121.81743, 37.3925], [-121.81891, 37.3932], [-121.81893, 37.39319], [-121.81939, 37.39342], [-121.82085, 37.39349], [-121.82129, 37.39353], [-121.82187, 37.3942], [-121.8219, 37.39421], [-121.82199, 37.39431], [-121.82331, 37.39469], [-121.82365, 37.39481], [-121.82426, 37.39467], [-121.8252, 37.39455], [-121.82544, 37.3951], [-121.82559, 37.39516], [-121.82639, 37.39655], [-121.82685, 37.39745]]]} | Open Access 1 | 15183 | Alum Rock | 11074 | 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 | http://www.sanjoseca.gov/?nid=2819 | Santa Clara 19 | 640.163 | Alum Rock | 1872 | None 757 |
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]);