units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
60 rows where MNG_AGENCY = 68 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, YR_EST
DES_TP 10
- Local Park 45
- Local Recreation Area 7
- Local Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 45
- Restricted Access 15
MNG_AG_TYP 1
- City Agency 60
MNG_AGENCY 1
- San Ramon, City of · 60 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
183 | 183 | 182 | {"type": "Polygon", "coordinates": [[[-121.9589, 37.75072], [-121.95656, 37.75167], [-121.95627, 37.75123], [-121.95597, 37.75097], [-121.95558, 37.75036], [-121.95489, 37.74989], [-121.95534, 37.74942], [-121.95561, 37.74904], [-121.95572, 37.74886], [-121.9561, 37.74807], [-121.95647, 37.74778], [-121.95661, 37.7477], [-121.95692, 37.74756], [-121.95773, 37.74884], [-121.9589, 37.75072]]]} | Open Access 1 | 506 | Athan Downs Park | 31278 | 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 | Contra Costa 12 | 20.518 | Athan Downs Park | 0 | Local Park 2 | 4 | |
6734 | 6734 | 6733 | {"type": "Polygon", "coordinates": [[[-121.94697, 37.73689], [-121.94504, 37.73765], [-121.94449, 37.73676], [-121.94458, 37.73673], [-121.94465, 37.73663], [-121.9447, 37.7366], [-121.94629, 37.73598], [-121.94635, 37.73601], [-121.94661, 37.73631], [-121.94697, 37.73689]]]} | Open Access 1 | 5066 | Boone Acres | 31281 | 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 | Contra Costa 12 | 5.452 | Boone Acres | None 546 | |||
8470 | 8470 | 8469 | {"type": "Polygon", "coordinates": [[[-121.94855, 37.72697], [-121.94802, 37.72737], [-121.94747, 37.72752], [-121.94722, 37.7271], [-121.9467, 37.7264], [-121.94669, 37.72636], [-121.94658, 37.72614], [-121.94652, 37.72592], [-121.94646, 37.72549], [-121.94641, 37.72526], [-121.94638, 37.72523], [-121.94627, 37.72499], [-121.94613, 37.72477], [-121.94586, 37.72446], [-121.94572, 37.72427], [-121.94539, 37.72367], [-121.94653, 37.72513], [-121.94832, 37.72678], [-121.94855, 37.72697]]]} | Open Access 1 | 13199 | Centennial Park | 17028 | 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 | Contra Costa 12 | 5.528 | Centennial Park | 0 | Local Park 2 | 4 | |
8471 | 8471 | 8470 | {"type": "Polygon", "coordinates": [[[-121.93101, 37.72813], [-121.93092, 37.72817], [-121.93056, 37.7283], [-121.9304, 37.72839], [-121.93026, 37.72841], [-121.92975, 37.7287], [-121.92917, 37.72874], [-121.92848, 37.72913], [-121.92835, 37.72899], [-121.92849, 37.72891], [-121.92856, 37.72879], [-121.9287, 37.72876], [-121.92915, 37.7285], [-121.9292, 37.72846], [-121.92923, 37.72838], [-121.92921, 37.7283], [-121.92901, 37.72806], [-121.92902, 37.728], [-121.92937, 37.72775], [-121.93021, 37.72728], [-121.93024, 37.72727], [-121.93101, 37.72813]]]} | Open Access 1 | 13201 | Richard Fahey Village Green | 31285 | 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 | Contra Costa 12 | 4.407 | Richard Fahey Village Green | 0 | Local Park 2 | 4 | |
17026 | 17026 | 17025 | {"type": "Polygon", "coordinates": [[[-121.92429, 37.73448], [-121.92386, 37.73452], [-121.92261, 37.73371], [-121.92234, 37.73207], [-121.92317, 37.73206], [-121.9232, 37.7322], [-121.92324, 37.73234], [-121.92329, 37.73243], [-121.92342, 37.73259], [-121.92358, 37.73273], [-121.92376, 37.73283], [-121.92426, 37.73299], [-121.92428, 37.73302], [-121.9242, 37.73331], [-121.92418, 37.73362], [-121.92429, 37.73448]]]} | Open Access 1 | 13203 | Alcosta Senior and Community Center Park and Gardens | 31296 | 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 | Contra Costa 12 | 7.203 | Alcosta Senior and Community Ctr. Park and Gardens | 0 | Local Recreation Area 3 | 4 | |
8473 | 8473 | 8472 | {"type": "Polygon", "coordinates": [[[-121.94319, 37.7784], [-121.94287, 37.77836], [-121.9428, 37.77864], [-121.94262, 37.77909], [-121.94262, 37.77953], [-121.94256, 37.7805], [-121.94264, 37.78069], [-121.94276, 37.78085], [-121.94257, 37.78093], [-121.94237, 37.78093], [-121.94237, 37.78121], [-121.94228, 37.78121], [-121.94222, 37.77952], [-121.94219, 37.77951], [-121.94215, 37.77903], [-121.9422, 37.77889], [-121.94239, 37.77851], [-121.94253, 37.77815], [-121.94258, 37.77791], [-121.94252, 37.77766], [-121.94239, 37.77737], [-121.94211, 37.77743], [-121.94209, 37.77737], [-121.94198, 37.7773], [-121.94184, 37.77732], [-121.94177, 37.77742], [-121.94095, 37.7778], [-121.94018, 37.7767], [-121.94014, 37.77661], [-121.94011, 37.77647], [-121.94012, 37.77631], [-121.94019, 37.77615], [-121.94025, 37.77606], [-121.94037, 37.77593], [-121.94049, 37.77585], [-121.94071, 37.77576], [-121.94091, 37.77573], [-121.94111, 37.77572], [-121.94136, 37.77577], [-121.94151, 37.77583], [-121.9417, 37.77596], [-121.94247, 37.77695], [-121.94272, 37.7773], [-121.94314, 37.7782], [-121.94319, 37.7784]]]} | Open Access 1 | 13209 | Coyote Crossing | 31283 | 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 | Contra Costa 12 | 11.589 | Coyote Crossing | None 709 | |||
8474 | 8474 | 8473 | {"type": "Polygon", "coordinates": [[[-121.92385, 37.78744], [-121.92375, 37.78823], [-121.92185, 37.78835], [-121.92151, 37.78783], [-121.92175, 37.78771], [-121.92181, 37.78772], [-121.92187, 37.78771], [-121.92192, 37.78769], [-121.922, 37.78759], [-121.9226, 37.78726], [-121.92295, 37.78703], [-121.923, 37.78705], [-121.92312, 37.78715], [-121.92329, 37.78726], [-121.92349, 37.78734], [-121.92385, 37.78744]]]} | Open Access 1 | 13211 | Red Willow Park | 24229 | 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 | Contra Costa 12 | 4.827 | Red Willow Park | 0 | Local Park 2 | 4 | |
8475 | 8475 | 8474 | {"type": "Polygon", "coordinates": [[[-121.9392, 37.7711], [-121.93917, 37.77112], [-121.93842, 37.77114], [-121.93831, 37.77113], [-121.9382, 37.77109], [-121.93808, 37.77101], [-121.93801, 37.7709], [-121.93796, 37.77068], [-121.93799, 37.77056], [-121.93804, 37.77047], [-121.9386, 37.77065], [-121.9386, 37.77073], [-121.93918, 37.77072], [-121.9392, 37.7711]]]} | Open Access 1 | 13213 | Windy Hills Park | 27643 | 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 | Contra Costa 12 | 1.359 | Windy Hills Park | 2000 | Local Park 2 | 4 | |
11265 | 11265 | 11264 | {"type": "Polygon", "coordinates": [[[-121.95991, 37.77099], [-121.95916, 37.77133], [-121.95755, 37.76909], [-121.95614, 37.76973], [-121.95547, 37.76887], [-121.95514, 37.76854], [-121.95568, 37.76829], [-121.95516, 37.76775], [-121.95458, 37.76799], [-121.95222, 37.76585], [-121.95221, 37.76579], [-121.95401, 37.76453], [-121.95488, 37.76399], [-121.95991, 37.77099]]]} | Open Access 1 | 21945 | Central Park | 31279 | 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 | Contra Costa 12 | 41.371 | Central Park | 0 | Local Park 2 | 4 | |
11292 | 11292 | 11291 | {"type": "Polygon", "coordinates": [[[-121.94007, 37.74339], [-121.93937, 37.74367], [-121.93873, 37.74277], [-121.93857, 37.74256], [-121.93822, 37.74221], [-121.93808, 37.74203], [-121.93887, 37.74172], [-121.94007, 37.74339]]]} | Open Access 1 | 21970 | Del Mar Dog Park | 18030 | 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 | Contra Costa 12 | 3.734 | Del Mar Dog Park | 0 | Local Park 2 | 4 | |
11300 | 11300 | 11299 | {"type": "Polygon", "coordinates": [[[-121.96015, 37.75422], [-121.96011, 37.75435], [-121.95895, 37.75414], [-121.95885, 37.75415], [-121.95868, 37.75388], [-121.95862, 37.7538], [-121.95853, 37.75373], [-121.95842, 37.75367], [-121.9583, 37.75364], [-121.95811, 37.75362], [-121.95801, 37.75363], [-121.95786, 37.75367], [-121.95693, 37.75405], [-121.95683, 37.7541], [-121.95674, 37.75418], [-121.95663, 37.75433], [-121.95652, 37.7543], [-121.95641, 37.75431], [-121.95564, 37.75462], [-121.95559, 37.75465], [-121.95554, 37.75478], [-121.95531, 37.75475], [-121.95508, 37.7548], [-121.95413, 37.75519], [-121.95397, 37.75529], [-121.95387, 37.75542], [-121.95369, 37.75536], [-121.95338, 37.75549], [-121.95306, 37.75573], [-121.95289, 37.75616], [-121.9527, 37.75599], [-121.95223, 37.75564], [-121.9521, 37.75556], [-121.95245, 37.7556], [-121.95256, 37.7556], [-121.95273, 37.75554], [-121.95284, 37.75544], [-121.95303, 37.75544], [-121.9532, 37.75539], [-121.95422, 37.75496], [-121.95431, 37.7549], [-121.95439, 37.75482], [-121.95444, 37.75472], [-121.95457, 37.75474], [-121.95464, 37.75473], [-121.95543, 37.75441], [-121.95547, 37.75438], [-121.95553, 37.75427], [-121.95576, 37.75429], [-121.95588, 37.75428], [-121.95601, 37.75424], [-121.95705, 37.7538], [-121.95714, 37.75373], [-121.95724, 37.75359], [-121.95733, 37.75361], [-121.95744, 37.7536], [-121.95775, 37.75346], [-121.95778, 37.75342], [-121.95776, 37.75334], [-121.95692, 37.75203], [-121.95721, 37.75189], [-121.95715, 37.75195], [-121.95715, 37.75204], [-121.95757, 37.75268], [-121.95761, 37.75271], [-121.95771, 37.75274], [-121.95797, 37.75264], [-121.95804, 37.75265], [-121.95797, 37.75308], [-121.9581, 37.7533], [-121.95821, 37.75335], [-121.95821, 37.75339], [-121.95825, 37.75346], [-121.95833, 37.7535], [-121.95838, 37.7535], [-121.95847, 37.75347], [-121.95873, 37.75369], [-121.9589, 37.75393], [-121.95895, 37.75398], [-121.95901, 37.75401], [-121.95908, 37.75402], [-121.95923, 37.75399], [-121.95926, 37.75404], [-121.95934, 37.75407], [-121.95939, 37.75408], [-121.95946, 37.75406], [-121.95955, 37.75411], [-121.96015, 37.75422]]]} | Open Access 1 | 21971 | Inverness Park | 20224 | 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 | Contra Costa 12 | 5.908 | Inverness Park | 0 | Local Park 2 | 4 | |
11301 | 11301 | 11300 | {"type": "Polygon", "coordinates": [[[-121.97305, 37.75923], [-121.97264, 37.75935], [-121.97238, 37.7594], [-121.97211, 37.75943], [-121.97184, 37.75943], [-121.97157, 37.75941], [-121.97131, 37.75937], [-121.97113, 37.75933], [-121.97053, 37.75914], [-121.97021, 37.75907], [-121.96989, 37.75901], [-121.96957, 37.75897], [-121.96925, 37.75897], [-121.96893, 37.75899], [-121.96861, 37.75904], [-121.96816, 37.75914], [-121.96813, 37.75913], [-121.96809, 37.7591], [-121.96797, 37.75882], [-121.96789, 37.7587], [-121.96823, 37.75858], [-121.96858, 37.75762], [-121.96929, 37.75712], [-121.97281, 37.75831], [-121.97288, 37.75846], [-121.9728, 37.75859], [-121.97305, 37.75923]]]} | Open Access 1 | 21972 | Memorial Park | 22133 | 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 | Contra Costa 12 | 17.079 | Memorial Park | 0 | Local Park 2 | 4 | |
11302 | 11302 | 11301 | {"type": "Polygon", "coordinates": [[[-121.99072, 37.77668], [-121.99044, 37.77695], [-121.98928, 37.77606], [-121.98814, 37.77604], [-121.98827, 37.77573], [-121.98834, 37.77549], [-121.98841, 37.77517], [-121.98844, 37.77492], [-121.99072, 37.77668]]]} | Open Access 1 | 21973 | Mill Creek Hollow | 22223 | 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 | Contra Costa 12 | 3.523 | Mill Creek Hollow | None 989 | |||
11293 | 11293 | 11292 | {"type": "Polygon", "coordinates": [[[-121.92078, 37.73564], [-121.92042, 37.7358], [-121.92003, 37.7357], [-121.9198, 37.73567], [-121.91934, 37.73567], [-121.91901, 37.73571], [-121.91897, 37.7357], [-121.91895, 37.73567], [-121.91877, 37.7353], [-121.9186, 37.7351], [-121.91853, 37.73497], [-121.9184, 37.73421], [-121.9188, 37.73408], [-121.91905, 37.73433], [-121.9202, 37.73443], [-121.92054, 37.73475], [-121.92074, 37.73482], [-121.92078, 37.73564]]]} | Open Access 1 | 21974 | Old Ranch Park | 23100 | 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 | Contra Costa 12 | 6.737 | Old Ranch Park | 0 | Local Park 2 | 4 | |
11589 | 11589 | 11588 | {"type": "Polygon", "coordinates": [[[-121.91992, 37.77604], [-121.91982, 37.77629], [-121.91977, 37.7766], [-121.91977, 37.77685], [-121.91983, 37.77709], [-121.91991, 37.77733], [-121.91989, 37.77736], [-121.91774, 37.77781], [-121.91718, 37.77795], [-121.91808, 37.77551], [-121.9186, 37.77565], [-121.91992, 37.77604]]]} | Open Access 1 | 23706 | Valley View Park | 26807 | 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 | Contra Costa 12 | 10.024 | Valley View Park | 0 | Local Park 2 | 4 | |
11601 | 11601 | 11600 | {"type": "Polygon", "coordinates": [[[-121.89039, 37.76561], [-121.89032, 37.76633], [-121.89026, 37.76641], [-121.89013, 37.76649], [-121.8901, 37.76661], [-121.88904, 37.76652], [-121.88888, 37.76634], [-121.88882, 37.76533], [-121.88876, 37.76527], [-121.88875, 37.76518], [-121.8891, 37.76524], [-121.89022, 37.76531], [-121.89022, 37.76539], [-121.89025, 37.76546], [-121.89039, 37.76561]]]} | Open Access 1 | 23707 | Hidden Valley Park | 19918 | 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 | Contra Costa 12 | 4.547 | Hidden Valley Park | 0 | Local Park 2 | 4 | |
11602 | 11602 | 11601 | {"type": "Polygon", "coordinates": [[[-121.89919, 37.76468], [-121.90011, 37.76471], [-121.90024, 37.76475], [-121.90032, 37.7648], [-121.90038, 37.76489], [-121.9004, 37.76498], [-121.90037, 37.76562], [-121.90035, 37.7657], [-121.90031, 37.76575], [-121.90018, 37.76584], [-121.90002, 37.76586], [-121.89914, 37.76584], [-121.89902, 37.7658], [-121.89893, 37.76574], [-121.89887, 37.76566], [-121.89885, 37.76558], [-121.89888, 37.7649], [-121.89892, 37.76482], [-121.89899, 37.76475], [-121.89909, 37.7647], [-121.89919, 37.76468]]]} | Open Access 1 | 23708 | Bellingham Square | 15991 | 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 | Contra Costa 12 | 4.044 | Bellingham Square | 0 | Local Park 2 | 4 | |
11605 | 11605 | 11604 | {"type": "Polygon", "coordinates": [[[-121.90018, 37.76147], [-121.90015, 37.76151], [-121.89894, 37.76161], [-121.89888, 37.76156], [-121.89882, 37.76113], [-121.89873, 37.7609], [-121.89847, 37.76033], [-121.89847, 37.7603], [-121.89851, 37.76019], [-121.8988, 37.76016], [-121.89906, 37.76012], [-121.8996, 37.75986], [-121.89982, 37.75979], [-121.89984, 37.75977], [-121.89991, 37.76], [-121.89983, 37.76005], [-121.89981, 37.76012], [-121.89987, 37.7602], [-121.89991, 37.76029], [-121.90009, 37.76085], [-121.90013, 37.76102], [-121.90018, 37.76147]]]} | Open Access 1 | 23709 | East Branch Park | 18364 | 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 | Contra Costa 12 | 5.077 | East Branch Park | 0 | Local Park 2 | 4 | |
11904 | 11904 | 11903 | {"type": "Polygon", "coordinates": [[[-121.92089, 37.78122], [-121.92073, 37.7813], [-121.9201, 37.7815], [-121.91992, 37.78151], [-121.91983, 37.78173], [-121.91963, 37.78164], [-121.91938, 37.78148], [-121.91938, 37.78143], [-121.92004, 37.78079], [-121.92017, 37.78059], [-121.92047, 37.78065], [-121.92065, 37.78077], [-121.92071, 37.78083], [-121.92082, 37.78115], [-121.92089, 37.78122]]]} | Open Access 1 | 24473 | Hidden Crest Park | 19906 | 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 | Contra Costa 12 | 2.067 | Hidden Crest Park | 0 | Local Park 2 | 4 | |
11885 | 11885 | 11884 | {"type": "Polygon", "coordinates": [[[-121.89013, 37.75908], [-121.88996, 37.75937], [-121.88997, 37.75971], [-121.88991, 37.75987], [-121.88982, 37.76003], [-121.88939, 37.7599], [-121.88887, 37.7598], [-121.8888, 37.75978], [-121.88877, 37.75972], [-121.88897, 37.75933], [-121.88903, 37.7591], [-121.88903, 37.75896], [-121.88901, 37.75883], [-121.88895, 37.75869], [-121.88884, 37.75853], [-121.88887, 37.75852], [-121.88911, 37.75868], [-121.88927, 37.75876], [-121.89013, 37.75908]]]} | Open Access 1 | 24474 | Limerick Park | 21242 | 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 | Contra Costa 12 | 2.775 | Limerick 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]);