units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
35 rows where DES_TP = 14, GAP_STS = 4 and MNG_AGENCY = 129
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 35
MNG_AGENCY 1
- Poway, City of · 35 ✖
DES_TP 1
- Local Other or Unknown · 35 ✖
ACCESS_TYP 1
- Open Access 35
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3581 | 3581 | 3580 | {"type": "Polygon", "coordinates": [[[-117.06669, 32.93389], [-117.06669, 32.93424], [-117.06636, 32.93423], [-117.06575, 32.93426], [-117.06303, 32.93451], [-117.06295, 32.93426], [-117.06337, 32.93406], [-117.06374, 32.93381], [-117.06492, 32.93381], [-117.06669, 32.93389]]]} | Open Access 1 | 36687 | Poway holding 30 | 23955 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.51 | Poway holding 30 | 0 | Local Other or Unknown 14 | 4 | |
7830 | 7830 | 7829 | {"type": "Polygon", "coordinates": [[[-117.05962, 32.93512], [-117.05625, 32.93698], [-117.05427, 32.93557], [-117.05391, 32.93515], [-117.05962, 32.93512]]]} | Open Access 1 | 35850 | Poway holding 11 | 23934 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 13.923 | Poway holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13400 | 13400 | 13399 | {"type": "Polygon", "coordinates": [[[-117.02894, 33.01149], [-117.02839, 33.01226], [-117.02831, 33.01206], [-117.0279, 33.01182], [-117.02767, 33.01162], [-117.02781, 33.01138], [-117.02765, 33.01079], [-117.02712, 33.01022], [-117.0267, 33.00993], [-117.02621, 33.00987], [-117.02595, 33.00955], [-117.02569, 33.00944], [-117.02576, 33.00932], [-117.0259, 33.00914], [-117.02663, 33.00952], [-117.02678, 33.00925], [-117.0269, 33.00896], [-117.02702, 33.00866], [-117.02713, 33.00822], [-117.02757, 33.00777], [-117.02751, 33.00701], [-117.02768, 33.00696], [-117.02795, 33.00752], [-117.02735, 33.00867], [-117.02731, 33.00986], [-117.02804, 33.01051], [-117.02894, 33.01149]]]} | Open Access 1 | 35512 | Poway holding 29 | 23953 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 8.564 | Poway holding 29 | 0 | Local Other or Unknown 14 | 4 | |
13401 | 13401 | 13400 | {"type": "Polygon", "coordinates": [[[-117.06276, 32.93262], [-117.06259, 32.93285], [-117.06243, 32.93294], [-117.06232, 32.93308], [-117.06211, 32.93322], [-117.06207, 32.93368], [-117.06184, 32.93365], [-117.06165, 32.93359], [-117.06148, 32.93352], [-117.06123, 32.93336], [-117.06172, 32.93277], [-117.06228, 32.93288], [-117.06276, 32.93262]]]} | Open Access 1 | 35513 | Poway holding 27 | 23951 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.662 | Poway holding 27 | 0 | Local Other or Unknown 14 | 4 | |
13409 | 13409 | 13408 | {"type": "Polygon", "coordinates": [[[-117.02379, 33.00511], [-117.02377, 33.00515], [-117.02368, 33.00518], [-117.02366, 33.00476], [-117.02327, 33.00289], [-117.02341, 33.00257], [-117.0234, 33.00228], [-117.02348, 33.00229], [-117.02352, 33.00233], [-117.02348, 33.00314], [-117.0235, 33.00363], [-117.02379, 33.00511]]]} | Open Access 1 | 35556 | Poway holding 1 | 23932 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.739 | Poway holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13422 | 13422 | 13421 | {"type": "Polygon", "coordinates": [[[-117.01899, 33.00326], [-117.01877, 33.0035], [-117.01828, 33.00434], [-117.01789, 33.00419], [-117.0176, 33.00404], [-117.0174, 33.00384], [-117.01723, 33.00361], [-117.01693, 33.00298], [-117.01687, 33.00254], [-117.01777, 33.00133], [-117.01774, 33.00097], [-117.01699, 33.00054], [-117.01631, 33.00005], [-117.01628, 32.99955], [-117.01612, 32.99902], [-117.01544, 32.99905], [-117.0148, 32.99905], [-117.01479, 32.99948], [-117.01474, 32.99947], [-117.01468, 32.99949], [-117.01462, 32.99951], [-117.01459, 32.99957], [-117.01463, 33.00048], [-117.01462, 33.0005], [-117.01457, 33.00053], [-117.01448, 33.00053], [-117.01441, 32.99889], [-117.01185, 32.99918], [-117.00983, 32.99975], [-117.00991, 32.9967], [-117.01443, 32.99673], [-117.01442, 32.99873], [-117.01597, 32.99816], [-117.01744, 32.99936], [-117.01835, 32.99958], [-117.01826, 33.00023], [-117.01839, 33.00069], [-117.01863, 33.00109], [-117.01899, 33.00326]]]} | Open Access 1 | 35557 | Poway holding 2 | 23943 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 53.235 | Poway holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13430 | 13430 | 13429 | {"type": "Polygon", "coordinates": [[[-117.02163, 33.04292], [-117.0212, 33.04359], [-117.02138, 33.0441], [-117.02079, 33.04412], [-117.02079, 33.04317], [-117.01906, 33.04209], [-117.01646, 33.04278], [-117.01645, 33.04412], [-117.01413, 33.04412], [-117.01409, 33.04239], [-117.01591, 33.04236], [-117.01638, 33.04216], [-117.01783, 33.04196], [-117.01829, 33.04176], [-117.01925, 33.04138], [-117.01935, 33.04108], [-117.01954, 33.0411], [-117.01974, 33.04109], [-117.0199, 33.04104], [-117.02017, 33.04092], [-117.02021, 33.04094], [-117.02042, 33.04111], [-117.02055, 33.04119], [-117.02083, 33.04128], [-117.021, 33.04138], [-117.02114, 33.04151], [-117.02127, 33.04169], [-117.02146, 33.04247], [-117.02147, 33.04256], [-117.02155, 33.04271], [-117.02156, 33.04281], [-117.02163, 33.04292]]]} | Open Access 1 | 35553 | Poway holding 6 | 23965 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 24.996 | Poway holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13431 | 13431 | 13430 | {"type": "Polygon", "coordinates": [[[-117.06328, 32.94091], [-117.06329, 32.94167], [-117.06327, 32.94175], [-117.06322, 32.9418], [-117.06314, 32.94186], [-117.06307, 32.94188], [-117.0623, 32.94191], [-117.06217, 32.94194], [-117.06206, 32.94199], [-117.06198, 32.94207], [-117.06193, 32.94217], [-117.06192, 32.94228], [-117.06135, 32.94229], [-117.06146, 32.94309], [-117.06154, 32.94327], [-117.06148, 32.94368], [-117.06178, 32.94378], [-117.06159, 32.94404], [-117.06156, 32.94419], [-117.06017, 32.94606], [-117.05968, 32.94581], [-117.05959, 32.945], [-117.05574, 32.94526], [-117.05385, 32.94458], [-117.05495, 32.94345], [-117.05483, 32.94322], [-117.05478, 32.94321], [-117.05458, 32.9416], [-117.05491, 32.94153], [-117.05495, 32.94165], [-117.05706, 32.9425], [-117.05721, 32.94244], [-117.05859, 32.94298], [-117.05881, 32.94152], [-117.06002, 32.9417], [-117.06041, 32.9417], [-117.06087, 32.94166], [-117.06127, 32.9416], [-117.06164, 32.9415], [-117.06328, 32.94091]]]} | Open Access 1 | 35554 | Poway holding 3 | 23954 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 59.873 | Poway holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13432 | 13432 | 13431 | {"type": "Polygon", "coordinates": [[[-117.02617, 33.00623], [-117.02578, 33.00626], [-117.0255, 33.0061], [-117.02516, 33.00568], [-117.02487, 33.00565], [-117.02439, 33.00576], [-117.0243, 33.00716], [-117.02459, 33.0073], [-117.02428, 33.0073], [-117.02425, 33.00729], [-117.02423, 33.00725], [-117.02422, 33.00722], [-117.02427, 33.00658], [-117.02428, 33.00627], [-117.02427, 33.00577], [-117.02425, 33.00555], [-117.02388, 33.00376], [-117.02386, 33.00356], [-117.02384, 33.0031], [-117.02388, 33.00235], [-117.0239, 33.00232], [-117.02394, 33.0023], [-117.02404, 33.00229], [-117.02402, 33.00268], [-117.0247, 33.00289], [-117.02451, 33.00337], [-117.02431, 33.00428], [-117.02428, 33.00459], [-117.02444, 33.00473], [-117.02482, 33.00514], [-117.02562, 33.00557], [-117.02562, 33.00588], [-117.02572, 33.00598], [-117.02616, 33.00603], [-117.02617, 33.00623]]]} | Open Access 1 | 35555 | Poway holding 4 | 23964 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 5.991 | Poway holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13433 | 13433 | 13432 | {"type": "Polygon", "coordinates": [[[-117.02384, 33.00745], [-117.02372, 33.00902], [-117.0237, 33.00904], [-117.02343, 33.00903], [-117.0236, 33.00877], [-117.02364, 33.0079], [-117.02322, 33.00746], [-117.02384, 33.00745]]]} | Open Access 1 | 35558 | Poway holding 7 | 23966 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.96 | Poway holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13502 | 13502 | 13501 | {"type": "Polygon", "coordinates": [[[-117.00549, 33.03005], [-117.00539, 33.03347], [-117.00095, 33.03353], [-117.0009, 33.0371], [-117.00526, 33.037], [-117.00533, 33.04071], [-116.99687, 33.04097], [-116.99663, 33.04096], [-116.99652, 33.0372], [-116.9965, 33.03012], [-117.00549, 33.03005]]]} | Open Access 1 | 35794 | Poway holding 38 | 23963 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 203.096 | Poway holding 38 | 0 | Local Other or Unknown 14 | 4 | |
13507 | 13507 | 13506 | {"type": "Polygon", "coordinates": [[[-117.02323, 33.03387], [-117.02274, 33.03451], [-117.02253, 33.03474], [-117.02131, 33.03575], [-117.02116, 33.03585], [-117.02103, 33.03592], [-117.02086, 33.03597], [-117.0205, 33.03603], [-117.02019, 33.03599], [-117.01962, 33.03585], [-117.01922, 33.0358], [-117.01917, 33.03576], [-117.01909, 33.03566], [-117.01898, 33.03562], [-117.01887, 33.03564], [-117.0188, 33.0357], [-117.01876, 33.03578], [-117.01872, 33.03582], [-117.01852, 33.03584], [-117.0187, 33.03328], [-117.02247, 33.03317], [-117.02249, 33.03358], [-117.02232, 33.03364], [-117.02187, 33.03382], [-117.0216, 33.03389], [-117.02024, 33.03403], [-117.02005, 33.03407], [-117.0199, 33.03413], [-117.01975, 33.03422], [-117.01953, 33.03442], [-117.0195, 33.0345], [-117.01919, 33.03449], [-117.01889, 33.03529], [-117.01998, 33.03546], [-117.02089, 33.03505], [-117.02144, 33.03483], [-117.02276, 33.03424], [-117.02286, 33.03373], [-117.02303, 33.03376], [-117.02318, 33.03382], [-117.02323, 33.03387]]]} | Open Access 1 | 35792 | Poway holding 17 | 23940 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 16.135 | Poway holding 17 | 0 | Local Other or Unknown 14 | 4 | |
13508 | 13508 | 13507 | {"type": "Polygon", "coordinates": [[[-117.05244, 32.94534], [-117.05245, 32.946], [-117.05201, 32.94727], [-117.05199, 32.94823], [-117.0518, 32.94822], [-117.0513, 32.94828], [-117.05087, 32.94837], [-117.0503, 32.94854], [-117.04966, 32.94861], [-117.04965, 32.94884], [-117.04926, 32.94898], [-117.04886, 32.94908], [-117.04851, 32.94913], [-117.04806, 32.94914], [-117.04719, 32.94914], [-117.04497, 32.94911], [-117.04457, 32.94908], [-117.04435, 32.94902], [-117.04404, 32.94897], [-117.04387, 32.94896], [-117.04333, 32.94899], [-117.04283, 32.94892], [-117.0429, 32.94867], [-117.04306, 32.9476], [-117.0431, 32.94741], [-117.04319, 32.94716], [-117.04332, 32.94688], [-117.04347, 32.94663], [-117.04365, 32.94638], [-117.04443, 32.94544], [-117.04458, 32.94519], [-117.04473, 32.94493], [-117.04484, 32.94468], [-117.04501, 32.94413], [-117.0461, 32.94432], [-117.04752, 32.94427], [-117.04807, 32.94422], [-117.04918, 32.94464], [-117.05211, 32.94535], [-117.05244, 32.94534]]]} | Open Access 1 | 35793 | Poway holding 18 | 23941 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 94.222 | Poway holding 18 | 0 | Local Other or Unknown 14 | 4 | |
13522 | 13522 | 13521 | {"type": "Polygon", "coordinates": [[[-117.0667, 32.93509], [-117.06608, 32.93509], [-117.06608, 32.93563], [-117.06586, 32.93563], [-117.06584, 32.93509], [-117.06421, 32.9351], [-117.06356, 32.93482], [-117.06295, 32.9351], [-117.06222, 32.93511], [-117.06222, 32.93513], [-117.06232, 32.93522], [-117.06227, 32.93524], [-117.06225, 32.93528], [-117.06224, 32.93532], [-117.06225, 32.93536], [-117.06196, 32.93565], [-117.06156, 32.9357], [-117.06157, 32.93563], [-117.06154, 32.93558], [-117.06149, 32.93553], [-117.06141, 32.93552], [-117.06141, 32.93511], [-117.06204, 32.93511], [-117.06205, 32.93509], [-117.06188, 32.93492], [-117.06198, 32.93491], [-117.06198, 32.9349], [-117.06196, 32.93488], [-117.06267, 32.93479], [-117.06298, 32.93478], [-117.06579, 32.93453], [-117.06636, 32.9345], [-117.06669, 32.93451], [-117.0667, 32.93509]]]} | Open Access 1 | 35819 | Poway holding 34 | 23959 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.144 | Poway holding 34 | 0 | Local Other or Unknown 14 | 4 | |
13523 | 13523 | 13522 | {"type": "Polygon", "coordinates": [[[-117.06423, 32.94261], [-117.06344, 32.94237], [-117.0629, 32.94227], [-117.06287, 32.94234], [-117.06251, 32.94227], [-117.06244, 32.94228], [-117.06202, 32.94219], [-117.06208, 32.94207], [-117.06213, 32.94202], [-117.06229, 32.94198], [-117.06305, 32.94195], [-117.06315, 32.94193], [-117.06323, 32.94189], [-117.0633, 32.94183], [-117.06335, 32.94176], [-117.06336, 32.94166], [-117.064, 32.94171], [-117.06418, 32.94234], [-117.06423, 32.94261]]]} | Open Access 1 | 35820 | Poway holding 35 | 23960 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 2.641 | Poway holding 35 | 0 | Local Other or Unknown 14 | 4 | |
13524 | 13524 | 13523 | {"type": "Polygon", "coordinates": [[[-117.02155, 32.95986], [-117.02155, 32.95994], [-117.02103, 32.95994], [-117.02095, 32.96008], [-117.02096, 32.96039], [-117.02106, 32.96047], [-117.02091, 32.96064], [-117.02085, 32.96074], [-117.0208, 32.96091], [-117.0208, 32.96142], [-117.02082, 32.96161], [-117.0209, 32.96194], [-117.02088, 32.96203], [-117.02077, 32.96215], [-117.02066, 32.96219], [-117.02019, 32.96218], [-117.02019, 32.96179], [-117.02008, 32.96109], [-117.02, 32.96079], [-117.01987, 32.96057], [-117.01968, 32.96061], [-117.01969, 32.96053], [-117.01966, 32.96046], [-117.01972, 32.96042], [-117.01971, 32.95998], [-117.01905, 32.95999], [-117.01906, 32.96152], [-117.0189, 32.96152], [-117.01889, 32.95985], [-117.02155, 32.95986]]]} | Open Access 1 | 35821 | Poway holding 8 | 23967 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 6.389 | Poway holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13525 | 13525 | 13524 | {"type": "Polygon", "coordinates": [[[-117.05948, 32.9619], [-117.05908, 32.96188], [-117.0591, 32.96481], [-117.05736, 32.9648], [-117.0574, 32.96441], [-117.05678, 32.96442], [-117.05736, 32.96317], [-117.0573, 32.96299], [-117.05708, 32.9631], [-117.05686, 32.9631], [-117.05685, 32.96274], [-117.057, 32.96261], [-117.05757, 32.96261], [-117.05757, 32.96294], [-117.05838, 32.96292], [-117.05838, 32.96226], [-117.05817, 32.96171], [-117.05927, 32.96123], [-117.05927, 32.96136], [-117.05948, 32.9619]]]} | Open Access 1 | 35822 | Poway holding 37 | 23962 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 13.225 | Poway holding 37 | 0 | Local Other or Unknown 14 | 4 | |
13526 | 13526 | 13525 | {"type": "Polygon", "coordinates": [[[-117.03112, 33.0179], [-117.03112, 33.01828], [-117.03018, 33.0182], [-117.02981, 33.01779], [-117.03112, 33.0179]]]} | Open Access 1 | 35823 | Poway holding 32 | 23957 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 1.1 | Poway holding 32 | 0 | Local Other or Unknown 14 | 4 | |
13527 | 13527 | 13526 | {"type": "Polygon", "coordinates": [[[-117.02371, 33.01452], [-117.0236, 33.01454], [-117.02354, 33.01365], [-117.02349, 33.01341], [-117.02363, 33.01341], [-117.02368, 33.01347], [-117.02367, 33.01393], [-117.02371, 33.01452]]]} | Open Access 1 | 35824 | Poway holding 31 | 23956 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 0.361 | Poway holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13540 | 13540 | 13539 | {"type": "Polygon", "coordinates": [[[-117.02815, 33.00388], [-117.02776, 33.00411], [-117.02767, 33.0045], [-117.02735, 33.00465], [-117.02745, 33.00503], [-117.02729, 33.00571], [-117.02741, 33.00617], [-117.02718, 33.00647], [-117.02748, 33.00684], [-117.02709, 33.00695], [-117.02685, 33.00632], [-117.02636, 33.00622], [-117.02635, 33.00607], [-117.02637, 33.00592], [-117.02701, 33.00604], [-117.02713, 33.00529], [-117.02715, 33.00465], [-117.02718, 33.0044], [-117.02746, 33.00417], [-117.02761, 33.00355], [-117.02726, 33.00317], [-117.02684, 33.00317], [-117.02684, 33.00313], [-117.02686, 33.00309], [-117.02727, 33.00279], [-117.02813, 33.00347], [-117.02815, 33.00388]]]} | Open Access 1 | 35849 | Poway holding 10 | 23933 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 4.566 | Poway holding 10 | 0 | Local Other or Unknown 14 | 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]);