units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, LABEL_NAME = "Año Nuevo SR", MNG_AGENCY = 47 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

MNG_AGENCY 1

  • California Department of Parks and Recreation · 1 ✖

ACCESS_TYP 1

  • Open Access · 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
16635 16635 16634 {"type": "Polygon", "coordinates": [[[-122.36285, 37.16507], [-122.36126, 37.16527], [-122.36126, 37.16528], [-122.36133, 37.16546], [-122.36109, 37.16567], [-122.36038, 37.16385], [-122.35952, 37.16255], [-122.3593, 37.16241], [-122.35855, 37.16133], [-122.35842, 37.16091], [-122.35826, 37.16065], [-122.3577, 37.1601], [-122.35599, 37.15761], [-122.35555, 37.157], [-122.35507, 37.1564], [-122.35475, 37.15602], [-122.35431, 37.15553], [-122.34999, 37.1509], [-122.34961, 37.15056], [-122.34922, 37.15023], [-122.34852, 37.14972], [-122.34807, 37.14944], [-122.3476, 37.14917], [-122.34685, 37.14881], [-122.34681, 37.14853], [-122.34631, 37.14829], [-122.34573, 37.14835], [-122.33069, 37.1435], [-122.32563, 37.14174], [-122.326, 37.14148], [-122.32644, 37.14131], [-122.32688, 37.14128], [-122.32753, 37.1412], [-122.32809, 37.14106], [-122.32857, 37.14103], [-122.32877, 37.14075], [-122.32948, 37.14052], [-122.3299, 37.14031], [-122.33012, 37.14016], [-122.3302, 37.13989], [-122.3303, 37.13963], [-122.33051, 37.13942], [-122.33089, 37.13931], [-122.33118, 37.13917], [-122.33135, 37.13904], [-122.33151, 37.13869], [-122.33151, 37.13861], [-122.33176, 37.13834], [-122.33203, 37.13838], [-122.33251, 37.13834], [-122.33251, 37.13803], [-122.33259, 37.13804], [-122.33283, 37.13793], [-122.33328, 37.13777], [-122.33339, 37.13769], [-122.33353, 37.13767], [-122.33367, 37.13763], [-122.33402, 37.13768], [-122.33438, 37.13764], [-122.33464, 37.13748], [-122.33502, 37.13734], [-122.33516, 37.13732], [-122.33537, 37.13723], [-122.3356, 37.13722], [-122.33602, 37.13727], [-122.33612, 37.13722], [-122.33614, 37.13714], [-122.33614, 37.13704], [-122.33631, 37.13684], [-122.33653, 37.13663], [-122.3367, 37.13657], [-122.33691, 37.13662], [-122.33708, 37.1366], [-122.33717, 37.13651], [-122.33721, 37.13637], [-122.33754, 37.13615], [-122.33782, 37.1359], [-122.33811, 37.13583], [-122.33837, 37.13574], [-122.33848, 37.13597], [-122.3385, 37.13611], [-122.33855, 37.13624], [-122.33869, 37.13651], [-122.33935, 37.13752], [-122.33955, 37.13776], [-122.33991, 37.13808], [-122.34029, 37.13837], [-122.34044, 37.13844], [-122.34055, 37.13855], [-122.34113, 37.13886], [-122.3414, 37.13905], [-122.34157, 37.1391], [-122.34182, 37.13929], [-122.34198, 37.13937], [-122.34207, 37.13949], [-122.3422, 37.13959], [-122.34246, 37.13976], [-122.34262, 37.13983], [-122.34275, 37.13993], [-122.34302, 37.1401], [-122.34313, 37.14021], [-122.34326, 37.14046], [-122.34336, 37.14058], [-122.34342, 37.14071], [-122.34361, 37.14095], [-122.34368, 37.14107], [-122.34376, 37.14135], [-122.34372, 37.14162], [-122.34367, 37.14176], [-122.34369, 37.1419], [-122.34361, 37.14231], [-122.34365, 37.14258], [-122.34362, 37.14272], [-122.34363, 37.14286], [-122.34367, 37.143], [-122.34377, 37.14327], [-122.3439, 37.14352], [-122.34398, 37.14365], [-122.34403, 37.14379], [-122.34419, 37.14403], [-122.34432, 37.14412], [-122.34443, 37.14423], [-122.34475, 37.14432], [-122.34505, 37.14446], [-122.34523, 37.14448], [-122.34531, 37.14455], [-122.34542, 37.1448], [-122.34557, 37.14485], [-122.34571, 37.14494], [-122.34587, 37.14498], [-122.346, 37.14509], [-122.34615, 37.14515], [-122.34629, 37.14524], [-122.34642, 37.14534], [-122.34658, 37.1454], [-122.3467, 37.1455], [-122.34706, 37.14557], [-122.34722, 37.14555], [-122.34739, 37.1456], [-122.34792, 37.14564], [-122.34809, 37.14559], [-122.34827, 37.14558], [-122.34842, 37.14564], [-122.34858, 37.14559], [-122.34875, 37.14562], [-122.34891, 37.14556], [-122.34908, 37.14556], [-122.34925, 37.1455], [-122.34959, 37.14543], [-122.34969, 37.1453], [-122.34982, 37.14521], [-122.35, 37.14518], [-122.35036, 37.14517], [-122.35071, 37.1452], [-122.35098, 37.14537], [-122.35115, 37.14543], [-122.35115, 37.14557], [-122.35112, 37.1457], [-122.35128, 37.14574], [-122.35135, 37.14562], [-122.35133, 37.14548], [-122.35139, 37.14535], [-122.35153, 37.14527], [-122.3517, 37.14528], [-122.35186, 37.14535], [-122.35199, 37.14544], [-122.35209, 37.14556], [-122.35212, 37.14569], [-122.35226, 37.14595], [-122.35213, 37.14604], [-122.35178, 37.1461], [-122.35161, 37.14615], [-122.35152, 37.14626], [-122.3515, 37.1464], [-122.35159, 37.14651], [-122.35166, 37.14664], [-122.35179, 37.14674], [-122.35194, 37.14681], [-122.35207, 37.14691], [-122.35223, 37.14695], [-122.3524, 37.14695], [-122.35247, 37.14682], [-122.35259, 37.14671], [-122.35276, 37.14672], [-122.3529, 37.14663], [-122.35307, 37.14662], [-122.35323, 37.14656], [-122.35338, 37.14663], [-122.35347, 37.14675], [-122.35374, 37.14693], [-122.35381, 37.14705], [-122.35395, 37.14712], [-122.35396, 37.14711], [-122.35395, 37.14699], [-122.35402, 37.14686], [-122.35419, 37.14688], [-122.3547, 37.14727], [-122.35486, 37.14732], [-122.35503, 37.14757], [-122.35528, 37.14777], [-122.35541, 37.14786], [-122.35558, 37.14789], [-122.35569, 37.14799], [-122.35568, 37.14813], [-122.35551, 37.14814], [-122.35533, 37.14812], [-122.35517, 37.14815], [-122.35512, 37.14828], [-122.35517, 37.14842], [-122.35533, 37.14846], [-122.3555, 37.14844], [-122.35584, 37.14845], [-122.35601, 37.14851], [-122.35602, 37.14865], [-122.35586, 37.14871], [-122.35577, 37.14882], [-122.35561, 37.14888], [-122.35565, 37.14901], [-122.35575, 37.14913], [-122.35592, 37.14909], [-122.35644, 37.14908], [-122.35655, 37.14896], [-122.35689, 37.14901], [-122.35737, 37.14915], [-122.35752, 37.14924], [-122.35769, 37.14924], [-122.35785, 37.14931], [-122.35802, 37.14933], [-122.35818, 37.14937], [-122.35819, 37.14936], [-122.35818, 37.14924], [-122.35835, 37.14926], [-122.35863, 37.14941], [-122.3588, 37.14946], [-122.35895, 37.14954], [-122.35942, 37.14971], [-122.35959, 37.14968], [-122.3599, 37.14958], [-122.36007, 37.14956], [-122.36014, 37.14943], [-122.36025, 37.14932], [-122.36052, 37.1495], [-122.36077, 37.1497], [-122.36098, 37.14992], [-122.36112, 37.15002], [-122.36119, 37.15015], [-122.36116, 37.15029], [-122.36082, 37.15033], [-122.36066, 37.15028], [-122.36053, 37.15018], [-122.3602, 37.15028], [-122.36015, 37.15041], [-122.36007, 37.15054], [-122.36006, 37.15067], [-122.35994, 37.15094], [-122.35985, 37.15107], [-122.35974, 37.15118], [-122.35956, 37.15157], [-122.35956, 37.15171], [-122.35969, 37.15211], [-122.35971, 37.15226], [-122.35958, 37.15266], [-122.3596, 37.15293], [-122.35965, 37.15306], [-122.35967, 37.15321], [-122.35968, 37.15335], [-122.35973, 37.15349], [-122.35972, 37.15376], [-122.35978, 37.1539], [-122.35982, 37.15404], [-122.35982, 37.15433], [-122.35983, 37.15447], [-122.3598, 37.15462], [-122.3598, 37.15476], [-122.35983, 37.15504], [-122.35991, 37.15517], [-122.35991, 37.15531], [-122.36012, 37.15569], [-122.36016, 37.15597], [-122.36027, 37.15608], [-122.36029, 37.15637], [-122.36037, 37.1565], [-122.36041, 37.15677], [-122.3605, 37.15689], [-122.36052, 37.15717], [-122.36061, 37.15729], [-122.3606, 37.15757], [-122.36064, 37.15771], [-122.36073, 37.15784], [-122.36077, 37.15797], [-122.36084, 37.1581], [-122.36088, 37.15837], [-122.36094, 37.1585], [-122.36087, 37.15863], [-122.36079, 37.1589], [-122.36079, 37.15903], [-122.36086, 37.15931], [-122.36085, 37.15945], [-122.36088, 37.15959], [-122.3609, 37.15987], [-122.36115, 37.16039], [-122.36123, 37.16052], [-122.36124, 37.16066], [-122.36132, 37.16078], [-122.36135, 37.16092], [-122.36143, 37.16105], [-122.36148, 37.16118], [-122.36149, 37.16132], [-122.36155, 37.16145], [-122.36157, 37.16159], [-122.36166, 37.16186], [-122.36177, 37.16198], [-122.3618, 37.16211], [-122.36186, 37.16224], [-122.36196, 37.16236], [-122.362, 37.16285], [-122.36203, 37.16298], [-122.36203, 37.16312], [-122.36208, 37.1634], [-122.36215, 37.16367], [-122.36231, 37.16407], [-122.36246, 37.16432], [-122.3625, 37.16445], [-122.36262, 37.16455], [-122.36266, 37.16469], [-122.36278, 37.1648], [-122.36285, 37.16507]], [[-122.35773, 37.15583], [-122.35773, 37.15585], [-122.35797, 37.15608], [-122.35918, 37.15553], [-122.35912, 37.1551], [-122.35773, 37.15583]]]} Open Access 1 16724 Año Nuevo State Reserve 27969 204 California Department of Parks and Recreation 48 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 204 California Department of Parks and Recreation 47 State 5 State Agency 5   San Mateo 15 567.291 Año Nuevo SR 2008 State Conservation Area 8 2

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