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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3571 | 3571 | 39975 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
13382 | 13382 | 39972 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 0 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 41235 | |||||||||
94339 | 94339 | 85503 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
120969 | 120969 | 85508 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
125232 | 125232 | 85499 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | |||||
140801 | 140801 | 85504 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Nebraska St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 49678 | 6009335.0 | 2098038.0 | 37.7413397420659 | -122.410307693317 | (37.7413397420659, -122.410307693317) | ||||
145878 | 145878 | 89262 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Polk St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 51891 | 6007302.316366 | 2111625.640546 | 37.7785341058364 | -122.41829917319299 | (37.7785341058364, -122.418299173193) | ||||
98074 | 98074 | 49016 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 San Marcos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46202 | 5993947.57587841 | 2100008.88350341 | 37.745876723459396 | -122.463654612612 | (37.7458767234594, -122.463654612612) | ||||
86484 | 86484 | 46614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1 Sola Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2002 12:00:00 AM | Permit Number 44737 | 5995007.33907927 | 2100649.9152063 | 37.7476978436736 | -122.46003655522199 | (37.7476978436736, -122.460036555222) | |||
3903 | 3903 | 220233 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Ashbury St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/23/1987 12:00:00 AM | 39 | Width 4ft | Permit Number 12054 | 5999170.85741 | 2106639.03394 | 37.764381073148705 | -122.44607010996201 | (37.7643810731487, -122.446070109962) | |
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
116268 | 116268 | 42069 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | 10 | 3x3 | Permit Number 42381 | 6015269.0 | 2115673.0 | 37.790092461076604 | -122.39102211089701 | (37.7900924610766, -122.391022110897) |
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) | |||
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) | |||
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) | |||
116158 | 116158 | 89312 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/18/1969 12:00:00 AM | 3x3 | Permit Number 6484 | 6002340.0 | 2108819.0 | 37.7705471897255 | -122.43526488371799 | (37.7705471897255, -122.435264883718) | ||
138494 | 138494 | 55211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 101X Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | Permit Number 775231 | 5999977.22784047 | 2112772.7148777 | 37.781268623734604 | -122.44372179014601 | (37.7812686237346, -122.443721790146) | |||
92936 | 92936 | 34180 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 104 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1997 12:00:00 AM | Permit Number 38006 | 5998990.33122805 | 2116224.12146592 | 37.7906889445626 | -122.447384447462 | (37.7906889445626, -122.447384447462) | |||
160004 | 160004 | 121403 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1089 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6015119.7462 | 2089795.6867 | 37.719030579981705 | -122.38973034355601 | (37.7190305799817, -122.389730343556) | |||
53245 | 53245 | 93875 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Beulah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997572.0 | 2107825.0 | 37.76754600118029 | -122.451685641377 | (37.7675460011803, -122.451685641377) | |||||
83315 | 83315 | 88823 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 110 Clayton St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51710 | 5998275.0 | 2110294.0 | 37.7743654794888 | -122.44943198445 | (37.7743654794888, -122.44943198445) | ||||
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) | ||
106622 | 106622 | 48778 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1144REVISED Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46034 | 6000652.0009049 | 2108954.44361468 | 37.770823081138296 | -122.441113390762 | (37.7708230811383, -122.441113390762) | ||||
115003 | 115003 | 43419 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1181 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43160 | 6005197.0928245 | 2101475.30196221 | 37.7505449630015 | -122.424859624053 | (37.7505449630015, -122.424859624053) | ||||
88260 | 88260 | 30316 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1190 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.792650334753205 | -122.412449106972 | (37.7926503347532, -122.412449106972) | |||
127282 | 127282 | 30315 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1190 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/24/1955 12:00:00 AM | Permit Number 12 | 6009097.70753924 | 2116729.99483623 | 37.792650334753205 | -122.412449106972 | (37.7926503347532, -122.412449106972) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
3621 | 3621 | 249566 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1201 Franklin St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 4ft | 6005942.163819999 | 2114329.62673 | 37.7858819315591 | -122.42319672154899 | (37.7858819315591, -122.423196721549) | |||
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) | |||
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) | |||
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) | |||
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) | |||
117299 | 117299 | 50732 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1238 08TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | Permit Number 47282 | 5993659.1 | 2107052.1 | 37.7651989529315 | -122.465163596685 | (37.7651989529315, -122.465163596685) | |||
45050 | 45050 | 51789 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1238 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2005 12:00:00 AM | 13 | Permit Number 48038 | 5987411.1576 | 2106813.4078 | 37.7641812994666 | -122.486755921101 | (37.7641812994666, -122.486755921101) | ||
116341 | 116341 | 44107 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1244 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43617 | 6007592.1489348 | 2118533.63720141 | 37.7975180839438 | -122.417786315081 | (37.7975180839438, -122.417786315081) | ||||
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) | ||
176938 | 176938 | 66480 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 127 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | 30 | Permit Number 29809 | 5994252.33765 | 2114707.89192 | 37.7862539074759 | -122.46366743555599 | (37.7862539074759, -122.463667435556) | ||
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) | |||
14724 | 14724 | 28654 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Evans Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2004 12:00:00 AM | 3 | 6x3 | 6017442.42343 | 2097139.5251799999 | 37.739323847514 | -122.38221228939 | (37.739323847514, -122.38221228939) | ||
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) | |||
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) | |||
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) | |||
91072 | 91072 | 32418 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | |||
141176 | 141176 | 32419 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1300 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/08/1996 12:00:00 AM | Permit Number 36947 | 5990009.30581449 | 2102467.22445118 | 37.752398967394 | -122.477452096473 | (37.752398967394, -122.477452096473) | |||
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) | |||
63651 | 63651 | 109426 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 132 Locust St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2015 12:00:00 AM | 3 | 5997544.3 | 2115966.4 | 37.7898985728773 | -122.452369007612 | (37.7898985728773, -122.452369007612) | ||||
30134 | 30134 | 34162 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1321 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1997 12:00:00 AM | Permit Number 37995 | 6002005.24557776 | 2100252.01136141 | 37.747005294912896 | -122.435809748575 | (37.7470052949129, -122.435809748575) | |||
82012 | 82012 | 38955 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1322 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1998 12:00:00 AM | Permit Number 40750 | 5999535.03970594 | 2108258.16543211 | 37.768847591977796 | -122.44492690983 | (37.7688475919778, -122.44492690983) | |||
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) | |||
162465 | 162465 | 45658 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1330 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Permit Number 44353 | 6006595.78539 | 2119080.50195 | 37.7989635159037 | -122.421272856775 | (37.7989635159037, -122.421272856775) | |||
56042 | 56042 | 58355 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1340 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/1978 12:00:00 AM | 8 | Permit Number 17382 | 6008945.8597800005 | 2117518.1337200003 | 37.7948058484612 | -122.41303025994301 | (37.7948058484612, -122.413030259943) | ||
940 | 940 | 51496 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1350 REVISED Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/16/2005 12:00:00 AM | Permit Number 47808 | 6000958.86990754 | 2110035.78536621 | 37.773809648853 | -122.44012948036101 | (37.773809648853, -122.440129480361) | |||
18193 | 18193 | 39379 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1354 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | Permit Number 40920 | 6007143.93712268 | 2107602.08417603 | 37.7674774616365 | -122.41856167807501 | (37.7674774616365, -122.418561678075) | |||
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) | |||
54385 | 54385 | 57519 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/1976 12:00:00 AM | 20 | Permit Number 16376 | 6008935.4598199995 | 2117576.8667900003 | 37.7949665312373 | -122.41307040029301 | (37.7949665312373, -122.413070400293) | ||
147827 | 147827 | 59324 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1370 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/31/2012 12:00:00 AM | 1 | Permit Number 769281 | 5983406.5406 | 2105829.5951 | 37.761245750286996 | -122.50053376884199 | (37.761245750287, -122.500533768842) | ||
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) | ||
36213 | 36213 | 87049 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 139 Welsh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2007 12:00:00 AM | 13 | 3x3 | Permit Number 49986 | 6013117.93675 | 2111529.65612 | 37.7785962007824 | -122.398173856333 | (37.7785962007824, -122.398173856333) | |
180477 | 180477 | 87050 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 139 Welsh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | Permit Number 49986 | 6013132.69582 | 2111542.77268 | 37.7786330379242 | -122.398123719151 | (37.7786330379242, -122.398123719151) | ||
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) | ||
120219 | 120219 | 98758 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 141 Retiro Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768795 | 6001830.6 | 2121663.0 | 37.8057845723141 | -122.437947027917 | (37.8057845723141, -122.437947027917) | |||
2780 | 2780 | 246115 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1410 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998952.8623 | 2108365.1171 | 37.769108011186106 | -122.446948309851 | (37.7691080111861, -122.446948309851) | |
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) | ||
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) | |||
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) | |||
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) | ||
2778 | 2778 | 246114 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1418 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998969.2151 | 2108370.2652 | 37.769123080801 | -122.44689211719 | (37.769123080801, -122.44689211719) | |
2779 | 2779 | 246118 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1420 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 6 | Width 0ft | Permit Number 31980 | 5998892.5994 | 2108357.8492 | 37.769084612317705 | -122.44715623175301 | (37.7690846123177, -122.447156231753) | |
112583 | 112583 | 49595 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1442 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46465 | 6005191.43444841 | 2099927.58829524 | 37.7462949778276 | -122.42476909833599 | (37.7462949778276, -122.424769098336) | ||||
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) | |||
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) | |||
111922 | 111922 | 44211 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1466 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 43658 | 5990873.69248126 | 2105421.34105709 | 37.76056030978 | -122.474678523283 | (37.76056030978, -122.474678523283) | ||||
123109 | 123109 | 103476 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 147 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2013 12:00:00 AM | Permit Number 775299 | 6001179.7 | 2121217.2 | 37.8045234887457 | -122.440167571349 | (37.8045234887457, -122.440167571349) | |||
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) | ||
2994 | 2994 | 142170 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1477 GROVE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000804.7229 | 2110664.0211 | 37.7755258488103 | -122.440707770392 | (37.7755258488103, -122.440707770392) | |||
154141 | 154141 | 101137 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1477 Grove St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000842.8876 | 2110669.9339 | 37.7755442571847 | -122.440576174035 | (37.7755442571847, -122.440576174035) | |||
185372 | 185372 | 101136 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1477 Grove St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000824.6116 | 2110666.7087 | 37.7755343608772 | -122.44063916358499 | (37.7755343608772, -122.440639163585) | |||
85496 | 85496 | 40557 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1494 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2002 12:00:00 AM | Permit Number 46100 | 6003279.18698139 | 2099536.66435899 | 37.74511340174829 | -122.431353516201 | (37.7451134017483, -122.431353516201) | |||
92300 | 92300 | 50099 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1510 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46827 | 5992486.72879777 | 2096933.93018279 | 37.7373493975579 | -122.468482291601 | (37.7373493975579, -122.468482291601) | ||
86002 | 86002 | 50101 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1520 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.46855986898599 | (37.7372891525979, -122.468559868986) | ||
122709 | 122709 | 50100 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1520 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46828 | 5992463.83947388 | 2096912.47054003 | 37.7372891525979 | -122.46855986898599 | (37.7372891525979, -122.468559868986) | ||
127874 | 127874 | 46533 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1526 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44685 | 6001986.07565014 | 2099639.81164239 | 37.7453232498567 | -122.435832240904 | (37.7453232498567, -122.435832240904) | ||||
102797 | 102797 | 50102 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) | ||
109013 | 109013 | 50104 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46829 | 5992435.00755539 | 2096888.46432184 | 37.737221572040205 | -122.468657807095 | (37.7372215720402, -122.468657807095) |
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");