units_with_maps

Table actions

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

1 row where DES_TP = 914, LABEL_NAME = "Pamo Valley", MNG_AGENCY = 4 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • San Diego, City of · 1 ✖

DES_TP 1

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
10469 10469 10468 {"type": "Polygon", "coordinates": [[[-116.87571, 33.09862], [-116.87572, 33.10309], [-116.87571, 33.10591], [-116.8671, 33.10593], [-116.86705, 33.10975], [-116.85853, 33.10983], [-116.85852, 33.11698], [-116.86277, 33.11704], [-116.8628, 33.12446], [-116.86277, 33.1319], [-116.85839, 33.13185], [-116.85815, 33.14289], [-116.86264, 33.14294], [-116.86258, 33.1466], [-116.86255, 33.15026], [-116.86691, 33.1503], [-116.86681, 33.15392], [-116.86668, 33.15799], [-116.86657, 33.15802], [-116.86628, 33.15822], [-116.86612, 33.15829], [-116.86599, 33.15832], [-116.86579, 33.15836], [-116.86503, 33.15835], [-116.8649, 33.15837], [-116.86443, 33.1585], [-116.86413, 33.15866], [-116.86403, 33.15869], [-116.86345, 33.15885], [-116.86319, 33.15888], [-116.86299, 33.15884], [-116.86254, 33.15865], [-116.86222, 33.15858], [-116.86208, 33.15854], [-116.86182, 33.15842], [-116.86134, 33.15814], [-116.86129, 33.15805], [-116.86144, 33.15801], [-116.86151, 33.15797], [-116.86154, 33.15792], [-116.86159, 33.15779], [-116.86159, 33.15771], [-116.86152, 33.15758], [-116.86143, 33.15753], [-116.86135, 33.15753], [-116.86127, 33.15756], [-116.86121, 33.15762], [-116.86115, 33.15765], [-116.86094, 33.15763], [-116.86056, 33.15763], [-116.86043, 33.15767], [-116.86026, 33.15784], [-116.85986, 33.15809], [-116.85981, 33.15809], [-116.85976, 33.15807], [-116.85971, 33.15797], [-116.85957, 33.15785], [-116.8594, 33.15779], [-116.8593, 33.1578], [-116.85921, 33.15785], [-116.85909, 33.15795], [-116.85902, 33.15804], [-116.85893, 33.15825], [-116.85887, 33.15831], [-116.85876, 33.15835], [-116.85852, 33.15835], [-116.8584, 33.15833], [-116.8582, 33.15827], [-116.85799, 33.15818], [-116.85783, 33.15808], [-116.85743, 33.15792], [-116.85724, 33.15786], [-116.85706, 33.15784], [-116.85677, 33.15776], [-116.85645, 33.15775], [-116.85637, 33.15774], [-116.85601, 33.15752], [-116.85545, 33.15732], [-116.85535, 33.15726], [-116.85533, 33.15727], [-116.85534, 33.15738], [-116.85597, 33.15763], [-116.85629, 33.15783], [-116.85644, 33.15786], [-116.85675, 33.15786], [-116.85707, 33.15795], [-116.85721, 33.15797], [-116.85737, 33.15802], [-116.85773, 33.15816], [-116.85793, 33.15828], [-116.8582, 33.15839], [-116.85837, 33.15844], [-116.85864, 33.15847], [-116.85879, 33.15846], [-116.85891, 33.15842], [-116.85897, 33.15838], [-116.85906, 33.15827], [-116.85914, 33.15809], [-116.85918, 33.15803], [-116.85931, 33.15792], [-116.85936, 33.1579], [-116.85944, 33.15792], [-116.85952, 33.15796], [-116.85972, 33.15818], [-116.85985, 33.15821], [-116.85991, 33.15819], [-116.86035, 33.15791], [-116.86043, 33.15785], [-116.86046, 33.15779], [-116.86054, 33.15775], [-116.86093, 33.15774], [-116.86117, 33.15776], [-116.86126, 33.15773], [-116.86136, 33.15764], [-116.8614, 33.15763], [-116.86146, 33.15772], [-116.86146, 33.15778], [-116.86141, 33.15789], [-116.86124, 33.15794], [-116.86118, 33.15798], [-116.86116, 33.15802], [-116.86116, 33.15809], [-116.86118, 33.15814], [-116.86128, 33.15824], [-116.86157, 33.15842], [-116.86194, 33.1586], [-116.8622, 33.15869], [-116.86252, 33.15875], [-116.86285, 33.15891], [-116.86299, 33.15896], [-116.86315, 33.15899], [-116.86331, 33.15899], [-116.86347, 33.15896], [-116.86408, 33.15879], [-116.8642, 33.15875], [-116.86427, 33.1587], [-116.86455, 33.15857], [-116.86497, 33.15847], [-116.86583, 33.15847], [-116.86603, 33.15843], [-116.86625, 33.15836], [-116.86639, 33.15829], [-116.86664, 33.15812], [-116.86667, 33.15811], [-116.86657, 33.16118], [-116.86232, 33.16116], [-116.86231, 33.16117], [-116.86228, 33.16497], [-116.86646, 33.16496], [-116.86638, 33.16837], [-116.86233, 33.16831], [-116.86242, 33.17187], [-116.85753, 33.17179], [-116.85772, 33.17887], [-116.84925, 33.17895], [-116.84933, 33.18263], [-116.84494, 33.18265], [-116.8448, 33.17533], [-116.84919, 33.1753], [-116.84907, 33.16825], [-116.8492, 33.15756], [-116.84482, 33.15753], [-116.84479, 33.16118], [-116.84029, 33.16122], [-116.84046, 33.15394], [-116.84072, 33.14636], [-116.84494, 33.14641], [-116.84499, 33.14277], [-116.84084, 33.14274], [-116.84093, 33.13967], [-116.84097, 33.13904], [-116.84505, 33.13906], [-116.84522, 33.12799], [-116.84957, 33.12798], [-116.84958, 33.12432], [-116.84954, 33.12064], [-116.8411, 33.12049], [-116.84115, 33.11338], [-116.84547, 33.11339], [-116.84555, 33.1097], [-116.83252, 33.10957], [-116.83263, 33.10587], [-116.84113, 33.10593], [-116.84972, 33.10597], [-116.84972, 33.10233], [-116.85412, 33.10235], [-116.85408, 33.09859], [-116.8581, 33.09877], [-116.85796, 33.09924], [-116.85792, 33.09958], [-116.85793, 33.09982], [-116.85803, 33.10046], [-116.85803, 33.10071], [-116.85791, 33.10179], [-116.85785, 33.10203], [-116.85777, 33.10223], [-116.85708, 33.10362], [-116.85695, 33.10385], [-116.85544, 33.10595], [-116.85544, 33.10598], [-116.85546, 33.10599], [-116.85499, 33.10665], [-116.85467, 33.10709], [-116.85458, 33.10718], [-116.85436, 33.10744], [-116.85407, 33.10784], [-116.85369, 33.10845], [-116.85355, 33.10877], [-116.85351, 33.10891], [-116.85345, 33.10914], [-116.85343, 33.10939], [-116.85334, 33.10982], [-116.85335, 33.11019], [-116.8534, 33.11045], [-116.8534, 33.11055], [-116.85337, 33.11071], [-116.85335, 33.11077], [-116.8533, 33.11123], [-116.8533, 33.11151], [-116.85335, 33.11188], [-116.85343, 33.11217], [-116.85349, 33.11268], [-116.85353, 33.11291], [-116.85356, 33.11327], [-116.85361, 33.11338], [-116.85363, 33.11349], [-116.85365, 33.11402], [-116.8536, 33.11427], [-116.85316, 33.11543], [-116.85304, 33.11564], [-116.85296, 33.11576], [-116.85261, 33.11614], [-116.85234, 33.11642], [-116.85164, 33.11699], [-116.85152, 33.11711], [-116.85135, 33.11735], [-116.85117, 33.11772], [-116.85109, 33.11781], [-116.85068, 33.11809], [-116.85002, 33.11849], [-116.84972, 33.11864], [-116.84964, 33.11871], [-116.84936, 33.11939], [-116.84934, 33.11948], [-116.84935, 33.11965], [-116.84938, 33.11973], [-116.84965, 33.12074], [-116.84971, 33.12116], [-116.84964, 33.12367], [-116.84969, 33.12397], [-116.84975, 33.12419], [-116.84985, 33.12443], [-116.84994, 33.12461], [-116.85018, 33.12493], [-116.85234, 33.12741], [-116.85246, 33.1276], [-116.85262, 33.12802], [-116.85267, 33.12828], [-116.85267, 33.1285], [-116.85259, 33.1293], [-116.85232, 33.13287], [-116.85232, 33.13307], [-116.85226, 33.13388], [-116.8522, 33.1346], [-116.85215, 33.13492], [-116.85208, 33.13624], [-116.85203, 33.13646], [-116.85196, 33.13666], [-116.85171, 33.13711], [-116.85133, 33.13793], [-116.85117, 33.13823], [-116.85107, 33.13838], [-116.85008, 33.14039], [-116.85012, 33.14045], [-116.85002, 33.1405], [-116.84918, 33.14218], [-116.84901, 33.14246], [-116.84888, 33.14264], [-116.84875, 33.14277], [-116.8475, 33.14397], [-116.84737, 33.14414], [-116.84727, 33.14433], [-116.84723, 33.14447], [-116.8472, 33.14469], [-116.84721, 33.14478], [-116.84719, 33.1477], [-116.84713, 33.15025], [-116.84716, 33.15037], [-116.84722, 33.15045], [-116.84743, 33.15071], [-116.84756, 33.15094], [-116.84762, 33.15111], [-116.84762, 33.15115], [-116.84819, 33.15299], [-116.8494, 33.15573], [-116.85055, 33.15751], [-116.85071, 33.15772], [-116.85099, 33.15815], [-116.85137, 33.1587], [-116.85174, 33.15934], [-116.8518, 33.15949], [-116.85184, 33.15968], [-116.85196, 33.16109], [-116.85199, 33.16118], [-116.852, 33.16136], [-116.85213, 33.16137], [-116.85212, 33.16116], [-116.85208, 33.16096], [-116.85197, 33.15967], [-116.85193, 33.15948], [-116.85188, 33.15934], [-116.85148, 33.15863], [-116.85107, 33.15805], [-116.85071, 33.1575], [-116.85056, 33.15731], [-116.8496, 33.15583], [-116.8495, 33.15565], [-116.84866, 33.15374], [-116.84852, 33.15345], [-116.84829, 33.15289], [-116.84775, 33.1511], [-116.84769, 33.15093], [-116.84755, 33.15066], [-116.84742, 33.15049], [-116.8473, 33.15036], [-116.84726, 33.15026], [-116.84733, 33.1477], [-116.84732, 33.1459], [-116.84734, 33.14459], [-116.84739, 33.14438], [-116.84747, 33.14422], [-116.84764, 33.144], [-116.84885, 33.14285], [-116.84902, 33.14267], [-116.84916, 33.14247], [-116.85017, 33.14048], [-116.85118, 33.13843], [-116.85135, 33.13817], [-116.85148, 33.13792], [-116.85187, 33.13708], [-116.85208, 33.1367], [-116.85217, 33.13644], [-116.85221, 33.13628], [-116.85228, 33.13496], [-116.85238, 33.13404], [-116.85244, 33.13329], [-116.85245, 33.13292], [-116.85262, 33.13072], [-116.85262, 33.13058], [-116.8528, 33.12852], [-116.8528, 33.12825], [-116.85276, 33.12803], [-116.85261, 33.12762], [-116.85247, 33.12738], [-116.85029, 33.12487], [-116.8501, 33.12462], [-116.84999, 33.12443], [-116.8499, 33.12423], [-116.84983, 33.12399], [-116.84977, 33.12363], [-116.84984, 33.12114], [-116.84981, 33.12087], [-116.84977, 33.12067], [-116.84951, 33.1197], [-116.84948, 33.11963], [-116.84947, 33.11951], [-116.84948, 33.11944], [-116.84977, 33.11876], [-116.84982, 33.11872], [-116.85003, 33.11862], [-116.85068, 33.11823], [-116.85078, 33.11816], [-116.8508, 33.11816], [-116.85116, 33.11791], [-116.85129, 33.11774], [-116.85147, 33.11739], [-116.85164, 33.11716], [-116.85233, 33.11658], [-116.85268, 33.11625], [-116.85307, 33.11581], [-116.85319, 33.11564], [-116.8533, 33.11543], [-116.85373, 33.11428], [-116.85378, 33.11404], [-116.85376, 33.11346], [-116.85372, 33.11332], [-116.85369, 33.11325], [-116.85367, 33.11295], [-116.85362, 33.11268], [-116.85357, 33.11217], [-116.8535, 33.11197], [-116.85343, 33.11149], [-116.85343, 33.11125], [-116.85353, 33.11058], [-116.85352, 33.11042], [-116.85348, 33.11015], [-116.85347, 33.10983], [-116.85356, 33.1094], [-116.85358, 33.10916], [-116.85365, 33.10889], [-116.85381, 33.1085], [-116.85408, 33.10805], [-116.85428, 33.10775], [-116.8546, 33.10734], [-116.85477, 33.10715], [-116.85519, 33.10659], [-116.85557, 33.10604], [-116.8556, 33.10605], [-116.85562, 33.10603], [-116.85715, 33.1039], [-116.85725, 33.10371], [-116.8579, 33.10241], [-116.85806, 33.10199], [-116.85813, 33.10169], [-116.85823, 33.10075], [-116.85823, 33.10043], [-116.85812, 33.09977], [-116.85812, 33.09946], [-116.85814, 33.09932], [-116.8583, 33.09878], [-116.85832, 33.09878], [-116.85837, 33.10147], [-116.85854, 33.10229], [-116.86711, 33.10226], [-116.8671, 33.09865], [-116.87571, 33.09862]], [[-116.8492, 33.15754], [-116.84921, 33.15755], [-116.85017, 33.15755], [-116.85018, 33.15754], [-116.84922, 33.15667], [-116.8492, 33.15754]]]} No Public Access 3 18526 Pamo Valley 23380 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 3682.059 Pamo Valley   None 914  

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