units_with_maps

Table actions

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

39 rows where ACCESS_TYP = 1, LAYER = 2, MNG_AGENCY = 144 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 39 ✖

MNG_AGENCY 1

  • Petaluma, City of · 39 ✖

ACCESS_TYP 1

  • Open Access · 39 ✖
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
361 361 360 {"type": "Polygon", "coordinates": [[[-122.63718, 38.23184], [-122.63689, 38.23236], [-122.6359, 38.23199], [-122.63619, 38.23148], [-122.63718, 38.23184]]]} Open Access 1 10069 Walnut Park 27241 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 1.484 Walnut Park 0 Local Park 2 4
1225 1225 1224 {"type": "Polygon", "coordinates": [[[-122.60828, 38.227], [-122.60689, 38.2283], [-122.60534, 38.22861], [-122.60511, 38.22845], [-122.60348, 38.22942], [-122.60099, 38.2291], [-122.59955, 38.22805], [-122.59813, 38.22962], [-122.59712, 38.22934], [-122.59572, 38.22889], [-122.58667, 38.22545], [-122.58472, 38.22752], [-122.58065, 38.22602], [-122.58089, 38.22576], [-122.58083, 38.22535], [-122.57915, 38.22443], [-122.57979, 38.22381], [-122.58026, 38.22347], [-122.58051, 38.22326], [-122.58068, 38.22298], [-122.58181, 38.2234], [-122.58545, 38.21911], [-122.58592, 38.21923], [-122.58644, 38.21924], [-122.58741, 38.2193], [-122.58767, 38.21927], [-122.58832, 38.21912], [-122.58881, 38.21891], [-122.58985, 38.21833], [-122.59071, 38.218], [-122.5915, 38.21787], [-122.59165, 38.21787], [-122.59273, 38.21894], [-122.59312, 38.21949], [-122.59357, 38.22006], [-122.59404, 38.22053], [-122.59456, 38.22086], [-122.59507, 38.22105], [-122.59564, 38.22119], [-122.5964, 38.22125], [-122.59841, 38.22082], [-122.59919, 38.22081], [-122.60016, 38.22118], [-122.60112, 38.22129], [-122.60174, 38.22118], [-122.60284, 38.22117], [-122.60389, 38.22166], [-122.60493, 38.22272], [-122.60556, 38.22413], [-122.60673, 38.22506], [-122.60825, 38.22572], [-122.6084, 38.22616], [-122.60841, 38.22662], [-122.60828, 38.227]]]} Open Access 1 7020 Shollenberger Park 8553 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/parks-pages/shollenberger.html Sonoma 16 455.472 Shollenberger Park 0 Local Park 2 4
1283 1283 1282 {"type": "Polygon", "coordinates": [[[-122.63231, 38.24197], [-122.63157, 38.24277], [-122.63066, 38.24226], [-122.63059, 38.24198], [-122.63119, 38.24133], [-122.63231, 38.24197]]]} Open Access 1 9981 Kenilworth Park 20597 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 3.259 Kenilworth Park 0 Local Park 2 4
1459 1459 1458 {"type": "Polygon", "coordinates": [[[-122.60411, 38.24256], [-122.60085, 38.24618], [-122.5962, 38.24357], [-122.59614, 38.24353], [-122.59611, 38.24345], [-122.59612, 38.2434], [-122.59614, 38.24335], [-122.59829, 38.24098], [-122.59893, 38.24133], [-122.59953, 38.24067], [-122.59953, 38.24066], [-122.5989, 38.2403], [-122.59979, 38.23932], [-122.60141, 38.24023], [-122.60169, 38.24044], [-122.60193, 38.24069], [-122.60218, 38.24107], [-122.60195, 38.24135], [-122.60411, 38.24256]]]} Open Access 1 9831 Crinella Park 17820 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 66.215 Crinella Park 0 Local Park 2 4
1461 1461 1460 {"type": "Polygon", "coordinates": [[[-122.61278, 38.23578], [-122.61245, 38.23612], [-122.6117, 38.23568], [-122.61154, 38.23563], [-122.61117, 38.23564], [-122.61068, 38.23584], [-122.6104, 38.23602], [-122.61028, 38.23596], [-122.61032, 38.23587], [-122.61023, 38.23582], [-122.61004, 38.23605], [-122.60976, 38.23592], [-122.60964, 38.23594], [-122.60959, 38.23598], [-122.60918, 38.23576], [-122.60926, 38.2357], [-122.60938, 38.23568], [-122.60941, 38.23558], [-122.60947, 38.23551], [-122.60951, 38.23535], [-122.60958, 38.23532], [-122.60958, 38.23524], [-122.60955, 38.23516], [-122.60957, 38.23511], [-122.60966, 38.2351], [-122.60968, 38.23494], [-122.60955, 38.23492], [-122.6095, 38.23484], [-122.60964, 38.23476], [-122.61007, 38.23474], [-122.61085, 38.23474], [-122.61185, 38.23525], [-122.61278, 38.23578]]]} Open Access 1 9843 Miwok Park 22330 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 6.479 Miwok Park 0 Local Park 2 4
1464 1464 1463 {"type": "Polygon", "coordinates": [[[-122.65082, 38.26559], [-122.6502, 38.26627], [-122.64983, 38.26609], [-122.64991, 38.26593], [-122.64994, 38.26571], [-122.65012, 38.26568], [-122.65023, 38.26564], [-122.65032, 38.26558], [-122.65048, 38.26541], [-122.65082, 38.26559]]]} Open Access 1 9921 McDowell Meadows Park 22025 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 0.978 McDowell Meadows Park 0 Local Park 2 4
1467 1467 1466 {"type": "Polygon", "coordinates": [[[-122.63156, 38.23591], [-122.63154, 38.23595], [-122.6314, 38.2361], [-122.63078, 38.23576], [-122.63084, 38.23571], [-122.63152, 38.23585], [-122.63156, 38.23591]]]} Open Access 1 10033 Sunset Park 26058 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 0.319 Sunset Park 0 Local Park 2 4
1469 1469 1468 {"type": "Polygon", "coordinates": [[[-122.60249, 38.23759], [-122.6023, 38.23782], [-122.60201, 38.23804], [-122.60184, 38.23794], [-122.60183, 38.2379], [-122.6019, 38.23778], [-122.6022, 38.23745], [-122.60226, 38.23746], [-122.60249, 38.23759]]]} Open Access 1 10045 Anna's Meadows 15501 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 0.457 Anna's Meadows   None 121  
1472 1472 1471 {"type": "Polygon", "coordinates": [[[-122.62727, 38.24423], [-122.62614, 38.24562], [-122.62614, 38.24564], [-122.62491, 38.24476], [-122.62415, 38.24407], [-122.6233, 38.24296], [-122.62246, 38.24147], [-122.62271, 38.24132], [-122.62324, 38.24158], [-122.62375, 38.24187], [-122.62435, 38.24203], [-122.62705, 38.24364], [-122.62685, 38.24396], [-122.62727, 38.24423]]]} Open Access 1 10010 Kenilworth Athletic Fields 20596 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 20.13 Kenilworth Athletic Fields 0 Local Recreation Area 3 4
1473 1473 1472 {"type": "Polygon", "coordinates": [[[-122.59778, 38.23707], [-122.59771, 38.23722], [-122.59758, 38.23746], [-122.59738, 38.23787], [-122.59702, 38.23833], [-122.59676, 38.23857], [-122.59633, 38.23834], [-122.59654, 38.23789], [-122.59716, 38.23673], [-122.59778, 38.23707]]]} Open Access 1 10021 Case Del Oro Park 16941 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 2.947 Case Del Oro Park 0 Local Park 2 4
1474 1474 1473 {"type": "Polygon", "coordinates": [[[-122.63904, 38.22399], [-122.63784, 38.22593], [-122.63747, 38.22579], [-122.63737, 38.22594], [-122.63689, 38.22572], [-122.63666, 38.22609], [-122.63629, 38.22594], [-122.63779, 38.2235], [-122.63904, 38.22399]]]} Open Access 1 10057 McNear Park 22061 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 8.003 McNear Park 2000 Local Park 2 4
1475 1475 1474 {"type": "Polygon", "coordinates": [[[-122.65291, 38.23673], [-122.65273, 38.23676], [-122.65189, 38.23692], [-122.65155, 38.23704], [-122.65136, 38.23727], [-122.65093, 38.23771], [-122.64945, 38.23663], [-122.64994, 38.23625], [-122.65004, 38.23632], [-122.65025, 38.23633], [-122.65288, 38.23598], [-122.65291, 38.23673]]]} Open Access 1 10104 Oak Hill Park 22980 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 7.285 Oak Hill Park 0 Local Park 2 4
1477 1477 1476 {"type": "Polygon", "coordinates": [[[-122.65571, 38.24345], [-122.65543, 38.24366], [-122.65535, 38.24362], [-122.65517, 38.24361], [-122.65505, 38.24377], [-122.65504, 38.24386], [-122.65516, 38.24392], [-122.65466, 38.24428], [-122.65343, 38.24401], [-122.65391, 38.2427], [-122.6541, 38.24267], [-122.65493, 38.24288], [-122.65496, 38.24293], [-122.65532, 38.24313], [-122.65533, 38.24319], [-122.6557, 38.24327], [-122.65571, 38.24345]]]} Open Access 1 10116 Cherry Valley Park 17173 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 5.354 Cherry Valley Park 0 Local Park 2 4
3218 3218 3217 {"type": "MultiPolygon", "coordinates": [[[[-122.63176, 38.26966], [-122.63117, 38.27031], [-122.62234, 38.26535], [-122.62274, 38.2649], [-122.62292, 38.26507], [-122.62306, 38.26515], [-122.62318, 38.26519], [-122.62345, 38.26523], [-122.62384, 38.2652], [-122.62397, 38.26522], [-122.62406, 38.26525], [-122.62443, 38.26546], [-122.62452, 38.26553], [-122.62464, 38.26555], [-122.62465, 38.26564], [-122.62535, 38.26603], [-122.62566, 38.26601], [-122.62567, 38.2661], [-122.62572, 38.2662], [-122.62579, 38.26629], [-122.62588, 38.26637], [-122.62608, 38.26647], [-122.62644, 38.26655], [-122.62667, 38.26665], [-122.62681, 38.26676], [-122.627, 38.26699], [-122.62715, 38.26713], [-122.62741, 38.26731], [-122.62761, 38.26742], [-122.62787, 38.26751], [-122.62811, 38.26753], [-122.62825, 38.26752], [-122.62839, 38.26747], [-122.62849, 38.26742], [-122.62859, 38.26735], [-122.62829, 38.26768], [-122.6283, 38.26769], [-122.62985, 38.26856], [-122.62991, 38.26861], [-122.62999, 38.26864], [-122.63129, 38.26937], [-122.63135, 38.26942], [-122.63147, 38.26945], [-122.63151, 38.26952], [-122.63176, 38.26966]]], [[[-122.63916, 38.27377], [-122.63855, 38.27445], [-122.63365, 38.2717], [-122.63425, 38.27103], [-122.63916, 38.27377]]], [[[-122.64797, 38.27641], [-122.64737, 38.27708], [-122.64371, 38.27505], [-122.64235, 38.27656], [-122.63864, 38.27449], [-122.63924, 38.27382], [-122.6413, 38.27497], [-122.64192, 38.27478], [-122.64294, 38.27478], [-122.64359, 38.27407], [-122.64429, 38.27441], [-122.64477, 38.27461], [-122.64497, 38.2747], [-122.6455, 38.27504], [-122.64664, 38.27567], [-122.64674, 38.27576], [-122.64685, 38.27579], [-122.64797, 38.27641]]]]} Open Access 1 28207 Petaluma Urban Separator 23625 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 55.708 Petaluma Urban Separator   None 265  
3219 3219 3218 {"type": "Polygon", "coordinates": [[[-122.64114, 38.23479], [-122.64083, 38.23488], [-122.64076, 38.23474], [-122.64106, 38.23464], [-122.64114, 38.23479]]]} Open Access 1 28210 Putnam Plaza 24037 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 0.122 Putnam Plaza 0 Local Park 2 4
3810 3810 3809 {"type": "Polygon", "coordinates": [[[-122.6307, 38.21993], [-122.63068, 38.22035], [-122.62958, 38.22036], [-122.62935, 38.22045], [-122.6293, 38.22056], [-122.62924, 38.22066], [-122.62902, 38.22065], [-122.62899, 38.22063], [-122.62886, 38.22061], [-122.62878, 38.22063], [-122.62846, 38.22063], [-122.62846, 38.21987], [-122.62849, 38.21982], [-122.62844, 38.21951], [-122.6285, 38.21947], [-122.62939, 38.21947], [-122.62953, 38.21953], [-122.62967, 38.21953], [-122.62973, 38.21975], [-122.62987, 38.21992], [-122.6307, 38.21993]]]} Open Access 1 10133 Grant Park 19440 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 4.258 Grant Park 0 Local Park 2 4
5586 5586 5585 {"type": "Polygon", "coordinates": [[[-122.5889, 38.23692], [-122.58862, 38.23722], [-122.58856, 38.23723], [-122.58789, 38.23684], [-122.58781, 38.23683], [-122.58773, 38.23685], [-122.58813, 38.2364], [-122.58837, 38.23654], [-122.58839, 38.23659], [-122.58843, 38.23663], [-122.58889, 38.23687], [-122.5889, 38.23692]]]} Open Access 1 48806 Southgate Park 33528 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 1.079 Southgate Park 0 Local Park 2 4
5587 5587 5586 {"type": "Polygon", "coordinates": [[[-122.62098, 38.22346], [-122.62096, 38.22431], [-122.62061, 38.22421], [-122.62066, 38.22397], [-122.62047, 38.22393], [-122.62007, 38.22387], [-122.61965, 38.22384], [-122.61933, 38.22378], [-122.61924, 38.22346], [-122.61889, 38.22338], [-122.61885, 38.22347], [-122.61883, 38.22363], [-122.61874, 38.22359], [-122.61874, 38.2235], [-122.61879, 38.22337], [-122.61861, 38.22326], [-122.62098, 38.22346]]]} Open Access 1 48807 Riverview Park 33529 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 2.473 Riverview Park 0 Local Park 2 4
5588 5588 5587 {"type": "Polygon", "coordinates": [[[-122.64921, 38.26791], [-122.64874, 38.26797], [-122.64866, 38.26796], [-122.64862, 38.26791], [-122.64852, 38.26752], [-122.64921, 38.26791]]]} Open Access 1 48808 Maria Pocket Park 33530 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 0.325 Maria PP 0 Local Park 2 4
5636 5636 5635 {"type": "Polygon", "coordinates": [[[-122.63444, 38.23534], [-122.63418, 38.23571], [-122.63379, 38.23586], [-122.63372, 38.23586], [-122.63364, 38.23585], [-122.63289, 38.23545], [-122.63285, 38.23545], [-122.63279, 38.23547], [-122.63252, 38.23569], [-122.63254, 38.23561], [-122.63232, 38.23551], [-122.63121, 38.23488], [-122.63129, 38.23468], [-122.63126, 38.23465], [-122.63166, 38.23421], [-122.63111, 38.23393], [-122.63152, 38.23326], [-122.63195, 38.23347], [-122.63287, 38.23386], [-122.63321, 38.23397], [-122.63283, 38.23465], [-122.6335, 38.23491], [-122.6336, 38.23489], [-122.63374, 38.23473], [-122.63384, 38.23468], [-122.63395, 38.23468], [-122.6342, 38.23476], [-122.63429, 38.23482], [-122.63433, 38.2349], [-122.63429, 38.23523], [-122.63444, 38.23534]]]} Open Access 1 29793 McNear Peninsula Waterfront Park 22062 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 10.139 McNear Peninsula Waterfront Park 0 Local Park 2 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]);