units_with_maps

Table actions

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

18 rows where DES_TP = 2, MNG_AGENCY = 438 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • City Agency · 18 ✖

MNG_AGENCY 1

  • Novato, City of · 18 ✖

DES_TP 1

  • Local Park · 18 ✖

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
2151 2151 2150 {"type": "Polygon", "coordinates": [[[-122.51223, 38.05306], [-122.51195, 38.05327], [-122.51195, 38.05346], [-122.51202, 38.0536], [-122.51213, 38.05378], [-122.51193, 38.05388], [-122.51179, 38.05368], [-122.51166, 38.05346], [-122.51151, 38.05307], [-122.5111, 38.05093], [-122.51155, 38.05089], [-122.51183, 38.05062], [-122.51193, 38.05077], [-122.51197, 38.05182], [-122.51223, 38.05306]]]} Open Access 1 16049 South Hamilton Park 25655 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 4.657 South Hamilton Park 0 Local Park 2 4
2493 2493 2492 {"type": "MultiPolygon", "coordinates": [[[[-122.55812, 38.0849], [-122.55687, 38.08592], [-122.55674, 38.08612], [-122.5571, 38.08641], [-122.55704, 38.08644], [-122.55698, 38.08645], [-122.55692, 38.08644], [-122.55686, 38.08641], [-122.55663, 38.08617], [-122.55652, 38.08622], [-122.55498, 38.08474], [-122.55505, 38.08468], [-122.55722, 38.08325], [-122.55733, 38.08336], [-122.55792, 38.08372], [-122.55785, 38.08372], [-122.55754, 38.0847], [-122.558, 38.08489], [-122.55812, 38.0849]]], [[[-122.5575, 38.08673], [-122.5574, 38.0868], [-122.5571, 38.08656], [-122.5572, 38.08649], [-122.5575, 38.08673]]]]} Open Access 1 17513 Lynnwood Hill Park 21611 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 11.591 Lynnwood Hill Park 0 Local Park 2 4
8732 8732 8731 {"type": "Polygon", "coordinates": [[[-122.57419, 38.09413], [-122.57358, 38.09537], [-122.57338, 38.09532], [-122.57302, 38.09516], [-122.57287, 38.09523], [-122.57259, 38.09509], [-122.57268, 38.095], [-122.57282, 38.09478], [-122.5729, 38.09453], [-122.5729, 38.09421], [-122.57275, 38.09411], [-122.5727, 38.09421], [-122.57275, 38.09441], [-122.57274, 38.09472], [-122.57258, 38.09475], [-122.57249, 38.0949], [-122.57251, 38.09512], [-122.57216, 38.09517], [-122.57195, 38.09518], [-122.57167, 38.09542], [-122.57174, 38.09569], [-122.57143, 38.09573], [-122.57139, 38.09576], [-122.57142, 38.09565], [-122.57187, 38.09512], [-122.57177, 38.09423], [-122.57254, 38.09391], [-122.57254, 38.09389], [-122.57248, 38.09381], [-122.5728, 38.09366], [-122.5732, 38.09352], [-122.57322, 38.09359], [-122.57326, 38.09363], [-122.57335, 38.09366], [-122.57336, 38.09378], [-122.57419, 38.09413]]]} Open Access 1 14177 Arroyo Avichi Park 15609 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 6.693 Arroyo Avichi Park 0 Local Park 2 4
8734 8734 8733 {"type": "Polygon", "coordinates": [[[-122.581, 38.1081], [-122.5809, 38.10823], [-122.58084, 38.10819], [-122.58055, 38.10821], [-122.58039, 38.10812], [-122.58018, 38.10786], [-122.57967, 38.10776], [-122.57965, 38.10774], [-122.5795, 38.10771], [-122.57942, 38.10758], [-122.57933, 38.10753], [-122.57915, 38.10757], [-122.57915, 38.10752], [-122.5791, 38.10741], [-122.57874, 38.10726], [-122.57855, 38.10712], [-122.57861, 38.10698], [-122.57873, 38.1068], [-122.57942, 38.1071], [-122.57928, 38.10729], [-122.57928, 38.10731], [-122.57968, 38.10741], [-122.57995, 38.1075], [-122.581, 38.1081]]]} Open Access 1 14179 Lee Gerner Park 21133 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 1.981 Lee Gerner Park 0 Local Park 2 4
8737 8737 8736 {"type": "Polygon", "coordinates": [[[-122.58109, 38.10941], [-122.58106, 38.10996], [-122.57892, 38.10984], [-122.57911, 38.10932], [-122.58109, 38.10941]]]} Open Access 1 14184 Marion Park 21863 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 2.69 Marion Park 0 Local Park 2 4
8738 8738 8737 {"type": "Polygon", "coordinates": [[[-122.61236, 38.09894], [-122.61225, 38.099], [-122.61161, 38.09914], [-122.61091, 38.09951], [-122.61049, 38.09932], [-122.61015, 38.09943], [-122.60997, 38.09966], [-122.6099, 38.09962], [-122.61008, 38.09938], [-122.61027, 38.09932], [-122.61025, 38.09913], [-122.61081, 38.09907], [-122.61074, 38.09859], [-122.61089, 38.09837], [-122.61059, 38.09825], [-122.61119, 38.09811], [-122.61176, 38.09821], [-122.61236, 38.09894]]]} Open Access 1 14186 Marin Highlands Park 21816 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 3.848 Marin Highlands Park 0 Local Park 2 4
8739 8739 8738 {"type": "Polygon", "coordinates": [[[-122.59108, 38.11488], [-122.59098, 38.11496], [-122.59088, 38.11494], [-122.59064, 38.11491], [-122.59011, 38.11489], [-122.58985, 38.11483], [-122.58959, 38.11473], [-122.5893, 38.11468], [-122.58909, 38.11454], [-122.58898, 38.11431], [-122.58885, 38.11447], [-122.58796, 38.11408], [-122.58806, 38.11394], [-122.58805, 38.11393], [-122.58912, 38.1124], [-122.59071, 38.11312], [-122.59025, 38.11373], [-122.5903, 38.11381], [-122.5903, 38.11383], [-122.59108, 38.11488]]]} Open Access 1 14188 Pioneer Park 23727 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 10.39 Pioneer Park 0 Local Park 2 4
8740 8740 8739 {"type": "Polygon", "coordinates": [[[-122.56052, 38.10124], [-122.56043, 38.10138], [-122.55845, 38.10046], [-122.55862, 38.10039], [-122.55951, 38.09996], [-122.56052, 38.10124]]]} Open Access 1 14190 Slade Park 25551 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 2.663 Slade Park 0 Local Park 2 4
8741 8741 8740 {"type": "Polygon", "coordinates": [[[-122.57836, 38.11028], [-122.57813, 38.11063], [-122.57791, 38.11055], [-122.57803, 38.11021], [-122.57836, 38.11028]]]} Open Access 1 14192 Stafford Grove Park 25773 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 0.262 Stafford Grove Park 0 Local Park 2 4
8835 8835 8834 {"type": "Polygon", "coordinates": [[[-122.51829, 38.05553], [-122.5182, 38.05557], [-122.51815, 38.05558], [-122.51807, 38.05563], [-122.51794, 38.05579], [-122.51791, 38.05602], [-122.51781, 38.05627], [-122.51773, 38.05621], [-122.51759, 38.05633], [-122.51767, 38.05647], [-122.51752, 38.05666], [-122.51722, 38.05681], [-122.51714, 38.05677], [-122.51656, 38.05602], [-122.51705, 38.05584], [-122.51688, 38.05554], [-122.5168, 38.05516], [-122.51724, 38.0551], [-122.51762, 38.05497], [-122.51773, 38.05497], [-122.5178, 38.05499], [-122.51785, 38.05503], [-122.51795, 38.05523], [-122.51805, 38.05536], [-122.51814, 38.05544], [-122.51829, 38.05553]]]} Open Access 1 16045 Hamilton Amphitheater Park 19614 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 4.114 Hamilton Amphitheater Park 0 Local Park 2 4
9544 9544 9543 {"type": "Polygon", "coordinates": [[[-122.51183, 38.05062], [-122.51155, 38.05089], [-122.5111, 38.05093], [-122.51105, 38.05068], [-122.51103, 38.05067], [-122.51092, 38.05008], [-122.51148, 38.05001], [-122.51163, 38.05032], [-122.51183, 38.05062]]]} Open Access 1 16051 Hamilton Airport Park 19613 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 1.388 Hamilton Airport Park 0 Local Park 2 4
9562 9562 9561 {"type": "Polygon", "coordinates": [[[-122.54628, 38.10563], [-122.54644, 38.10593], [-122.54644, 38.10602], [-122.54641, 38.1061], [-122.54633, 38.10618], [-122.54624, 38.10623], [-122.54589, 38.10628], [-122.54581, 38.10602], [-122.54594, 38.10557], [-122.54628, 38.10563]]]} Open Access 1 16069 Pansy Tong Lo Park 23394 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 0.8 Pansy Tong Lo Park 0 Local Park 2 4
9570 9570 9569 {"type": "Polygon", "coordinates": [[[-122.54218, 38.04659], [-122.5421, 38.04696], [-122.54177, 38.04686], [-122.54204, 38.04666], [-122.54174, 38.0464], [-122.54122, 38.04642], [-122.54096, 38.04662], [-122.53947, 38.04637], [-122.53912, 38.04636], [-122.53866, 38.04642], [-122.5385, 38.04642], [-122.53837, 38.04638], [-122.53808, 38.0462], [-122.53782, 38.04612], [-122.53723, 38.04602], [-122.53704, 38.04601], [-122.53691, 38.04603], [-122.5369, 38.04589], [-122.53793, 38.04594], [-122.53834, 38.04628], [-122.54119, 38.04606], [-122.54191, 38.04624], [-122.54218, 38.04659]]]} Open Access 1 16101 Creekside Park 17775 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 3.21 Creekside Park 2000 Local Park 2 4
9951 9951 9950 {"type": "Polygon", "coordinates": [[[-122.56858, 38.07328], [-122.5683, 38.07334], [-122.5661, 38.07208], [-122.56477, 38.0713], [-122.56449, 38.07091], [-122.56574, 38.07035], [-122.56735, 38.07115], [-122.56712, 38.07182], [-122.56858, 38.07328]]]} Open Access 1 17118 Joseph Hoog Park 20496 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 9.783 Joseph Hoog Park 0 Local Park 2 4
10258 10258 10257 {"type": "Polygon", "coordinates": [[[-122.6044, 38.11523], [-122.60401, 38.11547], [-122.60362, 38.11549], [-122.60327, 38.11551], [-122.60268, 38.11561], [-122.60212, 38.11576], [-122.60137, 38.11603], [-122.60117, 38.11622], [-122.60129, 38.11642], [-122.60028, 38.11679], [-122.59952, 38.11704], [-122.59946, 38.11692], [-122.59906, 38.11686], [-122.59767, 38.11627], [-122.59708, 38.11628], [-122.59681, 38.11631], [-122.59652, 38.11639], [-122.59601, 38.11658], [-122.59577, 38.1161], [-122.59574, 38.1161], [-122.59581, 38.11624], [-122.59574, 38.11617], [-122.59565, 38.11613], [-122.59475, 38.11598], [-122.594, 38.11622], [-122.59361, 38.11667], [-122.59353, 38.11668], [-122.59348, 38.11672], [-122.5936, 38.11656], [-122.59382, 38.11611], [-122.59381, 38.11605], [-122.59329, 38.11588], [-122.59289, 38.11571], [-122.5928, 38.11566], [-122.59282, 38.11562], [-122.59253, 38.11541], [-122.5927, 38.11548], [-122.59284, 38.11556], [-122.59299, 38.11572], [-122.59312, 38.1158], [-122.59326, 38.11584], [-122.59352, 38.11595], [-122.59376, 38.11599], [-122.5939, 38.11599], [-122.59406, 38.11556], [-122.5945, 38.11562], [-122.59482, 38.11551], [-122.59496, 38.11552], [-122.5952, 38.11568], [-122.59556, 38.11568], [-122.59603, 38.11594], [-122.5972, 38.11604], [-122.59755, 38.11602], [-122.59755, 38.11592], [-122.59758, 38.11572], [-122.5975, 38.11561], [-122.59744, 38.11557], [-122.59713, 38.11554], [-122.59715, 38.11548], [-122.59712, 38.11541], [-122.5977, 38.11495], [-122.59757, 38.11444], [-122.5971, 38.11419], [-122.5972, 38.11381], [-122.59804, 38.11335], [-122.59838, 38.11248], [-122.59892, 38.11261], [-122.60023, 38.11313], [-122.59964, 38.11467], [-122.6018, 38.11517], [-122.60192, 38.11504], [-122.60229, 38.11503], [-122.60263, 38.11471], [-122.60299, 38.11473], [-122.60314, 38.11465], [-122.60314, 38.11463], [-122.60302, 38.11458], [-122.60304, 38.11455], [-122.60308, 38.11453], [-122.6032, 38.11435], [-122.60328, 38.11438], [-122.60327, 38.11448], [-122.60342, 38.11445], [-122.60384, 38.11471], [-122.60409, 38.11493], [-122.6044, 38.11523]]]} Open Access 1 17960 Miwok Park 22329 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 38.09 Miwok Park 0 Local Park 2 4
10375 10375 10374 {"type": "Polygon", "coordinates": [[[-122.62073, 38.11658], [-122.61955, 38.11934], [-122.61965, 38.11941], [-122.61975, 38.11965], [-122.61979, 38.1197], [-122.61923, 38.12094], [-122.61892, 38.12082], [-122.61836, 38.12064], [-122.61504, 38.11981], [-122.61393, 38.11933], [-122.61262, 38.11896], [-122.61136, 38.1185], [-122.60995, 38.11791], [-122.60992, 38.11788], [-122.6099, 38.11783], [-122.61, 38.11749], [-122.61012, 38.11691], [-122.61025, 38.11652], [-122.61008, 38.11648], [-122.61032, 38.11576], [-122.61127, 38.116], [-122.61141, 38.1156], [-122.6114, 38.11559], [-122.61113, 38.11553], [-122.61123, 38.11513], [-122.61058, 38.11496], [-122.61101, 38.11368], [-122.61165, 38.11393], [-122.61336, 38.11466], [-122.6148, 38.11518], [-122.61976, 38.11657], [-122.62052, 38.11661], [-122.62073, 38.11658]]]} Open Access 1 18316 O'Hair Park 22949 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 102.314 O'Hair Park 0 Local Park 2 4
14036 14036 14035 {"type": "Polygon", "coordinates": [[[-122.56117, 38.07261], [-122.56102, 38.0727], [-122.5608, 38.07244], [-122.56044, 38.07264], [-122.56031, 38.07249], [-122.56005, 38.07227], [-122.55995, 38.07215], [-122.55991, 38.07205], [-122.55989, 38.07193], [-122.55989, 38.07182], [-122.55992, 38.07173], [-122.55995, 38.07171], [-122.55999, 38.0717], [-122.56041, 38.07178], [-122.56032, 38.0721], [-122.56099, 38.07235], [-122.56117, 38.07261]]]} Open Access 1 38056 Hillside Park 19982 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 1.216 Hillside Park 0 Local Park 2 4
14044 14044 14043 {"type": "Polygon", "coordinates": [[[-122.55513, 38.06704], [-122.55509, 38.06722], [-122.55483, 38.06718], [-122.5545, 38.06718], [-122.55446, 38.06716], [-122.55444, 38.0671], [-122.55462, 38.06687], [-122.55513, 38.06704]]]} Open Access 1 38045 Wallace Family Park 27218 1226 Novato, City of 444 City 2 City Agency 2 http://www.ci.novato.ca.us/Index.aspx?page=520 City 2 1226 Novato, City of 438 City 2 City Agency 2   Marin 23 0.372 Wallace Family Park 0 Local Park 2 4

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