units_with_maps

Table actions

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

75 rows where ACCESS_TYP = 1, COUNTY = 45 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 75 ✖
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
3116 3116 3115 {"type": "Polygon", "coordinates": [[[-124.09163, 40.87827], [-124.09018, 40.87896], [-124.0902, 40.87926], [-124.08942, 40.87931], [-124.08939, 40.87902], [-124.08899, 40.87904], [-124.08936, 40.87884], [-124.08966, 40.87866], [-124.08999, 40.8784], [-124.09022, 40.87817], [-124.0905, 40.87782], [-124.09073, 40.87745], [-124.09081, 40.87728], [-124.09093, 40.87696], [-124.09163, 40.87827]]]} Open Access 1 25392 Shay Park 25378 1432 Arcata, City of 587 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1432 Arcata, City of 577 City 2 City Agency 2   Humboldt 45 4.66 Shay Park 0 Local Park 2 4
3117 3117 3116 {"type": "Polygon", "coordinates": [[[-124.08408, 40.88028], [-124.08369, 40.88029], [-124.08369, 40.88098], [-124.0828, 40.88077], [-124.08276, 40.88073], [-124.08253, 40.88085], [-124.08238, 40.88096], [-124.08226, 40.88107], [-124.08211, 40.88124], [-124.08228, 40.881], [-124.08245, 40.8808], [-124.08266, 40.88058], [-124.08296, 40.88032], [-124.0833, 40.88008], [-124.08351, 40.87995], [-124.08381, 40.8798], [-124.08407, 40.8797], [-124.08408, 40.88028]]]} Open Access 1 25393 Larson Park 21039 1432 Arcata, City of 587 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1432 Arcata, City of 577 City 2 City Agency 2   Humboldt 45 2.175 Larson Park 0 Local Park 2 4
3459 3459 3458 {"type": "Polygon", "coordinates": [[[-124.10794, 40.50115], [-124.10684, 40.50146], [-124.10667, 40.50143], [-124.10657, 40.50108], [-124.10649, 40.50061], [-124.10638, 40.4999], [-124.10749, 40.49987], [-124.10765, 40.50033], [-124.10794, 40.50115]]]} Open Access 1 25412 Firemans Park and Picnic Area 18912 1435 Rio Dell, City of 642 City 2 City Agency 2 http://www.riodellcity.com/ City 2 1435 Rio Dell, City of 632 City 2 City Agency 2   Humboldt 45 4.191 Firemans Park and Picnic Area 0 Local Recreation Area 3 4
4045 4045 4044 {"type": "Polygon", "coordinates": [[[-124.15929, 40.80679], [-124.15833, 40.80685], [-124.15205, 40.80941], [-124.15206, 40.80915], [-124.1521, 40.80913], [-124.15242, 40.80909], [-124.15293, 40.80893], [-124.15289, 40.80874], [-124.1529, 40.80873], [-124.15265, 40.80808], [-124.15266, 40.8073], [-124.15296, 40.80725], [-124.15394, 40.80714], [-124.15431, 40.80703], [-124.15452, 40.80699], [-124.15554, 40.80682], [-124.15649, 40.80662], [-124.15822, 40.80621], [-124.15877, 40.8061], [-124.15888, 40.80654], [-124.15919, 40.80646], [-124.15929, 40.80679]]]} Open Access 1 47004 Halvorsen Park 30638 1419 Eureka, City of 715 City 2 City Agency 2 http://www.ci.eureka.ca.gov/depts/pnr/default.asp City 2 1419 Eureka, City of 698 City 2 City Agency 2   Humboldt 45 16.928 Halvorsen Park 0 Local Park 2 4
4046 4046 4045 {"type": "Polygon", "coordinates": [[[-124.15715, 40.8062], [-124.15676, 40.8063], [-124.1567, 40.80581], [-124.15684, 40.80579], [-124.15682, 40.80563], [-124.15701, 40.80564], [-124.15705, 40.8057], [-124.15695, 40.80574], [-124.15699, 40.80581], [-124.1569, 40.80584], [-124.15691, 40.80588], [-124.15681, 40.80592], [-124.15687, 40.80605], [-124.15711, 40.80612], [-124.15715, 40.8062]]]} Open Access 1 47006 Clara May Berry Park & Playground 30640 1419 Eureka, City of 715 City 2 City Agency 2 http://www.ci.eureka.ca.gov/depts/pnr/default.asp City 2 1419 Eureka, City of 698 City 2 City Agency 2   Humboldt 45 0.321 Clara May Berry Park & Playground 0 Local Recreation Area 3 4
4047 4047 4046 {"type": "Polygon", "coordinates": [[[-124.16724, 40.80471], [-124.16678, 40.80478], [-124.1667, 40.80448], [-124.16716, 40.80442], [-124.16724, 40.80471]]]} Open Access 1 47007 Old Town Gazebo Plaza 30641 1419 Eureka, City of 715 City 2 City Agency 2 http://www.ci.eureka.ca.gov/depts/pnr/default.asp City 2 1419 Eureka, City of 698 City 2 City Agency 2   Humboldt 45 0.327 Old Town Gazebo Plaza 0 Local Park 2 4
4048 4048 4047 {"type": "Polygon", "coordinates": [[[-124.16743, 40.80385], [-124.16722, 40.80388], [-124.16726, 40.80382], [-124.16725, 40.8038], [-124.16723, 40.80379], [-124.16718, 40.80357], [-124.16736, 40.80355], [-124.16743, 40.80385]]]} Open Access 1 47008 Clark Plaza 30642 1419 Eureka, City of 715 City 2 City Agency 2 http://www.ci.eureka.ca.gov/depts/pnr/default.asp City 2 1419 Eureka, City of 698 City 2 City Agency 2   Humboldt 45 0.13 Clark Plaza 0 Local Park 2 4
4049 4049 4048 {"type": "Polygon", "coordinates": [[[-124.14319, 40.78825], [-124.14318, 40.78947], [-124.14308, 40.78949], [-124.14308, 40.78963], [-124.14222, 40.78962], [-124.14222, 40.78824], [-124.14319, 40.78825]]]} Open Access 1 47019 Eureka Dog Park 30655 1419 Eureka, City of 715 City 2 City Agency 2 http://www.ci.eureka.ca.gov/depts/pnr/default.asp City 2 1419 Eureka, City of 698 City 2 City Agency 2   Humboldt 45 3.069 Eureka Dog Park 0 Local Park 2 4
4054 4054 4053 {"type": "Polygon", "coordinates": [[[-123.99072, 40.88019], [-123.99054, 40.88024], [-123.99034, 40.88033], [-123.9902, 40.8802], [-123.99043, 40.88006], [-123.99072, 40.88019]]]} Open Access 1 47032 City of Blue Lake Park 30683 1443 Blue Lake, City of 716 City 2 City Agency 2 http://bluelake.ca.gov/ City 2 1443 Blue Lake, City of 699 City 2 City Agency 2   Humboldt 45 0.153 City of Blue Lake Park 0 Local Park 2 4
4059 4059 4058 {"type": "Polygon", "coordinates": [[[-124.14507, 41.05769], [-124.14489, 41.05781], [-124.14479, 41.05795], [-124.14489, 41.05811], [-124.14453, 41.05839], [-124.14421, 41.05841], [-124.14377, 41.0584], [-124.1432, 41.05837], [-124.14317, 41.05823], [-124.14301, 41.05823], [-124.14301, 41.05837], [-124.14057, 41.05836], [-124.14055, 41.05825], [-124.13974, 41.05835], [-124.1395, 41.05884], [-124.13923, 41.05903], [-124.13892, 41.05909], [-124.13916, 41.05822], [-124.14054, 41.05772], [-124.14055, 41.05731], [-124.14186, 41.05739], [-124.14207, 41.0573], [-124.1432, 41.05748], [-124.14409, 41.05757], [-124.1448, 41.05732], [-124.14507, 41.05769]]]} Open Access 1 44400 Tsurai Village 26557 1664 Trinidad, City of 718 City 2 City Agency 2 http://www.trinidad.ca.gov/ City 2 1664 Trinidad, City of 701 City 2 City Agency 2   Humboldt 45 11.477 Tsurai Village   None 351  
4691 4691 4690 {"type": "Polygon", "coordinates": [[[-124.08692, 40.86833], [-124.08671, 40.86888], [-124.08598, 40.86873], [-124.08619, 40.86818], [-124.08692, 40.86833]]]} Open Access 1 44899 Arcata Plaza 15571 1432 Arcata, City of 587 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1432 Arcata, City of 577 City 2 City Agency 2   Humboldt 45 1.01 Arcata Plaza 0 Local Park 2 4
4770 4770 4769 {"type": "MultiPolygon", "coordinates": [[[[-124.10601, 40.49914], [-124.10572, 40.49916], [-124.10573, 40.49867], [-124.10555, 40.49848], [-124.10587, 40.49829], [-124.10601, 40.49914]]], [[[-124.10652, 40.49814], [-124.10615, 40.49811], [-124.10585, 40.49742], [-124.10652, 40.49814], [-124.10652, 40.49814]]]]} Open Access 1 46930 Unknown park - Rio Dell, City of 30546 1435 Rio Dell, City of 642 City 2 City Agency 2 http://www.riodellcity.com/ City 2 1435 Rio Dell, City of 632 City 2 City Agency 2 http://www.riodellcity.com/planning-pdf/Rio%20Dell%20Zoning%20Map.pdf Humboldt 45 0.75   0 Local Other or Unknown 14 4
4774 4774 4773 {"type": "Polygon", "coordinates": [[[-124.10655, 40.50715], [-124.10654, 40.50718], [-124.10649, 40.5072], [-124.10591, 40.5071], [-124.10587, 40.50708], [-124.10587, 40.50705], [-124.10588, 40.50702], [-124.10605, 40.50694], [-124.10617, 40.50686], [-124.1063, 40.50671], [-124.10635, 40.50669], [-124.1064, 40.50673], [-124.10649, 40.50701], [-124.10655, 40.50715]]]} Open Access 1 46937 Unnamed site - Rio Dell, City of 30560 1435 Rio Dell, City of 642 City 2 City Agency 2 http://www.riodellcity.com/ City 2 1435 Rio Dell, City of 632 City 2 City Agency 2   Humboldt 45 0.418   0 Local Other or Unknown 14 4
5570 5570 5569 {"type": "Polygon", "coordinates": [[[-124.14435, 40.77531], [-124.14434, 40.77623], [-124.14315, 40.77622], [-124.14316, 40.77549], [-124.14339, 40.7753], [-124.14435, 40.77531]]]} Open Access 1 44165 Hartman Ball Field 19712 1419 Eureka, City of 715 City 2 City Agency 2 http://www.ci.eureka.ca.gov/depts/pnr/default.asp City 2 1419 Eureka, City of 698 City 2 City Agency 2   Humboldt 45 2.468 Hartman Ball Field 0 Local Recreation Area 3 4
5643 5643 5642 {"type": "Polygon", "coordinates": [[[-124.1067, 40.4986], [-124.10642, 40.49873], [-124.10646, 40.49915], [-124.10623, 40.49904], [-124.10611, 40.49827], [-124.10632, 40.49821], [-124.1067, 40.4986]]]} Open Access 1 46931 Rio Dell City Hall Grounds 30548 1435 Rio Dell, City of 642 City 2 City Agency 2 http://www.riodellcity.com/ City 2 1435 Rio Dell, City of 632 City 2 City Agency 2   Humboldt 45 0.64 Rio Dell City Hall Grounds   None 457  
12069 12069 12068 {"type": "Polygon", "coordinates": [[[-124.174, 40.78401], [-124.174, 40.78456], [-124.17298, 40.78455], [-124.17297, 40.78439], [-124.17198, 40.78439], [-124.17198, 40.78413], [-124.17249, 40.78413], [-124.1725, 40.78384], [-124.17297, 40.78384], [-124.17298, 40.78375], [-124.17379, 40.78376], [-124.17379, 40.784], [-124.174, 40.78401]]]} Open Access 1 24769 20-30 Park and Playground 15177 1419 Eureka, City of 715 City 2 City Agency 2 http://www.ci.eureka.ca.gov/depts/pnr/default.asp City 2 1419 Eureka, City of 698 City 2 City Agency 2   Humboldt 45 2.7 20-30 Park and Playground 0 Local Recreation Area 3 4
12176 12176 12175 {"type": "MultiPolygon", "coordinates": [[[[-124.0809, 40.90088], [-124.08082, 40.90117], [-124.08031, 40.90155], [-124.0803, 40.90137], [-124.08001, 40.90137], [-124.08016, 40.90113], [-124.08043, 40.90093], [-124.08058, 40.90074], [-124.0809, 40.90088]]], [[[-124.08262, 40.9], [-124.0818, 40.90012], [-124.08143, 40.90028], [-124.08122, 40.90049], [-124.08104, 40.90075], [-124.08071, 40.9006], [-124.08146, 40.8999], [-124.08251, 40.89977], [-124.08262, 40.9]]], [[[-124.08444, 40.90006], [-124.0829, 40.90006], [-124.08274, 40.89974], [-124.08351, 40.89951], [-124.08428, 40.89974], [-124.08444, 40.90006]]]]} Open Access 1 25386 Valley West Park 26813 1432 Arcata, City of 587 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1432 Arcata, City of 577 City 2 City Agency 2   Humboldt 45 3.57 Valley West Park 0 Local Park 2 4
12177 12177 12176 {"type": "Polygon", "coordinates": [[[-124.09141, 40.89419], [-124.09106, 40.8951], [-124.08936, 40.89476], [-124.0896, 40.89423], [-124.08968, 40.89424], [-124.08979, 40.89399], [-124.08908, 40.89382], [-124.08916, 40.89365], [-124.09141, 40.89419]]]} Open Access 1 25387 Pacific Union Park 23307 1432 Arcata, City of 587 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1432 Arcata, City of 577 City 2 City Agency 2   Humboldt 45 4.148 Pacific Union Park 0 Local Park 2 4
12189 12189 12188 {"type": "Polygon", "coordinates": [[[-124.08886, 40.8933], [-124.08859, 40.8939], [-124.08786, 40.89378], [-124.08791, 40.89359], [-124.08798, 40.89359], [-124.08806, 40.89356], [-124.08811, 40.89352], [-124.08813, 40.89347], [-124.08813, 40.89341], [-124.0881, 40.89337], [-124.08804, 40.89333], [-124.08798, 40.89331], [-124.08813, 40.89282], [-124.08864, 40.89295], [-124.08852, 40.89321], [-124.08886, 40.8933]]]} Open Access 1 25388 Chevret-Vaissade Park 17186 1432 Arcata, City of 587 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1432 Arcata, City of 577 City 2 City Agency 2   Humboldt 45 1.478 Chevret-Vaissade Park 0 Local Park 2 4
12190 12190 12189 {"type": "Polygon", "coordinates": [[[-124.08621, 40.88376], [-124.08501, 40.884], [-124.08491, 40.88399], [-124.08505, 40.88368], [-124.08526, 40.88372], [-124.08612, 40.8835], [-124.08621, 40.88376]]]} Open Access 1 25389 Cahill Park 16657 1432 Arcata, City of 587 City 2 City Agency 2 http://www.cityofarcata.org/rec City 2 1432 Arcata, City of 577 City 2 City Agency 2   Humboldt 45 0.726 Cahill Park 0 Local Park 2 4

Next page

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