units_with_maps

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

12 rows where DES_TP = 354

View and edit SQL

Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, COUNTY, LABEL_NAME, YR_EST

DES_TP

  • Private Agricultural · 12
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
4085 4084 {"type": "Polygon", "coordinates": [[[-122.41578, 37.23817], [-122.41569, 37.23824], [-122.40876, 37.23907], [-122.40848, 37.2366], [-122.40732, 37.23475], [-122.41318, 37.23173], [-122.41374, 37.23239], [-122.41406, 37.23283], [-122.41436, 37.23334], [-122.4146, 37.23387], [-122.41476, 37.23431], [-122.41487, 37.23475], [-122.41517, 37.23665], [-122.41524, 37.23699], [-122.41533, 37.23727], [-122.41546, 37.23759], [-122.41559, 37.23786], [-122.41578, 37.23817]]]} No Public Access 3 47457 Pebble Beach Farm 31170 3054 Peninsula Open Space Trust 338 Non Profit 6 Non Profit - Land Trust 10 http://www.openspacetrust.org/ Non Governmental Organization 10 3054 Peninsula Open Space Trust 335 Non Profit 6 Non Profit - Land Trust 10   San Mateo 15 95.575 Pebble Beach Farm 0 Private Agricultural 354 4
4329 4328 {"type": "Polygon", "coordinates": [[[-122.38517, 37.32725], [-122.38494, 37.32739], [-122.38456, 37.32774], [-122.38408, 37.32822], [-122.38366, 37.32869], [-122.38338, 37.32908], [-122.38289, 37.32997], [-122.38272, 37.3302], [-122.38257, 37.33035], [-122.38242, 37.33046], [-122.38208, 37.33065], [-122.38183, 37.33074], [-122.3794, 37.33144], [-122.37913, 37.33149], [-122.37883, 37.33149], [-122.37858, 37.33146], [-122.37838, 37.33141], [-122.37842, 37.33132], [-122.37781, 37.33039], [-122.37792, 37.32985], [-122.3777, 37.32951], [-122.37762, 37.32919], [-122.37805, 37.32924], [-122.37853, 37.32895], [-122.379, 37.32892], [-122.37937, 37.32876], [-122.38008, 37.32805], [-122.38082, 37.3248], [-122.38128, 37.32459], [-122.38265, 37.32446], [-122.3834, 37.32467], [-122.38409, 37.32473], [-122.38471, 37.32495], [-122.38517, 37.32725]]]} No Public Access 3 45471 San Gregorio Farm 33759 3054 Peninsula Open Space Trust 338 Non Profit 6 Non Profit - Land Trust 10 http://www.openspacetrust.org/ Non Governmental Organization 10 3054 Peninsula Open Space Trust 335 Non Profit 6 Non Profit - Land Trust 10   San Mateo 15 71.471 San Gregorio Farm 0 Private Agricultural 354 4
5951 5950 {"type": "Polygon", "coordinates": [[[-122.13572, 37.97756], [-122.13173, 37.97702], [-122.13064, 37.9769], [-122.13031, 37.97702], [-122.12902, 37.976], [-122.12723, 37.97528], [-122.12741, 37.97418], [-122.12748, 37.97401], [-122.12776, 37.97409], [-122.12803, 37.97406], [-122.12832, 37.97415], [-122.12851, 37.97406], [-122.12879, 37.97379], [-122.12957, 37.97372], [-122.12999, 37.97379], [-122.13061, 37.97367], [-122.13091, 37.97379], [-122.13243, 37.97472], [-122.13281, 37.97486], [-122.13315, 37.97511], [-122.13386, 37.97514], [-122.13446, 37.97527], [-122.13488, 37.97533], [-122.13524, 37.97586], [-122.13521, 37.97623], [-122.13562, 37.97692], [-122.13572, 37.97756]]]} Restricted Access 2 47322 West Hills Farm 31029 3045 John Muir Land Trust 108 Non Profit 6 Non Profit - Land Trust 10 http://www.jmlt.org/ Non Governmental Organization 10 3045 John Muir Land Trust 105 Non Profit 6 Non Profit - Land Trust 10 http://www.jmlt.org/ Contra Costa 12 45.463 West Hills Farm 0 Private Agricultural 354 4
10341 10340 {"type": "Polygon", "coordinates": [[[-121.80063, 36.71388], [-121.80041, 36.71423], [-121.7996, 36.71582], [-121.79919, 36.71731], [-121.79904, 36.71798], [-121.7999, 36.72298], [-121.79929, 36.72379], [-121.79896, 36.72387], [-121.79857, 36.72412], [-121.7987, 36.72467], [-121.79841, 36.72503], [-121.78914, 36.72115], [-121.78929, 36.72074], [-121.78951, 36.72025], [-121.78977, 36.71978], [-121.79008, 36.71932], [-121.79048, 36.71881], [-121.79226, 36.7168], [-121.79248, 36.71652], [-121.79262, 36.71625], [-121.79275, 36.7159], [-121.7928, 36.71561], [-121.7928, 36.71522], [-121.79283, 36.71498], [-121.79292, 36.71464], [-121.79304, 36.71435], [-121.79323, 36.71404], [-121.7935, 36.7137], [-121.79382, 36.71339], [-121.79419, 36.71313], [-121.79445, 36.71299], [-121.79473, 36.71286], [-121.79768, 36.71187], [-121.79791, 36.71182], [-121.79815, 36.71178], [-121.79842, 36.71177], [-121.79863, 36.71178], [-121.79889, 36.71183], [-121.79883, 36.712], [-121.79968, 36.71227], [-121.79995, 36.71261], [-121.80063, 36.71388]]]} No Public Access 3 18242 Ocean Mist Farm 23054 3042 Ag Land Trust 947 Non Profit 6 Non Profit - Land Trust 10 http://aglandtrust.org/ Non Governmental Organization 10 3042 Ag Land Trust 919 Non Profit 6 Non Profit - Land Trust 10   Monterey 14 222.013 Ocean Mist Farm 0 Private Agricultural 354 4
12072 12071 {"type": "Polygon", "coordinates": [[[-121.80298, 36.90656], [-121.80079, 36.90583], [-121.79959, 36.90978], [-121.79915, 36.91014], [-121.79852, 36.91054], [-121.79837, 36.91073], [-121.79829, 36.91092], [-121.79815, 36.91137], [-121.79801, 36.91174], [-121.7962, 36.91182], [-121.79546, 36.91077], [-121.79548, 36.9117], [-121.79406, 36.91079], [-121.79138, 36.91198], [-121.7909, 36.91005], [-121.78992, 36.90875], [-121.78817, 36.90682], [-121.7872, 36.90587], [-121.78927, 36.90449], [-121.78825, 36.90348], [-121.78962, 36.90254], [-121.78813, 36.90001], [-121.78886, 36.89953], [-121.79278, 36.89846], [-121.79056, 36.89453], [-121.79121, 36.89437], [-121.79235, 36.89414], [-121.79283, 36.89407], [-121.79355, 36.89401], [-121.7943, 36.89401], [-121.79467, 36.89403], [-121.79766, 36.89424], [-121.79821, 36.89431], [-121.79878, 36.89444], [-121.79908, 36.89454], [-121.79932, 36.89464], [-121.79921, 36.8947], [-121.79921, 36.89471], [-121.80228, 36.89656], [-121.80239, 36.89645], [-121.80244, 36.89698], [-121.80298, 36.90656]]]} Restricted Access 2 24771 Watsonville Slough Farms 27311 3036 Land Trust of Santa Cruz County 121 Non Profit 6 Non Profit - Land Trust 10 http://www.landtrustsantacruz.org/ Non Governmental Organization 10 3036 Land Trust of Santa Cruz County 118 Non Profit 6 Non Profit - Land Trust 10   Santa Cruz 5 489.686 Watsonville Slough Farms 0 Private Agricultural 354 4
12361 12360 {"type": "Polygon", "coordinates": [[[-122.51194, 37.55293], [-122.51175, 37.5529], [-122.51142, 37.5529], [-122.51116, 37.55285], [-122.5109, 37.55283], [-122.51049, 37.55289], [-122.5104, 37.55289], [-122.51017, 37.55282], [-122.50992, 37.55279], [-122.50984, 37.55282], [-122.50966, 37.55296], [-122.50957, 37.55297], [-122.50949, 37.55299], [-122.50915, 37.55295], [-122.50902, 37.55297], [-122.50904, 37.55116], [-122.50851, 37.54998], [-122.50883, 37.54911], [-122.51181, 37.54893], [-122.51174, 37.5492], [-122.51169, 37.54951], [-122.51167, 37.54981], [-122.51167, 37.55012], [-122.51175, 37.55091], [-122.51202, 37.55236], [-122.51194, 37.55293]]]} Restricted Access 2 46924 Ocean View Farms 30541 3054 Peninsula Open Space Trust 338 Non Profit 6 Non Profit - Land Trust 10 http://www.openspacetrust.org/ Non Governmental Organization 10 3054 Peninsula Open Space Trust 335 Non Profit 6 Non Profit - Land Trust 10   San Mateo 15 27.623 Ocean View Farms 0 Private Agricultural 354 4
13138 13137 {"type": "Polygon", "coordinates": [[[-122.28644, 37.82262], [-122.286, 37.82271], [-122.28597, 37.82264], [-122.28553, 37.82273], [-122.28539, 37.82229], [-122.28607, 37.82144], [-122.28644, 37.82262]]]} Open Access 1 45086 West Oakland Park and Urban Farm 28126 3350 City Slicker Farms 1044 Non Profit 6 Non Profit - Other 22 http://www.cityslickerfarms.org Non Governmental Organization 10 3350 City Slicker Farms 1005 Non Profit 6 Non Profit - Other 20   Alameda 17 1.868 West Oakland Park and Urban Farm 2016 Private Agricultural 354 4
14358 14357 {"type": "Polygon", "coordinates": [[[-122.40096, 37.23962], [-122.40071, 37.2399], [-122.39979, 37.24033], [-122.39908, 37.24045], [-122.399, 37.24071], [-122.39914, 37.24096], [-122.39919, 37.24122], [-122.39907, 37.24148], [-122.39804, 37.24293], [-122.39818, 37.24357], [-122.39811, 37.24416], [-122.39792, 37.24436], [-122.39766, 37.24437], [-122.39668, 37.24368], [-122.39622, 37.24363], [-122.3958, 37.24372], [-122.39558, 37.2439], [-122.3954, 37.24434], [-122.39538, 37.24469], [-122.39557, 37.24504], [-122.39559, 37.24531], [-122.39585, 37.24562], [-122.3959, 37.24576], [-122.39577, 37.24596], [-122.39542, 37.24613], [-122.39526, 37.24641], [-122.39536, 37.24762], [-122.39577, 37.24806], [-122.39611, 37.24815], [-122.39649, 37.24817], [-122.39688, 37.2483], [-122.39733, 37.24828], [-122.39736, 37.24843], [-122.39671, 37.24881], [-122.3966, 37.24925], [-122.39648, 37.24944], [-122.39607, 37.2498], [-122.39541, 37.24914], [-122.39414, 37.24644], [-122.39404, 37.24569], [-122.39065, 37.24423], [-122.39004, 37.24313], [-122.39062, 37.24161], [-122.38905, 37.241], [-122.38849, 37.242], [-122.38606, 37.24189], [-122.38515, 37.24199], [-122.38511, 37.24194], [-122.38479, 37.24206], [-122.38415, 37.24398], [-122.38401, 37.2453], [-122.38533, 37.24794], [-122.38517, 37.24844], [-122.3855, 37.2485], [-122.38553, 37.24866], [-122.38603, 37.24861], [-122.38586, 37.24929], [-122.3857, 37.24956], [-122.38562, 37.24968], [-122.38556, 37.24971], [-122.38537, 37.24972], [-122.38426, 37.24968], [-122.38359, 37.24923], [-122.38325, 37.24927], [-122.38257, 37.24927], [-122.38198, 37.24929], [-122.38168, 37.24952], [-122.38201, 37.25144], [-122.37991, 37.25173], [-122.37994, 37.25183], [-122.37901, 37.25199], [-122.37859, 37.25209], [-122.37822, 37.25221], [-122.37803, 37.25222], [-122.37762, 37.25246], [-122.37638, 37.25296], [-122.37554, 37.25306], [-122.37504, 37.25323], [-122.37505, 37.25119], [-122.37372, 37.25118], [-122.37374, 37.25103], [-122.37352, 37.25074], [-122.37327, 37.25014], [-122.37317, 37.25004], [-122.37274, 37.24994], [-122.37278, 37.24823], [-122.37508, 37.24754], [-122.37513, 37.23903], [-122.37523, 37.23564], [-122.36792, 37.23562], [-122.368, 37.23541], [-122.36792, 37.23507], [-122.36746, 37.23448], [-122.3669, 37.23403], [-122.36732, 37.23375], [-122.36773, 37.23421], [-122.36809, 37.23435], [-122.36894, 37.23418], [-122.36953, 37.23447], [-122.37007, 37.23374], [-122.3714, 37.23377], [-122.37199, 37.23386], [-122.37292, 37.23419], [-122.37472, 37.23417], [-122.3766, 37.23468], [-122.38228, 37.23162], [-122.38466, 37.2318], [-122.38685, 37.22939], [-122.38784, 37.22922], [-122.38959, 37.22943], [-122.39085, 37.22942], [-122.39244, 37.22884], [-122.39653, 37.23524], [-122.40096, 37.23962]]]} Restricted Access 2 44411 Butano Farms 16544 3054 Peninsula Open Space Trust 338 Non Profit 6 Non Profit - Land Trust 10 http://www.openspacetrust.org/ Non Governmental Organization 10 3054 Peninsula Open Space Trust 335 Non Profit 6 Non Profit - Land Trust 10   San Mateo 15 907.833 Butano Farms 0 Private Agricultural 354 4
14367 14366 {"type": "Polygon", "coordinates": [[[-120.89575, 38.77206], [-120.89569, 38.7757], [-120.89226, 38.77559], [-120.88668, 38.7755], [-120.88666, 38.77689], [-120.88636, 38.77689], [-120.88533, 38.77673], [-120.8842, 38.77672], [-120.88374, 38.77607], [-120.88346, 38.77538], [-120.8834, 38.77513], [-120.88364, 38.77442], [-120.8838, 38.77408], [-120.88402, 38.77386], [-120.88412, 38.77373], [-120.88422, 38.77354], [-120.88464, 38.7725], [-120.88339, 38.77217], [-120.88247, 38.77199], [-120.88103, 38.7716], [-120.88074, 38.77155], [-120.88022, 38.77076], [-120.87982, 38.77018], [-120.88005, 38.76937], [-120.88022, 38.76839], [-120.87781, 38.76803], [-120.87784, 38.76644], [-120.87907, 38.76639], [-120.87951, 38.76636], [-120.87988, 38.76637], [-120.88248, 38.76627], [-120.88339, 38.76626], [-120.88371, 38.76645], [-120.88383, 38.76683], [-120.88563, 38.76669], [-120.88553, 38.76647], [-120.88536, 38.76627], [-120.88498, 38.76597], [-120.88571, 38.76604], [-120.88809, 38.76659], [-120.88843, 38.76763], [-120.8883, 38.76776], [-120.88845, 38.76799], [-120.88889, 38.76804], [-120.89269, 38.76882], [-120.8928, 38.7691], [-120.89288, 38.76925], [-120.89318, 38.76973], [-120.89326, 38.76973], [-120.89396, 38.77094], [-120.8947, 38.77132], [-120.89538, 38.77175], [-120.89546, 38.77197], [-120.89575, 38.77206]], [[-120.88918, 38.77107], [-120.88858, 38.772], [-120.88999, 38.77375], [-120.89141, 38.77284], [-120.89124, 38.77239], [-120.8911, 38.77213], [-120.89067, 38.77179], [-120.89046, 38.77168], [-120.8901, 38.77139], [-120.88985, 38.77128], [-120.88918, 38.77107]]]} Open Access 1 44452 Wakamatsu Tea and Silk Colony Farm 29217 3003 American River Conservancy 604 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/ Non Governmental Organization 10 3003 American River Conservancy 593 Non Profit 6 Non Profit - Land Trust 10 http://www.arconservancy.org/site/c.psKZL3PFLrF/b.7719191/k.2889/Wakamatsu_Tea_and_Silk_Colony_Farm_historic_site_of_the_first_Japanese_Colony_in_the_United_States.htm El Dorado 34 263.063 Wakamatsu Tea and Silk Colony Farm 0 Private Agricultural 354 4
14592 14591 {"type": "Polygon", "coordinates": [[[-121.50388, 36.97423], [-121.49381, 36.97987], [-121.49263, 36.98059], [-121.49332, 36.98142], [-121.4935, 36.98161], [-121.49377, 36.98195], [-121.48591, 36.98642], [-121.48466, 36.98592], [-121.48745, 36.98306], [-121.48758, 36.9831], [-121.48771, 36.98296], [-121.48839, 36.98317], [-121.49944, 36.9734], [-121.50077, 36.97148], [-121.50388, 36.97423]]]} No Public Access 3 44803 Gonzales Farm 28146 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   Santa Clara 19 111.334 Gonzales Farm 0 Private Agricultural 354 4
14593 14592 {"type": "Polygon", "coordinates": [[[-121.50077, 36.97148], [-121.49944, 36.9734], [-121.48839, 36.98317], [-121.48771, 36.98296], [-121.48823, 36.98239], [-121.49949, 36.97035], [-121.50077, 36.97148]]]} No Public Access 3 44804 Gonzales Farm 28146 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   San Benito 38 59.149 Gonzales Farm 0 Private Agricultural 354 4
14746 14745 {"type": "Polygon", "coordinates": [[[-118.23664, 33.94324], [-118.23665, 33.94382], [-118.23662, 33.94385], [-118.23513, 33.94385], [-118.23512, 33.94321], [-118.2366, 33.94322], [-118.23664, 33.94324]]]} Open Access 1 45090 MudTown Farms 28055 3351 Watts Labor Community Action Committee 1122 Non Profit 6 Non Profit - Other 22 http://www.wlcac.org/ Non Governmental Organization 10 3351 Watts Labor Community Action Committee 1077 Non Profit 6 Non Profit - Other 20   Los Angeles 6 2.45 MudTown Farms 0 Private Agricultural 354 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 61.766ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette