units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "6.423"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1640 | 1640 | 1639 | {"type": "Polygon", "coordinates": [[[-117.65166, 33.64041], [-117.6516, 33.64043], [-117.65136, 33.64074], [-117.65134, 33.64074], [-117.65137, 33.64044], [-117.65136, 33.6404], [-117.65133, 33.64039], [-117.65114, 33.64037], [-117.65106, 33.64039], [-117.65096, 33.64041], [-117.65085, 33.64049], [-117.65019, 33.64026], [-117.65016, 33.64027], [-117.6501, 33.64051], [-117.65006, 33.6405], [-117.65007, 33.64024], [-117.65001, 33.64023], [-117.64985, 33.64028], [-117.64982, 33.64013], [-117.64986, 33.63997], [-117.64989, 33.63992], [-117.65003, 33.63977], [-117.6502, 33.6395], [-117.65028, 33.63915], [-117.65029, 33.63879], [-117.65025, 33.63869], [-117.65003, 33.63841], [-117.64991, 33.63833], [-117.64961, 33.63823], [-117.64965, 33.63817], [-117.64994, 33.63824], [-117.65022, 33.63806], [-117.65071, 33.63857], [-117.65113, 33.63893], [-117.65127, 33.63908], [-117.6514, 33.63933], [-117.65151, 33.63979], [-117.65153, 33.64005], [-117.65166, 33.64041]]]} | Open Access 1 | 12490 | Minaya Park | 22258 | 1207 | Mission Viejo, City of 182 | City 2 | City Agency 2 | http://cityofmissionviejo.org/ | City 2 | 1207 | Mission Viejo, City of 178 | City 2 | City Agency 2 | Orange 3 | 6.423 | Minaya Park | 0 | Local Park 2 | 4 | |
10641 | 10641 | 10640 | {"type": "Polygon", "coordinates": [[[-121.81329, 37.2961], [-121.81329, 37.29614], [-121.81326, 37.29617], [-121.813, 37.29628], [-121.8123, 37.29672], [-121.81215, 37.29673], [-121.81209, 37.29676], [-121.81183, 37.29657], [-121.8116, 37.29678], [-121.81166, 37.29689], [-121.81147, 37.29697], [-121.8112, 37.29654], [-121.81095, 37.296], [-121.81176, 37.29608], [-121.81177, 37.29603], [-121.81215, 37.29608], [-121.81219, 37.29596], [-121.81212, 37.29593], [-121.81214, 37.2958], [-121.81162, 37.29575], [-121.81164, 37.29567], [-121.81144, 37.29564], [-121.81136, 37.29534], [-121.8115, 37.29542], [-121.81162, 37.29542], [-121.81168, 37.29539], [-121.81192, 37.2952], [-121.81204, 37.29513], [-121.81297, 37.29488], [-121.81301, 37.29489], [-121.81304, 37.29493], [-121.81321, 37.29533], [-121.81324, 37.29546], [-121.81325, 37.29588], [-121.81329, 37.2961]]]} | Open Access 1 | 18969 | Ramblewood Park | 24107 | 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 | 6.423 | Ramblewood Park | 1985 | Local Park 2 | 4 | |
14970 | 14970 | 14969 | {"type": "Polygon", "coordinates": [[[-120.15795, 39.13429], [-120.15786, 39.13569], [-120.15552, 39.13559], [-120.15642, 39.13422], [-120.15795, 39.13429]]]} | Open Access 1 | 45583 | Kilner Park | 28409 | 2260 | Tahoe City Public Utilities District 993 | Special District 4 | Water District 13 | http://www.tahoecitypud.com/parksrec.shtml | Special District 4 | 2260 | Tahoe City Public Utilities District 658 | Special District 4 | Water District 13 | https://www.tcpud.org/parks-recreation/facilities-parks-and-rentals/parks/kilner-park | Placer 35 | 6.423 | Kilner Park | 0 | Local Park 2 | 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]);