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

5 rows where ACCESS_TYP = 3 and MNG_AGENCY = 29

View and edit SQL

MNG_AG_TYP

MNG_AGENCY

  • Santa Rosa, City of · 5

ACCESS_TYP

  • No Public Access · 5
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
1452 1451 {"type": "MultiPolygon", "coordinates": [[[[-122.77242, 38.38856], [-122.77237, 38.38856], [-122.77228, 38.38852], [-122.77236, 38.38852], [-122.77242, 38.38856]]], [[[-122.78653, 38.39443], [-122.78225, 38.39597], [-122.77744, 38.39198], [-122.77726, 38.39206], [-122.77695, 38.39211], [-122.77686, 38.39216], [-122.77651, 38.39193], [-122.77658, 38.39187], [-122.77677, 38.39178], [-122.77708, 38.3917], [-122.77709, 38.39169], [-122.77328, 38.38856], [-122.77867, 38.38851], [-122.77897, 38.38833], [-122.77912, 38.38832], [-122.77993, 38.38786], [-122.78653, 38.39443]]], [[[-122.79813, 38.3852], [-122.79796, 38.38596], [-122.7971, 38.38672], [-122.79711, 38.38673], [-122.79756, 38.38673], [-122.79756, 38.38824], [-122.79762, 38.38827], [-122.79761, 38.38881], [-122.7974, 38.38973], [-122.79746, 38.39027], [-122.79521, 38.39118], [-122.79444, 38.39148], [-122.78668, 38.39437], [-122.78491, 38.39263], [-122.78087, 38.38859], [-122.78007, 38.38777], [-122.7815, 38.38698], [-122.78782, 38.38684], [-122.78778, 38.38579], [-122.78764, 38.38578], [-122.78757, 38.38314], [-122.79463, 38.38229], [-122.79484, 38.38244], [-122.79564, 38.38276], [-122.79618, 38.38313], [-122.79632, 38.38369], [-122.79703, 38.38415], [-122.79707, 38.38419], [-122.79708, 38.38424], [-122.79813, 38.3852]]]]} No Public Access 3 Alpha Farm   15405 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 410.933 Alpha Farm  
1864 1863 {"type": "Polygon", "coordinates": [[[-122.79598, 38.68638], [-122.79593, 38.68645], [-122.79587, 38.68663], [-122.79584, 38.68702], [-122.79582, 38.68712], [-122.79577, 38.68724], [-122.79549, 38.68779], [-122.79545, 38.68786], [-122.79501, 38.68816], [-122.79483, 38.68832], [-122.79478, 38.6885], [-122.79478, 38.68903], [-122.79483, 38.68923], [-122.79486, 38.68944], [-122.79482, 38.68962], [-122.79478, 38.68969], [-122.79471, 38.68978], [-122.79457, 38.68984], [-122.79425, 38.68987], [-122.79372, 38.68983], [-122.79362, 38.68984], [-122.79311, 38.68994], [-122.79276, 38.69005], [-122.79265, 38.69012], [-122.79244, 38.6902], [-122.79194, 38.69034], [-122.79183, 38.69038], [-122.79175, 38.69043], [-122.79171, 38.6905], [-122.79168, 38.69063], [-122.79137, 38.69088], [-122.79073, 38.69135], [-122.79069, 38.69141], [-122.79067, 38.69148], [-122.7907, 38.6916], [-122.79102, 38.69195], [-122.79109, 38.69208], [-122.79115, 38.69228], [-122.79115, 38.69241], [-122.79113, 38.69252], [-122.79101, 38.69282], [-122.79094, 38.6929], [-122.79085, 38.69297], [-122.79052, 38.69312], [-122.79023, 38.69322], [-122.79012, 38.69328], [-122.78934, 38.69224], [-122.78925, 38.6893], [-122.78809, 38.68905], [-122.7847, 38.68871], [-122.78467, 38.68598], [-122.79598, 38.68638]]]} No Public Access 3 Bear Canyon   15921 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 98.24 Bear Canyon  
2300 2299 {"type": "MultiPolygon", "coordinates": [[[[-122.81587, 38.40123], [-122.81272, 38.40264], [-122.81266, 38.4026], [-122.81259, 38.40252], [-122.81251, 38.40232], [-122.8125, 38.40212], [-122.81253, 38.40196], [-122.81251, 38.40187], [-122.81245, 38.40185], [-122.81236, 38.40191], [-122.81224, 38.40206], [-122.81216, 38.4022], [-122.81215, 38.40227], [-122.8122, 38.40247], [-122.81207, 38.40279], [-122.81206, 38.40286], [-122.8121, 38.40292], [-122.80774, 38.40488], [-122.80551, 38.40586], [-122.80424, 38.40644], [-122.80102, 38.40784], [-122.80079, 38.40792], [-122.80001, 38.40832], [-122.79906, 38.40885], [-122.79838, 38.40919], [-122.79601, 38.41007], [-122.79446, 38.41071], [-122.79431, 38.4105], [-122.7948, 38.41031], [-122.7948, 38.41029], [-122.79468, 38.41014], [-122.79451, 38.41029], [-122.79424, 38.4104], [-122.79317, 38.40885], [-122.79019, 38.40445], [-122.79012, 38.40432], [-122.78868, 38.40221], [-122.7934, 38.40115], [-122.81277, 38.39668], [-122.81331, 38.39672], [-122.81342, 38.39753], [-122.81363, 38.39754], [-122.81382, 38.39773], [-122.81484, 38.39865], [-122.81524, 38.39907], [-122.8155, 38.39927], [-122.8156, 38.39953], [-122.81568, 38.40008], [-122.81565, 38.40089], [-122.81569, 38.40107], [-122.81573, 38.40118], [-122.81584, 38.40118], [-122.81587, 38.40123]], [[-122.79166, 38.40561], [-122.7905, 38.40387], [-122.79017, 38.40336], [-122.79016, 38.40336], [-122.79016, 38.40341], [-122.79022, 38.40352], [-122.7916, 38.40558], [-122.79165, 38.40562], [-122.79166, 38.40561]], [[-122.79449, 38.40987], [-122.7939, 38.40892], [-122.7932, 38.40791], [-122.79289, 38.40741], [-122.79266, 38.40708], [-122.79264, 38.40708], [-122.79309, 38.40795], [-122.79429, 38.41005], [-122.79431, 38.41005], [-122.79449, 38.40987]]], [[[-122.81641, 38.40121], [-122.81554, 38.4016], [-122.81554, 38.40315], [-122.81577, 38.40353], [-122.8131, 38.40439], [-122.80605, 38.40685], [-122.79987, 38.40907], [-122.79972, 38.40883], [-122.80116, 38.40807], [-122.80147, 38.40794], [-122.80164, 38.40818], [-122.80555, 38.4068], [-122.80919, 38.40545], [-122.81178, 38.40453], [-122.81178, 38.40451], [-122.81153, 38.40448], [-122.81074, 38.40427], [-122.81033, 38.40411], [-122.81012, 38.40399], [-122.81108, 38.40358], [-122.81322, 38.40262], [-122.81613, 38.40122], [-122.81641, 38.40121]]]]} No Public Access 3 Brown Farm   16443 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 468.353 Brown Farm  
5694 5693 {"type": "Polygon", "coordinates": [[[-122.81259, 38.40564], [-122.81258, 38.40688], [-122.81096, 38.40685], [-122.81095, 38.40686], [-122.81097, 38.4091], [-122.81254, 38.40914], [-122.81254, 38.4196], [-122.81121, 38.41961], [-122.81123, 38.42122], [-122.81049, 38.42125], [-122.81052, 38.42267], [-122.80968, 38.42267], [-122.80969, 38.42059], [-122.80968, 38.42058], [-122.80889, 38.4206], [-122.80889, 38.42267], [-122.80642, 38.42269], [-122.80108, 38.42268], [-122.79501, 38.42272], [-122.79499, 38.41973], [-122.80359, 38.4197], [-122.80349, 38.41056], [-122.80349, 38.4086], [-122.80676, 38.40743], [-122.80677, 38.40815], [-122.80679, 38.40816], [-122.80709, 38.40804], [-122.80708, 38.40732], [-122.80753, 38.40716], [-122.80756, 38.4078], [-122.80855, 38.40771], [-122.81022, 38.40712], [-122.81024, 38.4062], [-122.81245, 38.40541], [-122.81259, 38.40564]]]} No Public Access 3 Kelly Farm   20586 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 369.086 Kelly Farm  
9985 9984 {"type": "Polygon", "coordinates": [[[-122.8297, 38.43042], [-122.82594, 38.43042], [-122.82593, 38.43055], [-122.8217, 38.43054], [-122.82214, 38.4304], [-122.82226, 38.43033], [-122.8223, 38.43029], [-122.8224, 38.43024], [-122.82275, 38.42998], [-122.82309, 38.42985], [-122.82498, 38.42959], [-122.82517, 38.42953], [-122.82525, 38.42956], [-122.82525, 38.42923], [-122.82513, 38.42923], [-122.8249, 38.42929], [-122.8235, 38.42949], [-122.82314, 38.42952], [-122.82295, 38.42956], [-122.82253, 38.42973], [-122.82216, 38.43], [-122.82202, 38.43006], [-122.82193, 38.43014], [-122.82177, 38.43018], [-122.82162, 38.43024], [-122.82125, 38.43031], [-122.82113, 38.43037], [-122.82108, 38.43037], [-122.82099, 38.43033], [-122.82089, 38.43032], [-122.82052, 38.43008], [-122.82053, 38.42921], [-122.82048, 38.4251], [-122.8205, 38.42385], [-122.82826, 38.42594], [-122.82825, 38.42605], [-122.82941, 38.42635], [-122.82931, 38.42976], [-122.82941, 38.43012], [-122.8297, 38.43042]]]} No Public Access 3 Stone Farm   25869 1324 Santa Rosa, City of 29 City 2 City Agency 2 http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx City 2 111.836 Stone Farm  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);