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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 118552 | 118552 | 62554 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 950 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22751 | 6002017.25559301 | 2109492.91057277 | 37.772379247666 | -122.436429497983 | (37.772379247666, -122.436429497983) | ||
| 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) | |||
| 118915 | 118915 | 62557 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 231 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22756 | 6002274.80033002 | 2109264.35337792 | 37.7717663171547 | -122.435522274291 | (37.7717663171547, -122.435522274291) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 125545 | 125545 | 62551 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 873 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22748 | 6002404.22700345 | 2109493.88447514 | 37.7724039027427 | -122.435090998906 | (37.7724039027427, -122.435090998906) | ||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |
| 127934 | 127934 | 30293 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 2101 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1956 12:00:00 AM | Permit Number 136 | 6003511.17021246 | 2117907.12338032 | 37.795567335959 | -122.43186281655198 | (37.795567335959, -122.431862816552) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | ||||
| 140069 | 140069 | 36668 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 973 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/1998 12:00:00 AM | Permit Number 39474 | 6001922.20638095 | 2109427.06790723 | 37.7721930587125 | -122.436753567493 | (37.7721930587125, -122.436753567493) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||||
| 142959 | 142959 | 62555 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 968 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/08/1986 12:00:00 AM | Permit Number 22753 | 6001933.57765066 | 2109481.17221936 | 37.7723422619436 | -122.43671810696199 | (37.7723422619436, -122.436718106962) | ||
| 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) | |||
| 143512 | 143512 | 53569 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 718 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/1988 12:00:00 AM | Permit Number 6489 | 6002262.08955542 | 2108831.48537983 | 37.7705770468004 | -122.435535269571 | (37.7705770468004, -122.435535269571) | ||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 155250 | 155250 | 247417 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 981 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6001920.2327 | 2109431.4693 | 37.772205031674794 | -122.436760709737 | (37.7722050316748, -122.436760709737) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 158386 | 158386 | 247305 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 873 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002334.5255 | 2109487.5806 | 37.7723826357595 | -122.435331651709 | (37.7723826357595, -122.435331651709) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 164949 | 164949 | 247413 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 963 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001970.4339 | 2109438.2533 | 37.772226511757204 | -122.436587545425 | (37.7722265117572, -122.436587545425) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) |
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");