Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10993 | 10993 | 764 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1200X 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3 | 5984614.2914 | 2106873.7688 | 37.76418358274471 | -122.496433785178 | (37.7641835827447, -122.496433785178) | |||
| 21099 | 21099 | 1649 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1357X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6005247.73797 | 2100448.62508 | 37.7477288052344 | -122.424611464856 | (37.7477288052344, -122.424611464856) | |||
| 13841 | 13841 | 3685 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout 5 | Tree 1 | Port 9 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767871999 | (37.744924332395, -122.38470767872) | |||
| 118559 | 118559 | 3686 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
| 140153 | 140153 | 3687 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 128521 | 128521 | 3688 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 18 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 99473 | 99473 | 3689 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127726 | 127726 | 3690 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 127580 | 127580 | 3691 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 200X Cargo Way | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12 | 8 | 6017218.5539168 | 2098854.5663776 | 37.7440206368399 | -122.38310567533199 | (37.7440206368399, -122.383105675332) | |||
| 81922 | 81922 | 3865 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 220 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X4 | 6016069.3729239 | 2096169.6764515 | 37.7365849077155 | -122.386892111244 | (37.7365849077155, -122.386892111244) | |||
| 58 | 58 | 4749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1255 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2015 12:00:00 AM | 8 | 3X3 | 6007516.58505 | 2121541.63395 | 37.805773032263296 | -122.41826116482599 | (37.8057730322633, -122.418261164826) | ||
| 100701 | 100701 | 5321 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1861X Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001005.43894 | 2114739.90905 | 37.7867286257608 | -122.440305813645 | (37.7867286257608, -122.440305813645) | |||
| 117968 | 117968 | 5435 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 6 | 6004896.4850004995 | 2105439.5076575 | 37.7614127588524 | -122.426181340905 | (37.7614127588524, -122.426181340905) | |||
| 97092 | 97092 | 5467 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 600X Dolores St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 48 | 6004918.892342701 | 2104703.9652182 | 37.7593943997498 | -122.426051479658 | (37.7593943997498, -122.426051479658) | ||||
| 21846 | 21846 | 5476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 635 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 4X4 | 6005015.06111 | 2104677.01858 | 37.7593258454205 | -122.425716962778 | (37.7593258454205, -122.425716962778) | |||
| 13761 | 13761 | 6553 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Evans Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x8 | 6017462.04156 | 2097126.1556099998 | 37.7392882208803 | -122.382143528109 | (37.7392882208803, -122.382143528109) | |||
| 20374 | 20374 | 6568 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1301 Evans Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017234.1596238 | 2097288.6286052 | 37.7397217505579 | -122.382942754401 | (37.7397217505579, -122.382942754401) | |||
| 100857 | 100857 | 6573 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1329 Evans Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6017090.4856833 | 2097396.2206334 | 37.7400092370914 | -122.383447010551 | (37.7400092370914, -122.383447010551) | |||
| 79905 | 79905 | 6621 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1415 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | |||
| 53801 | 53801 | 6629 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1415 Evans Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 05/16/2013 12:00:00 AM | 17 | 4x4 | 6016652.34226 | 2097729.17939 | 37.7408992492988 | -122.38498513575001 | (37.7408992492988, -122.38498513575) | ||
| 128827 | 128827 | 6631 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1415 Evans Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/15/2001 12:00:00 AM | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | ||
| 81179 | 81179 | 6632 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1415 Evans Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 18 | 3x3 | 6016617.7688071 | 2097746.8662364 | 37.740945901362 | -122.385105911093 | (37.740945901362, -122.385105911093) | |||
| 15459 | 15459 | 6794 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1375 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1992 12:00:00 AM | 6 | 3x3 | 6016884.458330001 | 2097207.3634599997 | 37.7394792845271 | -122.38414622657 | (37.7394792845271, -122.38414622657) | ||
| 16744 | 16744 | 6812 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016477.270719999 | 2097595.73141 | 37.740523142935096 | -122.385581175844 | (37.7405231429351, -122.385581175844) | ||
| 118616 | 118616 | 6824 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1450X Fairfax Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 18 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | |||
| 14058 | 14058 | 6836 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1475 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2015 12:00:00 AM | 3 | 3X3 | 6016046.71071 | 2097829.88517 | 37.7411422488076 | -122.387086226361 | (37.7411422488076, -122.387086226361) | ||
| 99539 | 99539 | 6978 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 762 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003781.28082 | 2110436.25509 | 37.77506951805171 | -122.430394888902 | (37.7750695180517, -122.430394888902) | |||
| 6449 | 6449 | 7072 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1652 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999508.2617 | 2109836.0506 | 37.7731785369509 | -122.44513298700899 | (37.7731785369509, -122.445132987009) | |||
| 7305 | 7305 | 7157 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 719 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6003511.3637 | 2110856.3338 | 37.776207657227204 | -122.431358584421 | (37.7762076572272, -122.431358584421) | |||
| 19250 | 19250 | 7648 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3303 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1999 12:00:00 AM | 3 | 4x4 | 6008513.3556 | 2099374.88287 | 37.7449644349621 | -122.413243176241 | (37.7449644349621, -122.413243176241) | ||
| 24674 | 24674 | 7916 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1225 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x4 | 6005951.06937 | 2114267.1292 | 37.785710831353896 | -122.423161466763 | (37.7857108313539, -122.423161466763) | |||
| 81784 | 81784 | 7920 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1295X Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6005919.56037 | 2114492.67616 | 37.786328349346 | -122.423286518029 | (37.786328349346, -122.423286518029) | |||
| 22181 | 22181 | 9403 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 461 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/1998 12:00:00 AM | 6 | 3x3 | 6001657.4794 | 2097610.8780099996 | 37.7397336029134 | -122.43682325371599 | (37.7397336029134, -122.436823253716) | ||
| 8940 | 8940 | 9931 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005032.8646599995 | 2117688.63241 | 37.7950535595338 | -122.426581919932 | (37.7950535595338, -122.426581919932) | |||
| 6625 | 6625 | 9932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005031.67767 | 2117702.0644 | 37.795090373265296 | -122.42658698402501 | (37.7950903732653, -122.426586984025) | |||
| 17458 | 17458 | 10319 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 739 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6002579.70252 | 2109173.84871 | 37.7715351260824 | -122.434461126791 | (37.7715351260824, -122.434461126791) | |||
| 20504 | 20504 | 10495 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1701 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5997835.7259 | 2108510.475 | 37.7694432404816 | -122.450822883239 | (37.7694432404816, -122.450822883239) | |||
| 121435 | 121435 | 11773 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 79124 | 79124 | 11774 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 2x3 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 111936 | 111936 | 11787 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 92042 | 92042 | 11788 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 102978 | 102978 | 11789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 91193 | 91193 | 11791 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1199X Junipero Serra Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x4 | 5991174.554565701 | 2089606.7568954 | 37.7171549272284 | -122.472485017828 | (37.7171549272284, -122.472485017828) | |||
| 122991 | 122991 | 11815 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 112455 | 112455 | 11817 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 5991184.5559808 | 2089595.7938424998 | 37.7171254042551 | -122.47244964923901 | (37.7171254042551, -122.472449649239) | |||
| 118852 | 118852 | 11820 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1299X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | |||
| 96683 | 96683 | 11823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1299X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991432.171815401 | 2088660.0347764 | 37.7145703669544 | -122.47152561846501 | (37.7145703669544, -122.471525618465) | |||
| 141134 | 141134 | 12730 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3x3 | 5990437.55256 | 2114717.69591 | 37.786060275243294 | -122.476866177185 | (37.7860602752433, -122.476866177185) | |||
| 140687 | 140687 | 12731 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5990457.99077 | 2114717.95371 | 37.7860621686583 | -122.476795486066 | (37.7860621686583, -122.476795486066) | |||
| 98768 | 98768 | 12732 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990481.52989 | 2114717.45643 | 37.7860621686584 | -122.476714011555 | (37.7860621686584, -122.476714011555) | |||
| 96356 | 96356 | 12740 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1637 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 5990313.43665 | 2114711.3516599997 | 37.7860356551531 | -122.477295116444 | (37.7860356551531, -122.477295116444) | |||
| 77970 | 77970 | 12741 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1638 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5990321.4540800005 | 2114762.4147099997 | 37.786176325151295 | -122.47727111168899 | (37.7861763251513, -122.477271111689) | |||
| 80818 | 80818 | 12743 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1641 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5990285.065780001 | 2114712.64103 | 37.7860375492525 | -122.477393365207 | (37.7860375492525, -122.477393365207) | |||
| 92803 | 92803 | 12746 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1708 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5990140.905069999 | 2114757.41663 | 37.7861521246527 | -122.477895391404 | (37.7861521246527, -122.477895391404) | |||
| 108115 | 108115 | 12747 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1711 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 5x5 | 5990137.03852 | 2114678.28277 | 37.7859346208741 | -122.47790298136299 | (37.7859346208741, -122.477902981363) | |||
| 114826 | 114826 | 12748 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1714 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5990114.56006 | 2114756.24917 | 37.7861473900704 | -122.477986451795 | (37.7861473900704, -122.477986451795) | |||
| 103717 | 103717 | 12749 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1714 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3X3 | 5990095.47734 | 2114754.58354 | 37.7861417091128 | -122.478052350416 | (37.7861417091128, -122.478052350416) | |||
| 93494 | 93494 | 12757 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1739 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5990002.61461 | 2114703.0924299997 | 37.7859949384969 | -122.47836986084299 | (37.7859949384969, -122.478369860843) | |||
| 108564 | 108564 | 12808 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2112 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5 | 5988878.34651 | 2114712.3148 | 37.7859549296707 | -122.482260152644 | (37.7859549296707, -122.482260152644) | |||
| 101444 | 101444 | 12809 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2112 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5 | 5988863.55424 | 2114711.62184 | 37.7859521665696 | -122.482311278452 | (37.7859521665696, -122.482311278452) | |||
| 119447 | 119447 | 12833 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2235 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5988515.78975 | 2114643.77047 | 37.785745630994 | -122.483509457664 | (37.785745630994, -122.483509457664) | |||
| 7745 | 7745 | 13062 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2000 12:00:00 AM | 6 | 2X2 | 6009500.6409 | 2120545.5727 | 37.8031495768645 | -122.41132460578899 | (37.8031495768645, -122.411324605789) | ||
| 6476 | 6476 | 13064 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 590 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 6009534.3118 | 2120532.6199 | 37.8031159000828 | -122.411207170734 | (37.8031159000828, -122.411207170734) | |||
| 120724 | 120724 | 13067 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 610 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 2X2 | 6009404.55183 | 2120549.65161 | 37.803155386878 | -122.41165741430001 | (37.803155386878, -122.4116574143) | |||
| 670 | 670 | 13108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.80087277869679 | -122.427090735634 | (37.8008727786968, -122.427090735634) | |||
| 6364 | 6364 | 13127 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | |||
| 112742 | 112742 | 13155 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1871 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 6003453.14477 | 2119540.71202 | 37.8000494585448 | -122.43218031398199 | (37.8000494585448, -122.432180313982) | |||
| 115272 | 115272 | 13202 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2131 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002190.758780001 | 2119430.36525 | 37.7996748204961 | -122.436540743333 | (37.7996748204961, -122.436540743333) | |||
| 20788 | 20788 | 14571 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 5x5 | 5999361.6418 | 2109001.7234 | 37.7708793165263 | -122.445580154944 | (37.7708793165263, -122.445580154944) | |||
| 20602 | 20602 | 14575 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1134 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1997 12:00:00 AM | 18 | 4X4 | 5999433.6283 | 2108924.6352 | 37.770671761343706 | -122.445325609236 | (37.7706717613437, -122.445325609236) | ||
| 112652 | 112652 | 14999 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1459X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016235.7427248005 | 2097702.9858463 | 37.7408042749191 | -122.38642376985001 | (37.7408042749191, -122.38642376985) | |||
| 2379 | 2379 | 17840 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2017 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004165.4355 | 2115291.4590000003 | 37.7884224532463 | -122.429412324105 | (37.7884224532463, -122.429412324105) | |||
| 6667 | 6667 | 17874 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2158 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003619.9977 | 2115267.4707 | 37.7883256917387 | -122.4312977384 | (37.7883256917387, -122.4312977384) | |||
| 2354 | 2354 | 18870 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2269 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003913.0 | 2115924.0 | 37.790144955549394 | -122.430330857904 | (37.7901449555494, -122.430330857904) | |||
| 95715 | 95715 | 20475 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 123025 | 123025 | 20477 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1203X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 40 | 5984781.3005655 | 2107242.2257009 | 37.7652050441375 | -122.49588333961701 | (37.7652050441375, -122.495883339617) | |||
| 101610 | 101610 | 20510 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1211X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 60 | 5984783.690159501 | 2107169.3790132 | 37.7650051676015 | -122.49586970049101 | (37.7650051676015, -122.495869700491) | |||
| 17561 | 17561 | 22565 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 231 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6001358.74635 | 2097645.7360799997 | 37.7398123322633 | -122.437858639569 | (37.7398123322633, -122.437858639569) | |||
| 20368 | 20368 | 22570 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 285 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6001210.73338 | 2097821.1569 | 37.7402855789128 | -122.438382969513 | (37.7402855789128, -122.438382969513) | |||
| 88826 | 88826 | 22610 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 3X5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
| 31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
| 120636 | 120636 | 22615 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 8575 | 8575 | 22617 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/25/1997 12:00:00 AM | 6 | 3x5 | 6005634.7978 | 2112724.8918 | 37.781458374599794 | -122.424145957729 | (37.7814583745998, -122.424145957729) | ||
| 126289 | 126289 | 22618 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034003 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | |||
| 124938 | 124938 | 23448 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6006201.29445 | 2118123.14104 | 37.796312596515 | -122.422569862433 | (37.796312596515, -122.422569862433) | |||
| 102341 | 102341 | 23450 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2200 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6006201.29445 | 2118123.14104 | 37.796312596515 | -122.422569862433 | (37.796312596515, -122.422569862433) | |||
| 2194 | 2194 | 23455 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6005973.83981 | 2118127.35599 | 37.796311335142995 | -122.423357203778 | (37.796311335143, -122.423357203778) | |||
| 3914 | 3914 | 23457 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2249 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5x5 | 6005866.883230001 | 2118164.3475 | 37.7964068674367 | -122.42372992781901 | (37.7964068674367, -122.423729927819) | |||
| 8478 | 8478 | 23520 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2725 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6005647.500080001 | 2119771.5564099997 | 37.800807467849395 | -122.424603426707 | (37.8008074678494, -122.424603426707) | |||
| 5765 | 5765 | 23561 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2930 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6005650.5577 | 2120458.20498 | 37.8026930017358 | -122.424641718951 | (37.8026930017358, -122.424641718951) | |||
| 144206 | 144206 | 23573 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 3025 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6005485.556059999 | 2120793.85256 | 37.80360528368389 | -122.42523660667801 | (37.8036052836839, -122.425236606678) | |||
| 14181 | 14181 | 24141 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6016711.43718 | 2095116.50195 | 37.733728630852795 | -122.38459886076001 | (37.7337286308528, -122.38459886076) | |||
| 13458 | 13458 | 24144 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6016701.61434 | 2095161.25681 | 37.7338509755474 | -122.38463593799999 | (37.7338509755474, -122.384635938) | |||
| 9391 | 9391 | 24148 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Whitney Young Cir | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x4 | 6016357.373923 | 2096088.8828188 | 37.736379006835996 | -122.385890729183 | (37.736379006836, -122.385890729183) | |||
| 113430 | 113430 | 24924 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2199X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6001667.079621499 | 2113903.324382 | 37.7844692272317 | -122.437956753313 | (37.7844692272317, -122.437956753313) | |||
| 82591 | 82591 | 24927 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 36 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 107042 | 107042 | 24929 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | |||
| 83248 | 83248 | 24932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/22/1996 12:00:00 AM | 18 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) | ||
| 141366 | 141366 | 24933 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2099X Post St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6001850.6502853 | 2113928.178638 | 37.7845479080691 | -122.437323443199 | (37.7845479080691, -122.437323443199) |
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");