units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 532 and SUID_NMA = 17321
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3035 | 3035 | 3034 | {"type": "MultiPolygon", "coordinates": [[[[-121.58153, 39.13959], [-121.58099, 39.13957], [-121.58098, 39.14007], [-121.58002, 39.13989], [-121.5793, 39.13947], [-121.57827, 39.13833], [-121.57987, 39.13726], [-121.58002, 39.13793], [-121.58003, 39.13794], [-121.58079, 39.13758], [-121.58075, 39.1371], [-121.5809, 39.13702], [-121.58148, 39.13702], [-121.58153, 39.13959]]], [[[-121.58358, 39.13917], [-121.58346, 39.1392], [-121.58336, 39.1393], [-121.58332, 39.13936], [-121.58333, 39.13952], [-121.58335, 39.13959], [-121.5831, 39.13961], [-121.58302, 39.13925], [-121.58264, 39.13928], [-121.58256, 39.13862], [-121.58294, 39.1386], [-121.58297, 39.1387], [-121.58352, 39.13866], [-121.58358, 39.13917]]], [[[-121.58347, 39.13844], [-121.58291, 39.13849], [-121.58282, 39.13783], [-121.58304, 39.1378], [-121.58292, 39.1376], [-121.58335, 39.13757], [-121.58347, 39.13844]]], [[[-121.58363, 39.13698], [-121.58335, 39.137], [-121.58332, 39.13675], [-121.5833, 39.13674], [-121.58325, 39.13681], [-121.58332, 39.13733], [-121.58303, 39.13735], [-121.58299, 39.13694], [-121.58315, 39.13668], [-121.58345, 39.13644], [-121.58356, 39.13643], [-121.58333, 39.13671], [-121.58359, 39.1367], [-121.58363, 39.13698]]], [[[-121.58366, 39.13898], [-121.58363, 39.13898], [-121.58359, 39.13866], [-121.58362, 39.13865], [-121.58366, 39.13898]]], [[[-121.58804, 39.13538], [-121.58605, 39.13554], [-121.58609, 39.13598], [-121.58553, 39.13603], [-121.58547, 39.13559], [-121.58579, 39.13556], [-121.58583, 39.13539], [-121.58744, 39.13512], [-121.58796, 39.13517], [-121.58804, 39.13538]]], [[[-121.58935, 39.13511], [-121.58855, 39.13522], [-121.58855, 39.13524], [-121.58876, 39.13529], [-121.58895, 39.13528], [-121.589, 39.13571], [-121.58844, 39.13575], [-121.58839, 39.13532], [-121.58851, 39.13531], [-121.5885, 39.13523], [-121.58813, 39.13425], [-121.58884, 39.13422], [-121.58905, 39.13424], [-121.58918, 39.13455], [-121.58929, 39.13495], [-121.58935, 39.13511]]], [[[-121.595, 39.13575], [-121.59481, 39.13599], [-121.59408, 39.13568], [-121.59345, 39.13544], [-121.59277, 39.13527], [-121.59214, 39.13517], [-121.59154, 39.13514], [-121.59152, 39.13499], [-121.59147, 39.13488], [-121.59, 39.13509], [-121.5898, 39.13432], [-121.59013, 39.13435], [-121.59016, 39.13386], [-121.59041, 39.13391], [-121.59219, 39.13392], [-121.595, 39.13575]]]]} | Open Access 1 | 20801 | City of Marysville Open Space | 17321 | 1199 | Marysville, City of 539 | City 2 | City Agency 2 | http://www.marysville.ca.us/index.php/city-services/parks-facilities | City 2 | 1199 | Marysville, City of 532 | City 2 | City Agency 2 | Yuba 25 | 33.048 | City of Marysville OS | 0 | Local Recreation Area 3 | 4 | |
3036 | 3036 | 3035 | {"type": "MultiPolygon", "coordinates": [[[[-121.5847, 39.16478], [-121.5847, 39.16478], [-121.58413, 39.16478], [-121.58463, 39.16423], [-121.5847, 39.16478]]], [[[-121.58671, 39.16202], [-121.58655, 39.16263], [-121.58625, 39.16476], [-121.58489, 39.16477], [-121.58479, 39.16405], [-121.58626, 39.16253], [-121.58671, 39.16202]]], [[[-121.58991, 39.15874], [-121.58919, 39.15957], [-121.5898, 39.16065], [-121.58937, 39.16079], [-121.5894, 39.16105], [-121.58779, 39.16135], [-121.58752, 39.16178], [-121.58796, 39.16474], [-121.58678, 39.16476], [-121.58709, 39.16225], [-121.58728, 39.16184], [-121.58723, 39.16144], [-121.58987, 39.15846], [-121.58991, 39.15874]]], [[[-121.58521, 39.16318], [-121.5842, 39.16428], [-121.58341, 39.16488], [-121.58194, 39.16491], [-121.58191, 39.1647], [-121.58205, 39.16477], [-121.58288, 39.16477], [-121.58289, 39.1647], [-121.58319, 39.16469], [-121.58393, 39.16421], [-121.58488, 39.1632], [-121.58521, 39.16318]]], [[[-121.58511, 39.16506], [-121.58493, 39.16586], [-121.58289, 39.1659], [-121.58368, 39.1651], [-121.58511, 39.16506]]], [[[-121.58306, 39.16512], [-121.58229, 39.16591], [-121.57622, 39.16602], [-121.57619, 39.16521], [-121.57895, 39.16517], [-121.581, 39.16515], [-121.58096, 39.16479], [-121.58169, 39.16478], [-121.58175, 39.16516], [-121.58306, 39.16512]]]]} | Open Access 1 | 20802 | City of Marysville Open Space | 17321 | 1199 | Marysville, City of 539 | City 2 | City Agency 2 | http://www.marysville.ca.us/index.php/city-services/parks-facilities | City 2 | 1199 | Marysville, City of 532 | City 2 | City Agency 2 | Yuba 25 | 36.043 | City of Marysville OS | 0 | Local Recreation Area 3 | 4 | |
16165 | 16165 | 16164 | {"type": "MultiPolygon", "coordinates": [[[[-121.5975, 39.15604], [-121.59252, 39.15638], [-121.59249, 39.15596], [-121.59302, 39.15547], [-121.59298, 39.15513], [-121.59239, 39.15518], [-121.59274, 39.15479], [-121.59336, 39.15469], [-121.59333, 39.15412], [-121.59341, 39.15404], [-121.59345, 39.15484], [-121.59386, 39.15442], [-121.59382, 39.15362], [-121.59403, 39.1534], [-121.59487, 39.15334], [-121.59482, 39.15258], [-121.5949, 39.1525], [-121.59496, 39.15324], [-121.59529, 39.15289], [-121.59525, 39.15229], [-121.59548, 39.15227], [-121.59551, 39.15263], [-121.59588, 39.15224], [-121.59697, 39.15215], [-121.5975, 39.15604]], [[-121.59421, 39.15401], [-121.59423, 39.15401], [-121.59464, 39.15357], [-121.59464, 39.15355], [-121.5942, 39.15358], [-121.59421, 39.15401]]], [[[-121.59657, 39.15203], [-121.59601, 39.15208], [-121.596, 39.15202], [-121.5965, 39.15149], [-121.59657, 39.15203]]], [[[-121.59741, 39.15196], [-121.59685, 39.15201], [-121.59673, 39.15114], [-121.59729, 39.15109], [-121.59741, 39.15196]]], [[[-121.59804, 39.15191], [-121.59748, 39.15196], [-121.59736, 39.15108], [-121.59792, 39.15103], [-121.59804, 39.15191]]], [[[-121.5991, 39.15591], [-121.5978, 39.15602], [-121.59767, 39.15506], [-121.59843, 39.15498], [-121.59848, 39.15525], [-121.599, 39.15521], [-121.5991, 39.15591]]], [[[-121.59879, 39.15118], [-121.59823, 39.15123], [-121.5982, 39.15101], [-121.59877, 39.15096], [-121.59879, 39.15118]]], [[[-121.59952, 39.15178], [-121.59896, 39.15183], [-121.59883, 39.15096], [-121.59939, 39.15091], [-121.59952, 39.15178]]], [[[-121.60036, 39.15171], [-121.5998, 39.15176], [-121.59967, 39.15089], [-121.60024, 39.15084], [-121.60036, 39.15171]]], [[[-121.60099, 39.15166], [-121.60043, 39.1517], [-121.60031, 39.15083], [-121.60087, 39.15078], [-121.60099, 39.15166]]]]} | Open Access 1 | 20800 | City of Marysville Open Space | 17321 | 1199 | Marysville, City of 539 | City 2 | City Agency 2 | http://www.marysville.ca.us/index.php/city-services/parks-facilities | City 2 | 1199 | Marysville, City of 532 | City 2 | City Agency 2 | Yuba 25 | 41.697 | City of Marysville OS | 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]);