units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, COUNTY = 5, DES_TP = 55 and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11563 | 11563 | 11562 | {"type": "Polygon", "coordinates": [[[-122.064, 36.98385], [-122.06366, 36.98401], [-122.06267, 36.98408], [-122.06257, 36.98463], [-122.06235, 36.98486], [-122.06189, 36.98495], [-122.06155, 36.98351], [-122.06155, 36.98317], [-122.06189, 36.98305], [-122.06343, 36.98349], [-122.06394, 36.98377], [-122.064, 36.98385]]]} | Open Access 1 | 23588 | California State Lands Commission | 16724 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Santa Cruz 5 | 5.72 | SLC | 0 | State Resource Management Area 55 | 3 | |
15543 | 15543 | 15542 | {"type": "Polygon", "coordinates": [[[-121.94199, 37.09322], [-121.94136, 37.09493], [-121.93644, 37.09377], [-121.9334, 37.09311], [-121.92926, 37.09429], [-121.92814, 37.09429], [-121.92807, 37.09247], [-121.92768, 37.09126], [-121.92602, 37.09191], [-121.92581, 37.09156], [-121.92513, 37.08878], [-121.92606, 37.08835], [-121.92599, 37.0874], [-121.92455, 37.08523], [-121.91982, 37.08517], [-121.91944, 37.08506], [-121.91927, 37.08508], [-121.91897, 37.08494], [-121.91868, 37.08501], [-121.91831, 37.08489], [-121.91802, 37.08501], [-121.91779, 37.08501], [-121.91769, 37.08515], [-121.91769, 37.0854], [-121.91793, 37.08589], [-121.91788, 37.08602], [-121.91744, 37.0862], [-121.91738, 37.08639], [-121.91725, 37.08657], [-121.91709, 37.08693], [-121.91681, 37.08712], [-121.91668, 37.08752], [-121.91677, 37.08791], [-121.9167, 37.08801], [-121.91623, 37.08784], [-121.91614, 37.08808], [-121.9159, 37.08828], [-121.91582, 37.08841], [-121.9152, 37.08867], [-121.91471, 37.08912], [-121.91464, 37.08938], [-121.91477, 37.08986], [-121.91477, 37.09037], [-121.91485, 37.09064], [-121.9147, 37.09087], [-121.91473, 37.09136], [-121.91511, 37.09178], [-121.91546, 37.09201], [-121.91541, 37.09216], [-121.91411, 37.09231], [-121.91395, 37.09239], [-121.9138, 37.09236], [-121.91332, 37.09256], [-121.91329, 37.09276], [-121.91361, 37.09317], [-121.91371, 37.09346], [-121.91367, 37.09362], [-121.91371, 37.09391], [-121.91364, 37.09415], [-121.91331, 37.09427], [-121.913, 37.09428], [-121.91299, 37.09438], [-121.91318, 37.09452], [-121.91327, 37.09466], [-121.91351, 37.09461], [-121.91378, 37.09462], [-121.91439, 37.09461], [-121.9144, 37.09495], [-121.91426, 37.09518], [-121.91456, 37.09558], [-121.91361, 37.09752], [-121.91192, 37.10024], [-121.91188, 37.10017], [-121.91144, 37.09986], [-121.91134, 37.09956], [-121.91142, 37.099], [-121.91131, 37.09872], [-121.91136, 37.09762], [-121.91107, 37.09713], [-121.91036, 37.09687], [-121.91012, 37.09668], [-121.91012, 37.09606], [-121.91017, 37.09602], [-121.91005, 37.09578], [-121.91005, 37.09531], [-121.90995, 37.09484], [-121.90949, 37.09435], [-121.91084, 37.09353], [-121.91095, 37.0934], [-121.91107, 37.09321], [-121.91126, 37.09281], [-121.91148, 37.09253], [-121.9116, 37.09241], [-121.91212, 37.09212], [-121.91227, 37.09201], [-121.91236, 37.09192], [-121.91242, 37.09131], [-121.9124, 37.091], [-121.91237, 37.09083], [-121.91234, 37.09075], [-121.91224, 37.09059], [-121.91215, 37.0904], [-121.91211, 37.09016], [-121.91208, 37.08986], [-121.91192, 37.08912], [-121.91193, 37.08885], [-121.91192, 37.08857], [-121.91183, 37.08825], [-121.91175, 37.08786], [-121.91183, 37.08718], [-121.91198, 37.08674], [-121.91201, 37.08658], [-121.91205, 37.08633], [-121.91203, 37.08626], [-121.91202, 37.08608], [-121.91185, 37.08567], [-121.91173, 37.08545], [-121.91169, 37.08521], [-121.91177, 37.08492], [-121.91192, 37.08457], [-121.91199, 37.08449], [-121.91211, 37.08439], [-121.91261, 37.08406], [-121.91278, 37.08393], [-121.91291, 37.0838], [-121.91303, 37.08365], [-121.91303, 37.08364], [-121.91242, 37.0837], [-121.91183, 37.08358], [-121.91117, 37.08368], [-121.91093, 37.08364], [-121.91054, 37.08343], [-121.91025, 37.08337], [-121.90949, 37.08339], [-121.90882, 37.08368], [-121.90837, 37.08389], [-121.90779, 37.08424], [-121.90756, 37.0845], [-121.90674, 37.08497], [-121.90624, 37.08545], [-121.90573, 37.08607], [-121.90514, 37.08659], [-121.90455, 37.08684], [-121.90373, 37.08683], [-121.90275, 37.08659], [-121.90243, 37.08665], [-121.90195, 37.08699], [-121.90167, 37.08744], [-121.90155, 37.08768], [-121.90052, 37.08832], [-121.90025, 37.08864], [-121.89991, 37.08897], [-121.89959, 37.0891], [-121.89856, 37.0892], [-121.89833, 37.08931], [-121.89791, 37.08992], [-121.89766, 37.09021], [-121.89575, 37.09085], [-121.89552, 37.09109], [-121.89532, 37.09141], [-121.8947, 37.09157], [-121.8938, 37.09207], [-121.8935, 37.09234], [-121.89289, 37.0927], [-121.89154, 37.09267], [-121.88762, 37.09225], [-121.88736, 37.09205], [-121.88731, 37.09175], [-121.8872, 37.09164], [-121.8871, 37.09164], [-121.88678, 37.09169], [-121.88633, 37.09129], [-121.88593, 37.09118], [-121.88572, 37.09119], [-121.88543, 37.09123], [-121.88457, 37.09158], [-121.88415, 37.09163], [-121.88349, 37.09153], [-121.88325, 37.09153], [-121.88273, 37.09162], [-121.88232, 37.09147], [-121.88194, 37.09104], [-121.88175, 37.09089], [-121.88148, 37.09082], [-121.88111, 37.09086], [-121.88089, 37.09076], [-121.88028, 37.09043], [-121.87987, 37.09031], [-121.87876, 37.09019], [-121.87763, 37.09003], [-121.87683, 37.08997], [-121.87629, 37.0899], [-121.87585, 37.08971], [-121.87518, 37.08931], [-121.87496, 37.08925], [-121.8742, 37.08892], [-121.87273, 37.08853], [-121.87221, 37.08857], [-121.87188, 37.08845], [-121.87168, 37.0884], [-121.87131, 37.08854], [-121.8709, 37.08852], [-121.87044, 37.08828], [-121.87006, 37.08819], [-121.86897, 37.0882], [-121.8685, 37.08815], [-121.86829, 37.08796], [-121.86809, 37.08784], [-121.86763, 37.08767], [-121.86702, 37.08737], [-121.86633, 37.0872], [-121.86512, 37.08685], [-121.86405, 37.0866], [-121.86307, 37.08643], [-121.86212, 37.08605], [-121.86217, 37.07666], [-121.86257, 37.07666], [-121.86311, 37.0766], [-121.86366, 37.07689], [-121.86411, 37.07699], [-121.86442, 37.07708], [-121.86499, 37.07754], [-121.86555, 37.07812], [-121.86609, 37.07854], [-121.86645, 37.07862], [-121.86679, 37.07862], [-121.8672, 37.07875], [-121.86793, 37.07913], [-121.86873, 37.07928], [-121.87007, 37.07993], [-121.8707, 37.08009], [-121.87114, 37.08005], [-121.87158, 37.07988], [-121.87195, 37.07954], [-121.87246, 37.07968], [-121.87264, 37.07991], [-121.87284, 37.07998], [-121.87329, 37.07992], [-121.87369, 37.07974], [-121.87411, 37.07911], [-121.8743, 37.07891], [-121.87456, 37.07881], [-121.87491, 37.07881], [-121.87559, 37.0791], [-121.87623, 37.07928], [-121.87769, 37.07922], [-121.87795, 37.0793], [-121.87814, 37.08005], [-121.87836, 37.08036], [-121.87876, 37.0805], [-121.87923, 37.08054], [-121.87987, 37.08042], [-121.88081, 37.07996], [-121.88193, 37.07937], [-121.88232, 37.07906], [-121.88241, 37.07855], [-121.88279, 37.07817], [-121.88348, 37.07783], [-121.88391, 37.07748], [-121.88421, 37.07704], [-121.88428, 37.07639], [-121.88459, 37.07581], [-121.88475, 37.07529], [-121.88485, 37.07454], [-121.88509, 37.07429], [-121.88541, 37.07413], [-121.8858, 37.07412], [-121.88617, 37.07404], [-121.88701, 37.07371], [-121.88787, 37.07373], [-121.88831, 37.0737], [-121.88871, 37.0736], [-121.88938, 37.07364], [-121.89041, 37.07362], [-121.89093, 37.07374], [-121.89139, 37.0741], [-121.89218, 37.07418], [-121.89293, 37.0742], [-121.89349, 37.0743], [-121.89395, 37.07435], [-121.89456, 37.07464], [-121.895, 37.07474], [-121.89556, 37.07479], [-121.89626, 37.07475], [-121.89712, 37.07452], [-121.89779, 37.07428], [-121.89838, 37.07416], [-121.89942, 37.07414], [-121.90011, 37.07406], [-121.90076, 37.07408], [-121.90117, 37.07419], [-121.90167, 37.07442], [-121.90231, 37.07491], [-121.90301, 37.07493], [-121.90348, 37.07481], [-121.90409, 37.07469], [-121.90436, 37.07455], [-121.90551, 37.07424], [-121.90687, 37.07365], [-121.90761, 37.07341], [-121.90792, 37.07343], [-121.90855, 37.07342], [-121.90906, 37.0733], [-121.90938, 37.07303], [-121.90998, 37.07273], [-121.91022, 37.07271], [-121.9108, 37.07271], [-121.91138, 37.07246], [-121.91171, 37.07218], [-121.91191, 37.07212], [-121.91208, 37.0722], [-121.91261, 37.07251], [-121.91286, 37.0725], [-121.91306, 37.07239], [-121.91326, 37.072], [-121.91329, 37.07157], [-121.91346, 37.07104], [-121.91377, 37.07065], [-121.92441, 37.07077], [-121.92442, 37.07076], [-121.92435, 37.07052], [-121.92444, 37.07042], [-121.92503, 37.07011], [-121.92501, 37.06991], [-121.92485, 37.06968], [-121.92434, 37.06938], [-121.92432, 37.06933], [-121.92444, 37.06912], [-121.92477, 37.06884], [-121.92504, 37.06876], [-121.92534, 37.06881], [-121.92571, 37.06881], [-121.92593, 37.06878], [-121.92606, 37.06864], [-121.92614, 37.06847], [-121.93032, 37.06851], [-121.93857, 37.06844], [-121.93851, 37.06854], [-121.93827, 37.06856], [-121.93806, 37.06873], [-121.93836, 37.06922], [-121.93835, 37.06951], [-121.93811, 37.0699], [-121.93113, 37.07241], [-121.93442, 37.07651], [-121.93501, 37.0784], [-121.93238, 37.07854], [-121.93162, 37.08048], [-121.93352, 37.08387], [-121.93396, 37.08472], [-121.93513, 37.086], [-121.936, 37.0866], [-121.93548, 37.08655], [-121.9355, 37.08689], [-121.93575, 37.08703], [-121.93626, 37.08702], [-121.93642, 37.08689], [-121.93662, 37.08771], [-121.9376, 37.08853], [-121.93758, 37.08856], [-121.93776, 37.08877], [-121.93832, 37.08911], [-121.93902, 37.08932], [-121.93946, 37.08964], [-121.93931, 37.08973], [-121.9393, 37.08974], [-121.93984, 37.09012], [-121.94026, 37.09092], [-121.94199, 37.09322]]]} | Open Access 1 | 926 | Soquel Demonstration State Forest | 1372 | 202 | California Department of Forestry and Fire Protection 346 | State 5 | State Agency 5 | http://www.fire.ca.gov/ | Other State 5 | 202 | California Department of Forestry and Fire Protection 343 | State 5 | State Agency 5 | http://www.fire.ca.gov/resource_mgt/resource_mgt_stateforests_soquel.php | Santa Cruz 5 | 2735.523 | Soquel DSF | 0 | State Resource Management Area 55 | 3 |
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]);