Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1271 | 1271 | 19821 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY25 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 10ST | ||||||||
| 6661 | 6661 | 19920 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY36 | -2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 8239 | 8239 | 19878 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY33 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 9803 | 9803 | 19944 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY39 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 10529 | 10529 | 20302 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 50X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11072 | 11072 | 19946 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY39 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 11626 | 11626 | 19961 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY41 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 12402 | 12402 | 19975 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY45 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 30ST | ||||||||
| 12733 | 12733 | 19954 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY39 | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 12756 | 12756 | 19777 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY18 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 50ST | ||||||||
| 13663 | 13663 | 19874 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY33 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
| 14132 | 14132 | 19895 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY33 | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 25ST | ||||||||
| 15605 | 15605 | 19771 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 15986 | 15986 | 19773 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 20ST | ||||||||
| 125954 | 125954 | 114239 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1300x JUNIPERO SERRA BLVD | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | ||||
| 49231 | 49231 | 114226 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 80545 | 80545 | 114228 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 86013 | 86013 | 114235 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 105010 | 105010 | 114230 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 105541 | 105541 | 114227 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 112189 | 112189 | 114231 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 117729 | 117729 | 114237 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 125709 | 125709 | 114234 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 128194 | 128194 | 114232 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 128290 | 128290 | 114229 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 138891 | 138891 | 114238 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 139193 | 139193 | 114233 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 139478 | 139478 | 114236 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 99x FONT BLVD | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 22 | 5990948.0 | 2088640.0 | 37.71448733391829 | -122.473197635313 | (37.7144873339183, -122.473197635313) | ||||
| 10024 | 10024 | 173625 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1200X Junipero Serra Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 89097 | 89097 | 114144 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 118401 | 118401 | 114145 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 140509 | 140509 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 90632 | 90632 | 19347 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 600 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992459.1729484005 | 2089876.0608299 | 37.7179686413438 | -122.46806431972901 | (37.7179686413438, -122.468064319729) | |||
| 113489 | 113489 | 34853 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 85 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/01/1997 12:00:00 AM | Permit Number 38476 | 6001445.41488356 | 2093713.29123004 | 37.7290196763486 | -122.437277475077 | (37.7290196763486, -122.437277475077) | ||
| 104931 | 104931 | 98197 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 830 Joost Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6x24 | 5996641.8 | 2095053.2 | 37.732424500806204 | -122.45398057585 | (37.7324245008062, -122.45398057585) | ||||
| 92132 | 92132 | 1711 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 5 Bass Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016572.54474 | 2095129.81679 | 37.7337575087508 | -122.38507998492099 | (37.7337575087508, -122.385079984921) | |||
| 108741 | 108741 | 1912 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 8 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016615.0158522995 | 2095214.1533182 | 37.7339914292631 | -122.384939021898 | (37.7339914292631, -122.384939021898) | |||
| 66111 | 66111 | 54159 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 262 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 13 | Permit Number 9894 | 6012942.04708 | 2095291.8384200002 | 37.7340008934128 | -122.397643138528 | (37.7340008934128, -122.397643138528) | ||
| 88406 | 88406 | 1916 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 11 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016651.815200901 | 2095266.4928856997 | 37.734137178639 | -122.384815438972 | (37.734137178639, -122.384815438972) | |||
| 163249 | 163249 | 185019 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 2701 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5985029.339 | 2096373.5559999999 | 37.735377177897504 | -122.494224278603 | (37.7353771778975, -122.494224278603) | |||
| 94545 | 94545 | 29878 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1500X La Salle Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | 12x31 | 6015992.691127599 | 2095862.2429535 | 37.735736511316 | -122.38713579848 | (37.735736511316, -122.38713579848) | |||
| 122220 | 122220 | 188563 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1 Waterville St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6011470.31075 | 2096143.8224099998 | 37.7362581989524 | -122.402791312072 | (37.7362581989524, -122.402791312072) | ||||
| 111114 | 111114 | 21436 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 2692X Sunset Blvd | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 114506 | 114506 | 21403 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 2692X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 124593 | 124593 | 21441 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 2692X Sunset Blvd | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 141252 | 141252 | 21440 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 2692X Sunset Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 16025 | 16025 | 6425 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1100X Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/04/2003 12:00:00 AM | 12 | 3x3 | 6018217.31109 | 2096647.32337 | 37.7380151271058 | -122.379498860299 | (37.7380151271058, -122.379498860299) | ||
| 16877 | 16877 | 6427 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1100X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6018163.14059 | 2096688.19053 | 37.738124352445396 | -122.379688994958 | (37.7381243524454, -122.379688994958) | |||
| 111524 | 111524 | 6728 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1200X Fairfax Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 144285 | 144285 | 6704 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1200X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
| 64140 | 64140 | 220121 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1000 San Jose Ave | 67 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6005092.0847 | 2097087.14126 | 37.7384901445062 | -122.424910586579 | (37.7384901445062, -122.424910586579) | ||||
| 154515 | 154515 | 220120 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1000 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6005087.11734 | 2097092.81243 | 37.738505435679 | -122.42492816469802 | (37.738505435679, -122.424928164698) | ||||
| 177759 | 177759 | 220119 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1000 San Jose Ave | 65 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005096.05499 | 2097092.9842599998 | 37.7385064123255 | -122.42489727481001 | (37.7385064123255, -122.42489727481) | ||||
| 155811 | 155811 | 220118 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1000 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005108.5209099995 | 2097145.57569 | 37.738651520647295 | -122.424857914163 | (37.7386515206473, -122.424857914163) | ||||
| 90517 | 90517 | 44253 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1375 Evans Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.38428155142701 | (37.7404816352752, -122.384281551427) | |||
| 97823 | 97823 | 44252 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1375 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2001 12:00:00 AM | Permit Number 43687 | 6016852.68384064 | 2097573.05225711 | 37.7404816352752 | -122.38428155142701 | (37.7404816352752, -122.384281551427) | |||
| 143084 | 143084 | 26889 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1601 Galvez Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6015842.1307553 | 2097647.0535434 | 37.7406288998504 | -122.38778084281601 | (37.7406288998504, -122.387780842816) | |||
| 9841 | 9841 | 6835 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1485 FAIRFAX AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/03/2017 08:13:00 AM | 3 | 3X3 | 6016296.0 | 2097688.0 | 37.7407664622153 | -122.38621437638201 | (37.7407664622153, -122.386214376382) | ||
| 115416 | 115416 | 23685 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 330 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006867.213435099 | 2098039.8280465 | 37.741206118003504 | -122.418840582769 | (37.7412061180035, -122.418840582769) | |||
| 83308 | 83308 | 85506 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
| 87896 | 87896 | 85505 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
| 28668 | 28668 | 200915 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 3801 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015749.7726 | 2098032.6644 | 37.741682591651504 | -122.388127088521 | (37.7416825916515, -122.388127088521) | |||
| 89051 | 89051 | 23661 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 308 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006889.9376932 | 2098288.2721448997 | 37.741889569517795 | -122.418779625482 | (37.7418895695178, -122.418779625482) | |||
| 86806 | 86806 | 23658 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 302 Virginia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/1997 12:00:00 AM | 8 | 3X3 | 6006870.1278442005 | 2098321.8073815 | 37.7419805343744 | -122.418850499491 | (37.7419805343744, -122.418850499491) | ||
| 109120 | 109120 | 30340 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 175 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/15/1956 12:00:00 AM | Permit Number 26 | 5994414.04695782 | 2098601.44324242 | 37.7420391129783 | -122.461939590962 | (37.7420391129783, -122.461939590962) | |||
| 140917 | 140917 | 22125 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 3795X 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015845.491830001 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | |||
| 144493 | 144493 | 22130 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 3795X 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015845.491830001 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | |||
| 172611 | 172611 | 188562 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 3601 03rd St | 11 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6015968.542719999 | 2098749.82191 | 37.7436638776954 | -122.387420665355 | (37.7436638776954, -122.387420665355) | |||
| 130947 | 130947 | 188561 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 2230 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6012197.23492 | 2099395.45129 | 37.745227044201606 | -122.400506356909 | (37.7452270442016, -122.400506356909) | |||
| 133168 | 133168 | 185643 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 2100 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985040.1399 | 2100443.7841 | 37.7465535598153 | -122.494486886414 | (37.7465535598153, -122.494486886414) | |||
| 72017 | 72017 | 185642 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 2100 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985069.1522 | 2100447.6812 | 37.7465659581193 | -122.494386853704 | (37.7465659581193, -122.494386853704) | |||
| 137682 | 137682 | 186270 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1800 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984992.9477 | 2102426.3669 | 37.7519944279313 | -122.49479621795 | (37.7519944279313, -122.49479621795) | |||
| 69730 | 69730 | 186367 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1801 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984825.2316 | 2102541.2113 | 37.7522999403759 | -122.49538466495501 | (37.7522999403759, -122.495384664955) | |||
| 82824 | 82824 | 86923 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 195 Chattanooga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 49881 | 6004763.0 | 2102539.0 | 37.7534411018365 | -122.426436480741 | (37.7534411018365, -122.426436480741) | |||
| 41839 | 41839 | 186118 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1700 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984966.576 | 2103035.9667 | 37.753666677492106 | -122.49493235748999 | (37.7536666774921, -122.49493235749) | |||
| 170858 | 170858 | 188558 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6013273.06711 | 2102892.5718 | 37.7548893269913 | -122.397031443052 | (37.7548893269913, -122.397031443052) | ||||
| 158685 | 158685 | 188556 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6013320.20258 | 2102893.09045 | 37.7548933748448 | -122.396868470618 | (37.7548933748448, -122.396868470618) | ||||
| 76488 | 76488 | 188550 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 6013235.33415 | 2102896.38806 | 37.7548977050817 | -122.397162202681 | (37.7548977050817, -122.397162202681) | ||||
| 56644 | 56644 | 188560 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013253.43645 | 2102897.8837 | 37.75490281952929 | -122.397099704282 | (37.7549028195293, -122.397099704282) | ||||
| 146457 | 146457 | 188555 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013407.8295599995 | 2102894.99959 | 37.7549034940071 | -122.396565563648 | (37.7549034940071, -122.396565563648) | ||||
| 28834 | 28834 | 188557 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6013310.23031 | 2102900.17201 | 37.7549122641975 | -122.39690345423 | (37.7549122641975, -122.39690345423) | ||||
| 148535 | 148535 | 188554 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013414.60293 | 2102900.51315 | 37.7549190100055 | -122.396542525734 | (37.7549190100055, -122.396542525734) | ||||
| 56540 | 56540 | 188559 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 6013256.52558 | 2102904.20918 | 37.7549203598944 | -122.39708946463399 | (37.7549203598944, -122.397089464634) | ||||
| 135768 | 135768 | 188553 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013421.85474 | 2102905.28008 | 37.754932502540704 | -122.396517780884 | (37.7549325025407, -122.396517780884) | ||||
| 148763 | 148763 | 188552 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013433.23441 | 2102906.76929 | 37.7549372248775 | -122.39647853087799 | (37.7549372248775, -122.396478530878) | ||||
| 48749 | 48749 | 188551 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013445.60553 | 2102908.4840599997 | 37.7549426217134 | -122.39643586793801 | (37.7549426217134, -122.396435867938) | ||||
| 137966 | 137966 | 188549 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6013485.706259999 | 2102911.9967099996 | 37.754954498175294 | -122.39629743348101 | (37.7549544981753, -122.396297433481) | ||||
| 165118 | 165118 | 188548 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6013494.18064 | 2102912.22652 | 37.7549556007366 | -122.39626814257299 | (37.7549556007366, -122.396268142573) | ||||
| 148166 | 148166 | 188547 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6013501.25195 | 2102912.88665 | 37.754957806785 | -122.396243734071 | (37.754957806785, -122.396243734071) | ||||
| 146893 | 146893 | 188542 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 900x Carolina St | 54 | Median : Yard 3 | Tree 1 | DPW 2 | 16 | 6012509.86374 | 2102962.70315 | 37.75503937799 | -122.39967575475401 | (37.75503937799, -122.399675754754) | ||||
| 179106 | 179106 | 188544 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1501 22nd St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6013369.71631 | 2103799.38115 | 37.757384608426 | -122.396760769601 | (37.757384608426, -122.396760769601) | ||||
| 186791 | 186791 | 188545 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 651 Missouri St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6013660.85413 | 2103803.37059 | 37.75741176256 | -122.39575417192499 | (37.75741176256, -122.395754171925) | ||||
| 160403 | 160403 | 188543 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1501 22nd St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6013381.403059999 | 2103831.17556 | 37.7574725594206 | -122.396722580779 | (37.7574725594206, -122.396722580779) | ||||
| 180597 | 180597 | 188546 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 651 Missouri St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6013632.1413199995 | 2103889.75102 | 37.757647347167 | -122.39585952569401 | (37.757647347167, -122.395859525694) | ||||
| 127671 | 127671 | 71106 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 4235 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/23/2015 07:32:00 AM | 3 | 4x4 | 6001944.69626247 | 2104668.40530987 | 37.7591282168027 | -122.436335144342 | (37.7591282168027, -122.436335144342) | |
| 46202 | 46202 | 182140 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1414 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5988688.757999999 | 2105677.7715 | 37.7611375509737 | -122.482253913011 | (37.7611375509737, -122.482253913011) | |||
| 141880 | 141880 | 45128 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 232 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2001 12:00:00 AM | Permit Number 43985 | 6004034.46486858 | 2105728.24125402 | 37.7621567917777 | -122.429183297925 | (37.7621567917777, -122.429183297925) | |||
| 95422 | 95422 | 65918 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1346 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28933 | 5994594.09113824 | 2106359.56698751 | 37.763351309716604 | -122.46187948930901 | (37.7633513097166, -122.461879489309) | ||
| 125223 | 125223 | 65914 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 431 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/1990 12:00:00 AM | Permit Number 28924 | 5994447.75768828 | 2106990.5338514 | 37.7650753550186 | -122.462431373492 | (37.7650753550186, -122.462431373492) | ||
| 180800 | 180800 | 181699 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1807 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5990039.1294 | 2107177.6156 | 37.765334173056104 | -122.477693245166 | (37.7653341730561, -122.477693245166) |
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");