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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26919 | 26919 | 40953 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2901 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Permit Number 41808 | 6001006.01269 | 2118383.69068 | 37.796733533576706 | -122.440565274273 | (37.7967335335767, -122.440565274273) | |||
| 27106 | 27106 | 195241 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400x Evans Ave | 17 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 6016370.1217 | 2098002.92096 | 37.7416352733631 | -122.38598003597299 | (37.7416352733631, -122.385980035973) | ||||
| 27137 | 27137 | 32285 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3074 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2009 12:00:00 AM | 10 | Permit Number 53054 | 5999478.30502 | 2116696.29164 | 37.7920132718557 | -122.44573006101601 | (37.7920132718557, -122.445730061016) | ||
| 27209 | 27209 | 94284 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3445 Washington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5998275.762069999 | 2115831.09513 | 37.7895689396898 | -122.44982847122499 | (37.7895689396898, -122.449828471225) | ||||
| 27570 | 27570 | 41961 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 300 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 4 | Permit Number 42317 | 6012040.27004 | 2118796.36454 | 37.7984887835795 | -122.402413030242 | (37.7984887835795, -122.402413030242) | |
| 27621 | 27621 | 37955 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 701 Minnesota St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 6 | Permit Number 40192 | 6015222.376130001 | 2105229.81644 | 37.761415218749 | -122.390453430208 | (37.761415218749, -122.390453430208) | |
| 27757 | 27757 | 48706 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 405 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 5 | Permit Number 45976 | 6014025.598999999 | 2115298.0713400003 | 37.788993919485705 | -122.395297934177 | (37.7889939194857, -122.395297934177) | ||
| 28194 | 28194 | 195471 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014542.5915 | 2117352.94839 | 37.794664873444795 | -122.393653075045 | (37.7946648734448, -122.393653075045) | ||||
| 28390 | 28390 | 195474 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014565.75221 | 2117404.86556 | 37.794808712796396 | -122.393576570627 | (37.7948087127964, -122.393576570627) | ||||
| 28855 | 28855 | 31531 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1394 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 15 | Permit Number 35086 | 6011135.19156 | 2101876.96342 | 37.751981450105205 | -122.40435337421499 | (37.7519814501052, -122.404353374215) | |
| 28986 | 28986 | 70938 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 740 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/18/1995 12:00:00 AM | 12 | 6004494.5748 | 2111134.0934 | 37.777025989784 | -122.42797718611901 | (37.777025989784, -122.427977186119) | ||
| 29261 | 29261 | 105753 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 13 | Permit Number 771077 | 6003146.89414 | 2120799.57812 | 37.803488607670296 | -122.433330062032 | (37.8034886076703, -122.433330062032) | ||
| 29274 | 29274 | 49590 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2333 REVISED Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2003 12:00:00 AM | 11 | Permit Number 46464 | 6003720.98998 | 2116321.71913 | 37.7912261132416 | -122.43102359505698 | (37.7912261132416, -122.431023595057) | ||
| 29835 | 29835 | 56007 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2903 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1973 12:00:00 AM | 15 | Permit Number 12087 | 6000743.03384 | 2115846.8596099997 | 37.7897530812795 | -122.441293125296 | (37.7897530812795, -122.441293125296) | ||
| 30411 | 30411 | 32368 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 41 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/2004 12:00:00 AM | 7 | Permit Number 47262 | 6005643.54813 | 2109477.47092 | 37.77254224086089 | -122.423884698438 | (37.7725422408609, -122.423884698438) | ||
| 31084 | 31084 | 134794 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1040 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6007385.13093 | 2120235.26271 | 37.8021786677605 | -122.418623384776 | (37.8021786677605, -122.418623384776) | ||||
| 31339 | 31339 | 33988 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2034 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Permit Number 37930 | 5999819.0443 | 2111618.0516 | 37.7780891914803 | -122.444186028633 | (37.7780891914803, -122.444186028633) | |||
| 31420 | 31420 | 102369 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | Permit Number 769895 | 5984151.59861 | 2110096.53732 | 37.773005270668 | -122.49827212221099 | (37.773005270668, -122.498272122211) | |||
| 31479 | 31479 | 195925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 90 Kiska Rd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018989.61551 | 2093779.2666099998 | 37.7301825662676 | -122.376629714494 | (37.7301825662676, -122.376629714494) | ||||
| 31501 | 31501 | 100039 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1925 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6005166.77799 | 2116408.4512099996 | 37.7915460749308 | -122.426027382675 | (37.7915460749308, -122.426027382675) | ||||
| 31598 | 31598 | 32719 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1059 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 15 | Permit Number 37112 | 6008120.91675 | 2116143.25856 | 37.7909844366445 | -122.415787285469 | (37.7909844366445, -122.415787285469) | |
| 31615 | 31615 | 68242 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1130 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1993 12:00:00 AM | 6 | Permit Number 32042 | 6009363.25832 | 2116758.49929 | 37.7927434997615 | -122.41153230236799 | (37.7927434997615, -122.411532302368) | ||
| 31829 | 31829 | 41777 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1436 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 7 | Permit Number 42190 | 6006741.3221 | 2115908.4236 | 37.7902619855897 | -122.42054396081001 | (37.7902619855897, -122.42054396081) | |
| 31865 | 31865 | 195466 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014635.8418 | 2117314.36588 | 37.794564116081204 | -122.393327712917 | (37.7945641160812, -122.393327712917) | ||||
| 31948 | 31948 | 135088 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010288.509880001 | 2122353.59437 | 37.8081581116658 | -122.40872577909201 | (37.8081581116658, -122.408725779092) | ||||
| 32502 | 32502 | 49217 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | 8 | Permit Number 46300 | 6013628.03234 | 2115005.09416 | 37.7881673534879 | -122.396652925588 | (37.7881673534879, -122.396652925588) | ||
| 32625 | 32625 | 59976 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1613 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1982 12:00:00 AM | 17 | Permit Number 19460 | 6000053.7203 | 2114619.5859 | 37.7863440168003 | -122.44358987665899 | (37.7863440168003, -122.443589876659) | ||
| 32729 | 32729 | 32786 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1659 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | 7 | Permit Number 37153 | 5999840.0614 | 2110872.9364 | 37.7760444944885 | -122.444059770227 | (37.7760444944885, -122.444059770227) | |
| 32852 | 32852 | 76301 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Townsend St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/27/1996 12:00:00 AM | 13 | 6015739.497330001 | 2112628.79912 | 37.781759872771104 | -122.389181562198 | (37.7817598727711, -122.389181562198) | ||
| 33244 | 33244 | 135096 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010210.74566 | 2122411.37483 | 37.808312406561896 | -122.40899898321501 | (37.8083124065619, -122.408998983215) | ||||
| 33270 | 33270 | 100128 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6005897.30712 | 2116933.8296 | 37.7930298924771 | -122.42353712664499 | (37.7930298924771, -122.423537126645) | ||||
| 33518 | 33518 | 60310 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1754 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/1982 12:00:00 AM | 11 | Permit Number 19880 | 5999394.732999999 | 2110513.9995 | 37.775033531216295 | -122.445574456546 | (37.7750335312163, -122.445574456546) | ||
| 33534 | 33534 | 48888 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3132 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | 8 | Permit Number 46094 | 5985804.5371900005 | 2113240.84362 | 37.7817354218334 | -122.492786120653 | (37.7817354218334, -122.492786120653) | ||
| 33675 | 33675 | 134800 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070 Lombard St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6007227.6114300005 | 2120220.91562 | 37.802130404749896 | -122.419167461114 | (37.8021304047499, -122.419167461114) | ||||
| 33828 | 33828 | 50333 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | 12 | Permit Number 47027 | 6011553.125580001 | 2113034.8624400003 | 37.78264186306829 | -122.403693105462 | (37.7826418630683, -122.403693105462) | ||
| 33845 | 33845 | 34882 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 211 Main St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/09/1997 12:00:00 AM | 9 | Permit Number 38492 | 6014696.45789 | 2115808.03068 | 37.790431437202294 | -122.393012527528 | (37.7904314372023, -122.393012527528) | ||
| 33988 | 33988 | 58720 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 626 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/1979 12:00:00 AM | 16 | Permit Number 17954 | 6004829.54923 | 2110924.32503 | 37.7764689624137 | -122.426803462526 | (37.7764689624137, -122.426803462526) | ||
| 34032 | 34032 | 135097 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6010211.1601599995 | 2122431.69205 | 37.8083682157885 | -122.408998983212 | (37.8083682157885, -122.408998983212) | ||||
| 34175 | 34175 | 44126 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1455 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2000 12:00:00 AM | 11 | Permit Number 43631 | 6007354.4656 | 2110676.258 | 37.7759302643824 | -122.418051446991 | (37.7759302643824, -122.418051446991) | ||
| 34222 | 34222 | 112612 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2195 Green St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 6002608.57385 | 2118132.38825 | 37.7961346471419 | -122.435002071707 | (37.7961346471419, -122.435002071707) | ||||
| 34258 | 34258 | 135145 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6009594.12763 | 2122497.09351 | 37.808513208082 | -122.411139022559 | (37.808513208082, -122.411139022559) | ||||
| 34855 | 34855 | 134971 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6009844.1621199995 | 2122376.03453 | 37.8081948291999 | -122.41026515223 | (37.8081948291999, -122.41026515223) | ||||
| 34870 | 34870 | 65069 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2221 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1989 12:00:00 AM | 14 | Permit Number 27026 | 5999792.9894 | 2116549.41734 | 37.7916279555213 | -122.444630692873 | (37.7916279555213, -122.444630692873) | ||
| 34886 | 34886 | 135069 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010465.71952 | 2122256.12348 | 37.8079004046485 | -122.408105617404 | (37.8079004046485, -122.408105617404) | ||||
| 35237 | 35237 | 50729 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3101 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2004 12:00:00 AM | 6 | Permit Number 47278 | 5999795.90279 | 2116038.2083799997 | 37.7902244762226 | -122.444583854383 | (37.7902244762226, -122.444583854383) | ||
| 35307 | 35307 | 135015 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1077 Front St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012578.55568 | 2120142.36821 | 37.802214619965206 | -122.40064498919399 | (37.8022146199652, -122.400644989194) | ||||
| 35544 | 35544 | 100126 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6005948.98718 | 2116940.10629 | 37.7930500435754 | -122.423358756926 | (37.7930500435754, -122.423358756926) | ||||
| 35659 | 35659 | 135604 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 15 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014333.85609 | 2117662.37655 | 37.7955028896086 | -122.394397008632 | (37.7955028896086, -122.394397008632) | ||||
| 35684 | 35684 | 40952 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2009 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1999 12:00:00 AM | 16 | Permit Number 41807 | 6003337.12414 | 2118228.33351 | 37.79643942829961 | -122.43248799984801 | (37.7964394282996, -122.432487999848) | ||
| 36040 | 36040 | 30411 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2515 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1956 12:00:00 AM | 12 | Permit Number 69 | 6000905.946280001 | 2118588.7147 | 37.7972907768996 | -122.440926241448 | (37.7972907768996, -122.440926241448) | ||
| 36071 | 36071 | 58770 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1161 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1980 12:00:00 AM | 15 | Permit Number 18263 | 6011968.302519999 | 2103006.99877 | 37.755130800349896 | -122.40155175312799 | (37.7551308003499, -122.401551753128) | ||
| 36274 | 36274 | 48761 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 9 | Permit Number 46024 | 6015190.35931 | 2112916.94352 | 37.782520594884794 | -122.391101484356 | (37.7825205948848, -122.391101484356) | ||
| 36296 | 36296 | 48763 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 6 | Permit Number 46024 | 6015369.50523 | 2113087.0413 | 37.782997584516295 | -122.390493601112 | (37.7829975845163, -122.390493601112) | ||
| 36305 | 36305 | 44014 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2000 12:00:00 AM | 5 | Permit Number 43560 | 6007942.877280001 | 2112742.21819 | 37.7816359965394 | -122.416162322553 | (37.7816359965394, -122.416162322553) | ||
| 36505 | 36505 | 135612 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014267.8224 | 2117757.0986900004 | 37.7957593033995 | -122.39463213458201 | (37.7957593033995, -122.394632134582) | ||||
| 36545 | 36545 | 41046 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3035 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1999 12:00:00 AM | 15 | Permit Number 41826 | 5999632.76754 | 2116670.2294400004 | 37.7919505297352 | -122.445193746689 | (37.7919505297352, -122.445193746689) | ||
| 36957 | 36957 | 37780 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 666 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | 11 | Permit Number 40115 | 6008939.41218 | 2093311.61708 | 37.72833993181921 | -122.411341689271 | (37.7283399318192, -122.411341689271) | |
| 37666 | 37666 | 100125 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1800 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6005967.88782 | 2116944.18436 | 37.793062307639204 | -122.423293649581 | (37.7930623076392, -122.423293649581) | ||||
| 38055 | 38055 | 134980 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2350 Stockton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6009736.585940001 | 2122356.6353700003 | 37.8081355332869 | -122.410636078516 | (37.8081355332869, -122.410636078516) | ||||
| 38057 | 38057 | 102379 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 851 38th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3 | 5984156.57881 | 2110013.67242 | 37.772778039448106 | -122.49824877411999 | (37.7727780394481, -122.49824877412) | ||||
| 38284 | 38284 | 67224 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6400 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30683 | 5983507.38436 | 2109708.43135 | 37.771901847852895 | -122.500471801712 | (37.7719018478529, -122.500471801712) | |
| 38556 | 38556 | 39530 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88x Arkansas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 11 | Permit Number 40969 | 6012826.83044 | 2106709.20057 | 37.7653440995751 | -122.39884251038 | (37.7653440995751, -122.39884251038) | |
| 38675 | 38675 | 54001 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 19 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 12 | Permit Number 9719 | 6010666.13404 | 2089379.87515 | 37.717640876409604 | -122.405095569414 | (37.7176408764096, -122.405095569414) | ||
| 38767 | 38767 | 52440 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2601 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 10 | Permit Number 48551 | 6001622.27003 | 2116946.74485 | 37.792823127533296 | -122.43832988971201 | (37.7928231275333, -122.438329889712) | |
| 38941 | 38941 | 55462 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 816 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 10 | Permit Number 11413 | 6003786.7971 | 2111121.3778 | 37.7769510085081 | -122.43042470073401 | (37.7769510085081, -122.430424700734) | ||
| 38947 | 38947 | 113765 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2550 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 6001218.390819999 | 2117197.66107 | 37.793489098005 | -122.439745324601 | (37.793489098005, -122.439745324601) | ||||
| 39036 | 39036 | 97437 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900 Pacific Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 6004957.66 | 2117462.59015 | 37.794428653010606 | -122.426826033691 | (37.7944286530106, -122.426826033691) | ||||
| 39070 | 39070 | 45634 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 851(REVISED) Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/23/2002 12:00:00 AM | 5 | Permit Number 44342 | 6006528.3531599995 | 2113452.17751 | 37.783505734738604 | -122.42110633918502 | (37.7835057347386, -122.421106339185) | ||
| 39094 | 39094 | 56656 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2375 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 6002164.4179 | 2114662.6243 | 37.7865823408236 | -122.436290495143 | (37.7865823408236, -122.436290495143) | ||||
| 39130 | 39130 | 134791 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1000 Lombard St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6007500.8396 | 2120253.7585299998 | 37.802235966276 | -122.418224288116 | (37.802235966276, -122.418224288116) | ||||
| 39150 | 39150 | 113524 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 201 Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 6008988.51434 | 2113183.39215 | 37.7829060928859 | -122.41257609783301 | (37.7829060928859, -122.412576097833) | ||||
| 39360 | 39360 | 35395 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1998 12:00:00 AM | 11 | Permit Number 38849 | 6004620.1621 | 2116759.4151 | 37.7924788247896 | -122.42794368686 | (37.7924788247896, -122.42794368686) | ||
| 39451 | 39451 | 33903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 38 Bluxome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 19 | Permit Number 41779 | 6013525.73614 | 2110964.76149 | 37.777067834438704 | -122.39672349989401 | (37.7770678344387, -122.396723499894) | ||
| 39637 | 39637 | 101740 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 10 | Permit Number 769428 | 6006182.95151 | 2117984.64817 | 37.7959312951427 | -122.42262348648998 | (37.7959312951427, -122.42262348649) | ||
| 39651 | 39651 | 48707 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 405 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/19/2002 12:00:00 AM | 5 | Permit Number 45976 | 6014016.476480001 | 2115289.5841 | 37.788970108137995 | -122.39532890233 | (37.788970108138, -122.39532890233) | ||
| 40081 | 40081 | 106423 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900 North Point St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2014 12:00:00 AM | 2 | Permit Number 771764 | 6006040.64932 | 2121438.39457 | 37.8054063741716 | -122.42336152412099 | (37.8054063741716, -122.423361524121) | ||
| 40435 | 40435 | 30337 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2560 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/1956 12:00:00 AM | 12 | Permit Number 25 | 6000739.87625 | 2117117.74077 | 37.7932424094526 | -122.441395280167 | (37.7932424094526, -122.441395280167) | ||
| 41636 | 41636 | 134799 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1070 Lombard St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6007233.50436 | 2120221.1606099997 | 37.802131409291796 | -122.419147086091 | (37.8021314092918, -122.419147086091) | ||||
| 41646 | 41646 | 39970 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2725 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Permit Number 41231 | 6001008.15535 | 2116533.12717 | 37.791652492608 | -122.440425071772 | (37.791652492608, -122.440425071772) | |||
| 41895 | 41895 | 135063 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010521.57842 | 2122228.08294 | 37.807826539739104 | -122.407910324225 | (37.8078265397391, -122.407910324225) | ||||
| 42035 | 42035 | 65953 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1965 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1990 12:00:00 AM | 11 | Permit Number 28974 | 6004745.50192 | 2117383.16929 | 37.794198585745 | -122.427554465664 | (37.794198585745, -122.427554465664) | ||
| 42607 | 42607 | 61071 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2611 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 10 | Permit Number 20905 | 5999981.3394 | 2114011.0881 | 37.7846691114124 | -122.44379656236 | (37.7846691114124, -122.44379656236) | |
| 42690 | 42690 | 135067 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010487.41512 | 2122245.5184 | 37.8078725004725 | -122.40802978564899 | (37.8078725004725, -122.408029785649) | ||||
| 42803 | 42803 | 30459 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 325 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 7 | Permit Number 108 | 6011351.83908 | 2119693.73811 | 37.8009142983168 | -122.404858440665 | (37.8009142983168, -122.404858440665) | ||
| 42840 | 42840 | 57848 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3441 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | 10 | Permit Number 16789 | 5998339.9787800005 | 2115840.2149099996 | 37.7895976541501 | -122.449606946609 | (37.7895976541501, -122.449606946609) | ||
| 43168 | 43168 | 49023 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 199 01st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/06/2003 12:00:00 AM | Permit Number 46205 | 6013823.58160426 | 2115158.37921296 | 37.788599120029396 | -122.39598709957701 | (37.7885991200294, -122.395987099577) | |||
| 43498 | 43498 | 48756 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 6 | Permit Number 46024 | 6015229.4751 | 2112952.03748 | 37.782619125504105 | -122.39096861310699 | (37.7826191255041, -122.390968613107) | ||
| 43662 | 43662 | 42533 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 616 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 10 | Permit Number 42640 | 6009446.62137 | 2111558.04307 | 37.7784689692185 | -122.410876400723 | (37.7784689692185, -122.410876400723) | |
| 43913 | 43913 | 33138 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3018 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1996 12:00:00 AM | 10 | Permit Number 37365 | 6002001.0895 | 2118547.49342 | 37.797239905847505 | -122.437133821084 | (37.7972399058475, -122.437133821084) | |
| 44024 | 44024 | 135602 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6014349.4143900005 | 2117640.04464 | 37.7954424362789 | -122.39434160947901 | (37.7954424362789, -122.394341609479) | ||||
| 44082 | 44082 | 41480 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2390 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 42055 | 6007082.30805796 | 2120481.73008774 | 37.8028383512958 | -122.41968879786002 | (37.8028383512958, -122.41968879786) | ||||
| 44159 | 44159 | 37237 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2200X Moraga St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1998 12:00:00 AM | 11 | Permit Number 39797 | 5987327.3366 | 2103738.2851 | 37.755732966947896 | -122.486819996525 | (37.7557329669479, -122.486819996525) | ||
| 44208 | 44208 | 135607 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 450x The Embarcadero | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | 6014352.16969 | 2117713.37896 | 37.7956439482691 | -122.394337212703 | (37.7956439482691, -122.394337212703) | ||||
| 44591 | 44591 | 100042 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1925 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6005174.91003 | 2116356.5458 | 37.79140401532911 | -122.42599554934799 | (37.7914040153291, -122.425995549348) | ||||
| 44638 | 44638 | 30457 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 331 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1956 12:00:00 AM | 7 | Permit Number 106 | 6011327.7484 | 2119687.70083 | 37.8008963748235 | -122.404941379744 | (37.8008963748235, -122.404941379744) | ||
| 44772 | 44772 | 69342 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1827 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/15/1994 12:00:00 AM | 5 | Permit Number 33430 | 6004791.180819999 | 2118085.0799 | 37.796128437328704 | -122.427446439101 | (37.7961284373287, -122.427446439101) | ||
| 45297 | 45297 | 108827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 545 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6012961.52713 | 2086598.5921 | 37.710132076897004 | -122.39696648323601 | (37.710132076897, -122.396966483236) | ||||
| 45359 | 45359 | 68576 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 32 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | 7 | Permit Number 32469 | 5981483.59375 | 2111332.3319599996 | 37.776241595894106 | -122.50759263196899 | (37.7762415958941, -122.507592631969) | |
| 45743 | 45743 | 135093 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010231.518209999 | 2122384.9462900003 | 37.8082410039906 | -122.408925228011 | (37.8082410039906, -122.408925228011) | ||||
| 45805 | 45805 | 48753 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 219 Brannan St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 9 | Permit Number 46024 | 6015491.39691 | 2113203.61462 | 37.783324429619796 | -122.39008004875099 | (37.7833244296198, -122.390080048751) |
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");