superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=472"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15257 | 15257 | 15256 | {"type": "MultiPolygon", "coordinates": [[[[-122.59892, 38.66142], [-122.59885, 38.66152], [-122.59867, 38.66162], [-122.59756, 38.6619], [-122.59687, 38.6621], [-122.59669, 38.66219], [-122.59663, 38.66232], [-122.59663, 38.66243], [-122.59667, 38.6625], [-122.59678, 38.66258], [-122.59691, 38.66262], [-122.59716, 38.6626], [-122.59828, 38.66236], [-122.59849, 38.66241], [-122.59887, 38.6626], [-122.59882, 38.66273], [-122.5952, 38.66285], [-122.59064, 38.66279], [-122.59056, 38.66017], [-122.59056, 38.6575], [-122.58386, 38.65697], [-122.58385, 38.65616], [-122.57943, 38.65593], [-122.5795, 38.64979], [-122.57728, 38.64861], [-122.57726, 38.64841], [-122.575, 38.6471], [-122.57492, 38.64323], [-122.57485, 38.64131], [-122.57247, 38.64042], [-122.57245, 38.63948], [-122.56921, 38.63821], [-122.5675, 38.63578], [-122.5677, 38.63576], [-122.56771, 38.63575], [-122.56715, 38.63492], [-122.56708, 38.63476], [-122.56386, 38.63178], [-122.56181, 38.6298], [-122.56046, 38.62857], [-122.55926, 38.62909], [-122.55559, 38.62524], [-122.55304, 38.62529], [-122.55134, 38.62683], [-122.54905, 38.62816], [-122.54906, 38.62901], [-122.54448, 38.62912], [-122.5444, 38.62378], [-122.54431, 38.62189], [-122.55349, 38.62169], [-122.55351, 38.62107], [-122.55339, 38.6145], [-122.55805, 38.61443], [-122.55813, 38.62154], [-122.56285, 38.62144], [-122.56291, 38.62505], [-122.5676, 38.62492], [-122.56767, 38.62854], [-122.57713, 38.63555], [-122.57717, 38.63883], [-122.57941, 38.63885], [-122.58189, 38.64072], [-122.58246, 38.64129], [-122.5825, 38.64179], [-122.58246, 38.64293], [-122.58269, 38.64356], [-122.58162, 38.64497], [-122.58604, 38.64533], [-122.58603, 38.64582], [-122.58604, 38.64928], [-122.59221, 38.64974], [-122.59239, 38.65154], [-122.59454, 38.65184], [-122.59699, 38.64999], [-122.59699, 38.6493], [-122.59737, 38.64956], [-122.59776, 38.64971], [-122.59798, 38.64985], [-122.59822, 38.65004], [-122.59828, 38.65029], [-122.59845, 38.65054], [-122.59864, 38.65068], [-122.59881, 38.65085], [-122.59901, 38.65093], [-122.59927, 38.65093], [-122.59943, 38.65101], [-122.59954, 38.65115], [-122.59966, 38.65155], [-122.59974, 38.6517], [-122.59981, 38.6522], [-122.59977, 38.65267], [-122.59975, 38.65285], [-122.59962, 38.65328], [-122.5995, 38.65357], [-122.59933, 38.65382], [-122.59889, 38.65463], [-122.59872, 38.65486], [-122.59858, 38.65494], [-122.59843, 38.65498], [-122.59829, 38.655], [-122.59795, 38.65497], [-122.59753, 38.65488], [-122.59723, 38.65489], [-122.59712, 38.65494], [-122.59686, 38.65521], [-122.59676, 38.65524], [-122.59636, 38.65529], [-122.59616, 38.65528], [-122.59597, 38.65525], [-122.5957, 38.65528], [-122.59554, 38.65531], [-122.59539, 38.65539], [-122.59531, 38.65545], [-122.5952, 38.65561], [-122.59504, 38.65621], [-122.59502, 38.65662], [-122.59505, 38.65689], [-122.59505, 38.65707], [-122.59489, 38.65742], [-122.5947, 38.65777], [-122.59475, 38.65824], [-122.59486, 38.6586], [-122.59484, 38.65894], [-122.59479, 38.65916], [-122.59471, 38.65938], [-122.59473, 38.6598], [-122.59478, 38.66003], [-122.59504, 38.66055], [-122.59513, 38.66068], [-122.59531, 38.66085], [-122.59555, 38.66097], [-122.59574, 38.66104], [-122.59604, 38.66108], [-122.59627, 38.66109], [-122.59638, 38.66106], [-122.59654, 38.66095], [-122.59713, 38.66034], [-122.59731, 38.66023], [-122.59741, 38.66019], [-122.59764, 38.66019], [-122.59772, 38.66021], [-122.59797, 38.66038], [-122.59806, 38.6605], [-122.59817, 38.66092], [-122.59825, 38.66102], [-122.59845, 38.66113], [-122.59878, 38.6612], [-122.59885, 38.66124], [-122.59891, 38.6613], [-122.59892, 38.66142]], [[-122.57718, 38.6407], [-122.57688, 38.64068], [-122.57669, 38.64103], [-122.57718, 38.64104], [-122.57718, 38.6407]]], [[[-122.57677, 38.60348], [-122.56738, 38.60361], [-122.56739, 38.60719], [-122.56655, 38.60718], [-122.5627, 38.60724], [-122.56112, 38.60719], [-122.55798, 38.60729], [-122.55794, 38.60578], [-122.55793, 38.60287], [-122.55786, 38.60055], [-122.55783, 38.59852], [-122.55785, 38.59662], [-122.55784, 38.59636], [-122.5578, 38.59307], [-122.56248, 38.593], [-122.56249, 38.59162], [-122.56798, 38.59158], [-122.56807, 38.59507], [-122.57657, 38.59504], [-122.57654, 38.59602], [-122.57676, 38.60263], [-122.57677, 38.60348]]], [[[-122.64952, 38.67069], [-122.64469, 38.67079], [-122.6449, 38.67738], [-122.64119, 38.67737], [-122.64127, 38.68493], [-122.63553, 38.68494], [-122.63537, 38.68483], [-122.63464, 38.68459], [-122.63398, 38.68329], [-122.63386, 38.68282], [-122.63369, 38.68262], [-122.63354, 38.6819], [-122.63325, 38.68149], [-122.63261, 38.68026], [-122.6325, 38.67977], [-122.6323, 38.67957], [-122.63183, 38.67921], [-122.63157, 38.67906], [-122.63119, 38.67889], [-122.63055, 38.67857], [-122.62974, 38.67802], [-122.6293, 38.67735], [-122.62904, 38.67718], [-122.62799, 38.67635], [-122.62753, 38.67593], [-122.62697, 38.6757], [-122.62666, 38.67542], [-122.62639, 38.675], [-122.62593, 38.67452], [-122.62559, 38.67412], [-122.63179, 38.67435], [-122.63179, 38.67078], [-122.63667, 38.67093], [-122.63635, 38.66763], [-122.63628, 38.66619], [-122.62728, 38.66638], [-122.62716, 38.66631], [-122.62277, 38.66646], [-122.6227, 38.66874], [-122.6044, 38.67308], [-122.60447, 38.66991], [-122.60467, 38.6627], [-122.6019, 38.66263], [-122.59932, 38.66272], [-122.59931, 38.66257], [-122.5992, 38.66242], [-122.59908, 38.66233], [-122.59886, 38.66222], [-122.5987, 38.66218], [-122.59855, 38.66215], [-122.59821, 38.66215], [-122.598, 38.66218], [-122.5976, 38.66228], [-122.59752, 38.66229], [-122.59746, 38.66226], [-122.59747, 38.6622], [-122.59751, 38.66215], [-122.59878, 38.66183], [-122.59899, 38.66177], [-122.59909, 38.6617], [-122.59929, 38.66148], [-122.59938, 38.66134], [-122.59941, 38.66128], [-122.59942, 38.66121], [-122.59938, 38.66116], [-122.59886, 38.66101], [-122.5987, 38.66099], [-122.59853, 38.66089], [-122.59845, 38.66083], [-122.59838, 38.66059], [-122.59833, 38.66047], [-122.59818, 38.6603], [-122.59799, 38.66014], [-122.59781, 38.66004], [-122.59752, 38.66], [-122.59728, 38.66004], [-122.59713, 38.66013], [-122.5969, 38.66028], [-122.59676, 38.66041], [-122.59646, 38.66073], [-122.59628, 38.66086], [-122.59577, 38.66087], [-122.59552, 38.66076], [-122.59536, 38.6606], [-122.59524, 38.66044], [-122.59506, 38.6601], [-122.59497, 38.65987], [-122.59494, 38.65953], [-122.59508, 38.65888], [-122.59509, 38.65871], [-122.59507, 38.65857], [-122.59493, 38.65806], [-122.59491, 38.65793], [-122.59492, 38.6578], [-122.59495, 38.65771], [-122.5951, 38.65749], [-122.59517, 38.65733], [-122.59524, 38.65715], [-122.59526, 38.657], [-122.59525, 38.65635], [-122.59533, 38.65585], [-122.59541, 38.65565], [-122.59552, 38.65555], [-122.59567, 38.65548], [-122.59596, 38.65545], [-122.59639, 38.65545], [-122.59673, 38.65542], [-122.59688, 38.65537], [-122.59701, 38.6553], [-122.59712, 38.65519], [-122.59724, 38.65514], [-122.59737, 38.6551], [-122.59839, 38.6552], [-122.59859, 38.65515], [-122.59875, 38.65506], [-122.59903, 38.65483], [-122.59986, 38.6534], [-122.59996, 38.65313], [-122.59999, 38.65283], [-122.60006, 38.65252], [-122.60008, 38.6522], [-122.60003, 38.65186], [-122.59997, 38.65155], [-122.59988, 38.65121], [-122.59978, 38.65102], [-122.59965, 38.65087], [-122.59925, 38.65071], [-122.59904, 38.65083], [-122.59898, 38.65084], [-122.59873, 38.65051], [-122.59853, 38.65039], [-122.59835, 38.64985], [-122.59755, 38.6493], [-122.59718, 38.64901], [-122.59692, 38.64883], [-122.59697, 38.64747], [-122.59707, 38.64634], [-122.60075, 38.64631], [-122.60064, 38.64457], [-122.60403, 38.64454], [-122.60406, 38.64272], [-122.61331, 38.64277], [-122.6133, 38.63554], [-122.61577, 38.63551], [-122.61697, 38.63645], [-122.62751, 38.64498], [-122.62753, 38.64559], [-122.6272, 38.64641], [-122.62677, 38.64761], [-122.62662, 38.64796], [-122.6263, 38.64833], [-122.62586, 38.64877], [-122.62527, 38.64917], [-122.62527, 38.6501], [-122.63018, 38.65009], [-122.63016, 38.65377], [-122.63975, 38.65384], [-122.6398, 38.65047], [-122.64459, 38.65246], [-122.64456, 38.65708], [-122.64932, 38.65711], [-122.64952, 38.67069]], [[-122.61279, 38.65695], [-122.61281, 38.65696], [-122.61775, 38.65709], [-122.61786, 38.65362], [-122.61309, 38.6535], [-122.61279, 38.65695]], [[-122.62674, 38.66613], [-122.62673, 38.66615], [-122.6271, 38.66628], [-122.62695, 38.66616], [-122.62674, 38.66613]]], [[[-122.63346, 38.6844], [-122.63161, 38.68438], [-122.62703, 38.68436], [-122.62699, 38.67709], [-122.61343, 38.67694], [-122.60426, 38.67697], [-122.6043, 38.67571], [-122.60458, 38.67563], [-122.60435, 38.67555], [-122.60439, 38.67313], [-122.60438, 38.67311], [-122.61097, 38.67159], [-122.62249, 38.66881], [-122.62247, 38.66883], [-122.62236, 38.6717], [-122.62233, 38.67177], [-122.62235, 38.67178], [-122.62262, 38.67172], [-122.62258, 38.67344], [-122.62525, 38.67347], [-122.62531, 38.67345], [-122.62525, 38.67367], [-122.62521, 38.67399], [-122.6254, 38.67448], [-122.62546, 38.67467], [-122.62563, 38.67499], [-122.62578, 38.67519], [-122.62585, 38.67534], [-122.6261, 38.67571], [-122.62624, 38.67613], [-122.62648, 38.67636], [-122.62691, 38.67667], [-122.62712, 38.67678], [-122.62764, 38.67709], [-122.62807, 38.6774], [-122.62834, 38.67762], [-122.62849, 38.67781], [-122.62875, 38.67806], [-122.6291, 38.67846], [-122.62926, 38.67869], [-122.62965, 38.67902], [-122.63038, 38.67942], [-122.63113, 38.67976], [-122.63132, 38.67988], [-122.63184, 38.68037], [-122.63198, 38.68064], [-122.63216, 38.68119], [-122.63241, 38.68164], [-122.63257, 38.68177], [-122.63275, 38.68182], [-122.63286, 38.68198], [-122.63292, 38.68235], [-122.63289, 38.68266], [-122.63294, 38.68312], [-122.63341, 38.6838], [-122.63347, 38.68419], [-122.63346, 38.6844]]]]} | Open Access 1 | Robert Louis Stevenson State Park | http://www.parks.ca.gov/?page_id=472 | 1712 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 5126.902 | Robert Louis Stevenson SP | 1949 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);