superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 1103, MNG_AG_TYP = 18 and PARK_URL = "http://www.vineyardatescondido.com/?doubleclick=false"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12881 | 12881 | 12880 | {"type": "Polygon", "coordinates": [[[-117.0607, 33.0691], [-117.06056, 33.06911], [-117.06032, 33.06962], [-117.06013, 33.07022], [-117.05995, 33.07071], [-117.05868, 33.07381], [-117.05857, 33.07384], [-117.05197, 33.07314], [-117.05161, 33.07306], [-117.05013, 33.07263], [-117.0498, 33.07251], [-117.05015, 33.07117], [-117.0501, 33.07055], [-117.05001, 33.07054], [-117.04992, 33.07056], [-117.04996, 33.07112], [-117.04961, 33.07247], [-117.04858, 33.07215], [-117.04909, 33.07113], [-117.0494, 33.07036], [-117.04945, 33.07026], [-117.04955, 33.07011], [-117.04976, 33.0699], [-117.05022, 33.06955], [-117.05031, 33.06955], [-117.05047, 33.06965], [-117.05065, 33.06972], [-117.05062, 33.06978], [-117.05061, 33.07004], [-117.0516, 33.07009], [-117.05241, 33.06989], [-117.05259, 33.07037], [-117.0535, 33.07116], [-117.05388, 33.0709], [-117.05426, 33.07057], [-117.05466, 33.07008], [-117.05485, 33.06937], [-117.05529, 33.06938], [-117.05577, 33.06924], [-117.05643, 33.06865], [-117.05689, 33.06906], [-117.05753, 33.06844], [-117.05702, 33.06809], [-117.05754, 33.06758], [-117.05804, 33.06727], [-117.05897, 33.06796], [-117.05896, 33.068], [-117.05978, 33.06862], [-117.0607, 33.0691]]]} | Restricted Access 2 | The Vineyard at Escondido Golf Course | http://www.vineyardatescondido.com/?doubleclick=false | 31472 | 6098 | American Golf 1103 | Private 7 | Commercial 18 | https://www.americangolf.com/about-us | Private 14 | 105.42 | The Vineyard at Escondido GC |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);