superunits_with_maps

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

68 rows where MNG_AGENCY = 348

View and edit SQL

MNG_AG_TYP

MNG_AGENCY

  • Brentwood, City of · 68

ACCESS_TYP

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
374 373 {"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.7383, 37.95128], [-121.7385, 37.95126]]]} Open Access 1 Palamino Park   32101 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.608 Palamino Park  
399 398 {"type": "MultiPolygon", "coordinates": [[[[-121.74781, 37.93934], [-121.74693, 37.93984], [-121.74693, 37.9397], [-121.74681, 37.93944], [-121.74647, 37.93923], [-121.74662, 37.93903], [-121.74649, 37.93872], [-121.74644, 37.93871], [-121.74645, 37.93864], [-121.74641, 37.93858], [-121.74645, 37.93844], [-121.74635, 37.93823], [-121.74569, 37.93842], [-121.74512, 37.93853], [-121.74512, 37.93852], [-121.74516, 37.93848], [-121.74572, 37.93837], [-121.74615, 37.93825], [-121.74648, 37.93812], [-121.74682, 37.93797], [-121.74701, 37.9382], [-121.74707, 37.9383], [-121.74708, 37.93865], [-121.74743, 37.93872], [-121.74743, 37.93883], [-121.74736, 37.93893], [-121.74738, 37.93902], [-121.74744, 37.93907], [-121.74753, 37.93909], [-121.74757, 37.93919], [-121.74781, 37.93934]]], [[[-121.74657, 37.93787], [-121.74655, 37.93791], [-121.74606, 37.9381], [-121.74596, 37.93812], [-121.74591, 37.9381], [-121.74578, 37.93783], [-121.74538, 37.93731], [-121.74532, 37.93722], [-121.74527, 37.93704], [-121.74527, 37.93687], [-121.7453, 37.93678], [-121.74528, 37.93671], [-121.74539, 37.93662], [-121.74539, 37.93635], [-121.74625, 37.93634], [-121.7461, 37.93645], [-121.74602, 37.93646], [-121.74595, 37.93649], [-121.74591, 37.93655], [-121.7459, 37.93661], [-121.74594, 37.93667], [-121.74603, 37.93673], [-121.74605, 37.93676], [-121.74611, 37.93708], [-121.74622, 37.93737], [-121.74634, 37.93756], [-121.74656, 37.93783], [-121.74657, 37.93787]]]]} Open Access 1 Black Gold Park   32010 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 6.247 Black Gold Park  
400 399 {"type": "Polygon", "coordinates": [[[-121.69761, 37.94167], [-121.69761, 37.94193], [-121.69738, 37.94194], [-121.69738, 37.94174], [-121.69746, 37.94173], [-121.69756, 37.94167], [-121.69761, 37.94167]]]} Open Access 1 Curtis Park   32011 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.127 Curtis Park  
403 402 {"type": "Polygon", "coordinates": [[[-121.73893, 37.93421], [-121.73889, 37.93425], [-121.73874, 37.93424], [-121.73856, 37.93418], [-121.73841, 37.93409], [-121.73829, 37.93399], [-121.73882, 37.93382], [-121.7389, 37.93401], [-121.73893, 37.93411], [-121.73893, 37.93421]]]} Open Access 1 Berkshire Park   32013 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.395 Berkshire Park  
448 447 {"type": "Polygon", "coordinates": [[[-121.69153, 37.94118], [-121.69124, 37.94131], [-121.69115, 37.94124], [-121.69108, 37.94124], [-121.69101, 37.94125], [-121.69085, 37.94096], [-121.69115, 37.94096], [-121.69136, 37.94101], [-121.69153, 37.94118]]]} Open Access 1 Windsor Park   32048 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.349 Windsor Park  
452 451 {"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 Almanor Pocket Park   32049 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.107 Almanor PP  
456 455 {"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 Almond Park   32050 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1.389 Almond Park  
478 477 {"type": "Polygon", "coordinates": [[[-121.71487, 37.96473], [-121.71469, 37.96499], [-121.71459, 37.96524], [-121.71411, 37.96524], [-121.71413, 37.96451], [-121.71416, 37.96449], [-121.7144, 37.96449], [-121.71463, 37.96446], [-121.71475, 37.96461], [-121.71486, 37.96469], [-121.71487, 37.96473]]]} Open Access 1 Steeplechase Park   32061 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1.12 Steeplechase Park  
483 482 {"type": "Polygon", "coordinates": [[[-121.718, 37.95923], [-121.71694, 37.95922], [-121.71692, 37.95889], [-121.71693, 37.95864], [-121.71698, 37.95861], [-121.71732, 37.95861], [-121.71748, 37.95864], [-121.71769, 37.95873], [-121.71781, 37.95881], [-121.71793, 37.95897], [-121.71798, 37.95909], [-121.718, 37.95923]]]} Open Access 1 Wheatfield Pocket Park   32082 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1.328 Wheatfield PP  
498 497 {"type": "Polygon", "coordinates": [[[-121.71934, 37.96296], [-121.71931, 37.96301], [-121.71905, 37.96319], [-121.71887, 37.96326], [-121.71868, 37.96331], [-121.71867, 37.96328], [-121.7183, 37.96328], [-121.71827, 37.96326], [-121.71828, 37.96276], [-121.71867, 37.96275], [-121.71867, 37.96227], [-121.71878, 37.96245], [-121.71891, 37.96261], [-121.71909, 37.96276], [-121.71931, 37.9629], [-121.71934, 37.96296]]]} Open Access 1 Medallion Park   32079 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1.349 Medallion Park  
536 535 {"type": "Polygon", "coordinates": [[[-121.68502, 37.93332], [-121.68478, 37.93333], [-121.68477, 37.93286], [-121.68501, 37.93286], [-121.68502, 37.93332]]]} Open Access 1 Rice Pocket Park   32117 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.271 Rice PP  
540 539 {"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 Stonehaven Park   32114 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.141 Stonehaven Park  
608 607 {"type": "Polygon", "coordinates": [[[-121.71387, 37.95128], [-121.71372, 37.95122], [-121.71357, 37.95117], [-121.7134, 37.95115], [-121.71292, 37.95113], [-121.71277, 37.95109], [-121.71258, 37.95102], [-121.71276, 37.95077], [-121.71319, 37.95053], [-121.71387, 37.95128]]]} Open Access 1 Caboose Park   32093 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 1.013 Caboose Park  
612 611 {"type": "Polygon", "coordinates": [[[-121.73119, 37.95185], [-121.73119, 37.95226], [-121.73077, 37.95226], [-121.73077, 37.9519], [-121.73078, 37.95186], [-121.73119, 37.95185]]]} Open Access 1 Fruitwood Park   32098 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.417 Fruitwood Park  
613 612 {"type": "Polygon", "coordinates": [[[-121.7244, 37.95094], [-121.72439, 37.95128], [-121.72409, 37.95128], [-121.7241, 37.95099], [-121.72412, 37.95095], [-121.72417, 37.95094], [-121.7244, 37.95094]]]} Open Access 1 La Pergola Pocket Park   32096 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.244 La Pergola PP  
614 613 {"type": "Polygon", "coordinates": [[[-121.7242, 37.95297], [-121.72419, 37.95332], [-121.72412, 37.95332], [-121.72407, 37.9533], [-121.72405, 37.95326], [-121.72406, 37.95297], [-121.7242, 37.95297]]]} Open Access 1 Giotto Pocket Park   32097 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.112 Giotto PP  
618 617 {"type": "Polygon", "coordinates": [[[-121.72506, 37.94971], [-121.72502, 37.94983], [-121.72487, 37.94983], [-121.72487, 37.94959], [-121.72504, 37.94968], [-121.72506, 37.94971]]]} Open Access 1 Fiorita Pocket Park   32099 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.083 Fiorita PP  
619 618 {"type": "Polygon", "coordinates": [[[-121.74031, 37.95246], [-121.74031, 37.95295], [-121.73971, 37.95295], [-121.73971, 37.95246], [-121.74031, 37.95246]]]} Open Access 1 Appaloosa Park   32100 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.713 Appaloosa Park  
620 619 {"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 Cherry Park   32103 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.435 Cherry Park  
621 620 {"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.73787, 37.93046], [-121.73791, 37.93053]]]} Open Access 1 Cortona Park   32104 1034 Brentwood, City of 348 City 2 City Agency 2 http://www.brentwoodca.gov/gov/parks/default.asp City 2 0.308 Cortona Park  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY(ACCESS_TYP) REFERENCES ACCESS_TYP(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(LAYER) REFERENCES LAYER(id)
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
                ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
                ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
                ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
                ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
                ON [superunits_with_maps] ([ACCESS_TYP]);
Powered by Datasette · Query took 47.242ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette