superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and YR_EST = 1872
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 2
ACCESS_TYP 1
- Open Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
985 | 985 | 984 | {"type": "Polygon", "coordinates": [[[-121.82685, 37.39745], [-121.82424, 37.39805], [-121.82003, 37.39552], [-121.81608, 37.39627], [-121.81562, 37.39619], [-121.81561, 37.39615], [-121.81502, 37.39608], [-121.81467, 37.39602], [-121.81167, 37.39704], [-121.81219, 37.39905], [-121.81062, 37.39974], [-121.81059, 37.39974], [-121.81011, 37.39966], [-121.81005, 37.39967], [-121.8087, 37.40019], [-121.80763, 37.39844], [-121.80757, 37.39844], [-121.80283, 37.39978], [-121.80112, 37.40036], [-121.79831, 37.4024], [-121.79418, 37.40641], [-121.78972, 37.40606], [-121.78961, 37.40571], [-121.78868, 37.40542], [-121.78834, 37.40549], [-121.78804, 37.40512], [-121.78726, 37.40494], [-121.78686, 37.40469], [-121.78657, 37.40468], [-121.78595, 37.4025], [-121.78513, 37.40055], [-121.78517, 37.39729], [-121.78521, 37.39698], [-121.78531, 37.39685], [-121.78492, 37.39673], [-121.78477, 37.39615], [-121.78472, 37.39609], [-121.78424, 37.39609], [-121.78386, 37.39578], [-121.78391, 37.39562], [-121.78424, 37.39524], [-121.78401, 37.3949], [-121.78388, 37.39414], [-121.78402, 37.39371], [-121.78388, 37.39348], [-121.78347, 37.39319], [-121.78345, 37.3928], [-121.78389, 37.39245], [-121.78387, 37.39171], [-121.78374, 37.3915], [-121.78559, 37.39101], [-121.78626, 37.39258], [-121.78877, 37.39788], [-121.78915, 37.39916], [-121.79264, 37.40064], [-121.79365, 37.39904], [-121.79415, 37.39821], [-121.79497, 37.39394], [-121.80037, 37.3915], [-121.80159, 37.39139], [-121.80345, 37.39415], [-121.80326, 37.39439], [-121.80328, 37.39444], [-121.80321, 37.39452], [-121.80322, 37.39454], [-121.80471, 37.39468], [-121.80596, 37.39492], [-121.80598, 37.39494], [-121.80605, 37.39495], [-121.80777, 37.39469], [-121.80787, 37.39371], [-121.8078, 37.39304], [-121.80771, 37.39282], [-121.80764, 37.39282], [-121.80761, 37.39269], [-121.80761, 37.39231], [-121.80771, 37.39227], [-121.8077, 37.39212], [-121.80831, 37.39186], [-121.80848, 37.39196], [-121.80871, 37.39201], [-121.80865, 37.39234], [-121.8095, 37.39298], [-121.80954, 37.39292], [-121.80984, 37.39268], [-121.80972, 37.39233], [-121.80957, 37.39176], [-121.80955, 37.39175], [-121.80951, 37.39178], [-121.80945, 37.39162], [-121.80957, 37.39134], [-121.81049, 37.39152], [-121.81104, 37.3915], [-121.81293, 37.39206], [-121.8144, 37.39192], [-121.81502, 37.392], [-121.81538, 37.39189], [-121.8162, 37.39211], [-121.8163, 37.3921], [-121.81669, 37.39222], [-121.81684, 37.39233], [-121.81744, 37.39247], [-121.81744, 37.3925], [-121.8189, 37.3932], [-121.81893, 37.39319], [-121.81939, 37.39342], [-121.82085, 37.39349], [-121.82129, 37.39353], [-121.82187, 37.39419], [-121.8219, 37.39421], [-121.82199, 37.39431], [-121.82331, 37.39469], [-121.82365, 37.39481], [-121.82426, 37.39467], [-121.8252, 37.39455], [-121.82543, 37.39509], [-121.82559, 37.39516], [-121.82639, 37.39655], [-121.82685, 37.39745]]]} | Open Access 1 | Alum Rock | http://www.sanjoseca.gov/?nid=2819 | 11074 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 640.224 | Alum Rock | 1872 |
8075 | 8075 | 8074 | {"type": "MultiPolygon", "coordinates": [[[[-121.84261, 37.39116], [-121.83907, 37.39173], [-121.8399, 37.39348], [-121.83764, 37.39413], [-121.83749, 37.39381], [-121.83634, 37.39411], [-121.83603, 37.39346], [-121.83535, 37.39365], [-121.83514, 37.39351], [-121.83479, 37.39284], [-121.8337, 37.3931], [-121.83358, 37.393], [-121.83348, 37.39314], [-121.83263, 37.39373], [-121.83233, 37.3939], [-121.83214, 37.39398], [-121.82811, 37.39532], [-121.82797, 37.3957], [-121.82734, 37.39585], [-121.82686, 37.39587], [-121.82686, 37.39615], [-121.82657, 37.39644], [-121.82651, 37.39643], [-121.82639, 37.39655], [-121.82559, 37.39517], [-121.82544, 37.3951], [-121.82551, 37.39493], [-121.82557, 37.39484], [-121.82568, 37.39476], [-121.82588, 37.39468], [-121.82608, 37.39465], [-121.82667, 37.39478], [-121.82741, 37.39505], [-121.82806, 37.39512], [-121.82842, 37.39499], [-121.82857, 37.39487], [-121.8294, 37.39408], [-121.82951, 37.39402], [-121.83052, 37.39357], [-121.83173, 37.39376], [-121.83224, 37.39365], [-121.83249, 37.39357], [-121.83269, 37.39339], [-121.83297, 37.39307], [-121.83327, 37.39283], [-121.83361, 37.3927], [-121.8347, 37.3924], [-121.83525, 37.392], [-121.83651, 37.39168], [-121.8373, 37.39157], [-121.83839, 37.39145], [-121.83978, 37.39108], [-121.84077, 37.39065], [-121.84249, 37.3909], [-121.84261, 37.39116]]], [[[-121.85173, 37.39157], [-121.85015, 37.39234], [-121.84982, 37.39254], [-121.84831, 37.39325], [-121.84618, 37.3903], [-121.84612, 37.39031], [-121.84611, 37.39032], [-121.84647, 37.39083], [-121.84326, 37.39189], [-121.84258, 37.39055], [-121.84259, 37.39049], [-121.84262, 37.39045], [-121.84295, 37.39028], [-121.84316, 37.39012], [-121.84333, 37.39004], [-121.8438, 37.38991], [-121.84439, 37.38982], [-121.84481, 37.38971], [-121.84507, 37.38962], [-121.84617, 37.38915], [-121.847, 37.38883], [-121.84745, 37.38873], [-121.84784, 37.38869], [-121.84857, 37.38873], [-121.849, 37.38872], [-121.84936, 37.3887], [-121.84959, 37.38864], [-121.85024, 37.38952], [-121.84926, 37.38971], [-121.84925, 37.38972], [-121.84935, 37.39009], [-121.84947, 37.39038], [-121.84955, 37.39054], [-121.84976, 37.39084], [-121.85002, 37.39131], [-121.85054, 37.39119], [-121.85122, 37.39088], [-121.85173, 37.39157]]], [[[-121.8495, 37.38752], [-121.84953, 37.38759], [-121.84953, 37.38769], [-121.8495, 37.38778], [-121.84928, 37.38818], [-121.84922, 37.38848], [-121.84897, 37.38856], [-121.84868, 37.38858], [-121.84862, 37.38858], [-121.84859, 37.38856], [-121.84858, 37.38853], [-121.84862, 37.38848], [-121.84864, 37.38844], [-121.84863, 37.3884], [-121.84859, 37.38835], [-121.8486, 37.38826], [-121.84865, 37.38811], [-121.84876, 37.38795], [-121.84887, 37.38784], [-121.84898, 37.38775], [-121.84942, 37.3875], [-121.8495, 37.38752]]], [[[-121.8564, 37.38301], [-121.85638, 37.38306], [-121.85412, 37.38465], [-121.854, 37.38475], [-121.85397, 37.38489], [-121.85326, 37.38521], [-121.85322, 37.38518], [-121.853, 37.38533], [-121.85277, 37.3856], [-121.8527, 37.38569], [-121.85248, 37.38617], [-121.8524, 37.38627], [-121.85226, 37.38638], [-121.85171, 37.38635], [-121.85151, 37.38647], [-121.8512, 37.38685], [-121.85081, 37.38712], [-121.85023, 37.38779], [-121.85011, 37.38764], [-121.84988, 37.38782], [-121.84989, 37.38784], [-121.85007, 37.38797], [-121.85006, 37.38798], [-121.84944, 37.38838], [-121.84943, 37.3883], [-121.84945, 37.38821], [-121.84963, 37.38787], [-121.8497, 37.38771], [-121.8497, 37.3876], [-121.84968, 37.38751], [-121.84962, 37.3874], [-121.84965, 37.38735], [-121.84963, 37.38732], [-121.84986, 37.38716], [-121.85123, 37.38607], [-121.85025, 37.38465], [-121.85052, 37.38453], [-121.85054, 37.38443], [-121.8507, 37.38439], [-121.85126, 37.38416], [-121.85132, 37.38412], [-121.85134, 37.38407], [-121.85133, 37.38401], [-121.85115, 37.38372], [-121.85117, 37.38369], [-121.85102, 37.38347], [-121.85101, 37.38342], [-121.85195, 37.38279], [-121.852, 37.38275], [-121.85203, 37.38267], [-121.8522, 37.3827], [-121.85189, 37.38293], [-121.85302, 37.38403], [-121.85382, 37.38486], [-121.85406, 37.38454], [-121.85425, 37.38376], [-121.85477, 37.38309], [-121.85562, 37.38231], [-121.85637, 37.38296], [-121.8564, 37.38301]]], [[[-121.85914, 37.38164], [-121.85847, 37.38104], [-121.85638, 37.38252], [-121.85608, 37.38226], [-121.85602, 37.38231], [-121.85588, 37.38217], [-121.85594, 37.3821], [-121.85582, 37.38199], [-121.85602, 37.38185], [-121.85629, 37.38155], [-121.85716, 37.38084], [-121.85739, 37.38069], [-121.85741, 37.38023], [-121.85771, 37.38002], [-121.85791, 37.38022], [-121.85855, 37.38093], [-121.85914, 37.38164]]], [[[-121.86118, 37.37735], [-121.86087, 37.37798], [-121.86079, 37.37825], [-121.8603, 37.37901], [-121.8601, 37.3791], [-121.86029, 37.37934], [-121.85926, 37.38006], [-121.85873, 37.37951], [-121.85851, 37.37957], [-121.8585, 37.37936], [-121.85954, 37.37905], [-121.85997, 37.37879], [-121.86029, 37.37845], [-121.86039, 37.37829], [-121.86075, 37.37722], [-121.86082, 37.37676], [-121.86085, 37.37671], [-121.86091, 37.37667], [-121.86097, 37.37666], [-121.86101, 37.37667], [-121.86117, 37.37684], [-121.8611, 37.37703], [-121.86118, 37.37735]]], [[[-121.86152, 37.37246], [-121.86128, 37.37648], [-121.86128, 37.37648], [-121.85963, 37.37483], [-121.85908, 37.37422], [-121.85905, 37.37411], [-121.85907, 37.37405], [-121.85909, 37.37402], [-121.86147, 37.37241], [-121.86152, 37.37246]]], [[[-121.86471, 37.37031], [-121.86175, 37.3723], [-121.86171, 37.37224], [-121.86323, 37.3712], [-121.8645, 37.37036], [-121.86471, 37.37031]]], [[[-121.86796, 37.36965], [-121.8679, 37.36974], [-121.86781, 37.3697], [-121.86615, 37.36954], [-121.86607, 37.3695], [-121.86599, 37.36949], [-121.86589, 37.36949], [-121.86575, 37.36952], [-121.86589, 37.36933], [-121.86603, 37.36942], [-121.86625, 37.36947], [-121.86796, 37.36965]]], [[[-121.8694, 37.37001], [-121.8693, 37.37008], [-121.8692, 37.37008], [-121.86908, 37.37003], [-121.86895, 37.36995], [-121.86876, 37.36991], [-121.86851, 37.36982], [-121.8694, 37.37001]]], [[[-121.87178, 37.37067], [-121.87149, 37.37068], [-121.87129, 37.37065], [-121.87106, 37.37058], [-121.87087, 37.37048], [-121.87041, 37.37061], [-121.86986, 37.37067], [-121.87064, 37.37051], [-121.87095, 37.37043], [-121.87117, 37.37057], [-121.8717, 37.37057], [-121.87178, 37.37067]]], [[[-121.87108, 37.36983], [-121.87029, 37.37016], [-121.87003, 37.36983], [-121.87014, 37.36984], [-121.87026, 37.36988], [-121.87092, 37.3696], [-121.87108, 37.36983]]]]} | Open Access 1 | Penitencia Creek Park | 23582 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 143.337 | Penitencia Creek Park | 1872 |
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]);