units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, MNG_AGENCY = 68, MNG_AG_TYP = 2 and UNIT_NAME = "Dougherty Valley Ridge Trail"
This data as json, copyable, CSV (advanced)
These facets timed out: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7251 | 7251 | 7250 | {"type": "Polygon", "coordinates": [[[-121.92994, 37.74522], [-121.92625, 37.74667], [-121.92569, 37.74579], [-121.92458, 37.74623], [-121.92512, 37.74711], [-121.92071, 37.74637], [-121.92092, 37.7457], [-121.92094, 37.7455], [-121.92092, 37.74535], [-121.921, 37.74482], [-121.9211, 37.7447], [-121.9213, 37.74459], [-121.92141, 37.74449], [-121.92146, 37.7444], [-121.92148, 37.74426], [-121.92136, 37.74378], [-121.92055, 37.74282], [-121.9205, 37.74268], [-121.92049, 37.74258], [-121.92053, 37.7422], [-121.92061, 37.74194], [-121.92088, 37.74171], [-121.9209, 37.74166], [-121.92086, 37.74144], [-121.921, 37.74106], [-121.92102, 37.74085], [-121.92096, 37.74024], [-121.92146, 37.73929], [-121.92181, 37.73883], [-121.92232, 37.73901], [-121.92245, 37.73928], [-121.92249, 37.73962], [-121.92256, 37.73977], [-121.92257, 37.73977], [-121.92276, 37.73954], [-121.92277, 37.73957], [-121.92258, 37.73982], [-121.9226, 37.73986], [-121.92258, 37.74002], [-121.9226, 37.74014], [-121.9227, 37.7404], [-121.92283, 37.74054], [-121.92298, 37.74068], [-121.92344, 37.74066], [-121.92396, 37.74073], [-121.92441, 37.74073], [-121.9246, 37.74075], [-121.9248, 37.74079], [-121.92491, 37.74089], [-121.92502, 37.74095], [-121.92519, 37.74109], [-121.92534, 37.74126], [-121.92543, 37.74145], [-121.92548, 37.74167], [-121.92547, 37.74189], [-121.92553, 37.74205], [-121.92563, 37.74213], [-121.92575, 37.74238], [-121.9259, 37.74263], [-121.92617, 37.74292], [-121.92625, 37.74304], [-121.92638, 37.74333], [-121.92669, 37.74351], [-121.92698, 37.74389], [-121.92725, 37.74414], [-121.92715, 37.74428], [-121.92706, 37.74444], [-121.92692, 37.74464], [-121.92691, 37.74469], [-121.92692, 37.74481], [-121.92801, 37.74475], [-121.92843, 37.74481], [-121.92869, 37.74482], [-121.92892, 37.74479], [-121.9294, 37.74467], [-121.92994, 37.74522]]]} | Open Access 1 | 48920 | Dougherty Valley Ridge Trail | 33643 | 2300 | Geologic Hazard Abatement District (San Ramon) 853 | Special District 4 | Special District - Other 26 | http://www.sanramon.ca.gov/engr/ghad.html | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 89.586 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7254 | 7254 | 7253 | {"type": "MultiPolygon", "coordinates": [[[[-121.92276, 37.73954], [-121.92256, 37.73979], [-121.92249, 37.73962], [-121.92245, 37.73928], [-121.92232, 37.73901], [-121.92181, 37.73883], [-121.92146, 37.73929], [-121.92096, 37.74024], [-121.92102, 37.74085], [-121.921, 37.74106], [-121.92086, 37.74144], [-121.9209, 37.74166], [-121.92088, 37.74171], [-121.92061, 37.74195], [-121.92053, 37.7422], [-121.92049, 37.74258], [-121.9205, 37.74268], [-121.92053, 37.74278], [-121.92058, 37.74286], [-121.92136, 37.74378], [-121.92147, 37.74422], [-121.92148, 37.74431], [-121.92146, 37.7444], [-121.92138, 37.74453], [-121.9213, 37.74459], [-121.9211, 37.7447], [-121.921, 37.74482], [-121.92092, 37.74535], [-121.92094, 37.7455], [-121.92092, 37.7457], [-121.92071, 37.74637], [-121.91927, 37.74613], [-121.91968, 37.74602], [-121.91984, 37.74603], [-121.92007, 37.7457], [-121.92025, 37.74584], [-121.92066, 37.74583], [-121.92071, 37.74569], [-121.92042, 37.74544], [-121.92047, 37.74537], [-121.92045, 37.74529], [-121.92075, 37.74515], [-121.92082, 37.74491], [-121.92083, 37.7446], [-121.92073, 37.7445], [-121.92078, 37.74446], [-121.9208, 37.7444], [-121.92088, 37.7444], [-121.92123, 37.74428], [-121.9212, 37.74406], [-121.92109, 37.74379], [-121.9207, 37.74358], [-121.92073, 37.74349], [-121.92068, 37.74342], [-121.92078, 37.74333], [-121.92065, 37.74309], [-121.91977, 37.74301], [-121.91985, 37.74232], [-121.9201, 37.74232], [-121.92032, 37.74197], [-121.92017, 37.74139], [-121.92017, 37.74113], [-121.92062, 37.74071], [-121.92054, 37.74037], [-121.92035, 37.74031], [-121.92036, 37.74026], [-121.92035, 37.74022], [-121.92058, 37.74012], [-121.92075, 37.73983], [-121.92098, 37.73938], [-121.92089, 37.73929], [-121.92106, 37.73914], [-121.9213, 37.73889], [-121.9215, 37.73864], [-121.92162, 37.73848], [-121.92173, 37.73867], [-121.92185, 37.7385], [-121.92201, 37.73855], [-121.92228, 37.73867], [-121.92246, 37.73881], [-121.92256, 37.73893], [-121.92262, 37.73906], [-121.92276, 37.73954]]], [[[-121.92287, 37.73974], [-121.9226, 37.73986], [-121.92258, 37.73982], [-121.92277, 37.73957], [-121.92287, 37.73974]]]]} | Open Access 1 | 48921 | Dougherty Valley Ridge Trail | 33643 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 10.256 | Dougherty Valley Ridge Trail | 0 | Local Recreation Area 3 | 4 |
7255 | 7255 | 7254 | {"type": "Polygon", "coordinates": [[[-121.92427, 37.74849], [-121.92332, 37.74921], [-121.92193, 37.74844], [-121.91908, 37.7461], [-121.92388, 37.7469], [-121.92427, 37.74849]]]} | Open Access 1 | 48922 | Dougherty Valley Ridge Trail | 33643 | 2031 | East Bay Municipal Utility District 433 | Special District 4 | Water District 13 | http://www.ebmud.com/ | Special District 4 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | http://www.sanramon.ca.gov/our_city/departments_and_divisions/parks_community_services/trails_open_space/dougherty_valley_ridge_trail | Contra Costa 12 | 17.382 | Dougherty Valley Ridge Trail | 0 | 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]);