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 | ||||||||
| 115717 | 115717 | 30311 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 860 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 9 | 5983275.48572939 | 2109941.19024403 | 37.7725273211727 | -122.50129116256599 | (37.7725273211727, -122.501291162566) | ||||
| 121565 | 121565 | 63206 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 3641 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23748 | 5984253.92200128 | 2113128.61080648 | 37.7813364679992 | -122.498142145884 | (37.7813364679992, -122.498142145884) | ||
| 120126 | 120126 | 63217 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 3621 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23761 | 5984312.74399006 | 2113130.81658791 | 37.78134597315321 | -122.497938816629 | (37.7813459731532, -122.497938816629) | ||
| 82454 | 82454 | 63210 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 3601 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23753 | 5984371.56597884 | 2113133.02236934 | 37.7813554779566 | -122.497735487323 | (37.7813554779566, -122.497735487323) | ||
| 57978 | 57978 | 71993 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 3449 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1986 12:00:00 AM | 20 | 5984766.04316 | 2113148.2827 | 37.7814204950816 | -122.496371935666 | (37.7814204950816, -122.496371935666) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 147482 | 147482 | 120027 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 5250 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5987077.12189 | 2109838.60933 | 37.7724681813772 | -122.488133553564 | (37.7724681813772, -122.488133553564) | |||
| 141918 | 141918 | 97334 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 211 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5987387.3 | 2114536.2 | 37.785384526712896 | -122.48740575699101 | (37.7853845267129, -122.487405756991) | ||||
| 93125 | 93125 | 12858 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 2455 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5987787.46088 | 2114620.72752 | 37.7856399434951 | -122.486027545007 | (37.7856399434951, -122.486027545007) | |||
| 62078 | 62078 | 120360 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 2420 Lake St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 5987898.73747 | 2114688.5608599996 | 37.785832678759796 | -122.48564754506 | (37.7858326787598, -122.48564754506) | |||
| 119393 | 119393 | 12836 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 2255 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 5988409.73159 | 2114642.3017599997 | 37.7857354248176 | -122.483876276617 | (37.7857354248176, -122.483876276617) | |||
| 32363 | 32363 | 120392 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 735 24th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5988458.4501 | 2110868.62788 | 37.775376814580895 | -122.48343098442899 | (37.7753768145809, -122.483430984429) | ||||
| 188788 | 188788 | 120393 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 735 24th Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 5988458.36945 | 2110846.11582 | 37.7753149980476 | -122.48342961272499 | (37.7753149980476, -122.483429612725) | ||||
| 33575 | 33575 | 120395 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 735 24th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5988459.668880001 | 2110795.1356099998 | 37.7751750962322 | -122.48342137966499 | (37.7751750962322, -122.483421379665) | ||||
| 118783 | 118783 | 12824 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 2201 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5 | 5988584.5219 | 2114647.3917900003 | 37.785759574315705 | -122.48327193233 | (37.7857595743157, -122.48327193233) | |||
| 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) | |||
| 141389 | 141389 | 61500 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 155 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/1984 12:00:00 AM | Permit Number 21453 | 5989580.98367675 | 2114335.37160458 | 37.784960794856 | -122.47980165523799 | (37.784960794856, -122.479801655238) | ||
| 121421 | 121421 | 61492 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 171 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/1984 12:00:00 AM | Permit Number 21441 | 5989584.76357215 | 2114231.48161607 | 37.7846757617561 | -122.479780973493 | (37.7846757617561, -122.479780973493) | ||
| 95854 | 95854 | 106400 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 100 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 5989617.86074 | 2114578.87225 | 37.7856315213945 | -122.479691897092 | (37.7856315213945, -122.479691897092) | |||
| 137956 | 137956 | 72077 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 140 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 12 | 5989623.30395 | 2114484.58501 | 37.785372951377894 | -122.479666163956 | (37.7853729513779, -122.479666163956) | ||
| 180699 | 180699 | 74002 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 140 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 7 | 5989624.30976 | 2114465.1650799997 | 37.785319688143396 | -122.47966126275 | (37.7853196881434, -122.47966126275) | ||
| 83780 | 83780 | 74217 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 140 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 10 | 5989626.45991 | 2114449.60046 | 37.785277076979796 | -122.47965268471701 | (37.7852770769798, -122.479652684717) | ||
| 109387 | 109387 | 65122 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 328 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27092 | 5989675.82756959 | 2113141.97698014 | 37.7816895771658 | -122.47938619127399 | (37.7816895771658, -122.479386191274) | ||
| 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) | |||
| 123928 | 123928 | 181700 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1805 Lincoln Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5990060.5745 | 2107178.3815 | 37.765337520509895 | -122.477619128372 | (37.7653375205099, -122.477619128372) | |||
| 138019 | 138019 | 181321 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1831 Lincoln Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5990078.1902 | 2107177.6156 | 37.7653364397928 | -122.47755814445699 | (37.7653364397928, -122.477558144457) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 163265 | 163265 | 122957 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 178 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993071.353730001 | 2114313.86484 | 37.7851038966064 | -122.46772463071301 | (37.7851038966064, -122.467724630713) | |||
| 137750 | 137750 | 53938 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 178 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1972 12:00:00 AM | 13 | Permit Number 9652 | 5993071.23757 | 2114298.66075 | 37.7850621436327 | -122.467723926434 | (37.7850621436327, -122.467723926434) | ||
| 88830 | 88830 | 56310 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 178 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/21/1984 12:00:00 AM | Permit Number 21650 | 5993077.11990526 | 2114307.36148956 | 37.7850863731263 | -122.467704208587 | (37.7850863731263, -122.467704208587) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||||
| 156487 | 156487 | 124766 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 138 Locust St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997561.1508599995 | 2115901.7779200003 | 37.7897221032522 | -122.452306040493 | (37.7897221032522, -122.452306040493) | |||
| 76647 | 76647 | 124765 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 138 Locust St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5997565.1935 | 2115884.13609 | 37.7896738950858 | -122.45229077990601 | (37.7896738950858, -122.452290779906) | |||
| 187436 | 187436 | 124764 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 138 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5997570.27212 | 2115851.1781 | 37.7895836921739 | -122.45227082935 | (37.7895836921739, -122.45227082935) | |||
| 138273 | 138273 | 34992 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 829 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/17/2000 12:00:00 AM | Permit Number 38570 | 5998631.01806421 | 2107405.55103252 | 37.7664548933778 | -122.447992448577 | (37.7664548933778, -122.447992448577) | ||
| 59119 | 59119 | 124763 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 55 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998922.83859 | 2116354.0427200003 | 37.7910418169751 | -122.447627323869 | (37.7910418169751, -122.447627323869) | |||
| 158344 | 158344 | 116890 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 799X Marina Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999183.52163 | 2121463.27937 | 37.8050853080999 | -122.447093221893 | (37.8050853080999, -122.447093221893) | |||
| 153965 | 153965 | 250152 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 2501 Lyon St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5999205.942969999 | 2117400.85973 | 37.7939322749156 | -122.44672314997 | (37.7939322749156, -122.44672314997) | ||||
| 116604 | 116604 | 40632 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1385 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1999 12:00:00 AM | Permit Number 41908 | 5999539.52102625 | 2107847.36223217 | 37.7677198855431 | -122.44488187524901 | (37.7677198855431, -122.444881875249) | |||
| 125901 | 125901 | 96094 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1524 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999743.8 | 2107236.2 | 37.766053443333796 | -122.444131380779 | (37.7660534433338, -122.444131380779) | ||||
| 174983 | 174983 | 142164 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 490 Baker St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6000672.4904 | 2110619.9435 | 37.775397291640104 | -122.44116203008998 | (37.7753972916401, -122.44116203009) | |||
| 2932 | 2932 | 142166 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1477 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000715.4928 | 2110652.1954 | 37.7754882965725 | -122.44101558938699 | (37.7754882965725, -122.441015589387) | |||
| 104319 | 104319 | 100365 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 450X Baker St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 769344 | 6000745.0 | 2110655.0 | 37.7754976778855 | -122.44091371844 | (37.7754976778855, -122.44091371844) | ||||
| 169053 | 169053 | 99111 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 2105 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 6000887.0683699995 | 2115666.65288 | 37.7892664842201 | -122.44078184902399 | (37.7892664842201, -122.440781849024) | ||||
| 170285 | 170285 | 99113 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 2105 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | 6000888.787269999 | 2115636.76287 | 37.7891845118984 | -122.440773756903 | (37.7891845118984, -122.440773756903) | ||||
| 82102 | 82102 | 101131 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1477 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||||
| 139830 | 139830 | 101135 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1477 Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000788.3 | 2110635.6 | 37.775446876390205 | -122.44076254186001 | (37.7754468763902, -122.44076254186) | ||||
| 130381 | 130381 | 244488 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1192 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6000913.4497 | 2109333.087 | 37.7718776296576 | -122.44023619364401 | (37.7718776296576, -122.440236193644) | |||
| 85992 | 85992 | 62564 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 401 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22765 | 6001708.19271751 | 2109769.06982879 | 37.7731199456311 | -122.437518353384 | (37.7731199456311, -122.437518353384) | ||
| 121534 | 121534 | 62547 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 339 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22742 | 6001725.06048849 | 2109561.60697562 | 37.772551263359 | -122.43744514665 | (37.772551263359, -122.43744514665) | ||
| 108904 | 108904 | 62556 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1009 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22755 | 6001742.0 | 2109408.0 | 37.7721304598957 | -122.437375549988 | (37.7721304598957, -122.437375549988) | ||
| 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) | ||
| 104951 | 104951 | 62548 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 364 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22743 | 6001791.89658849 | 2109658.78296356 | 37.7728218839519 | -122.437220913321 | (37.7728218839519, -122.437220913321) | ||
| 89303 | 89303 | 64732 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 259 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/28/1988 12:00:00 AM | Permit Number 25691 | 6001783.83117373 | 2109148.55885484 | 37.77142047705029 | -122.43721227336701 | (37.7714204770503, -122.437212273367) | ||
| 100519 | 100519 | 62546 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 324 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22741 | 6001810.43023006 | 2109526.13327918 | 37.7724587144958 | -122.43714730421101 | (37.7724587144958, -122.437147304211) | ||
| 91149 | 91149 | 62544 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 251 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22739 | 6001803.31467833 | 2109086.42479932 | 37.771250979895704 | -122.43714042967301 | (37.7712509798957, -122.437140429673) |
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");