units_with_maps

Table actions

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

214 rows where AGNCY_TYP = 3, DES_TP = 14 and MNG_AG_TYP = 3

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, COUNTY, YR_EST

MNG_AG_TYP 1

  • County Agency · 214 ✖

DES_TP 1

  • Local Other or Unknown · 214 ✖
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
133 133 132 {"type": "Polygon", "coordinates": [[[-119.74246, 34.44054], [-119.74244, 34.44072], [-119.74241, 34.44073], [-119.74215, 34.44091], [-119.74194, 34.44113], [-119.74168, 34.44129], [-119.74157, 34.44128], [-119.7414, 34.44128], [-119.74181, 34.44101], [-119.74204, 34.44079], [-119.74227, 34.44062], [-119.74234, 34.44054], [-119.74246, 34.44054]]]} Unknown Access 4 414 San Roque Creek 24990 325 Santa Barbara, County of 7 County 3 County Agency 3 http://cosb.countyofsb.org/parks/ County 3 325 Santa Barbara, County of 7 County 3 County Agency 3   Santa Barbara 7 0.477 San Roque Creek 0 Local Other or Unknown 14 4
392 392 391 {"type": "Polygon", "coordinates": [[[-117.64422, 33.55212], [-117.64418, 33.55263], [-117.64416, 33.55266], [-117.64412, 33.55267], [-117.64351, 33.55263], [-117.6435, 33.5526], [-117.64355, 33.55204], [-117.64422, 33.55212]]]} Open Access 1 35760 Orange holding 14 23161 312 Orange, County of 142 County 3 County Agency 3 http://ocparks.com/ County 3 312 Orange, County of 138 County 3 County Agency 3   Orange 3 0.99 Orange holding 14 0 Local Other or Unknown 14 4
393 393 392 {"type": "Polygon", "coordinates": [[[-117.63356, 33.5534], [-117.63355, 33.55342], [-117.63311, 33.55365], [-117.63308, 33.55364], [-117.63287, 33.55333], [-117.6327, 33.553], [-117.63271, 33.55298], [-117.63319, 33.55282], [-117.63322, 33.55283], [-117.63338, 33.55312], [-117.63356, 33.5534]]]} Open Access 1 35761 Orange holding 15 23162 312 Orange, County of 142 County 3 County Agency 3 http://ocparks.com/ County 3 312 Orange, County of 138 County 3 County Agency 3   Orange 3 1.023 Orange holding 15 0 Local Other or Unknown 14 4
472 472 471 {"type": "Polygon", "coordinates": [[[-118.60788, 34.06942], [-118.60718, 34.06977], [-118.60688, 34.06935], [-118.60758, 34.069], [-118.60788, 34.06942]]]} Open Access 1 35762 Los Angeles holding 8 21495 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 1.024 Los Angeles holding 8 0 Local Other or Unknown 14 4
884 884 883 {"type": "Polygon", "coordinates": [[[-122.78298, 39.06985], [-122.78285, 39.07024], [-122.78253, 39.07024], [-122.78268, 39.06984], [-122.78298, 39.06985]]]} Open Access 1 35936 Lake holding 49 20938 345 Lake, County of 279 County 3 County Agency 3 http://parks.lakecountyca.gov/ County 3 345 Lake, County of 275 County 3 County Agency 3   Lake 40 0.292 Lake holding 49 0 Local Other or Unknown 14 4
927 927 926 {"type": "Polygon", "coordinates": [[[-122.84377, 39.00039], [-122.84353, 39.00038], [-122.84353, 38.99972], [-122.84377, 38.99973], [-122.84377, 39.00039]]]} Open Access 1 35937 Lake holding 33 20921 345 Lake, County of 279 County 3 County Agency 3 http://parks.lakecountyca.gov/ County 3 345 Lake, County of 275 County 3 County Agency 3   Lake 40 0.38 Lake holding 33 0 Local Other or Unknown 14 4
3141 3141 3140 {"type": "Polygon", "coordinates": [[[-122.22656, 38.37413], [-122.20765, 38.37399], [-122.20771, 38.35953], [-122.21237, 38.35957], [-122.21237, 38.36318], [-122.22173, 38.36325], [-122.22177, 38.36686], [-122.22646, 38.3669], [-122.22656, 38.37413]]]} No Public Access 3 25801 Milliken Reservoir Property 22251 311 Napa, County of 498 County 3 County Agency 3 http://www.napaoutdoors.org/ County 3 311 Napa, County of 489 County 3 County Agency 3   Napa 11 489.122 Milliken Reservoir Property 2000 Local Other or Unknown 14 4
3454 3454 3453 {"type": "Polygon", "coordinates": [[[-118.63309, 34.12589], [-118.63308, 34.12624], [-118.63243, 34.12624], [-118.63244, 34.12598], [-118.63309, 34.12589]]]} Open Access 1 35562 Los Angeles holding 5 21492 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 0.502 Los Angeles holding 5 0 Local Other or Unknown 14 4
3768 3768 3767 {"type": "Polygon", "coordinates": [[[-122.88764, 39.13862], [-122.88696, 39.13862], [-122.88696, 39.13744], [-122.88763, 39.13743], [-122.88764, 39.13862]]]} Open Access 1 35976 Lake holding 16 20902 345 Lake, County of 279 County 3 County Agency 3 http://parks.lakecountyca.gov/ County 3 345 Lake, County of 275 County 3 County Agency 3   Lake 40 1.909 Lake holding 16 0 Local Other or Unknown 14 4
3887 3887 3886 {"type": "Polygon", "coordinates": [[[-117.63605, 33.54568], [-117.63574, 33.54607], [-117.6355, 33.54619], [-117.63546, 33.54618], [-117.63543, 33.54597], [-117.63539, 33.54497], [-117.63543, 33.54495], [-117.6355, 33.54496], [-117.63596, 33.54523], [-117.63605, 33.54568]]]} Open Access 1 35755 Orange holding 9 23176 312 Orange, County of 142 County 3 County Agency 3 http://ocparks.com/ County 3 312 Orange, County of 138 County 3 County Agency 3   Orange 3 1.436 Orange holding 9 0 Local Other or Unknown 14 4
3927 3927 3926 {"type": "Polygon", "coordinates": [[[-120.60126, 37.35998], [-120.60123, 37.36033], [-120.59996, 37.36035], [-120.59996, 37.35936], [-120.60081, 37.35938], [-120.60081, 37.36], [-120.60126, 37.35998]]]} Open Access 1 36303 Merced holding 1 22161 308 Merced, County of 476 County 3 County Agency 3 http://www.co.merced.ca.us/index.aspx?NID=757 County 3 308 Merced, County of 469 County 3 County Agency 3   Merced 37 2.379 Merced holding 1 0 Local Other or Unknown 14 4
3936 3936 3935 {"type": "Polygon", "coordinates": [[[-122.59631, 39.07494], [-122.59606, 39.07511], [-122.59596, 39.07494], [-122.59582, 39.07482], [-122.5958, 39.07463], [-122.5955, 39.07444], [-122.59503, 39.0741], [-122.59482, 39.07405], [-122.59455, 39.0738], [-122.59441, 39.07371], [-122.59415, 39.07361], [-122.59358, 39.07331], [-122.59349, 39.07311], [-122.59335, 39.07298], [-122.59295, 39.07246], [-122.59279, 39.07243], [-122.59296, 39.07226], [-122.59312, 39.07235], [-122.59336, 39.07267], [-122.59341, 39.07292], [-122.59385, 39.07332], [-122.59445, 39.0736], [-122.59595, 39.07453], [-122.59631, 39.07494]]]} Open Access 1 36271 Lake holding 32 20920 345 Lake, County of 279 County 3 County Agency 3 http://parks.lakecountyca.gov/ County 3 345 Lake, County of 275 County 3 County Agency 3   Lake 40 1.651 Lake holding 32 0 Local Other or Unknown 14 4
3939 3939 3938 {"type": "Polygon", "coordinates": [[[-121.62744, 39.74865], [-121.62744, 39.74881], [-121.62673, 39.74875], [-121.62673, 39.74859], [-121.62744, 39.74865]]]} Open Access 1 36311 Butte holding 14 16557 342 Butte, County of 705 County 3 County Agency 3 http://www.buttecounty.net/ County 3 342 Butte, County of 692 County 3 County Agency 3   Butte 42 0.271 Butte holding 14 0 Local Other or Unknown 14 4
3968 3968 3967 {"type": "Polygon", "coordinates": [[[-122.7831, 39.06946], [-122.78298, 39.06985], [-122.78268, 39.06984], [-122.78283, 39.06946], [-122.7831, 39.06946]]]} Open Access 1 36680 Lake holding 30 20918 345 Lake, County of 279 County 3 County Agency 3 http://parks.lakecountyca.gov/ County 3 345 Lake, County of 275 County 3 County Agency 3   Lake 40 0.262 Lake holding 30 0 Local Other or Unknown 14 4
3999 3999 3998 {"type": "Polygon", "coordinates": [[[-121.80809, 39.64191], [-121.80809, 39.64239], [-121.80736, 39.6424], [-121.80735, 39.64235], [-121.80731, 39.6423], [-121.80725, 39.64227], [-121.80719, 39.64226], [-121.80719, 39.64192], [-121.80809, 39.64191]]]} Open Access 1 43009 Butte holding 28 16572 342 Butte, County of 705 County 3 County Agency 3 http://www.buttecounty.net/ County 3 342 Butte, County of 692 County 3 County Agency 3   Butte 42 0.985 Butte holding 28 0 Local Other or Unknown 14 4
4000 4000 3999 {"type": "Polygon", "coordinates": [[[-121.7975, 39.63935], [-121.79716, 39.63942], [-121.797, 39.63897], [-121.79721, 39.63893], [-121.79729, 39.63902], [-121.7975, 39.63935]]]} Open Access 1 43010 Butte holding 29 16573 342 Butte, County of 705 County 3 County Agency 3 http://www.buttecounty.net/ County 3 342 Butte, County of 692 County 3 County Agency 3   Butte 42 0.324 Butte holding 29 0 Local Other or Unknown 14 4
4001 4001 4000 {"type": "Polygon", "coordinates": [[[-121.50716, 39.77435], [-121.50641, 39.77428], [-121.50606, 39.77367], [-121.50686, 39.77374], [-121.50716, 39.77435]]]} Open Access 1 43011 Butte holding 24 16568 342 Butte, County of 705 County 3 County Agency 3 http://www.buttecounty.net/ County 3 342 Butte, County of 692 County 3 County Agency 3   Butte 42 1.051 Butte holding 24 0 Local Other or Unknown 14 4
4002 4002 4001 {"type": "Polygon", "coordinates": [[[-121.27835, 39.52723], [-121.27753, 39.52727], [-121.27742, 39.52663], [-121.27778, 39.52662], [-121.27814, 39.52652], [-121.27835, 39.52723]]]} Open Access 1 43012 Butte holding 25 16569 342 Butte, County of 705 County 3 County Agency 3 http://www.buttecounty.net/ County 3 342 Butte, County of 692 County 3 County Agency 3   Butte 42 1.222 Butte holding 25 0 Local Other or Unknown 14 4
4003 4003 4002 {"type": "Polygon", "coordinates": [[[-121.74737, 39.49534], [-121.74694, 39.49534], [-121.74694, 39.49496], [-121.74736, 39.49496], [-121.74737, 39.49534]]]} Open Access 1 43013 Butte holding 23 16567 342 Butte, County of 705 County 3 County Agency 3 http://www.buttecounty.net/ County 3 342 Butte, County of 692 County 3 County Agency 3   Butte 42 0.385 Butte holding 23 0 Local Other or Unknown 14 4
4473 4473 4472 {"type": "MultiPolygon", "coordinates": [[[[-121.97217, 36.95571], [-121.97161, 36.95571], [-121.97067, 36.95684], [-121.96972, 36.95745], [-121.96972, 36.9572], [-121.96985, 36.95709], [-121.97002, 36.95701], [-121.97017, 36.95688], [-121.97046, 36.95667], [-121.97057, 36.95657], [-121.97068, 36.9564], [-121.97079, 36.9563], [-121.9709, 36.95613], [-121.97105, 36.95599], [-121.9711, 36.95587], [-121.97115, 36.95582], [-121.97122, 36.95566], [-121.97128, 36.95558], [-121.9715, 36.95551], [-121.97151, 36.95549], [-121.97172, 36.95544], [-121.97193, 36.95527], [-121.97196, 36.9553], [-121.97173, 36.9555], [-121.97217, 36.9556], [-121.97217, 36.95571]]], [[[-121.97325, 36.95473], [-121.97294, 36.95463], [-121.97273, 36.95464], [-121.97267, 36.95471], [-121.97265, 36.95471], [-121.97264, 36.95469], [-121.97275, 36.95462], [-121.97288, 36.95459], [-121.97305, 36.95462], [-121.97324, 36.95471], [-121.97325, 36.95473]]]]} Open Access 1 1619 Unnamed site - Santa Cruz, County of 28666 327 Santa Cruz, County of 5 County 3 County Agency 3 http://www.scparks.com/ County 3 327 Santa Cruz, County of 5 County 3 County Agency 3   Santa Cruz 5 1.964   0 Local Other or Unknown 14 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]);