Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 92954 | 92954 | 97034 | Property Tree 7 | :: 54 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 98644 | 98644 | 106968 | Property Tree 7 | :: 54 | 351 26th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.48618540122601 | (37.7828456076198, -122.486185401226) | ||||||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 125761 | 125761 | 108576 | Property Tree 7 | :: 54 | 2479 Diamond St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6002240.0 | 2097369.0 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | |||||
| 141787 | 141787 | 103673 | Property Tree 7 | :: 54 | 64 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003097.0 | 2107420.0 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | ||||||
| 84797 | 84797 | 112378 | Significant Tree 6 | :: 54 | 1850 19TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5990394.0 | 2102783.0 | 37.7532883185876 | -122.476144836826 | (37.7532883185876, -122.476144836826) | |||
| 85374 | 85374 | 114726 | Significant Tree 6 | :: 54 | 520 Townsend St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.40014623691201 | (37.7731959986981, -122.400146236912) | |||||
| 85903 | 85903 | 105084 | Significant Tree 6 | :: 54 | 344 Fulton St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 86041 | 86041 | 105089 | Significant Tree 6 | :: 54 | 344 Fulton St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 96301 | 96301 | 101476 | Significant Tree 6 | :: 54 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2015 12:00:00 AM | 3 | Permit Number 775316 | 6000089.0 | 2095440.1 | 37.7336838892166 | -122.44209059296301 | (37.7336838892166, -122.442090592963) | ||
| 96655 | 96655 | 105086 | Significant Tree 6 | :: 54 | 344 Fulton St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 97038 | 97038 | 105091 | Significant Tree 6 | :: 54 | 344 Fulton St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 97519 | 97519 | 114725 | Significant Tree 6 | :: 54 | 520 Townsend St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6012508.1 | 2109575.3 | 37.7731959986981 | -122.40014623691201 | (37.7731959986981, -122.400146236912) | |||||
| 100812 | 100812 | 115070 | Significant Tree 6 | :: 54 | 401 DARIEN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5992724.0 | 2094938.0 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | ||||
| 104314 | 104314 | 105082 | Significant Tree 6 | :: 54 | 344 Fulton St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 105651 | 105651 | 105081 | Significant Tree 6 | :: 54 | 344 Fulton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 110291 | 110291 | 105085 | Significant Tree 6 | :: 54 | 344 Fulton St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 118997 | 118997 | 105083 | Significant Tree 6 | :: 54 | 344 Fulton St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 120796 | 120796 | 105087 | Significant Tree 6 | :: 54 | 344 Fulton St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 121162 | 121162 | 105090 | Significant Tree 6 | :: 54 | 344 Fulton St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 141862 | 141862 | 105088 | Significant Tree 6 | :: 54 | 344 Fulton St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 99380 | 99380 | 119616 | Private 5 | :: 54 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 6005873.6969099995 | 2111410.5639299997 | 37.777863036884796 | -122.42322602570499 | (37.7778630368848, -122.423226025705) | |||
| 518 | 518 | 251314 | Planning Code 138.1 required 4 | :: 54 | 1108 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001901.0 | 2100825.0 | 37.7485726639367 | -122.43621121860001 | (37.7485726639367, -122.4362112186) | ||||
| 533 | 533 | 251313 | Planning Code 138.1 required 4 | :: 54 | 390 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 3255 | 3255 | 253377 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 3275 | 3275 | 253378 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 3345 | 3345 | 253419 | Planning Code 138.1 required 4 | :: 54 | 3499 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
| 5050 | 5050 | 253762 | Planning Code 138.1 required 4 | :: 54 | 520 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993490.0 | 2111935.0 | 37.778596343165496 | -122.46610332918101 | (37.7785963431655, -122.466103329181) | ||||
| 103215 | 103215 | 116528 | Planning Code 138.1 required 4 | :: 54 | 125 CROWN TER | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | 5998841.0 | 2104182.0 | 37.7576158290564 | -122.447034160915 | (37.7576158290564, -122.447034160915) | |||
| 870 | 870 | 117001 | DPW Maintained 3 | :: 54 | 1X Bernal Heights Blvd | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | ||||||||||
| 1988 | 1988 | 252845 | DPW Maintained 3 | :: 54 | 544 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2014 12:00:00 AM | 3x3 | 5993963.0 | 2110797.0 | 37.7754989773977 | -122.46438440768401 | (37.7754989773977, -122.464384407684) | |||
| 9914 | 9914 | 173708 | DPW Maintained 3 | :: 54 | 126 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001214.0 | 2098705.0 | 37.7427125900371 | -122.438434982469 | (37.7427125900371, -122.438434982469) | ||||
| 33065 | 33065 | 185060 | DPW Maintained 3 | :: 54 | 10x El Mirasol Pl | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5987413.8008 | 2096060.1353 | 37.7346558528299 | -122.485957413668 | (37.7346558528299, -122.485957413668) | |||
| 36394 | 36394 | 184614 | DPW Maintained 3 | :: 54 | 3600x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5982812.7565 | 2102876.5318 | 37.7531025964328 | -122.502368824356 | (37.7531025964328, -122.502368824356) | |||
| 40307 | 40307 | 184619 | DPW Maintained 3 | :: 54 | 3000x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984675.7685 | 2102938.8014 | 37.7533828605842 | -122.495930852185 | (37.7533828605842, -122.495930852185) | |||
| 40829 | 40829 | 184609 | DPW Maintained 3 | :: 54 | 3400x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5983436.8063 | 2102896.8371 | 37.7531949966988 | -122.500212272852 | (37.7531949966988, -122.500212272852) | |||
| 44250 | 44250 | 184634 | DPW Maintained 3 | :: 54 | 4100x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5981271.0577 | 2102821.0876 | 37.7528596561113 | -122.507696113948 | (37.7528596561113, -122.507696113948) | |||
| 47495 | 47495 | 184900 | DPW Maintained 3 | :: 54 | 3100x Noriega St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984148.1689 | 2102921.2035 | 37.7533036269678 | -122.49775407488501 | (37.7533036269678, -122.497754074885) | |||
| 68603 | 68603 | 142716 | DPW Maintained 3 | :: 54 | 1120 COLUMBUS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008073.8404 | 2121121.2819 | 37.804650203273 | -122.416302902461 | (37.804650203273, -122.416302902461) | |||
| 71149 | 71149 | 142745 | DPW Maintained 3 | :: 54 | 700x COLUMBUS AVE | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 6009127.5357 | 2120116.4029 | 37.8019502507169 | -122.412585395041 | (37.8019502507169, -122.412585395041) | |||
| 87071 | 87071 | 115068 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 92851 | 92851 | 7876 | DPW Maintained 3 | :: 54 | 1095X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2011 12:00:00 AM | 3 | 3x3 | 6006012.62101 | 2113826.37447 | 37.784504100894395 | -122.42291717866101 | (37.7845041008944, -122.422917178661) | ||
| 98812 | 98812 | 115061 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 106237 | 106237 | 115066 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 108481 | 108481 | 28868 | DPW Maintained 3 | :: 54 | 75 01st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2011 12:00:00 AM | 3 | 3x3 | 6013233.2298598 | 2115774.102568 | 37.790256890180295 | -122.39807285434601 | (37.7902568901803, -122.398072854346) | ||
| 110696 | 110696 | 115065 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 113187 | 113187 | 115067 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 117492 | 117492 | 115069 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 120235 | 120235 | 115062 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 125370 | 125370 | 3826 | DPW Maintained 3 | :: 54 | 120 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1992 12:00:00 AM | 3 | 3X3 | 6016868.5122165 | 2095917.6664165 | 37.7359371538987 | -122.384111573291 | (37.7359371538987, -122.384111573291) | ||
| 132958 | 132958 | 184627 | DPW Maintained 3 | :: 54 | 3300x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5983533.5949 | 2102898.8676 | 37.7532062522999 | -122.499877713808 | (37.7532062522999, -122.499877713808) | |||
| 144770 | 144770 | 115064 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 146223 | 146223 | 115063 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 156043 | 156043 | 184621 | DPW Maintained 3 | :: 54 | 3100x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984373.2194 | 2102928.6488 | 37.75333725996521 | -122.49697636521401 | (37.7533372599652, -122.496976365214) | |||
| 162177 | 162177 | 184618 | DPW Maintained 3 | :: 54 | 3900x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5981674.4395 | 2102837.4254 | 37.7529282714167 | -122.506302380507 | (37.7529282714167, -122.506302380507) | |||
| 174998 | 174998 | 184611 | DPW Maintained 3 | :: 54 | 3800x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5982199.0286 | 2102854.3652 | 37.753005653234204 | -122.504489538097 | (37.7530056532342, -122.504489538097) | |||
| 188070 | 188070 | 184620 | DPW Maintained 3 | :: 54 | 3000x Noriega St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | Width 0ft | 5984460.1938 | 2102931.6946 | 37.753350719104795 | -122.496675818993 | (37.7533507191048, -122.496675818993) | |||
| 161 | 161 | 142720 | Undocumented 2 | :: 54 | 1170 COLUMBUS AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6007999.4825 | 2121188.7351 | 37.8048312311886 | -122.416565007078 | (37.8048312311886, -122.416565007078) | ||||
| 443 | 443 | 251293 | Undocumented 2 | :: 54 | 3789 Market St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6000208.0 | 2102740.0 | 37.753734455764 | -122.44220302061701 | (37.753734455764, -122.442203020617) | ||||
| 514 | 514 | 251312 | Undocumented 2 | :: 54 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 667 | 667 | 251356 | Undocumented 2 | :: 54 | 519 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989039.0 | 2111772.0 | 37.777890994652296 | -122.481488924787 | (37.7778909946523, -122.481488924787) | ||||
| 1410 | 1410 | 139164 | Undocumented 2 | :: 54 | 1975 POST ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002726.0596 | 2114048.1262 | 37.784926980365206 | -122.43430340574699 | (37.7849269803652, -122.434303405747) | ||||
| 2526 | 2526 | 141913 | Undocumented 2 | :: 54 | 900 MCALLISTER ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004416.1749 | 2111910.2001 | 37.779152551854104 | -122.42830372330299 | (37.7791525518541, -122.428303723303) | |||
| 3620 | 3620 | 139511 | Undocumented 2 | :: 54 | 1400 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001017.0 | 2111110.0 | 37.776762480662704 | -122.440005440059 | (37.7767624806627, -122.440005440059) | |||
| 6373 | 6373 | 138089 | Undocumented 2 | :: 54 | 1600 SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6004809.7961 | 2114741.3813 | 37.7869485378128 | -122.427143741054 | (37.7869485378128, -122.427143741054) | ||||
| 7654 | 7654 | 139157 | Undocumented 2 | :: 54 | 1699 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6003069.5459 | 2114034.3612 | 37.7849086753549 | -122.433114070807 | (37.7849086753549, -122.433114070807) | ||||
| 18412 | 18412 | 247322 | Undocumented 2 | :: 54 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002795.6845 | 2109344.9924 | 37.7720173021936 | -122.433726268045 | (37.7720173021936, -122.433726268045) | ||||
| 22368 | 22368 | 183808 | Undocumented 2 | :: 54 | 1823 Rivera St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987517.377 | 2100286.1656 | 37.7462654526109 | -122.48590940972 | (37.7462654526109, -122.48590940972) | |||
| 22811 | 22811 | 185829 | Undocumented 2 | :: 54 | 2061 34th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985695.3610000005 | 2101217.9835 | 37.7487176270346 | -122.49227823369301 | (37.7487176270346, -122.492278233693) | |||
| 22852 | 22852 | 138173 | Undocumented 2 | :: 54 | 1953 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6000211.2401 | 2111613.6154 | 37.7780993776744 | -122.44282896766 | (37.7780993776744, -122.44282896766) | |||
| 23417 | 23417 | 183167 | Undocumented 2 | :: 54 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.741329561902596 | -122.50344114283101 | (37.7413295619026, -122.503441142831) | |||
| 23724 | 23724 | 181665 | Undocumented 2 | :: 54 | 1275 34th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985511.3315 | 2106531.7973 | 37.7632971348656 | -122.49330603001499 | (37.7632971348656, -122.493306030015) | |||
| 23777 | 23777 | 183752 | Undocumented 2 | :: 54 | 2287 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987917.4443 | 2099749.9687 | 37.7448165037016 | -122.484486720736 | (37.7448165037016, -122.484486720736) | |||
| 23835 | 23835 | 182329 | Undocumented 2 | :: 54 | 1501 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985565.7361 | 2104954.3084 | 37.75896897093661 | -122.493001657059 | (37.7589689709366, -122.493001657059) | |||
| 23845 | 23845 | 142111 | Undocumented 2 | :: 54 | 36 HEMWAY TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998636.7696 | 2110968.1942 | 37.7762373313333 | -122.448229118378 | (37.7762373313333, -122.448229118378) | |||
| 23926 | 23926 | 181820 | Undocumented 2 | :: 54 | 2299 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985846.0311 | 2099546.7997 | 37.7441378151504 | -122.491634223287 | (37.7441378151504, -122.491634223287) | |||
| 24053 | 24053 | 181971 | Undocumented 2 | :: 54 | 2467 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985787.1457 | 2098434.4072 | 37.7410800425161 | -122.49175595946801 | (37.7410800425161, -122.491755959468) | |||
| 24081 | 24081 | 183742 | Undocumented 2 | :: 54 | 2278 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988578.8889999995 | 2099828.4885 | 37.745070593746796 | -122.482205348546 | (37.7450705937468, -122.482205348546) | |||
| 24104 | 24104 | 248307 | Undocumented 2 | :: 54 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.44550750940901 | (37.7691713129844, -122.445507509409) | |||
| 24148 | 24148 | 182529 | Undocumented 2 | :: 54 | 1583 32nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986203.973999999 | 2104470.5925 | 37.7576781250927 | -122.490758769583 | (37.7576781250927, -122.490758769583) | |||
| 24206 | 24206 | 181982 | Undocumented 2 | :: 54 | 2479 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986720.0054 | 2098392.2737 | 37.7410188327151 | -122.488527415956 | (37.7410188327151, -122.488527415956) | |||
| 24275 | 24275 | 184454 | Undocumented 2 | :: 54 | 2153 48th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981374.6331 | 2100381.1786 | 37.7461664541179 | -122.507156946857 | (37.7461664541179, -122.507156946857) | |||
| 24313 | 24313 | 184893 | Undocumented 2 | :: 54 | 1786 46th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981952.8719 | 2102926.7078 | 37.753189803786896 | -122.505346142178 | (37.7531898037869, -122.505346142178) | |||
| 24402 | 24402 | 182453 | Undocumented 2 | :: 54 | 1500 31st Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986555.3586 | 2104541.3333 | 37.7578928802813 | -122.489548755928 | (37.7578928802813, -122.489548755928) | |||
| 24496 | 24496 | 184100 | Undocumented 2 | :: 54 | 1614 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985016.0366 | 2104172.5195 | 37.756790232687 | -122.494845106619 | (37.756790232687, -122.494845106619) | |||
| 24523 | 24523 | 141857 | Undocumented 2 | :: 54 | 1100 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004651.3626 | 2112630.8889 | 37.781144690344895 | -122.42754147050199 | (37.7811446903449, -122.427541470502) | |||
| 24606 | 24606 | 181614 | Undocumented 2 | :: 54 | 1246 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984927.2833 | 2106710.1633 | 37.7637526989564 | -122.49533918573601 | (37.7637526989564, -122.495339185736) | |||
| 24662 | 24662 | 124715 | Undocumented 2 | :: 54 | 599X 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002687.0 | 2100013.0 | 37.7463877287793 | -122.433435226166 | (37.7463877287793, -122.433435226166) | ||||
| 24683 | 24683 | 183508 | Undocumented 2 | :: 54 | 2547 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5988598.1694 | 2097978.5588 | 37.7399922937625 | -122.482003188533 | (37.7399922937625, -122.482003188533) | |||
| 24723 | 24723 | 181788 | Undocumented 2 | :: 54 | 3131 Ulloa St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986265.505 | 2098198.358 | 37.740459860841 | -122.49008463083 | (37.740459860841, -122.49008463083) | |||
| 24732 | 24732 | 141579 | Undocumented 2 | :: 54 | 500 BAKER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000650.2876 | 2110740.0178 | 37.7757257205697 | -122.44124745176501 | (37.7757257205697, -122.441247451765) | |||
| 24890 | 24890 | 183769 | Undocumented 2 | :: 54 | 2295 28th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987606.9921 | 2099681.9039 | 37.7446115325485 | -122.48555519813499 | (37.7446115325485, -122.485555198135) | |||
| 25062 | 25062 | 247418 | Undocumented 2 | :: 54 | 1001 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002608.194 | 2110213.5869 | 37.7743916070028 | -122.43443692499599 | (37.7743916070028, -122.434436924996) | |||
| 25160 | 25160 | 244247 | Undocumented 2 | :: 54 | 200 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005673.0642 | 2110022.6890000002 | 37.7740409443959 | -122.423821374378 | (37.7740409443959, -122.423821374378) | |||
| 25293 | 25293 | 182679 | Undocumented 2 | :: 54 | 2631 Moraga St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986083.8267 | 2103639.2241 | 37.7553883964845 | -122.49111310108299 | (37.7553883964845, -122.491113101083) | |||
| 25460 | 25460 | 181596 | Undocumented 2 | :: 54 | 1683 37th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984674.4393 | 2103735.9717 | 37.7555715918184 | -122.495994253801 | (37.7555715918184, -122.495994253801) | |||
| 25506 | 25506 | 137920 | Undocumented 2 | :: 54 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.788390961736795 | -122.433650548643 | (37.7883909617368, -122.433650548643) | |||
| 25583 | 25583 | 139608 | Undocumented 2 | :: 54 | 1724 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001827.9162 | 2112238.3787 | 37.7799068540457 | -122.437281058847 | (37.7799068540457, -122.437281058847) | |||
| 25649 | 25649 | 182532 | Undocumented 2 | :: 54 | 1581 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985581.6988 | 2104465.1884 | 37.7576269162189 | -122.492910423341 | (37.7576269162189, -122.492910423341) |
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");