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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 184047 | 184047 | 201550 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6020135.10106 | 2093474.49697 | 37.7294087400981 | -122.372648486831 | (37.7294087400981, -122.372648486831) | ||||
| 57763 | 57763 | 201551 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6020116.66531 | 2093486.6381700002 | 37.7294410644355 | -122.37271306177901 | (37.7294410644355, -122.372713061779) | ||||
| 45320 | 45320 | 201553 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | 6019956.36355 | 2093604.98051 | 37.72975719952 | -122.373275437534 | (37.72975719952, -122.373275437534) | ||||
| 47244 | 47244 | 201554 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | 6019933.4891099995 | 2093619.80077 | 37.729796635696296 | -122.373355543719 | (37.7297966356963, -122.373355543719) | ||||
| 72337 | 72337 | 201555 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6019901.03231 | 2093652.00045 | 37.7298832655955 | -122.373469980666 | (37.7298832655955, -122.373469980666) | ||||
| 173224 | 173224 | 201556 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | 6019865.267469999 | 2093672.4938299998 | 37.729937570248 | -122.37359504397101 | (37.729937570248, -122.373595043971) | ||||
| 146878 | 146878 | 201557 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 9ft | 6019843.77362 | 2093685.4029299999 | 37.7299718344327 | -122.373670245296 | (37.7299718344327, -122.373670245296) | |||
| 150959 | 150959 | 201558 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 7ft | 6019824.624340001 | 2093697.32313 | 37.7300035121512 | -122.37373727266899 | (37.7300035121512, -122.373737272669) | |||
| 68526 | 68526 | 201560 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 5ft | 6019794.81537 | 2093720.05192 | 37.7300642820202 | -122.373841900702 | (37.7300642820202, -122.373841900702) | |||
| 43046 | 43046 | 201567 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 799 Jerrold Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 9ft | 6019712.532430001 | 2093705.4483299998 | 37.730019658579295 | -122.37412535530899 | (37.7300196585793, -122.374125355309) | |||
| 178131 | 178131 | 201566 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 799 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6019697.16467 | 2093717.76615 | 37.7300526357971 | -122.374179337111 | (37.7300526357971, -122.374179337111) | ||||
| 153819 | 153819 | 201565 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 200 Jerrold Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | 6019673.98228 | 2093813.8250099998 | 37.730315120044295 | -122.374266134286 | (37.7303151200443, -122.374266134286) | ||||
| 134949 | 134949 | 194519 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1108 Griffith St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 8ft | 6018142.03115 | 2092982.0233 | 37.7279467796967 | -122.379504594361 | (37.7279467796967, -122.379504594361) | |||
| 69737 | 69737 | 194499 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 Evans Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6018054.76691 | 2096792.7027 | 37.7384053438433 | -122.38007096131201 | (37.7384053438433, -122.380070961312) | ||||
| 58460 | 58460 | 194518 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 15x Reuel Ct | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6017388.67134 | 2096078.81136 | 37.7364083704432 | -122.382324365581 | (37.7364083704432, -122.382324365581) | ||||
| 172327 | 172327 | 194517 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 15 Reuel Ct | 1 | : 4 | Tree 1 | Private 1 | 31 | 6017370.3907699995 | 2096095.6605599998 | 37.7364536252419 | -122.382388741749 | (37.7364536252419, -122.382388741749) | ||||
| 79699 | 79699 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 126X Mendell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 6017060.745069999 | 2098543.2218400002 | 37.74315702656929 | -122.38362967653299 | (37.7431570265693, -122.383629676533) | |||
| 40010 | 40010 | 113539 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | ||||
| 88481 | 88481 | 113536 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 96850 | 96850 | 113535 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12/05/2015 12:49:00 PM | 3 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||
| 103732 | 103732 | 113537 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 104927 | 104927 | 113538 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||||
| 111177 | 111177 | 110952 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 220 Newhall St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.38450453105301 | (37.7426065069695, -122.384504531053) | |||
| 111635 | 111635 | 110951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 220 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.38450453105301 | (37.7426065069695, -122.384504531053) | |||
| 112127 | 112127 | 110953 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 220 Newhall St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.38450453105301 | (37.7426065069695, -122.384504531053) | |||
| 162208 | 162208 | 194502 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 299 Cashmere St | 17 | : 4 | Tree 1 | Private 1 | 14 | 6016706.5669 | 2095967.5431400002 | 37.7360651504892 | -122.38467496140301 | (37.7360651504892, -122.384674961403) | ||||
| 68100 | 68100 | 194503 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016679.95616 | 2095990.1573599998 | 37.7361257728833 | -122.38476854124399 | (37.7361257728833, -122.384768541244) | ||||
| 69972 | 69972 | 194504 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6016665.2898 | 2096001.51106 | 37.7361561367049 | -122.38482004001001 | (37.7361561367049, -122.38482004001) | ||||
| 171534 | 171534 | 194505 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | 6016625.92106 | 2096014.8365599997 | 37.7361905483545 | -122.384957083216 | (37.7361905483545, -122.384957083216) | ||||
| 36172 | 36172 | 194506 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6016624.93937 | 2096021.7822099999 | 37.7362095654157 | -122.38496096110501 | (37.7362095654157, -122.384960961105) | ||||
| 39942 | 39942 | 194507 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016618.68245 | 2096023.0251200001 | 37.7362126321093 | -122.384982680622 | (37.7362126321093, -122.384982680622) | ||||
| 36701 | 36701 | 194508 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 299x Cashmere St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6016611.71691 | 2096022.49532 | 37.7362107920965 | -122.385006726687 | (37.7362107920965, -122.385006726687) | ||||
| 69629 | 69629 | 200633 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x Newcomb Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 6016537.4545 | 2094850.7585 | 37.732989329256505 | -122.38518186591601 | (37.7329893292565, -122.385181865916) | |||
| 147918 | 147918 | 200634 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x Newcomb Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 0ft | 6016413.6949 | 2094834.3971 | 37.7329375570822 | -122.38560859930901 | (37.7329375570822, -122.385608599309) | |||
| 68121 | 68121 | 194497 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1800 Illinois St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 7ft | 6016247.03322 | 2100654.64673 | 37.7489095539354 | -122.38659049936899 | (37.7489095539354, -122.386590499369) | |||
| 31604 | 31604 | 194496 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Tulare St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6016213.72406 | 2100305.90107 | 37.7479501266034 | -122.386681367746 | (37.7479501266034, -122.386681367746) | ||||
| 57923 | 57923 | 194495 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Tulare St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6016190.05979 | 2100302.2042099996 | 37.7479386656413 | -122.38676294076001 | (37.7479386656413, -122.38676294076) | ||||
| 77130 | 77130 | 194494 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3305 03rd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 10ft | 6016095.96516 | 2099918.6299099997 | 37.7468802400244 | -122.387061569634 | (37.7468802400244, -122.387061569634) | |||
| 144215 | 144215 | 116451 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 250X CASHMERE ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6016081.0 | 2096072.0 | 37.7363173516773 | -122.386845101275 | (37.7363173516773, -122.386845101275) | |||||
| 146895 | 146895 | 194509 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 19 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6016049.52573 | 2096064.5674400001 | 37.7362952006575 | -122.38695340369699 | (37.7362952006575, -122.386953403697) | ||||
| 131180 | 131180 | 194510 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016046.848569999 | 2096053.1347400001 | 37.7362636605344 | -122.38696186272199 | (37.7362636605344, -122.386961862722) | ||||
| 53902 | 53902 | 194511 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 21 | Median : Yard 3 | Tree 1 | DPW 2 | 29 | 6016041.40389 | 2096043.15017 | 37.73623594344121 | -122.386979991251 | (37.7362359434412, -122.386979991251) | ||||
| 56372 | 56372 | 194513 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 25 | Median : Yard 3 | Tree 1 | DPW 2 | 21 | 6016035.53821 | 2096012.28902 | 37.7361508801593 | -122.38699811976299 | (37.7361508801593, -122.386998119763) | ||||
| 68846 | 68846 | 194512 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 6016031.3750599995 | 2096031.1694 | 37.736202491347 | -122.387013830018 | (37.736202491347, -122.387013830018) | ||||
| 49014 | 49014 | 194514 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016024.76116 | 2095911.2144799998 | 37.7358727531167 | -122.387028333393 | (37.7358727531167, -122.387028333393) | ||||
| 187986 | 187986 | 194474 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 601 Illinois St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6016019.39456 | 2106196.24921 | 37.7641130167339 | -122.387764283717 | (37.7641130167339, -122.387764283717) | ||||
| 167614 | 167614 | 194515 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 19 | 6016017.1360599995 | 2095897.09694 | 37.7358335669715 | -122.38705371226901 | (37.7358335669715, -122.387053712269) | ||||
| 132404 | 132404 | 194516 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 301x Cashmere St | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 23 | 6016014.59895 | 2095892.62299 | 37.7358211419175 | -122.387062172188 | (37.7358211419175, -122.387062172188) | ||||
| 107740 | 107740 | 107644 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400x KIRKWOOD AVE | 1 | Median : Yard 3 | Tree 1 | Private 1 | 6015822.8 | 2096363.1 | 37.7371023539668 | -122.38775811873998 | (37.7371023539668, -122.38775811874) | |||||
| 95325 | 95325 | 111308 | Private 5 | Pinus radiata :: Monterey Pine 3 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6x90 | 6015099.0 | 2088640.0 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | ||||
| 130189 | 130189 | 194473 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 851 Indiana St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 8ft | 6014996.9291900005 | 2104399.3469599998 | 37.7591224196901 | -122.39117511273399 | (37.7591224196901, -122.391175112734) | |||
| 122932 | 122932 | 110876 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800 INDIANA ST | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 138742 | 138742 | 110890 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800 INDIANA ST | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 145529 | 145529 | 110881 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800 INDIANA ST | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | |||||
| 162681 | 162681 | 194478 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1000 Texas St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 36 | 6013925.61111 | 2102123.6200599996 | 37.7528142537945 | -122.394720899468 | (37.7528142537945, -122.394720899468) | ||||
| 33782 | 33782 | 194477 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1000 Texas St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6013908.27444 | 2102233.75002 | 37.7531156831575 | -122.394788565357 | (37.7531156831575, -122.394788565357) | ||||
| 154482 | 154482 | 201729 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6013763.5505 | 2095932.04649 | 37.735804483793004 | -122.394847748824 | (37.735804483793, -122.394847748824) | ||||
| 31259 | 31259 | 201730 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | 6013762.45417 | 2095926.0507 | 37.7357879596321 | -122.39485111951001 | (37.7357879596321, -122.39485111951) | ||||
| 149294 | 149294 | 201731 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 19 | 6013749.92034 | 2095926.84789 | 37.7357894516288 | -122.394894510001 | (37.7357894516288, -122.394894510001) | ||||
| 2976 | 2976 | 198801 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150 Executive Park Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 4ft | 6013745.097 | 2086994.3966599999 | 37.7112624653484 | -122.394285983735 | (37.7112624653484, -122.394285983735) | |||
| 51094 | 51094 | 201728 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1411 Phelps St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | 6013736.51011 | 2095944.0047900002 | 37.7358358152635 | -122.394942076023 | (37.7358358152635, -122.394942076023) | ||||
| 53071 | 53071 | 194492 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 651 Missouri St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6013622.036069999 | 2103861.64748 | 37.757569618766205 | -122.39589250475001 | (37.7575696187662, -122.39589250475) | ||||
| 9883 | 9883 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1101 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 64705 | 64705 | 194501 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1121 Jamestown Ave | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 56 | 6013422.70006 | 2090021.7257 | 37.7195569863524 | -122.395612244507 | (37.7195569863524, -122.395612244507) | ||||
| 34867 | 34867 | 194490 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 22nd St | 19 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | 6013346.63868 | 2103825.44695 | 37.757454894948104 | -122.396842409144 | (37.7574548949481, -122.396842409144) | ||||
| 152510 | 152510 | 194491 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 22nd St | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6013319.82421 | 2103789.39675 | 37.7573544163899 | -122.39693261744199 | (37.7573544163899, -122.396932617442) | ||||
| 150599 | 150599 | 194489 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1750 22nd St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6012793.88135 | 2103795.98527 | 37.7573432171426 | -122.398752009817 | (37.7573432171426, -122.398752009817) | ||||
| 27688 | 27688 | 194493 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2098 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6012789.47061 | 2098973.3906900003 | 37.744101165829996 | -122.398428883383 | (37.74410116583, -122.398428883383) | |||
| 86227 | 86227 | 112615 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1798x 22ND ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 05/02/2016 12:00:00 AM | 3 | 6012787.0 | 2103832.0 | 37.7574417223043 | -122.398778335858 | (37.7574417223043, -122.398778335858) | |||
| 85387 | 85387 | 107149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 612 WISCONSIN ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6012651.9 | 2104553.6 | 37.7594155491308 | -122.39929622330901 | (37.7594155491308, -122.399296223309) | |||||
| 20864 | 20864 | 112443 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2199x 25TH ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 6012503.0 | 2101856.0 | 37.752000229136705 | -122.399621792735 | (37.7520002291367, -122.399621792735) | ||||
| 44573 | 44573 | 112444 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2199x 25TH ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 6012503.0 | 2101856.0 | 37.752000229136705 | -122.399621792735 | (37.7520002291367, -122.399621792735) | ||||
| 120040 | 120040 | 112441 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2199x 25TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 30 | 3x3 | 6012503.0 | 2101856.0 | 37.752000229136705 | -122.399621792735 | (37.7520002291367, -122.399621792735) | |||
| 125001 | 125001 | 112442 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2199x 25TH ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 36 | 6012503.0 | 2101856.0 | 37.752000229136705 | -122.399621792735 | (37.7520002291367, -122.399621792735) | ||||
| 31535 | 31535 | 194476 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900x Carolina St | 43 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6012491.75598 | 2103075.9348299997 | 37.755349278054 | -122.39974632722799 | (37.755349278054, -122.399746327228) | ||||
| 132920 | 132920 | 194475 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900x Carolina St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012465.76971 | 2103588.87642 | 37.756756254802106 | -122.39987221343901 | (37.7567562548021, -122.399872213439) | ||||
| 128796 | 128796 | 109911 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1062X Carolina St | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476001 | (37.7552131559276, -122.39986897476) | |||||
| 9890 | 9890 | 3755 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1050 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012450.5971046 | 2103074.0676917997 | 37.7553418567665 | -122.39988853682199 | (37.7553418567665, -122.399888536822) | |||
| 10214 | 10214 | 173907 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2200 Jerrold Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6012443.0 | 2099218.0 | 37.7447535037256 | -122.399644080592 | (37.7447535037256, -122.399644080592) | |||||
| 9909 | 9909 | 173722 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 928 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3x3 | 6012423.0 | 2103596.0 | 37.7567734300957 | -122.400020627969 | (37.7567734300957, -122.400020627969) | |||
| 145389 | 145389 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 744 Carolina St | 1 | : 4 | Tree 1 | Private 1 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.759318660176504 | -122.40041614875601 | (37.7593186601765, -122.400416148756) | |||
| 83772 | 83772 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1160 Battery St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.40155068012699 | (37.8018575696458, -122.401550680127) | |||
| 155029 | 155029 | 132204 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 12 Greenwich St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 6012294.06984 | 2120559.14097 | 37.803343106346794 | -122.40165876436501 | (37.8033431063468, -122.401658764365) | ||||
| 160502 | 160502 | 194482 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6012279.12158 | 2102212.21544 | 37.752965837218 | -122.40042102023999 | (37.752965837218, -122.40042102024) | ||||
| 149165 | 149165 | 194480 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 17 | 6012271.44658 | 2102135.50365 | 37.7527547753262 | -122.400442174093 | (37.7527547753262, -122.400442174093) | ||||
| 171651 | 171651 | 194479 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 26 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6012266.007180001 | 2102082.8221 | 37.7526098199098 | -122.40045728448099 | (37.7526098199098, -122.400457284481) | ||||
| 187393 | 187393 | 132205 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 12 Greenwich St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6012257.5514 | 2120548.1369 | 37.8033108539845 | -122.401784364564 | (37.8033108539845, -122.401784364564) | ||||
| 172192 | 172192 | 194481 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1300x De Haro St | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6012253.2004 | 2102155.0186 | 37.752807341589296 | -122.400506643765 | (37.7528073415893, -122.400506643765) | ||||
| 91730 | 91730 | 99192 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1155@Sansome Battery St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Plaza | Permit Number 768022 | 6012245.0 | 2120028.0 | 37.80188198386271 | -122.401791216362 | (37.8018819838627, -122.401791216362) | |||
| 178075 | 178075 | 178250 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 287 Hester Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6012202.6988699995 | 2087794.30309 | 37.713372992543896 | -122.39967306036199 | (37.7133729925439, -122.399673060362) | ||||
| 147435 | 147435 | 194484 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2208 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012170.679769999 | 2101904.59247 | 37.7521151235314 | -122.40077442501699 | (37.7521151235314, -122.400774425017) | |||
| 74655 | 74655 | 194500 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2147 Revere Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 6012121.08502 | 2096564.86957 | 37.7374506208484 | -122.400570870653 | (37.7374506208484, -122.400570870653) | ||||
| 67218 | 67218 | 132208 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Union St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | 6012099.303230001 | 2119801.66278 | 37.8012523849575 | -122.402279475534 | (37.8012523849575, -122.402279475534) | ||||
| 183957 | 183957 | 132207 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Union St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012049.27862 | 2119798.13006 | 37.8012398924644 | -122.40245233511001 | (37.8012398924644, -122.40245233511) | ||||
| 159200 | 159200 | 132206 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 199 Union St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6012038.33041 | 2119798.95957 | 37.8012415589072 | -122.4024902793 | (37.8012415589072, -122.4024902793) | ||||
| 31917 | 31917 | 194488 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1401 Rhode Island St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 6012030.157269999 | 2101805.35505 | 37.751834800344 | -122.40125340303601 | (37.751834800344, -122.401253403036) | ||||
| 26474 | 26474 | 250207 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 212 Union St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 6011784.78005 | 2119790.75424 | 37.801204871053706 | -122.40336710211399 | (37.8012048710537, -122.403367102114) | |||
| 29301 | 29301 | 250202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 203 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 0ft | 6011755.5651 | 2119757.15751 | 37.8011109908426 | -122.403465834184 | (37.8011109908426, -122.403465834184) | |||
| 76954 | 76954 | 250209 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 212 Union St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | Width 0ft | 6011754.82957 | 2119792.32643 | 37.8012075150685 | -122.403470855112 | (37.8012075150685, -122.403470855112) | |||
| 134660 | 134660 | 194485 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 998 Kansas St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | Width 10ft | 6011603.18064 | 2103745.73679 | 37.7571388318007 | -122.40286641177299 | (37.7571388318007, -122.402866411773) |
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");