units_with_maps

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

81 rows where MNG_AGENCY = 441

View and edit SQL

Suggested facets: YR_EST, GAP_STS

MNG_AG_TYP

MNG_AGENCY

  • Napa, City of · 81
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
1885 1884 {"type": "Polygon", "coordinates": [[[-122.32856, 38.33136], [-122.32856, 38.3314], [-122.32852, 38.33143], [-122.32806, 38.3317], [-122.32787, 38.33177], [-122.32678, 38.33196], [-122.32661, 38.33166], [-122.32595, 38.33205], [-122.32547, 38.33244], [-122.32474, 38.33285], [-122.32463, 38.33273], [-122.32496, 38.33252], [-122.32458, 38.33221], [-122.3235, 38.33097], [-122.3236, 38.33092], [-122.32382, 38.33107], [-122.32453, 38.33125], [-122.32466, 38.3314], [-122.32493, 38.33124], [-122.32523, 38.33158], [-122.32523, 38.33164], [-122.32501, 38.33185], [-122.3249, 38.33198], [-122.32528, 38.33232], [-122.32614, 38.33146], [-122.32753, 38.33067], [-122.3277, 38.33086], [-122.32799, 38.33071], [-122.32856, 38.33136]]]} Open Access 1 14502 Las Flores Park 21052 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 8.061 Las Flores Park 0 Local Park 2 4
3530 3529 {"type": "Polygon", "coordinates": [[[-122.3149, 38.33891], [-122.31472, 38.33897], [-122.31412, 38.33907], [-122.31397, 38.33883], [-122.31467, 38.3386], [-122.3149, 38.33891]]]} Open Access 1 36316 North Jefferson Park 28695 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.602 North Jefferson Park 0 Local Park 2 4
3570 3569 {"type": "Polygon", "coordinates": [[[-122.29827, 38.33084], [-122.29801, 38.33096], [-122.29792, 38.33085], [-122.29785, 38.33081], [-122.29739, 38.3307], [-122.2972, 38.33046], [-122.29733, 38.3304], [-122.29775, 38.33062], [-122.29795, 38.33066], [-122.29796, 38.33065], [-122.29814, 38.33067], [-122.29827, 38.33084]]]} No Public Access 3 36603 Silverado Creek Maintenance District 30030 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.498 Silverado Creek Maintenance District   None 299  
4290 4289 {"type": "Polygon", "coordinates": [[[-122.26278, 38.28562], [-122.26276, 38.28579], [-122.26261, 38.28613], [-122.26192, 38.28607], [-122.26191, 38.28279], [-122.26229, 38.28278], [-122.26236, 38.28311], [-122.26242, 38.28319], [-122.2625, 38.28341], [-122.26252, 38.28403], [-122.26257, 38.28427], [-122.26252, 38.28447], [-122.26252, 38.2852], [-122.2626, 38.28545], [-122.26278, 38.28562]]]} Open Access 1 14429 Shurtleff Park 25435 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 4.96 Shurtleff Park 0 Local Park 2 4
4616 4615 {"type": "Polygon", "coordinates": [[[-122.25499, 38.35941], [-122.25411, 38.35979], [-122.25361, 38.35995], [-122.25326, 38.35997], [-122.25289, 38.3599], [-122.25265, 38.35979], [-122.25242, 38.35946], [-122.25248, 38.35927], [-122.25284, 38.35909], [-122.2538, 38.35892], [-122.2543, 38.35893], [-122.25499, 38.35941]]]} No Public Access 3 35922 Unnamed site - Napa, City of 28645 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 4.386   0 Local Other or Unknown 14 4
4630 4629 {"type": "Polygon", "coordinates": [[[-122.22625, 38.22568], [-122.22229, 38.22571], [-122.22225, 38.22421], [-122.22224, 38.22254], [-122.22307, 38.22433], [-122.2237, 38.22472], [-122.2237, 38.22525], [-122.22475, 38.22524], [-122.22476, 38.22438], [-122.22452, 38.22437], [-122.22415, 38.22431], [-122.22384, 38.22431], [-122.22307, 38.22385], [-122.22241, 38.22243], [-122.22242, 38.22209], [-122.22261, 38.22185], [-122.22315, 38.22161], [-122.22316, 38.22152], [-122.22322, 38.22151], [-122.22325, 38.22127], [-122.22366, 38.2211], [-122.22393, 38.22126], [-122.22421, 38.22139], [-122.22447, 38.22149], [-122.2248, 38.22157], [-122.22525, 38.22163], [-122.2262, 38.22165], [-122.22625, 38.22568]]]} No Public Access 3 36293 Unnamed site - Napa, City of 28645 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 35.376   0 Local Other or Unknown 14 4
4631 4630 {"type": "MultiPolygon", "coordinates": [[[[-122.34618, 38.30909], [-122.34596, 38.30934], [-122.34614, 38.30944], [-122.34597, 38.30955], [-122.34589, 38.30957], [-122.34581, 38.30954], [-122.34512, 38.30898], [-122.34519, 38.30876], [-122.34544, 38.30879], [-122.34534, 38.30904], [-122.34535, 38.30905], [-122.34567, 38.30906], [-122.34612, 38.30899], [-122.34618, 38.30909]]], [[[-122.3487, 38.31069], [-122.34864, 38.31088], [-122.34806, 38.31077], [-122.34714, 38.31048], [-122.34688, 38.31036], [-122.34665, 38.31022], [-122.34613, 38.30976], [-122.3461, 38.30972], [-122.34611, 38.30968], [-122.34617, 38.30961], [-122.34625, 38.30956], [-122.34634, 38.30965], [-122.34665, 38.30968], [-122.34674, 38.30993], [-122.34686, 38.31013], [-122.34726, 38.31024], [-122.3475, 38.31039], [-122.34763, 38.31031], [-122.34789, 38.31053], [-122.34805, 38.31036], [-122.34821, 38.31049], [-122.34838, 38.31044], [-122.34859, 38.31072], [-122.3487, 38.31069]]]]} Open Access 1 36294 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 2.657   0 Local Other or Unknown 14 4
4632 4631 {"type": "Polygon", "coordinates": [[[-122.27703, 38.31682], [-122.27674, 38.3171], [-122.27647, 38.31702], [-122.27594, 38.31695], [-122.27565, 38.31688], [-122.27558, 38.31653], [-122.27581, 38.31638], [-122.27597, 38.3162], [-122.27656, 38.31622], [-122.27679, 38.31615], [-122.27678, 38.31633], [-122.27683, 38.31652], [-122.27691, 38.31667], [-122.27703, 38.31682]]]} Open Access 1 36315 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 2.219   0 Local Other or Unknown 14 4
4633 4632 {"type": "Polygon", "coordinates": [[[-122.26376, 38.30317], [-122.26366, 38.30341], [-122.26313, 38.30317], [-122.26295, 38.30314], [-122.26275, 38.30314], [-122.26311, 38.30284], [-122.26376, 38.30317]]]} No Public Access 3 36317 Unnamed site - Napa, City of 28645 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.57   0 Local Other or Unknown 14 4
4634 4633 {"type": "Polygon", "coordinates": [[[-122.27749, 38.30276], [-122.27737, 38.30283], [-122.27718, 38.30304], [-122.27707, 38.30306], [-122.27701, 38.30305], [-122.27692, 38.30298], [-122.27666, 38.3027], [-122.27686, 38.3028], [-122.27706, 38.30284], [-122.27729, 38.30283], [-122.27735, 38.30281], [-122.27736, 38.30279], [-122.27749, 38.30276]]]} Open Access 1 36319 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.235   0 Local Other or Unknown 14 4
4636 4635 {"type": "Polygon", "coordinates": [[[-122.34106, 38.30681], [-122.341, 38.30679], [-122.34093, 38.30667], [-122.34086, 38.30658], [-122.34045, 38.3062], [-122.34007, 38.30593], [-122.33968, 38.30568], [-122.33914, 38.3054], [-122.3391, 38.30534], [-122.33912, 38.30527], [-122.33923, 38.30535], [-122.33938, 38.3054], [-122.33952, 38.30542], [-122.33961, 38.30547], [-122.33966, 38.30552], [-122.3398, 38.30569], [-122.33993, 38.3058], [-122.34012, 38.30586], [-122.34049, 38.30593], [-122.34063, 38.30599], [-122.34068, 38.30605], [-122.34073, 38.30625], [-122.3408, 38.30635], [-122.34083, 38.30638], [-122.34091, 38.30639], [-122.34105, 38.30635], [-122.34106, 38.30681]]]} Open Access 1 36336 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.856   0 Local Other or Unknown 14 4
4637 4636 {"type": "Polygon", "coordinates": [[[-122.31969, 38.31537], [-122.31968, 38.3154], [-122.31965, 38.31542], [-122.31947, 38.31545], [-122.31931, 38.31498], [-122.31956, 38.31521], [-122.31969, 38.31537]]]} Open Access 1 36337 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.169   0 Local Other or Unknown 14 4
4638 4637 {"type": "Polygon", "coordinates": [[[-122.2977, 38.32825], [-122.2972, 38.3285], [-122.29663, 38.32864], [-122.29655, 38.32859], [-122.29758, 38.3281], [-122.2977, 38.32825]]]} Open Access 1 36340 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.452   0 Local Other or Unknown 14 4
4662 4661 {"type": "Polygon", "coordinates": [[[-122.28082, 38.28098], [-122.27751, 38.28071], [-122.27753, 38.28051], [-122.28081, 38.28064], [-122.28082, 38.28098]]]} Open Access 1 36601 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 2.159   0 Local Other or Unknown 14 4
4663 4662 {"type": "Polygon", "coordinates": [[[-122.31677, 38.29327], [-122.31482, 38.29396], [-122.31422, 38.29403], [-122.31412, 38.29363], [-122.31425, 38.29329], [-122.31436, 38.29316], [-122.3144, 38.29308], [-122.3144, 38.29298], [-122.31651, 38.29297], [-122.31651, 38.29326], [-122.31677, 38.29327]]]} Open Access 1 36605 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 4.243   0 Local Other or Unknown 14 4
4665 4664 {"type": "Polygon", "coordinates": [[[-122.28966, 38.30079], [-122.28949, 38.30081], [-122.28941, 38.30051], [-122.28952, 38.30046], [-122.28962, 38.30044], [-122.28966, 38.30079]]]} Open Access 1 36611 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.157   0 Local Other or Unknown 14 4
4666 4665 {"type": "Polygon", "coordinates": [[[-122.28917, 38.3009], [-122.28907, 38.30095], [-122.28902, 38.30095], [-122.28885, 38.30075], [-122.28901, 38.30069], [-122.28917, 38.3009]]]} Open Access 1 36612 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.105   0 Local Other or Unknown 14 4
4667 4666 {"type": "Polygon", "coordinates": [[[-122.26819, 38.3106], [-122.26761, 38.3104], [-122.26755, 38.31017], [-122.26748, 38.31002], [-122.26773, 38.30992], [-122.26819, 38.3106]]]} No Public Access 3 36614 Unnamed site - Napa, City of 28645 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 0.487   0 Local Other or Unknown 14 4
4668 4667 {"type": "MultiPolygon", "coordinates": [[[[-122.28563, 38.32175], [-122.28561, 38.32179], [-122.28539, 38.32195], [-122.28528, 38.32197], [-122.28528, 38.32154], [-122.28548, 38.3215], [-122.28563, 38.3217], [-122.28563, 38.32175]]], [[[-122.28633, 38.32236], [-122.2863, 38.32236], [-122.28528, 38.32252], [-122.28528, 38.3224], [-122.28534, 38.32223], [-122.2854, 38.32215], [-122.28547, 38.32206], [-122.28558, 38.32197], [-122.28568, 38.32191], [-122.28575, 38.3219], [-122.2858, 38.3219], [-122.28614, 38.32221], [-122.28633, 38.32236]]], [[[-122.28707, 38.32222], [-122.28659, 38.32231], [-122.28628, 38.32208], [-122.2861, 38.32192], [-122.28591, 38.32174], [-122.2857, 38.32146], [-122.28679, 38.32126], [-122.28707, 38.32222]]]]} Open Access 1 36617 Unnamed site - Napa, City of 28646 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 3.179   0 Local Other or Unknown 14 4
4669 4668 {"type": "Polygon", "coordinates": [[[-122.34815, 38.318], [-122.34756, 38.31831], [-122.34706, 38.31768], [-122.34742, 38.31748], [-122.34791, 38.31776], [-122.34815, 38.318]]]} No Public Access 3 36618 Unnamed site - Napa, City of 28645 1397 Napa, City of 447 City 2 City Agency 2 http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 City 2 1397 Napa, City of 441 City 2 City Agency 2   Napa 11 1.089   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]);
Powered by Datasette · Query took 117.831ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette