Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 116897 | 116897 | 108813 | Undocumented 2 | :: 54 | 301-399 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |||||
| 83697 | 83697 | 108792 | Permitted Site 1 | :: 54 | 201-299 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
| 85159 | 85159 | 108793 | Permitted Site 1 | :: 54 | 201-299 University St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
| 135877 | 135877 | 199650 | Undocumented 2 | :: 54 | 0 | 1 | : 4 | Tree 1 | Private 1 | 0 | Width 0ft | 6014963.58685 | 2093280.8179400002 | 37.728591398452394 | -122.390513521988 | (37.7285913984524, -122.390513521988) | |||
| 85350 | 85350 | 40070 | Permitted Site 1 | :: 54 | 1434 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | Permit Number 41296 | 6015644.04223078 | 2093317.32333735 | 37.7287293601115 | -122.388163675017 | (37.7287293601115, -122.388163675017) | ||
| 183672 | 183672 | 200636 | Undocumented 2 | :: 54 | 1301 Quesada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6016782.3625 | 2093458.8747 | 37.729181036936396 | -122.384238246013 | (37.7291810369364, -122.384238246013) | |||
| 111918 | 111918 | 109831 | Permitted Site 1 | :: 54 | 146 Staples Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 12x15.3 | 5999109.5 | 2093827.3 | 37.7291996500545 | -122.445361075989 | (37.7291996500545, -122.445361075989) | ||||
| 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) | |||||
| 113475 | 113475 | 46634 | Permitted Site 1 | :: 54 | 1569 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44755 | 6014739.185840401 | 2093576.72961431 | 37.729391461068204 | -122.391309972305 | (37.7293914610682, -122.391309972305) | ||
| 127351 | 127351 | 35482 | Permitted Site 1 | :: 54 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | Permit Number 40088 | 6008340.04148266 | 2093836.36406151 | 37.7297471396453 | -122.413450843683 | (37.7297471396453, -122.413450843683) | ||
| 36680 | 36680 | 200762 | Undocumented 2 | :: 54 | 1999 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014632.1803 | 2093750.8421 | 37.7298635995705 | -122.39169207228201 | (37.7298635995705, -122.391692072282) | |||
| 158995 | 158995 | 200766 | Undocumented 2 | :: 54 | 1901 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6014720.1223 | 2093871.3227 | 37.7301992962685 | -122.39139646330901 | (37.7301992962685, -122.391396463309) | |||
| 154317 | 154317 | 200577 | Undocumented 2 | :: 54 | 1701 Keith St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6015592.5071 | 2093926.7262 | 37.7303998031535 | -122.38838435336201 | (37.7303998031535, -122.388384353362) | |||
| 101816 | 101816 | 31149 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.730761307799504 | -122.44892931603 | (37.7307613077995, -122.44892931603) | ||
| 126759 | 126759 | 31148 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.730761307799504 | -122.44892931603 | (37.7307613077995, -122.44892931603) | ||
| 43479 | 43479 | 122819 | Undocumented 2 | :: 54 | 121 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003309.0 | 2094407.0 | 37.7310302083694 | -122.430884409483 | (37.7310302083694, -122.430884409483) | ||||
| 85267 | 85267 | 46322 | Permitted Site 1 | :: 54 | 3080 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2002 12:00:00 AM | Permit Number 44576 | 5988871.55058969 | 2094853.71729449 | 37.731428183192705 | -122.480829241755 | (37.7314281831927, -122.480829241755) | |||
| 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) | ||||
| 129662 | 129662 | 200808 | Undocumented 2 | :: 54 | 1401 Oakdale Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6016065.8568 | 2094678.3259 | 37.732489764259896 | -122.386800296411 | (37.7324897642599, -122.386800296411) | |||
| 74359 | 74359 | 200626 | Undocumented 2 | :: 54 | 1370 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6016343.0854 | 2094895.2737 | 37.7331008048792 | -122.38585695867201 | (37.7331008048792, -122.385856958672) | |||
| 187469 | 187469 | 200742 | Undocumented 2 | :: 54 | 1454 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015834.4667 | 2094922.2745 | 37.733146784173606 | -122.38761728786601 | (37.7331467841736, -122.387617287866) | |||
| 125838 | 125838 | 121591 | Undocumented 2 | :: 54 | 162 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 6000339.0 | 2095263.0 | 37.7332118579221 | -122.44121356967199 | (37.7332118579221, -122.441213569672) | ||||
| 173333 | 173333 | 200730 | Undocumented 2 | :: 54 | 1466 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015770.4184 | 2094966.2292 | 37.733263927070006 | -122.387841787924 | (37.73326392707, -122.387841787924) | |||
| 135055 | 135055 | 200729 | Undocumented 2 | :: 54 | 1481 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6015678.7414 | 2094969.3688 | 37.7332674687178 | -122.38815896225799 | (37.7332674687178, -122.388158962258) | |||
| 42125 | 42125 | 200722 | Undocumented 2 | :: 54 | 1476 Oakdale Ave | 1 | unknown : Yard 19 | Tree 1 | Private 1 | 0 | Width 0ft | 6015747.1852 | 2094980.6714 | 37.7333022953684 | -122.387923119588 | (37.7333022953684, -122.387923119588) | |||
| 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) | ||
| 173497 | 173497 | 200570 | Undocumented 2 | :: 54 | 1445 La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6016341.8296 | 2095299.657 | 37.7342110910182 | -122.38588947759399 | (37.7342110910182, -122.385889477594) | |||
| 74054 | 74054 | 185122 | Undocumented 2 | :: 54 | 2850 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985897.3509 | 2095993.4067 | 37.734384144878 | -122.49119531195299 | (37.734384144878, -122.491195311953) | |||
| 183233 | 183233 | 186926 | Undocumented 2 | :: 54 | 2800 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985157.2666 | 2096011.7096 | 37.734391129301 | -122.493755335707 | (37.734391129301, -122.493755335707) | |||
| 33122 | 33122 | 185071 | Undocumented 2 | :: 54 | 2800 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984981.8139 | 2096034.5991 | 37.7344437114318 | -122.49436361071899 | (37.7344437114318, -122.494363610719) | |||
| 58562 | 58562 | 185072 | Undocumented 2 | :: 54 | 2801 Sunset Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985073.9331 | 2096042.9736 | 37.73447209618271 | -122.494045746017 | (37.7344720961827, -122.494045746017) | |||
| 79667 | 79667 | 109978 | Undocumented 2 | :: 54 | 75 Escondido Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986097.0 | 2096084.1 | 37.73464482809 | -122.490511739576 | (37.73464482809, -122.490511739576) | ||||
| 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) | |||
| 174948 | 174948 | 200699 | Undocumented 2 | :: 54 | 1501 Lane St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 6015860.7307 | 2095472.4329 | 37.734658863200295 | -122.38756485421699 | (37.7346588632003, -122.387564854217) | |||
| 19242 | 19242 | 36516 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
| 30528 | 30528 | 36517 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
| 89025 | 89025 | 36518 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
| 118134 | 118134 | 36519 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
| 116859 | 116859 | 45263 | Permitted Site 1 | :: 54 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44109 | 6007439.21136226 | 2095836.00424965 | 37.7351870945672 | -122.41670672522 | (37.7351870945672, -122.41670672522) | ||
| 69532 | 69532 | 184973 | Undocumented 2 | :: 54 | 2701 Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5985060.7433 | 2096318.9125 | 37.7352289790934 | -122.494111677716 | (37.7352289790934, -122.494111677716) | |||
| 51515 | 51515 | 120669 | Undocumented 2 | :: 54 | 61 Paradise Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/2016 12:00:00 AM | 3 | 3x3 | 6000974.0 | 2096001.0 | 37.7352743855737 | -122.43907108078899 | (37.7352743855737, -122.439071080789) | ||
| 30889 | 30889 | 245370 | Undocumented 2 | :: 54 | 3943 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005173.0525 | 2095986.3930000002 | 37.7354723102432 | -122.42455236124201 | (37.7354723102432, -122.424552361242) | |||
| 132272 | 132272 | 185049 | Undocumented 2 | :: 54 | 2731 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5983672.3577 | 2096556.9514 | 37.7358012305935 | -122.49892933938999 | (37.7358012305935, -122.49892933939) | |||
| 133705 | 133705 | 184974 | Undocumented 2 | :: 54 | 2700 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5984964.6462 | 2096531.6242 | 37.735807405046 | -122.494459590864 | (37.735807405046, -122.494459590864) | |||
| 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) | ||
| 188648 | 188648 | 182915 | Undocumented 2 | :: 54 | 2711 47th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981812.2124 | 2096648.8938 | 37.7359443944789 | -122.505367292654 | (37.7359443944789, -122.505367292654) | |||
| 127642 | 127642 | 36507 | Permitted Site 1 | :: 54 | 584 Anderson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.736199030760105 | -122.41551798135401 | (37.7361990307601, -122.415517981354) | ||
| 151546 | 151546 | 182946 | Undocumented 2 | :: 54 | 3500 Wawona St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982068.7362 | 2096751.2664 | 37.7362405734928 | -122.504487984804 | (37.7362405734928, -122.504487984804) | |||
| 29214 | 29214 | 182945 | Undocumented 2 | :: 54 | 2691 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981809.5051 | 2096798.8146 | 37.7363558765881 | -122.50538776138 | (37.7363558765881, -122.50538776138) | |||
| 77586 | 77586 | 121129 | Undocumented 2 | :: 54 | 201 Bemis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
| 97368 | 97368 | 121128 | Undocumented 2 | :: 54 | 201 Bemis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
| 99672 | 99672 | 121127 | Undocumented 2 | :: 54 | 201 Bemis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
| 119911 | 119911 | 121130 | Undocumented 2 | :: 54 | 201 Bemis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||||
| 145560 | 145560 | 121126 | Undocumented 2 | :: 54 | 201 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/2016 12:00:00 AM | 3 | 3x3 | 6003216.0 | 2096386.0 | 37.7364588227531 | -122.431347141396 | (37.7364588227531, -122.431347141396) | ||
| 154543 | 154543 | 182944 | Undocumented 2 | :: 54 | 2678 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981851.131 | 2096866.8374 | 37.7365450979685 | -122.50524888568701 | (37.7365450979685, -122.505248885687) | |||
| 147162 | 147162 | 182943 | Undocumented 2 | :: 54 | 2674 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981850.1157 | 2096894.2496 | 37.7366203046104 | -122.505254426993 | (37.7366203046104, -122.505254426993) | |||
| 137654 | 137654 | 182938 | Undocumented 2 | :: 54 | 2657 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981803.7519 | 2096965.6566 | 37.7368136403966 | -122.505420015001 | (37.7368136403966, -122.505420015001) | |||
| 35754 | 35754 | 182933 | Undocumented 2 | :: 54 | 2646 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981845.0394 | 2097064.8142 | 37.7370883295038 | -122.505284615423 | (37.7370883295038, -122.505284615423) | |||
| 48113 | 48113 | 185273 | Undocumented 2 | :: 54 | 2601 Sunset Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985037.6088 | 2097007.6084 | 37.7371186003252 | -122.494242407159 | (37.7371186003252, -122.494242407159) | |||
| 74865 | 74865 | 182936 | Undocumented 2 | :: 54 | 2643 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5982105.6241 | 2097104.0711 | 37.737211448275794 | -122.50438657908998 | (37.7372114482758, -122.50438657909) | |||
| 181678 | 181678 | 182929 | Undocumented 2 | :: 54 | 2635 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981797.6603 | 2097141.2975 | 37.737295543609996 | -122.50545409100799 | (37.73729554361, -122.505454091008) | |||
| 67752 | 67752 | 185275 | Undocumented 2 | :: 54 | 2600 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984941.5117 | 2097207.3396 | 37.7376613847371 | -122.494589373511 | (37.7376613847371, -122.494589373511) | |||
| 40189 | 40189 | 183398 | Undocumented 2 | :: 54 | 2676 23rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989291.1458 | 2097146.7716 | 37.7377487006662 | -122.479546347444 | (37.7377487006662, -122.479546347444) | |||
| 41622 | 41622 | 183384 | Undocumented 2 | :: 54 | 2659 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989243.3159 | 2097242.4314 | 37.7380085792734 | -122.479718714161 | (37.7380085792734, -122.479718714161) | |||
| 34204 | 34204 | 183601 | Undocumented 2 | :: 54 | 2647 22nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989550.5846 | 2097326.397 | 37.7382569723881 | -122.47866248497401 | (37.7382569723881, -122.478662484974) | |||
| 41764 | 41764 | 183600 | Undocumented 2 | :: 54 | 2639 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5989549.7171 | 2097348.9516 | 37.738318851123 | -122.47866713334 | (37.738318851123, -122.47866713334) | |||
| 51779 | 51779 | 183592 | Undocumented 2 | :: 54 | 2626 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988353.2202 | 2097405.0036 | 37.738403211903204 | -122.482808088928 | (37.7384032119032, -122.482808088928) | |||
| 93908 | 93908 | 51029 | Permitted Site 1 | :: 54 | 133 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | 3x3 | Permit Number 767941 | 6007256.96585115 | 2097027.84886938 | 37.7384493854458 | -122.417421253654 | (37.7384493854458, -122.417421253654) | ||
| 29089 | 29089 | 183590 | Undocumented 2 | :: 54 | 2630 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989282.842 | 2097424.4506 | 37.7385106529577 | -122.47959536842899 | (37.7385106529577, -122.479595368429) | |||
| 155025 | 155025 | 245380 | Undocumented 2 | :: 54 | 3620 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005334.5439 | 2097112.3285 | 37.7385729952273 | -122.424074069598 | (37.7385729952273, -122.424074069598) | |||
| 171810 | 171810 | 183571 | Undocumented 2 | :: 54 | 1950 Vicente St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986841.6497 | 2097598.0157 | 37.7388451080573 | -122.48804847269699 | (37.7388451080573, -122.488048472697) | |||
| 117306 | 117306 | 104857 | Permitted Site 1 | :: 54 | 2555 46th Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | ||||||
| 69546 | 69546 | 183561 | Undocumented 2 | :: 54 | 1842 Vicente St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987180.92 | 2097610.4334 | 37.7388989899745 | -122.486876361154 | (37.7388989899745, -122.486876361154) | |||
| 110497 | 110497 | 38040 | Permitted Site 1 | :: 54 | 271 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40242 | 5992319.7729488 | 2097504.33557698 | 37.7389059415194 | -122.46910103166401 | (37.7389059415194, -122.469101031664) | ||
| 176431 | 176431 | 183053 | Undocumented 2 | :: 54 | 2601 19th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5990456.6898 | 2097547.4037 | 37.738916368412106 | -122.47554578609 | (37.7389163684121, -122.47554578609) | |||
| 151024 | 151024 | 185250 | Undocumented 2 | :: 54 | 2582 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986168.5104 | 2097675.5504 | 37.7390187057813 | -122.49038154463301 | (37.7390187057813, -122.490381544633) | |||
| 115253 | 115253 | 106460 | Undocumented 2 | :: 54 | 701 Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6007932.0 | 2097222.5 | 37.739021812259104 | -122.415101080128 | (37.7390218122591, -122.415101080128) | |||||
| 117839 | 117839 | 106461 | Undocumented 2 | :: 54 | 701 Cortland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6007932.0 | 2097222.5 | 37.739021812259104 | -122.415101080128 | (37.7390218122591, -122.415101080128) | |||||
| 130550 | 130550 | 183044 | Undocumented 2 | :: 54 | 2538 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981509.8326 | 2097796.9898 | 37.739078951665704 | -122.50649783936599 | (37.7390789516657, -122.506497839366) | |||
| 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) | |||||
| 181628 | 181628 | 183542 | Undocumented 2 | :: 54 | 2598 27th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988033.5951 | 2097670.443 | 37.7391134369583 | -122.483932641735 | (37.7391134369583, -122.483932641735) | |||
| 167902 | 167902 | 185253 | Undocumented 2 | :: 54 | 2566 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985543.2782 | 2097747.3201 | 37.739179229362705 | -122.4925485642 | (37.7391792293627, -122.4925485642) | |||
| 69138 | 69138 | 185252 | Undocumented 2 | :: 54 | 2567 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986119.691000001 | 2097773.7197 | 37.7392854011049 | -122.49055755796302 | (37.7392854011049, -122.490557557963) | |||
| 157360 | 157360 | 185251 | Undocumented 2 | :: 54 | 2566 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986166.3878 | 2097773.7197 | 37.7392881285851 | -122.490396103482 | (37.7392881285851, -122.490396103482) | |||
| 166140 | 166140 | 183547 | Undocumented 2 | :: 54 | 2596 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5989272.1918 | 2097727.998 | 37.7393434967425 | -122.47965439539101 | (37.7393434967425, -122.479654395391) | |||
| 51477 | 51477 | 183544 | Undocumented 2 | :: 54 | 2575 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987672.5493 | 2097766.1311 | 37.739355145969206 | -122.48518797755 | (37.7393551459692, -122.48518797755) | |||
| 67201 | 67201 | 185245 | Undocumented 2 | :: 54 | 2562 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986166.3878 | 2097803.4358 | 37.73936972108589 | -122.49039828899599 | (37.7393697210859, -122.490398288996) | |||
| 72168 | 72168 | 182979 | Undocumented 2 | :: 54 | 800 Vicente St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5990295.2626 | 2097717.7991 | 37.739374871061294 | -122.47611636270099 | (37.7393748710613, -122.476116362701) | |||
| 171184 | 171184 | 183041 | Undocumented 2 | :: 54 | 2518 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5981505.7715 | 2097922.8827 | 37.7394243796804 | -122.506521214497 | (37.7394243796804, -122.506521214497) | |||
| 148201 | 148201 | 183536 | Undocumented 2 | :: 54 | 2576 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988338.1627 | 2097791.2913 | 37.7394629808799 | -122.48288845238899 | (37.7394629808799, -122.482888452389) | |||
| 132675 | 132675 | 183534 | Undocumented 2 | :: 54 | 2575 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988292.8495 | 2097803.675 | 37.739494346597795 | -122.483046031116 | (37.7394943465978, -122.483046031116) | |||
| 153506 | 153506 | 185241 | Undocumented 2 | :: 54 | 2551 34th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5985807.672 | 2097858.4902 | 37.73949992809371 | -122.49164260379601 | (37.7394999280937, -122.491642603796) | |||
| 131751 | 131751 | 185242 | Undocumented 2 | :: 54 | 2554 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986164.2652 | 2097852.2551 | 37.7395036419136 | -122.490409218419 | (37.7395036419136, -122.490409218419) | |||
| 133418 | 133418 | 185243 | Undocumented 2 | :: 54 | 2555 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986116.5072 | 2097857.5616 | 37.7395154226653 | -122.490574732795 | (37.7395154226653, -122.490574732795) | |||
| 32899 | 32899 | 183517 | Undocumented 2 | :: 54 | 2558 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5987405.7216 | 2097878.3252 | 37.739647654239604 | -122.486118771525 | (37.7396476542396, -122.486118771525) | |||
| 76561 | 76561 | 183521 | Undocumented 2 | :: 54 | 2567 25th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5988601.5425 | 2097854.7918 | 37.739652658082 | -122.481982461654 | (37.739652658082, -122.481982461654) | |||
| 172095 | 172095 | 183010 | Undocumented 2 | :: 54 | 2500 37th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5984919.7169 | 2097961.3416 | 37.7397303960744 | -122.494720300824 | (37.7397303960744, -122.494720300824) | |||
| 81123 | 81123 | 36532 | Permitted Site 1 | :: 54 | 3734St. Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39405 | 6008419.88910724 | 2097501.78967285 | 37.7398160862313 | -122.413433924041 | (37.7398160862313, -122.413433924041) | ||
| 155656 | 155656 | 183518 | Undocumented 2 | :: 54 | 2547 29th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5987357.881 | 2097941.2897 | 37.73981774986029 | -122.486288802943 | (37.7398177498603, -122.486288802943) | |||
| 171329 | 171329 | 185237 | Undocumented 2 | :: 54 | 2534 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5986160.02 | 2097977.4873 | 37.7398472482312 | -122.490433106843 | (37.7398472482312, -122.490433106843) |
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");