units_with_maps

Table actions

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

63 rows where DES_TP = 2, MNG_AGENCY = 348 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

  • City Agency · 63 ✖

MNG_AGENCY 1

  • Brentwood, City of · 63 ✖

DES_TP 1

  • Local Park · 63 ✖

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
1351 1351 1350 {"type": "Polygon", "coordinates": [[[-121.69897, 37.92733], [-121.69896, 37.92916], [-121.69801, 37.92915], [-121.69802, 37.92899], [-121.69829, 37.92877], [-121.69827, 37.92732], [-121.69897, 37.92733]]]} Open Access 1 11414 McClarren Park 21997 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 3.186 McClarren Park 0 Local Park 2 4
1352 1352 1351 {"type": "Polygon", "coordinates": [[[-121.69054, 37.92014], [-121.6899, 37.92051], [-121.68948, 37.92005], [-121.69016, 37.91969], [-121.69054, 37.92014]]]} Open Access 1 11501 Glory Park 19349 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 1.072 Glory Park 0 Local Park 2 4
1517 1517 1516 {"type": "Polygon", "coordinates": [[[-121.7324, 37.92885], [-121.73174, 37.92982], [-121.73166, 37.92985], [-121.72989, 37.92896], [-121.73018, 37.92863], [-121.73051, 37.92855], [-121.73172, 37.92869], [-121.73214, 37.92876], [-121.7324, 37.92885]]]} Open Access 1 11473 Apple Hill Park 15539 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 4.417 Apple Hill Park 0 Local Park 2 4
1641 1641 1640 {"type": "Polygon", "coordinates": [[[-121.7385, 37.95126], [-121.7385, 37.95176], [-121.73807, 37.95175], [-121.73798, 37.95173], [-121.73794, 37.95169], [-121.73791, 37.95162], [-121.73793, 37.95146], [-121.73794, 37.95141], [-121.73799, 37.95136], [-121.73807, 37.95133], [-121.73831, 37.95128], [-121.7385, 37.95126]]]} Open Access 1 47943 Palamino Park 32101 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 0.608 Palamino Park 0 Local Park 2 4
2318 2318 2317 {"type": "Polygon", "coordinates": [[[-121.70874, 37.95011], [-121.70776, 37.9515], [-121.70707, 37.95073], [-121.70736, 37.95001], [-121.70749, 37.94978], [-121.70758, 37.94967], [-121.70762, 37.94964], [-121.70771, 37.94965], [-121.70874, 37.95011]]]} Open Access 1 47936 Blue Goose Park 32090 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 4.006 Blue Goose Park 0 Local Park 2 4
2327 2327 2326 {"type": "Polygon", "coordinates": [[[-121.73383, 37.94934], [-121.73383, 37.94951], [-121.73379, 37.94955], [-121.73343, 37.94958], [-121.73313, 37.94958], [-121.73309, 37.94957], [-121.73306, 37.94953], [-121.73306, 37.94933], [-121.73383, 37.94934]]]} Open Access 1 47945 Cherry Park 32103 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 0.435 Cherry Park 0 Local Park 2 4
2328 2328 2327 {"type": "Polygon", "coordinates": [[[-121.73791, 37.93053], [-121.73775, 37.93058], [-121.7371, 37.93028], [-121.73713, 37.93021], [-121.7373, 37.93016], [-121.73735, 37.93021], [-121.73741, 37.93024], [-121.73749, 37.93025], [-121.73757, 37.93022], [-121.73763, 37.93035], [-121.73776, 37.93046], [-121.73782, 37.93047], [-121.73787, 37.93046], [-121.73791, 37.93053]]]} Open Access 1 47946 Cortona Park 32104 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 0.306 Cortona Park 0 Local Park 2 4
2330 2330 2329 {"type": "Polygon", "coordinates": [[[-121.68551, 37.94267], [-121.68464, 37.94266], [-121.68454, 37.94269], [-121.68446, 37.94275], [-121.68445, 37.942], [-121.68453, 37.94206], [-121.68463, 37.94208], [-121.68551, 37.94206], [-121.68551, 37.94267]]]} Open Access 1 47955 Mallard Park 32126 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 1.528 Mallard Park 0 Local Park 2 4
2332 2332 2331 {"type": "Polygon", "coordinates": [[[-121.68867, 37.94427], [-121.68866, 37.94482], [-121.68793, 37.94481], [-121.68787, 37.94478], [-121.68787, 37.94432], [-121.6879, 37.94427], [-121.68794, 37.94426], [-121.68867, 37.94427]]]} Open Access 1 47956 Pelican Park 32127 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 1.051 Pelican Park 0 Local Park 2 4
2353 2353 2352 {"type": "Polygon", "coordinates": [[[-121.71757, 37.93894], [-121.71719, 37.9393], [-121.71718, 37.93998], [-121.71723, 37.94015], [-121.71721, 37.94019], [-121.71703, 37.94018], [-121.71584, 37.93936], [-121.71585, 37.93876], [-121.71616, 37.93876], [-121.7162, 37.93712], [-121.71667, 37.93708], [-121.7167, 37.93662], [-121.71649, 37.93661], [-121.71647, 37.93649], [-121.71711, 37.93655], [-121.71714, 37.93833], [-121.71757, 37.93894]]]} Open Access 1 11402 Summerwood Park 25963 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 8.365 Summerwood Park 0 Local Park 2 4
2389 2389 2388 {"type": "Polygon", "coordinates": [[[-121.6885, 37.93079], [-121.68764, 37.93079], [-121.68768, 37.92743], [-121.68846, 37.92741], [-121.68847, 37.92742], [-121.6885, 37.93079]]]} Open Access 1 11489 Garin Park 19219 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 6.72 Garin Park 0 Local Park 2 4
2392 2392 2391 {"type": "Polygon", "coordinates": [[[-121.69418, 37.91989], [-121.69378, 37.92012], [-121.69347, 37.91978], [-121.69389, 37.91954], [-121.69418, 37.91989]]]} Open Access 1 11512 Spirit Park 25725 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 0.522 Spirit Park 0 Local Park 2 4
2513 2513 2512 {"type": "Polygon", "coordinates": [[[-121.73593, 37.94812], [-121.73565, 37.94812], [-121.73554, 37.94817], [-121.73546, 37.94809], [-121.73534, 37.94805], [-121.73409, 37.94804], [-121.73404, 37.948], [-121.73403, 37.94789], [-121.73398, 37.94779], [-121.73391, 37.94774], [-121.73378, 37.94771], [-121.73545, 37.94772], [-121.73593, 37.94812]]]} Open Access 1 47923 Almond Park 32050 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 1.389 Almond Park 0 Local Park 2 4
2521 2521 2520 {"type": "Polygon", "coordinates": [[[-121.68782, 37.93181], [-121.68752, 37.93182], [-121.68752, 37.93182], [-121.68753, 37.93177], [-121.68757, 37.93171], [-121.68782, 37.93158], [-121.68782, 37.93181]]]} Open Access 1 47922 Almanor Pocket Park 32049 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 0.107 Almanor PP 0 Local Park 2 4
3376 3376 3375 {"type": "Polygon", "coordinates": [[[-121.72839, 37.95212], [-121.72745, 37.9521], [-121.72746, 37.95152], [-121.72839, 37.9515], [-121.72839, 37.95212]]]} Open Access 1 24472 Yokut Park 27773 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 1.362 Yokut Park 0 Local Park 2 4
4248 4248 4247 {"type": "Polygon", "coordinates": [[[-121.72041, 37.93322], [-121.72041, 37.93341], [-121.72006, 37.93341], [-121.72011, 37.93326], [-121.72014, 37.93323], [-121.72041, 37.93322]]]} Open Access 1 47950 Stonehaven Park 32114 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 0.141 Stonehaven Park 0 Local Park 2 4
5191 5191 5190 {"type": "Polygon", "coordinates": [[[-121.6856, 37.93691], [-121.6856, 37.93746], [-121.68543, 37.93746], [-121.68543, 37.93691], [-121.6856, 37.93691]]]} Open Access 1 47953 Sawyer Pocket Park 32123 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 0.225 Sawyer PP 0 Local Park 2 4
5202 5202 5201 {"type": "Polygon", "coordinates": [[[-121.73096, 37.96109], [-121.73096, 37.9614], [-121.73047, 37.9614], [-121.73066, 37.9611], [-121.73074, 37.96112], [-121.73086, 37.96109], [-121.73096, 37.96109]]]} Open Access 1 47924 Amber Park 32051 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 0.281 Amber Park 0 Local Park 2 4
6517 6517 6516 {"type": "Polygon", "coordinates": [[[-121.71465, 37.92218], [-121.71415, 37.9226], [-121.714, 37.92308], [-121.71255, 37.92315], [-121.71247, 37.9229], [-121.71262, 37.92219], [-121.71315, 37.92159], [-121.71359, 37.92124], [-121.71414, 37.92094], [-121.71421, 37.92151], [-121.71441, 37.92186], [-121.71465, 37.92218]]]} Open Access 1 2754 Creekside Park 17771 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 6.922 Creekside Park 0 Local Park 2 4
7121 7121 7120 {"type": "Polygon", "coordinates": [[[-121.69461, 37.95525], [-121.69461, 37.95525], [-121.69322, 37.95527], [-121.69369, 37.95481], [-121.69393, 37.95494], [-121.6946, 37.95493], [-121.69461, 37.95525]]]} Open Access 1 11352 Homecoming Park 20059 1034 Brentwood, City of 351 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1034 Brentwood, City of 348 City 2 City Agency 2   Contra Costa 12 1.004 Homecoming 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]);