Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 159181 | 159181 | 98310 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1499@Newhall Evans Ave | 2 | Front Yard : 25 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 4 | Permit Number 768575 | 6016248.7932 | 2098029.2738099997 | 37.7417009175609 | -122.38640138991501 | (37.7417009175609, -122.386401389915) | ||
| 12077 | 12077 | 94990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.40477981842301 | (37.7116594240627, -122.404779818423) | ||||
| 88454 | 88454 | 94991 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010722.4 | 2087213.8 | 37.7116964188451 | -122.40474867386699 | (37.7116964188451, -122.404748673867) | ||||
| 183449 | 183449 | 190390 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1750 22nd St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 1 | 6012854.72935 | 2103804.1749299997 | 37.7573690942352 | -122.39854214671699 | (37.7573690942352, -122.398542146717) | ||||
| 49605 | 49605 | 87302 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 4 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 1 | Permit Number 50312 | 6011942.20762 | 2100900.73993 | 37.7493460165275 | -122.401493976188 | (37.7493460165275, -122.401493976188) | |||
| 28143 | 28143 | 87300 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 2 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 6 | Permit Number 50312 | 6011877.987480001 | 2100898.0514700003 | 37.749335051069004 | -122.401715863223 | (37.749335051069, -122.401715863223) | |||
| 49336 | 49336 | 87301 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 3 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 5 | Permit Number 50312 | 6011915.6161 | 2100899.61614 | 37.7493414470685 | -122.401585851825 | (37.7493414470685, -122.401585851825) | |||
| 152183 | 152183 | 87299 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 4 | Permit Number 50312 | 6011851.38946 | 2100896.5951099996 | 37.7493295679091 | -122.401807737936 | (37.7493295679091, -122.401807737936) | |||
| 6197 | 6197 | 23919 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1700X Webster St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6x6 | 6003523.3584 | 2114587.3577 | 37.7864527963196 | -122.431583520291 | (37.7864527963196, -122.431583520291) | |||
| 110746 | 110746 | 3757 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1056 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | |||
| 119885 | 119885 | 3756 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 1056 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012452.0863519 | 2103047.5184298 | 37.7552690413169 | -122.399881522302 | (37.7552690413169, -122.399881522302) | |||
| 39579 | 39579 | 244952 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 290 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 0ft | 6005205.1684 | 2109938.5353 | 37.7737834538473 | -122.425433917449 | (37.7737834538473, -122.425433917449) | |||
| 57029 | 57029 | 129009 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1137 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6011525.133769999 | 2119231.5602700002 | 37.7996549551749 | -122.404226217291 | (37.7996549551749, -122.404226217291) | |||
| 60014 | 60014 | 129023 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 400 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6011906.72239 | 2116826.4681700002 | 37.793072464585705 | -122.40273653976001 | (37.7930724645857, -122.40273653976) | |||
| 69471 | 69471 | 128994 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1414 Jones St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6008423.060869999 | 2117463.28601 | 37.794625888727495 | -122.41483533869801 | (37.7946258887275, -122.414835338698) | |||
| 147927 | 147927 | 226015 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2440 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6011224.38926 | 2102319.5101099997 | 37.753201570213896 | -122.404076055683 | (37.7532015702139, -122.404076055683) | |||
| 153634 | 153634 | 129024 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 400 Montgomery St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6011905.28525 | 2116843.33674 | 37.7931187014156 | -122.40274269923 | (37.7931187014156, -122.40274269923) | |||
| 160831 | 160831 | 128995 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1414 Jones St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6008424.44271 | 2117443.95005 | 37.794572874590294 | -122.41482918821 | (37.7945728745903, -122.41482918821) | |||
| 162869 | 162869 | 228337 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1768 Sanchez St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6003964.05943 | 2097961.58291 | 37.740827380874 | -122.428873076831 | (37.740827380874, -122.428873076831) | |||
| 164823 | 164823 | 226270 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 4491 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 26 | Width 8ft | 6000072.435819999 | 2101640.71207 | 37.7507083509117 | -122.442592908247 | (37.7507083509117, -122.442592908247) | |||
| 4344 | 4344 | 253624 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 735 Teresita Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2095994.0 | 37.735140362702396 | -122.446033688862 | (37.7351403627024, -122.446033688862) | ||||
| 27623 | 27623 | 192472 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 654 Minnesota St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 6015145.36132 | 2105441.65157 | 37.7619925996904 | -122.39073459873 | (37.7619925996904, -122.39073459873) | |||
| 29108 | 29108 | 190519 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 299 Bryant St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6015412.9478400005 | 2114035.0221599997 | 37.785602934875 | -122.39040956394501 | (37.785602934875, -122.390409563945) | |||
| 29354 | 29354 | 228255 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 470 Liberty St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6003278.43337 | 2103915.98823 | 37.7571379513705 | -122.43166872824301 | (37.7571379513705, -122.431668728243) | |||
| 29807 | 29807 | 226269 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 601 Grand View Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6000052.32454 | 2101592.71128 | 37.7505754059276 | -122.442659008402 | (37.7505754059276, -122.442659008402) | |||
| 31920 | 31920 | 228243 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 396 Cumberland St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6003155.66776 | 2104492.3906900003 | 37.758713655324 | -122.43213446015301 | (37.758713655324, -122.432134460153) | |||
| 32867 | 32867 | 219077 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 494 Victoria St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993267.6387 | 2090426.62452 | 37.7195270128342 | -122.465309800205 | (37.7195270128342, -122.465309800205) | |||
| 38697 | 38697 | 228343 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 50 Everson St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6003603.71357 | 2097148.2169 | 37.7385736618306 | -122.43006100933201 | (37.7385736618306, -122.430061009332) | |||
| 39620 | 39620 | 124187 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 40 Almaden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5995896.10311 | 2112493.6287599998 | 37.7802687106807 | -122.45782018278999 | (37.7802687106807, -122.45782018279) | ||||
| 43260 | 43260 | 192448 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2310 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6010888.50248 | 2105103.3176 | 37.7608265135647 | -122.40543366323 | (37.7608265135647, -122.40543366323) | |||
| 47942 | 47942 | 219125 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 149 Hamerton Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6001356.75125 | 2095315.06653 | 37.733412742195505 | -122.43769866186899 | (37.7334127421955, -122.437698661869) | |||
| 48307 | 48307 | 192459 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 651 Indiana St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6014938.7100599995 | 2105394.68115 | 37.761852161564605 | -122.391446047021 | (37.7618521615646, -122.391446047021) | |||
| 49658 | 49658 | 190382 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2350 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6011068.2259 | 2104645.22046 | 37.7595787284893 | -122.404779824648 | (37.7595787284893, -122.404779824648) | |||
| 55598 | 55598 | 219114 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 409 Bella Vista Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5997404.49541 | 2096329.01275 | 37.73597127834321 | -122.451435758472 | (37.7359712783432, -122.451435758472) | |||
| 57546 | 57546 | 219112 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 130 Brentwood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5995677.34458 | 2095602.5386599998 | 37.7338775046316 | -122.457354631219 | (37.7338775046316, -122.457354631219) | |||
| 58695 | 58695 | 190381 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2350 20th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 6011079.30934 | 2104645.54641 | 37.7595802429642 | -122.404741515334 | (37.7595802429642, -122.404741515334) | |||
| 63296 | 63296 | 129013 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 150 Francisco St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6010602.08919 | 2121361.05101 | 37.8054503923804 | -122.40757052527799 | (37.8054503923804, -122.407570525278) | ||||
| 71739 | 71739 | 219142 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 255 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998385.58971 | 2093771.8377200002 | 37.7290060129005 | -122.44785969336901 | (37.7290060129005, -122.447859693369) | ||||
| 71798 | 71798 | 192460 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 651 Indiana St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 6014934.120519999 | 2105449.3054400003 | 37.7620018933059 | -122.391465739479 | (37.7620018933059, -122.391465739479) | |||
| 74303 | 74303 | 192449 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2310 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010874.27982 | 2105104.21282 | 37.760828176397 | -122.405482916403 | (37.760828176397, -122.405482916403) | |||
| 75653 | 75653 | 219115 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 409 Bella Vista Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5997400.88581 | 2096335.81192 | 37.7359897405315 | -122.451448728489 | (37.7359897405315, -122.451448728489) | |||
| 129993 | 129993 | 128906 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 586 Spruce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5997146.092730001 | 2113991.53957 | 37.7844533108166 | -122.453604104844 | (37.7844533108166, -122.453604104844) | |||
| 136093 | 136093 | 219113 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 409 Bella Vista Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5997408.05803 | 2096319.9732700002 | 37.7359466621108 | -122.451422789356 | (37.7359466621108, -122.451422789356) | |||
| 138013 | 138013 | 192450 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2310 19th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6010867.63579 | 2105104.33666 | 37.7608281449347 | -122.40550590399599 | (37.7608281449347, -122.405505903996) | |||
| 147869 | 147869 | 176549 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 65 Ocean Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6001075.93443 | 2091730.69509 | 37.7235549090091 | -122.438412809004 | (37.7235549090091, -122.438412809004) | ||||
| 148595 | 148595 | 192474 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 654 Minnesota St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 6015149.97171 | 2105400.79096 | 37.761880661075395 | -122.390715797509 | (37.7618806610754, -122.390715797509) | |||
| 155568 | 155568 | 192451 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2310 19th St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6010858.43231 | 2105104.6131700003 | 37.760828389551705 | -122.405537754389 | (37.7608283895517, -122.405537754389) | |||
| 158625 | 158625 | 129012 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 150 Francisco St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6010624.52904 | 2121364.4676099997 | 37.8054610295673 | -122.40749310981501 | (37.8054610295673, -122.407493109815) | ||||
| 159270 | 159270 | 190365 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1401 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6014443.688019999 | 2101979.23692 | 37.75244659923371 | -122.392919179687 | (37.7524465992337, -122.392919179687) | ||||
| 160784 | 160784 | 192473 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 654 Minnesota St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6015149.47337 | 2105409.76647 | 37.7619052782381 | -122.390718148338 | (37.7619052782381, -122.390718148338) | |||
| 168120 | 168120 | 129006 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Fallon Pl | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6008915.40705 | 2118578.41421 | 37.7977154080083 | -122.41321064328301 | (37.7977154080083, -122.413210643283) | ||||
| 168686 | 168686 | 190518 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 299 Bryant St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6015402.02385 | 2114023.64667 | 37.785571094386 | -122.390446562985 | (37.785571094386, -122.390446562985) | |||
| 172043 | 172043 | 228254 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 470 Liberty St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6003313.06662 | 2103916.0849200003 | 37.7571401799037 | -122.431548960114 | (37.7571401799037, -122.431548960114) | |||
| 3256 | 3256 | 253373 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 78 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010457.0 | 2100357.0 | 37.7477700431666 | -122.406591570174 | (37.7477700431666, -122.406591570174) | ||||
| 30450 | 30450 | 249647 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2460 Lyon St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 10ft | 5999284.57219 | 2117293.7782799997 | 37.7936427489551 | -122.44644337897101 | (37.7936427489551, -122.446443378971) | |||
| 30493 | 30493 | 226043 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 San Jose Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6003683.45226 | 2095797.6378400002 | 37.7348697950059 | -122.42968901103399 | (37.7348697950059, -122.429689011034) | ||||
| 46848 | 46848 | 249650 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2401 Lyon St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | Width 10ft | 5999216.2482900005 | 2117285.03492 | 37.793614839395204 | -122.446679155136 | (37.7936148393952, -122.446679155136) | |||
| 60175 | 60175 | 226041 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 200 Eugenia Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6006552.18069 | 2098105.68452 | 37.741369201715706 | -122.419934527956 | (37.7413692017157, -122.419934527956) | ||||
| 136695 | 136695 | 226042 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 200 Eugenia Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6006560.74599 | 2098108.17356 | 37.7413765186154 | -122.419905088663 | (37.7413765186154, -122.419905088663) | ||||
| 148579 | 148579 | 88446 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1629 Green St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 51411 | 6005229.98772 | 2118491.64787 | 37.7972695780743 | -122.42595703411301 | (37.7972695780743, -122.425957034113) | ||
| 185839 | 185839 | 250211 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 212 Union St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 0ft | 6011741.8662 | 2119796.92436 | 37.80121941579 | -122.40351603796002 | (37.80121941579, -122.40351603796) | |||
| 132 | 132 | 116641 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 138 | 138 | 72565 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/16/1996 12:00:00 AM | 3 | 4x4 | Permit Number 770847 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |
| 139 | 139 | 116640 | Planning Code 138.1 required 4 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 10627 | 10627 | 1283 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 3995X Alemany Blvd | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 10x10 | 5992081.50866 | 2087171.0422099999 | 37.710519496741206 | -122.469172961285 | (37.7105194967412, -122.469172961285) | |||
| 24908 | 24908 | 116642 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 3x3 | 6015144.15756 | 2112956.70855 | 37.7826272167081 | -122.391264104249 | (37.7826272167081, -122.391264104249) | |||
| 82951 | 82951 | 109969 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1x DAVIS ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 18 | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | |
| 110771 | 110771 | 109970 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 44 | 1x DAVIS ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/28/2015 12:00:00 AM | 3x3 | Permit Number 774526 | 6013431.7 | 2116562.3 | 37.7924321476874 | -122.397441457592 | (37.7924321476874, -122.397441457592) | ||
| 24599 | 24599 | 225999 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 700 Duboce Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6002335.19401 | 2108315.06979 | 37.7691632487104 | -122.435245457027 | (37.7691632487104, -122.435245457027) | |||
| 24622 | 24622 | 247221 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Divisadero St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6001849.330080001 | 2108668.89946 | 37.770107174421796 | -122.436951364836 | (37.7701071744218, -122.436951364836) | |||
| 26377 | 26377 | 225990 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2 Pearl St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6005601.0883599995 | 2108893.1022200002 | 37.7709353079426 | -122.42399000814 | (37.7709353079426, -122.42399000814) | |||
| 26671 | 26671 | 190388 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 700 Rhode Island St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6011799.90498 | 2105067.41512 | 37.7607788503881 | -122.402278983608 | (37.7607788503881, -122.402278983608) | |||
| 28109 | 28109 | 190386 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 767 Rhode Island St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6011868.88552 | 2104842.63412 | 37.7601655019667 | -122.40202460676201 | (37.7601655019667, -122.402024606762) | |||
| 29498 | 29498 | 190455 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1751 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013882.7499 | 2094972.5307 | 37.7331764776989 | -122.39436846503901 | (37.7331764776989, -122.394368465039) | |||
| 31173 | 31173 | 225996 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 47 Octavia St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6005638.67194 | 2109514.80428 | 37.7726444739859 | -122.423904220905 | (37.7726444739859, -122.423904220905) | |||
| 32001 | 32001 | 190434 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 33 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017509.45239 | 2097206.48557 | 37.739511409230104 | -122.381985187163 | (37.7395114092301, -122.381985187163) | |||
| 32400 | 32400 | 192428 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 480 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6014110.58587 | 2112833.82618 | 37.782232395453796 | -122.39483123728 | (37.7822323954538, -122.39483123728) | |||
| 33767 | 33767 | 190391 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 571 Texas St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6013851.28196 | 2104449.17868 | 37.75919560292179 | -122.395140827087 | (37.7591956029218, -122.395140827087) | |||
| 35117 | 35117 | 190404 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 11 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012224.99422 | 2100912.98992 | 37.74939542707129 | -122.40051694820801 | (37.7493954270713, -122.400516948208) | |||
| 35280 | 35280 | 190389 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 707 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012743.008909999 | 2104201.32754 | 37.7584533636396 | -122.398956396938 | (37.7584533636396, -122.398956396938) | |||
| 36209 | 36209 | 190444 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1301 Evans Ave | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017091.55638 | 2097401.29734 | 37.7400232358798 | -122.383443661803 | (37.7400232358798, -122.383443661803) | |||
| 37346 | 37346 | 190445 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1201 Evans Ave | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017686.12557 | 2096959.12409 | 37.738841959282205 | -122.381357125839 | (37.7388419592822, -122.381357125839) | |||
| 37437 | 37437 | 190397 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012152.10777 | 2100910.4709400004 | 37.7493844454379 | -122.400768815931 | (37.7493844454379, -122.400768815931) | |||
| 39757 | 39757 | 202047 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 55 Exeter St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012547.51313 | 2090916.47332 | 37.721965061416796 | -122.398700225048 | (37.7219650614168, -122.398700225048) | |||
| 39849 | 39849 | 190429 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 27 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017626.76379 | 2097120.54655 | 37.7392819157251 | -122.381573596257 | (37.7392819157251, -122.381573596257) | |||
| 39886 | 39886 | 190442 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1355 Evans Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6016877.61035 | 2097560.61603 | 37.740448866128204 | -122.384194498593 | (37.7404488661282, -122.384194498593) | |||
| 39953 | 39953 | 246990 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 78 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 6004670.61163 | 2101066.74727 | 37.7493934152835 | -122.426651147943 | (37.7493934152835, -122.426651147943) | |||
| 40843 | 40843 | 192425 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 187 Clara St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6011952.39777 | 2111919.37561 | 37.779601291212394 | -122.402233334018 | (37.7796012912124, -122.402233334018) | |||
| 42115 | 42115 | 192437 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 106 Langton St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6010237.3697 | 2110691.53515 | 37.7761340485805 | -122.40807976548099 | (37.7761340485805, -122.408079765481) | |||
| 42788 | 42788 | 246481 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 330 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 5ft | 6004176.06205 | 2099871.25195 | 37.74608289033021 | -122.42827612036301 | (37.7460828903302, -122.428276120363) | |||
| 44896 | 44896 | 190421 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 17 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017813.9736 | 2096980.8190099997 | 37.7389085864479 | -122.38091659022899 | (37.7389085864479, -122.380916590229) | |||
| 45841 | 45841 | 190426 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 24 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6017676.692919999 | 2097082.9618400002 | 37.7391814722423 | -122.381398348955 | (37.7391814722423, -122.381398348955) | |||
| 46420 | 46420 | 190420 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 16 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017827.78919 | 2096970.1308799998 | 37.7388800015007 | -122.380868079005 | (37.7388800015007, -122.380868079005) | |||
| 49397 | 49397 | 192435 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 382 07th St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6010717.744530001 | 2110532.78766 | 37.7757250495103 | -122.406406823243 | (37.7757250495103, -122.406406823243) | |||
| 49434 | 49434 | 247805 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 488 30th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6003450.91279 | 2098365.25645 | 37.741906717527705 | -122.43067614380199 | (37.7419067175277, -122.430676143802) | |||
| 50394 | 50394 | 190425 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 23 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017693.17965 | 2097070.35958 | 37.739147779140396 | -122.38134046861299 | (37.7391477791404, -122.381340468613) | |||
| 50600 | 50600 | 219079 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2674 Ocean Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5990725.25402 | 2095140.06488 | 37.7323219940584 | -122.474441593613 | (37.7323219940584, -122.474441593613) | |||
| 51729 | 51729 | 176543 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 100 Panama St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992283.95996 | 2086838.07777 | 37.709616952417704 | -122.468449043003 | (37.7096169524177, -122.468449043003) | |||
| 52901 | 52901 | 190422 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 1300 Evans Ave | 18 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6017797.18223 | 2096994.0322599998 | 37.7389439406012 | -122.38097556597299 | (37.7389439406012, -122.380975565973) | |||
| 53438 | 53438 | 190407 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 13 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012292.256030001 | 2100918.21603 | 37.74941352772171 | -122.40028472078998 | (37.7494135277217, -122.40028472079) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");