units_with_maps

Table actions

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

12 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 352

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP, DES_TP

MNG_AGENCY 1

  • Martinez, City of · 12 ✖

ACCESS_TYP 1

  • Open Access · 12 ✖
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
1373 1373 1372 {"type": "Polygon", "coordinates": [[[-122.12277, 37.98731], [-122.12226, 37.98757], [-122.12207, 37.98735], [-122.12185, 37.98743], [-122.12071, 37.98629], [-122.12149, 37.98589], [-122.12277, 37.98731]]]} Open Access 1 12112 Nancy Boyd Park 22623 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 3.529 Nancy Boyd Park 0 Local Park 2 4
1588 1588 1587 {"type": "Polygon", "coordinates": [[[-122.13539, 38.01361], [-122.13479, 38.01396], [-122.1344, 38.01352], [-122.13499, 38.01317], [-122.13539, 38.01361]]]} Open Access 1 12148 Ygnacio Plaza Martinez Park 27770 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 0.965 Ygnacio Plaza Martinez Park 0 Local Park 2 4
2451 2451 2450 {"type": "Polygon", "coordinates": [[[-122.14512, 38.01547], [-122.14511, 38.01555], [-122.14506, 38.01563], [-122.14493, 38.01567], [-122.1447, 38.01566], [-122.14462, 38.01569], [-122.14447, 38.01578], [-122.14423, 38.016], [-122.14414, 38.01615], [-122.14397, 38.01638], [-122.14379, 38.01658], [-122.14259, 38.01583], [-122.14436, 38.01553], [-122.14435, 38.01531], [-122.14439, 38.01527], [-122.14494, 38.01527], [-122.14508, 38.01538], [-122.14512, 38.01547]]]} Open Access 1 12183 Rankin Park 24186 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 3.017 Rankin Park 0 Local Park 2 4
5150 5150 5149 {"type": "Polygon", "coordinates": [[[-122.13398, 38.01445], [-122.13343, 38.01479], [-122.13301, 38.01435], [-122.13357, 38.01402], [-122.13398, 38.01445]]]} Open Access 1 12160 Susana Park 26080 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 0.914 Susana Park 0 Local Park 2 4
7584 7584 7583 {"type": "Polygon", "coordinates": [[[-122.09881, 37.96587], [-122.09858, 37.96595], [-122.09694, 37.96348], [-122.09736, 37.96373], [-122.09774, 37.96377], [-122.09788, 37.96445], [-122.09881, 37.96587]]]} Open Access 1 12171 Foothills Park 18983 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 1.866 Foothills Park 2000 Local Park 2 4
7767 7767 7766 {"type": "Polygon", "coordinates": [[[-122.09667, 37.99585], [-122.09615, 37.99596], [-122.09581, 37.99551], [-122.09495, 37.99462], [-122.09564, 37.9944], [-122.09667, 37.99585]]]} Open Access 1 12124 Holiday Highlands Park 20030 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 2.388 Holiday Highlands Park 0 Local Park 2 4
8081 8081 8080 {"type": "Polygon", "coordinates": [[[-122.12208, 37.99953], [-122.12207, 38.00049], [-122.12143, 38.0005], [-122.12061, 37.99958], [-122.12208, 37.99953]]]} Open Access 1 12100 John Muir Park 20458 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 2.42 John Muir Park 0 Local Park 2 4
8083 8083 8082 {"type": "Polygon", "coordinates": [[[-122.11593, 38.00143], [-122.11599, 38.00166], [-122.11582, 38.0035], [-122.11502, 38.00348], [-122.11518, 38.00271], [-122.11518, 38.00234], [-122.11486, 38.00192], [-122.11442, 38.00148], [-122.11593, 38.00143]]]} Open Access 1 12089 Mountainview Park 22564 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 4.521 Mountainview Park 0 Local Park 2 4
8100 8100 8099 {"type": "Polygon", "coordinates": [[[-122.12743, 38.01388], [-122.12684, 38.01421], [-122.12642, 38.01377], [-122.12703, 38.01344], [-122.12743, 38.01388]]]} Open Access 1 12136 Cappy Ricks Park 16841 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 0.968 Cappy Ricks Park 0 Local Park 2 4
9288 9288 9287 {"type": "Polygon", "coordinates": [[[-122.12948, 38.0189], [-122.12919, 38.01904], [-122.12882, 38.01857], [-122.12913, 38.01843], [-122.12948, 38.0189]]]} Open Access 1 15506 Highland Avenue Park 19929 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 0.453 Highland Avenue Park 0 Local Park 2 4
9304 9304 9303 {"type": "Polygon", "coordinates": [[[-122.10163, 38.00127], [-122.10134, 38.00127], [-122.10128, 38.0012], [-122.10118, 38.00117], [-122.10025, 38.00119], [-122.10021, 38.00118], [-122.10015, 38.00111], [-122.10007, 38.00109], [-122.09999, 38.00111], [-122.09994, 38.00116], [-122.09955, 38.00116], [-122.09954, 38.0007], [-122.10162, 38.00068], [-122.10163, 38.00127]]]} Open Access 1 15508 Morello Park 22476 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 2.458 Morello Park 0 Local Park 2 4
10155 10155 10154 {"type": "Polygon", "coordinates": [[[-122.11132, 37.96097], [-122.11095, 37.96139], [-122.11059, 37.96121], [-122.11025, 37.96163], [-122.11003, 37.96435], [-122.10815, 37.96267], [-122.10729, 37.96263], [-122.10597, 37.96145], [-122.10589, 37.96083], [-122.10616, 37.96082], [-122.1081, 37.96183], [-122.1083, 37.96161], [-122.10843, 37.96151], [-122.10862, 37.96129], [-122.10842, 37.96118], [-122.10915, 37.96066], [-122.10919, 37.96072], [-122.10951, 37.96049], [-122.10973, 37.96048], [-122.11008, 37.9602], [-122.11104, 37.96083], [-122.11132, 37.96097]]]} Open Access 1 17697 Golden Hills Park 19364 1198 Martinez, City of 355 City 2 City Agency 2 http://www.cityofmartinez.org/depts/recreation/parks/default.asp City 2 1198 Martinez, City of 352 City 2 City Agency 2   Contra Costa 12 20.421 Golden Hills 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]);