units_with_maps

Table actions

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

25 rows where DES_TP = 2, LAYER = 2 and MNG_AGENCY = 577

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Arcata, City of · 25 ✖

DES_TP 1

  • Local Park · 25 ✖

ACCESS_TYP 1

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
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
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
12191 12191 12190 {"type": "Polygon", "coordinates": [[[-124.09816, 40.88452], [-124.09781, 40.88546], [-124.09624, 40.88518], [-124.09642, 40.88458], [-124.09643, 40.88448], [-124.09616, 40.88441], [-124.09613, 40.88449], [-124.09577, 40.88442], [-124.09578, 40.88437], [-124.09586, 40.88431], [-124.09586, 40.88424], [-124.09581, 40.88418], [-124.09568, 40.88415], [-124.09576, 40.88393], [-124.09816, 40.88452]]]} Open Access 1 25390 Ennes Park 18680 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.669 Ennes Park 0 Local Park 2 4
12192 12192 12191 {"type": "MultiPolygon", "coordinates": [[[[-124.0932, 40.88057], [-124.09245, 40.88055], [-124.09246, 40.88037], [-124.0932, 40.88038], [-124.09315, 40.88044], [-124.09314, 40.88048], [-124.09316, 40.88053], [-124.0932, 40.88057]]], [[[-124.09396, 40.87952], [-124.09421, 40.88044], [-124.09415, 40.88086], [-124.09415, 40.881], [-124.09403, 40.88131], [-124.09378, 40.88156], [-124.09362, 40.88161], [-124.09383, 40.88129], [-124.09385, 40.88064], [-124.0934, 40.88063], [-124.09341, 40.88058], [-124.09346, 40.88053], [-124.09348, 40.88049], [-124.09346, 40.88043], [-124.09341, 40.88035], [-124.09386, 40.88036], [-124.0939, 40.8795], [-124.09396, 40.87952]]]]} Open Access 1 25391 Westwood Manor Park 27438 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.723 Westwood Manor Park 0 Local Park 2 4
12193 12193 12192 {"type": "Polygon", "coordinates": [[[-124.09816, 40.87522], [-124.09806, 40.87548], [-124.09772, 40.8754], [-124.09781, 40.87514], [-124.09816, 40.87522]]]} Open Access 1 25394 Bloomfield Park 16169 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.227 Bloomfield Park 0 Local Park 2 4
12194 12194 12193 {"type": "Polygon", "coordinates": [[[-124.10196, 40.87464], [-124.10178, 40.87506], [-124.10161, 40.87507], [-124.1017, 40.8743], [-124.10188, 40.87446], [-124.1019, 40.8745], [-124.10191, 40.87458], [-124.10196, 40.87464]]]} Open Access 1 25395 Greeniview Park 19481 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.359 Greeniview Park 0 Local Park 2 4
12195 12195 12194 {"type": "Polygon", "coordinates": [[[-124.10363, 40.87107], [-124.1035, 40.87107], [-124.10349, 40.87112], [-124.10345, 40.87115], [-124.10343, 40.87119], [-124.10345, 40.87126], [-124.10354, 40.87129], [-124.10355, 40.87196], [-124.10344, 40.87196], [-124.10341, 40.87169], [-124.1033, 40.87168], [-124.10332, 40.87165], [-124.10338, 40.87163], [-124.10335, 40.87155], [-124.10335, 40.87128], [-124.10291, 40.87128], [-124.10295, 40.87121], [-124.10296, 40.87116], [-124.1028, 40.87113], [-124.10263, 40.87104], [-124.1026, 40.87104], [-124.10253, 40.87087], [-124.10253, 40.87073], [-124.10252, 40.87072], [-124.10258, 40.87061], [-124.10267, 40.87053], [-124.10267, 40.87046], [-124.10282, 40.87048], [-124.10284, 40.87043], [-124.10338, 40.87058], [-124.10349, 40.87075], [-124.10348, 40.8709], [-124.10363, 40.87093], [-124.10363, 40.87107]]]} Open Access 1 25397 Windsong Park 27634 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.768 Windsong Park 0 Local Park 2 4
12196 12196 12195 {"type": "Polygon", "coordinates": [[[-124.10402, 40.87414], [-124.10396, 40.87415], [-124.1039, 40.87418], [-124.10339, 40.87389], [-124.10351, 40.87388], [-124.10401, 40.87388], [-124.10402, 40.87414]]]} Open Access 1 25396 Mountain View Park 22560 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.262 Mtn. View Park 0 Local Park 2 4
12198 12198 12197 {"type": "Polygon", "coordinates": [[[-124.08833, 40.87401], [-124.08824, 40.87428], [-124.08822, 40.87429], [-124.08819, 40.87435], [-124.08811, 40.87435], [-124.08791, 40.8749], [-124.08773, 40.87486], [-124.08771, 40.8749], [-124.08738, 40.87483], [-124.08749, 40.87451], [-124.08715, 40.87443], [-124.08716, 40.8744], [-124.08751, 40.87447], [-124.0877, 40.87396], [-124.08777, 40.87397], [-124.0878, 40.8739], [-124.08833, 40.87401]]]} Open Access 1 25398 Stewart Park 25847 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.293 Stewart Park 0 Local Park 2 4
12199 12199 12198 {"type": "Polygon", "coordinates": [[[-124.08305, 40.87281], [-124.08288, 40.87326], [-124.08285, 40.87325], [-124.08292, 40.87278], [-124.08305, 40.87281]]]} Open Access 1 25399 Vinum Park 27151 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.09 Vinum Park 0 Local Park 2 4
12201 12201 12200 {"type": "MultiPolygon", "coordinates": [[[[-124.08224, 40.86983], [-124.08197, 40.87049], [-124.08181, 40.87124], [-124.08181, 40.87138], [-124.08178, 40.87152], [-124.08149, 40.87201], [-124.08143, 40.87205], [-124.08135, 40.87207], [-124.08115, 40.87203], [-124.08116, 40.87198], [-124.08124, 40.87204], [-124.08133, 40.87205], [-124.08139, 40.87203], [-124.08144, 40.87198], [-124.08145, 40.87191], [-124.08138, 40.87182], [-124.08138, 40.87175], [-124.08212, 40.8698], [-124.08224, 40.86983]]], [[[-124.08273, 40.86822], [-124.08237, 40.86951], [-124.08229, 40.8697], [-124.08217, 40.86967], [-124.08271, 40.86822], [-124.08273, 40.86822]]]]} Open Access 1 25401 D Street Linear Park 17890 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.238 D Street Linear Park 0 Local Park 2 4
12202 12202 12201 {"type": "Polygon", "coordinates": [[[-124.06734, 40.85995], [-124.0671, 40.86059], [-124.0665, 40.86058], [-124.06618, 40.86039], [-124.06578, 40.86068], [-124.0642, 40.86067], [-124.0642, 40.86061], [-124.06574, 40.86061], [-124.06612, 40.86035], [-124.06618, 40.86035], [-124.06618, 40.86013], [-124.0661, 40.85993], [-124.06609, 40.85936], [-124.0664, 40.85938], [-124.06655, 40.85941], [-124.06667, 40.85946], [-124.06678, 40.85952], [-124.06734, 40.85995]]]} Open Access 1 25403 Sunny Brae Park 26002 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.929 Sunny Brae Park 0 Local Park 2 4
12203 12203 12202 {"type": "Polygon", "coordinates": [[[-124.07064, 40.85552], [-124.07035, 40.85549], [-124.07033, 40.85561], [-124.07028, 40.85566], [-124.07013, 40.8556], [-124.07014, 40.85547], [-124.06892, 40.85533], [-124.0689, 40.85545], [-124.06812, 40.85538], [-124.06823, 40.85434], [-124.06957, 40.85436], [-124.07064, 40.85552]]]} Open Access 1 25404 Bayside Park 15898 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.738 Bayside Park 0 Local Park 2 4
12215 12215 12214 {"type": "MultiPolygon", "coordinates": [[[[-124.07687, 40.87124], [-124.07681, 40.8714], [-124.07594, 40.87121], [-124.07587, 40.87138], [-124.07464, 40.8711], [-124.07477, 40.87078], [-124.07687, 40.87124]]], [[[-124.07613, 40.87058], [-124.07601, 40.87091], [-124.07506, 40.87069], [-124.07517, 40.87037], [-124.07613, 40.87058]]], [[[-124.07704, 40.87078], [-124.07692, 40.87111], [-124.07627, 40.87097], [-124.07639, 40.87064], [-124.07704, 40.87078]]]]} Open Access 1 25406 Redwood Park 24251 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.69 Redwood Park 0 Local Park 2 4
12216 12216 12215 {"type": "Polygon", "coordinates": [[[-124.08807, 40.8624], [-124.08802, 40.86253], [-124.08718, 40.86235], [-124.08723, 40.86221], [-124.08807, 40.8624]]]} Open Access 1 25407 Rotary Park 24701 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.278 Rotary 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]);