units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, MNG_AG_TYP = 2 and YR_EST = 2001
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15679 | 15679 | 15678 | {"type": "Polygon", "coordinates": [[[-121.85663, 37.3456], [-121.85604, 37.34604], [-121.85601, 37.3461], [-121.85601, 37.34615], [-121.85607, 37.34627], [-121.85226, 37.34926], [-121.85206, 37.34901], [-121.85125, 37.34807], [-121.85017, 37.34696], [-121.85017, 37.34693], [-121.85019, 37.3469], [-121.85087, 37.34649], [-121.85104, 37.34645], [-121.85138, 37.34648], [-121.85155, 37.34647], [-121.85172, 37.34642], [-121.8519, 37.34631], [-121.85203, 37.34645], [-121.85208, 37.34643], [-121.85223, 37.34658], [-121.85228, 37.34656], [-121.8524, 37.34668], [-121.85248, 37.34669], [-121.85249, 37.34675], [-121.85254, 37.34679], [-121.8526, 37.34681], [-121.85264, 37.3468], [-121.85274, 37.34691], [-121.85282, 37.34687], [-121.85296, 37.34701], [-121.85302, 37.34702], [-121.85302, 37.34707], [-121.85305, 37.34711], [-121.85313, 37.34714], [-121.85312, 37.34721], [-121.85326, 37.34734], [-121.85346, 37.34721], [-121.85348, 37.34722], [-121.8538, 37.34703], [-121.85374, 37.34695], [-121.85377, 37.34692], [-121.85364, 37.34678], [-121.85372, 37.34673], [-121.85387, 37.34688], [-121.85508, 37.34613], [-121.8551, 37.34614], [-121.85528, 37.34603], [-121.85528, 37.34602], [-121.85468, 37.3454], [-121.85448, 37.34551], [-121.85444, 37.34546], [-121.85461, 37.34534], [-121.85417, 37.34488], [-121.85398, 37.34499], [-121.85399, 37.34488], [-121.85421, 37.34474], [-121.85383, 37.34435], [-121.85364, 37.34446], [-121.85358, 37.3444], [-121.85376, 37.34429], [-121.85373, 37.34425], [-121.85381, 37.34419], [-121.85356, 37.34394], [-121.85362, 37.3439], [-121.85362, 37.34389], [-121.85337, 37.34364], [-121.85335, 37.34364], [-121.85321, 37.3435], [-121.85323, 37.34348], [-121.85313, 37.34338], [-121.85427, 37.34267], [-121.85501, 37.3434], [-121.85521, 37.34357], [-121.85486, 37.34379], [-121.85486, 37.34381], [-121.85663, 37.3456]]]} | Restricted Access 2 | 13737 | Rancho del Pueblo Golf Course | 33035 | 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 | 30.551 | Rancho del Pueblo GC | 2001 | Local Recreation Area 3 | 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]);