units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 2 and UNIT_NAME = "Cosumnes River Preserve"
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_ID, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_ID
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2734 | 2734 | 2733 | {"type": "Polygon", "coordinates": [[[-121.33438, 38.34361], [-121.33319, 38.34464], [-121.33304, 38.34475], [-121.33156, 38.34376], [-121.32059, 38.34373], [-121.31587, 38.3413], [-121.31593, 38.33691], [-121.31584, 38.33662], [-121.33219, 38.33672], [-121.33217, 38.33698], [-121.33427, 38.34166], [-121.33351, 38.34218], [-121.33376, 38.3427], [-121.33414, 38.34327], [-121.33438, 38.34361]]]} | Restricted Access 2 | 21422 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 286.086 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
2735 | 2735 | 2734 | {"type": "Polygon", "coordinates": [[[-121.37929, 38.26206], [-121.37925, 38.26667], [-121.36993, 38.26662], [-121.36997, 38.26204], [-121.37929, 38.26206]]]} | Restricted Access 2 | 21423 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 102.78 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
3108 | 3108 | 3107 | {"type": "MultiPolygon", "coordinates": [[[[-121.46234, 38.2686], [-121.46231, 38.26876], [-121.46161, 38.26911], [-121.46002, 38.26922], [-121.45923, 38.26938], [-121.45839, 38.2697], [-121.45775, 38.26965], [-121.45753, 38.26953], [-121.45774, 38.2673], [-121.45781, 38.26714], [-121.4579, 38.2664], [-121.45801, 38.26606], [-121.4583, 38.26581], [-121.45862, 38.26576], [-121.45932, 38.26588], [-121.46083, 38.2659], [-121.46118, 38.26624], [-121.46112, 38.26713], [-121.46132, 38.26782], [-121.46167, 38.26823], [-121.46211, 38.2684], [-121.46234, 38.2686]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68418, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]} | Restricted Access 2 | 25288 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 35.364 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
11084 | 11084 | 11083 | {"type": "Polygon", "coordinates": [[[-121.4649, 38.3205], [-121.46195, 38.32051], [-121.44506, 38.32078], [-121.44502, 38.32049], [-121.44467, 38.32051], [-121.44283, 38.30486], [-121.46162, 38.30476], [-121.4649, 38.3205]]]} | Restricted Access 2 | 21325 | Cosumnes River Preserve | 17680 | 1097 | Elk Grove, City of 963 | City 2 | City Agency 2 | http://www.elkgrovecity.org/ | City 2 | 1097 | Elk Grove, City of 931 | City 2 | City Agency 2 | Sacramento 41 | 740.158 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
11133 | 11133 | 11132 | {"type": "Polygon", "coordinates": [[[-121.51691, 38.25947], [-121.50965, 38.26426], [-121.5083, 38.26215], [-121.50771, 38.26135], [-121.5073, 38.26083], [-121.50498, 38.25966], [-121.50269, 38.25821], [-121.5029, 38.25787], [-121.50312, 38.25794], [-121.50676, 38.25202], [-121.50862, 38.25131], [-121.50878, 38.25131], [-121.50893, 38.25149], [-121.50982, 38.25136], [-121.5103, 38.25196], [-121.51058, 38.25188], [-121.51111, 38.25283], [-121.51144, 38.25331], [-121.5121, 38.2541], [-121.51264, 38.25478], [-121.51317, 38.25533], [-121.51401, 38.25612], [-121.51486, 38.25683], [-121.51562, 38.2574], [-121.51648, 38.25796], [-121.51562, 38.25854], [-121.51691, 38.25947]]]} | Restricted Access 2 | 21424 | Cosumnes River Preserve | 17679 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 229.043 | Cosumnes River Preserve | 0 | Local Conservation Area 4 | 2 | |
11278 | 11278 | 11277 | {"type": "MultiPolygon", "coordinates": [[[[-121.47063, 38.2699], [-121.4706, 38.27064], [-121.45934, 38.27057], [-121.45744, 38.27053], [-121.45753, 38.26953], [-121.45775, 38.26965], [-121.45839, 38.2697], [-121.45923, 38.26938], [-121.46002, 38.26922], [-121.46161, 38.26911], [-121.46231, 38.26876], [-121.46234, 38.2686], [-121.46211, 38.2684], [-121.46167, 38.26823], [-121.46132, 38.26782], [-121.46112, 38.26713], [-121.46118, 38.26625], [-121.46083, 38.2659], [-121.45932, 38.26588], [-121.45862, 38.26576], [-121.45831, 38.26581], [-121.45801, 38.26607], [-121.4579, 38.2664], [-121.45781, 38.26714], [-121.45774, 38.2673], [-121.45767, 38.2673], [-121.45787, 38.26584], [-121.45678, 38.26697], [-121.4556, 38.26691], [-121.45491, 38.26671], [-121.45329, 38.26679], [-121.45334, 38.26641], [-121.45342, 38.2664], [-121.45386, 38.26294], [-121.45446, 38.25887], [-121.45447, 38.25847], [-121.45468, 38.2569], [-121.45524, 38.25732], [-121.45555, 38.2575], [-121.45556, 38.25748], [-121.45578, 38.25759], [-121.45787, 38.25723], [-121.45864, 38.25732], [-121.45909, 38.25763], [-121.45934, 38.25812], [-121.45982, 38.25857], [-121.46072, 38.25902], [-121.46149, 38.25921], [-121.46136, 38.26017], [-121.46129, 38.2603], [-121.46105, 38.26172], [-121.46263, 38.26384], [-121.46222, 38.26635], [-121.46232, 38.26641], [-121.46232, 38.26645], [-121.46266, 38.26659], [-121.46431, 38.26748], [-121.46447, 38.26828], [-121.46365, 38.26984], [-121.47063, 38.2699]]], [[[-121.50963, 38.2458], [-121.50927, 38.24638], [-121.50921, 38.24636], [-121.50864, 38.24741], [-121.50384, 38.24617], [-121.5037, 38.24612], [-121.50353, 38.24609], [-121.50271, 38.24588], [-121.50332, 38.25019], [-121.50249, 38.25022], [-121.50189, 38.25041], [-121.50176, 38.25041], [-121.50146, 38.25033], [-121.50137, 38.25027], [-121.50135, 38.2503], [-121.5013, 38.25028], [-121.50021, 38.25049], [-121.50021, 38.25051], [-121.5007, 38.25092], [-121.50104, 38.25101], [-121.50058, 38.25107], [-121.50044, 38.25101], [-121.50033, 38.25084], [-121.50004, 38.2507], [-121.49992, 38.25044], [-121.49966, 38.25014], [-121.49947, 38.24987], [-121.49933, 38.24952], [-121.49916, 38.24938], [-121.49894, 38.24893], [-121.4988, 38.24871], [-121.49867, 38.24842], [-121.49845, 38.24755], [-121.49846, 38.24721], [-121.4984, 38.24683], [-121.49827, 38.24643], [-121.49813, 38.2461], [-121.49781, 38.24554], [-121.49768, 38.24512], [-121.49757, 38.24494], [-121.49745, 38.24449], [-121.49737, 38.24423], [-121.49733, 38.24387], [-121.49726, 38.24348], [-121.49726, 38.24268], [-121.49731, 38.24198], [-121.49738, 38.24147], [-121.49733, 38.24066], [-121.49736, 38.24046], [-121.49739, 38.2404], [-121.49744, 38.24035], [-121.49751, 38.24033], [-121.49763, 38.24034], [-121.49767, 38.2403], [-121.49771, 38.24021], [-121.49806, 38.24029], [-121.498, 38.24057], [-121.49802, 38.2411], [-121.49806, 38.24127], [-121.49818, 38.24151], [-121.49846, 38.24191], [-121.49871, 38.24222], [-121.49906, 38.24253], [-121.49937, 38.24273], [-121.49966, 38.24285], [-121.50023, 38.24302], [-121.5084, 38.24517], [-121.50877, 38.24532], [-121.50886, 38.24538], [-121.50905, 38.24565], [-121.50963, 38.2458]]]]} | Restricted Access 2 | 21796 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 329.27 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
13925 | 13925 | 13924 | {"type": "MultiPolygon", "coordinates": [[[[-121.42884, 38.25745], [-121.42668, 38.25702], [-121.42528, 38.25894], [-121.42541, 38.26004], [-121.42473, 38.26004], [-121.42481, 38.26013], [-121.42492, 38.26134], [-121.42445, 38.26133], [-121.4244, 38.26068], [-121.4242, 38.26048], [-121.42356, 38.2608], [-121.42246, 38.26102], [-121.42229, 38.26121], [-121.42249, 38.26133], [-121.41767, 38.26132], [-121.41768, 38.26086], [-121.4176, 38.26002], [-121.41054, 38.26001], [-121.41046, 38.2696], [-121.40484, 38.26957], [-121.40485, 38.26886], [-121.40495, 38.26879], [-121.40595, 38.26827], [-121.40645, 38.26804], [-121.40687, 38.26777], [-121.40753, 38.26743], [-121.40777, 38.26728], [-121.40786, 38.26716], [-121.40863, 38.26543], [-121.40884, 38.26455], [-121.40887, 38.26428], [-121.40875, 38.26395], [-121.40855, 38.2636], [-121.4085, 38.26332], [-121.40852, 38.26314], [-121.40874, 38.26284], [-121.40882, 38.26243], [-121.40864, 38.26199], [-121.40843, 38.26173], [-121.40784, 38.2612], [-121.40789, 38.26079], [-121.40811, 38.26037], [-121.40873, 38.25947], [-121.40883, 38.25915], [-121.40879, 38.25872], [-121.40882, 38.25859], [-121.40891, 38.25851], [-121.40987, 38.25812], [-121.41021, 38.25792], [-121.41027, 38.25761], [-121.41019, 38.25731], [-121.40993, 38.25703], [-121.40961, 38.25681], [-121.40928, 38.25665], [-121.40909, 38.25652], [-121.40905, 38.25631], [-121.40906, 38.25616], [-121.40917, 38.25588], [-121.40923, 38.25559], [-121.40919, 38.25522], [-121.40912, 38.25493], [-121.40955, 38.25468], [-121.40923, 38.25439], [-121.40885, 38.2546], [-121.40871, 38.2547], [-121.40861, 38.25487], [-121.40871, 38.25527], [-121.40874, 38.25558], [-121.40869, 38.25579], [-121.40857, 38.25608], [-121.40856, 38.25633], [-121.40863, 38.25672], [-121.40899, 38.25696], [-121.40932, 38.25712], [-121.40957, 38.25729], [-121.40974, 38.25747], [-121.40977, 38.25762], [-121.40976, 38.2577], [-121.40961, 38.25779], [-121.40862, 38.2582], [-121.40836, 38.25841], [-121.4083, 38.2587], [-121.40834, 38.25912], [-121.40827, 38.25933], [-121.40766, 38.2602], [-121.40741, 38.26069], [-121.40734, 38.26132], [-121.40765, 38.26165], [-121.40805, 38.26197], [-121.4082, 38.26215], [-121.40832, 38.26246], [-121.40827, 38.26271], [-121.40805, 38.26301], [-121.408, 38.26333], [-121.40808, 38.26371], [-121.40829, 38.26408], [-121.40837, 38.26431], [-121.40835, 38.2645], [-121.40816, 38.26533], [-121.4074, 38.26702], [-121.40724, 38.26712], [-121.40659, 38.26746], [-121.40618, 38.26772], [-121.40569, 38.26794], [-121.40466, 38.26848], [-121.40446, 38.26861], [-121.40436, 38.26876], [-121.40436, 38.26929], [-121.40432, 38.26956], [-121.39215, 38.26949], [-121.39224, 38.26209], [-121.39776, 38.2621], [-121.39827, 38.26167], [-121.39866, 38.26069], [-121.39865, 38.25957], [-121.39916, 38.25819], [-121.3998, 38.25771], [-121.40069, 38.25608], [-121.40116, 38.25575], [-121.40126, 38.25502], [-121.40216, 38.2541], [-121.4041, 38.25411], [-121.40433, 38.25417], [-121.40522, 38.25423], [-121.40602, 38.25411], [-121.40637, 38.2538], [-121.40648, 38.25364], [-121.40855, 38.25364], [-121.41058, 38.25406], [-121.41059, 38.25414], [-121.42873, 38.25424], [-121.42884, 38.25745]]], [[[-121.42582, 38.27583], [-121.42168, 38.27584], [-121.4222, 38.27507], [-121.42063, 38.26884], [-121.42183, 38.26861], [-121.42579, 38.26863], [-121.42582, 38.27583]]]]} | Restricted Access 2 | 46984 | Cosumnes River Preserve | 30623 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | Sacramento 41 | 846.751 | Cosumnes River Preserve | 0 | Private Conservation 16 | 2 |
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]);