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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30391 | 30391 | 207358 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 171 Staples Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998941.871780001 | 2093762.1788299999 | 37.7290112721346 | -122.445935896945 | (37.7290112721346, -122.445935896945) | ||||
| 167231 | 167231 | 207166 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 174 Casitas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5995172.17423 | 2097043.6524099999 | 37.737805421392295 | -122.459205466579 | (37.7378054213923, -122.459205466579) | |||
| 30981 | 30981 | 71589 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 177 Goethe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 8 | 5994699.454059999 | 2086647.11862 | 37.7092318519263 | -122.460086907391 | (37.7092318519263, -122.460086907391) | ||
| 131950 | 131950 | 71605 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 178 Wilson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 7 | 5994512.31694 | 2086511.3564 | 37.7088483153534 | -122.46072384594 | (37.7088483153534, -122.46072384594) | ||
| 57515 | 57515 | 67671 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1780 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/05/1992 12:00:00 AM | 3 | Permit Number 31274 | 6014163.98928 | 2095111.2366 | 37.733572965423896 | -122.3934058406 | (37.7335729654239, -122.3934058406) | ||
| 166888 | 166888 | 207141 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1832 17th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990964.44749 | 2102904.31775 | 37.7536544876696 | -122.474180983561 | (37.7536544876696, -122.474180983561) | |||
| 38449 | 38449 | 226599 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1832 Castro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 6002599.9125 | 2100157.5460099997 | 37.746779676940896 | -122.43374669365 | (37.7467796769409, -122.43374669365) | |||
| 174997 | 174997 | 176989 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 5998947.7718 | 2089388.6360799999 | 37.717002872174504 | -122.445601123393 | (37.7170028721745, -122.445601123393) | ||||
| 178613 | 178613 | 176988 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 184 Mount Vernon Ave | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 5998975.21291 | 2089361.52774 | 37.7169300054919 | -122.445504324886 | (37.7169300054919, -122.445504324886) | ||||
| 60300 | 60300 | 182865 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1845 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989054.8495 | 2102750.5341 | 37.75312143070521 | -122.480773464165 | (37.7531214307052, -122.480773464165) | |||
| 34276 | 34276 | 182870 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1847 26th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988127.2852 | 2102724.1956 | 37.752995155363 | -122.483979194232 | (37.752995155363, -122.483979194232) | |||
| 186756 | 186756 | 182869 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1847 26th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5988126.7611 | 2102732.0567 | 37.753016709320995 | -122.48398158304701 | (37.753016709321, -122.483981583047) | |||
| 173676 | 173676 | 207279 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 186 Merced Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5994221.53046 | 2099188.36085 | 37.743639556416504 | -122.462647812372 | (37.7436395564165, -122.462647812372) | |||
| 187623 | 187623 | 226610 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 187 Bonview St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007102.33802 | 2097997.69789 | 37.7411036742096 | -122.418024617936 | (37.7411036742096, -122.418024617936) | |||
| 61927 | 61927 | 184535 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1914 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5981673.4595 | 2102023.0319999997 | 37.7506921190217 | -122.506245385817 | (37.7506921190217, -122.506245385817) | |||
| 26934 | 26934 | 227699 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 194 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005300.17225 | 2100223.67209 | 37.7471140970563 | -122.42441415180099 | (37.7471140970563, -122.424414151801) | |||
| 134189 | 134189 | 226586 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 195 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006490.36158 | 2105010.39 | 37.760324461620705 | -122.420638312212 | (37.7603244616207, -122.420638312212) | |||
| 52741 | 52741 | 92437 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1974 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52827 | 5982618.164 | 2101679.0263 | 37.7498031456316 | -122.502953108098 | (37.7498031456316, -122.502953108098) |
| 149732 | 149732 | 191412 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1998 Revere Ave | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 15 | 6013024.42365 | 2095944.26783 | 37.7357969159791 | -122.39740407446001 | (37.7357969159791, -122.39740407446) | ||||
| 24627 | 24627 | 207239 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 5996447.62341 | 2088998.17361 | 37.7157876983331 | -122.45421469505199 | (37.7157876983331, -122.454214695052) | |||
| 30605 | 30605 | 207238 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 34 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5996327.60089 | 2088999.83253 | 37.7157853699672 | -122.454629665632 | (37.7157853699672, -122.454629665632) | |||
| 33929 | 33929 | 207241 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 46 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5996475.13618 | 2088997.3163599998 | 37.7157869221947 | -122.45411953688601 | (37.7157869221947, -122.454119536886) | |||
| 65599 | 65599 | 207240 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 0ft | 5996458.70543 | 2088998.7901400002 | 37.7157900266684 | -122.45417643520001 | (37.7157900266684, -122.4541764352) | |||
| 69603 | 69603 | 207236 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5996258.071 | 2089000.15441 | 37.7157822655196 | -122.45487001484301 | (37.7157822655196, -122.454870014843) | |||
| 76312 | 76312 | 207237 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 33 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 0ft | 5996320.92755 | 2088998.85833 | 37.715782312278 | -122.454652661299 | (37.715782312278, -122.454652661299) | |||
| 133379 | 133379 | 207242 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1x Minerva St | 53 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 5996583.3083 | 2088999.01444 | 37.7157977869175 | -122.453745768776 | (37.7157977869175, -122.453745768776) | |||
| 52054 | 52054 | 226616 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.42341893953899 | (37.7385646686269, -122.423418939539) | |||
| 31229 | 31229 | 226622 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6004058.08528 | 2103018.40015 | 37.7547175483925 | -122.42890840132799 | (37.7547175483925, -122.428908401328) | |||
| 133848 | 133848 | 207319 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995627.90301 | 2100275.99182 | 37.7467068156796 | -122.45786363851299 | (37.7467068156796, -122.457863638513) | |||
| 175015 | 175015 | 207318 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5995646.386969999 | 2100270.85159 | 37.746693763801204 | -122.457799351359 | (37.7466937638012, -122.457799351359) | |||
| 177980 | 177980 | 207320 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995605.62076 | 2100279.71012 | 37.746715745033 | -122.45794095682699 | (37.746715745033, -122.457940956827) | |||
| 178122 | 178122 | 207321 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 20 Woodside Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995570.24881 | 2100282.2016 | 37.746720553705 | -122.458063448969 | (37.746720553705, -122.458063448969) | |||
| 63970 | 63970 | 227703 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 200 Kingston St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | Width 8ft | 6006269.2438199995 | 2098023.2428599996 | 37.7411268910989 | -122.420906974789 | (37.7411268910989, -122.420906974789) | |||
| 161425 | 161425 | 207217 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 201 Judson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 5998700.58194 | 2093477.09847 | 37.7282147273036 | -122.44674954686701 | (37.7282147273036, -122.446749546867) | |||
| 155540 | 155540 | 226607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 205 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997675.15136 | 2106444.92247 | 37.7637625662095 | -122.45122931550699 | (37.7637625662095, -122.451229315507) | |||
| 46244 | 46244 | 250337 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 21 25th Ave North | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5987995.71435 | 2115876.11718 | 37.7890990187437 | -122.485399212222 | (37.7890990187437, -122.485399212222) | |||
| 47592 | 47592 | 207190 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5999972.7522599995 | 2094392.56954 | 37.7308009895699 | -122.44241731471399 | (37.7308009895699, -122.442417314714) | ||||
| 53679 | 53679 | 207188 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5999995.26886 | 2094392.10213 | 37.7308009895535 | -122.442339437931 | (37.7308009895535, -122.442339437931) | ||||
| 152419 | 152419 | 207191 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999968.7786 | 2094392.65203 | 37.7308009895755 | -122.442431058168 | (37.7308009895755, -122.442431058168) | ||||
| 158363 | 158363 | 207189 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5999987.6528199995 | 2094392.26023 | 37.7308009895722 | -122.442365779062 | (37.7308009895722, -122.442365779062) | ||||
| 182650 | 182650 | 207192 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 212 Hearst Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5999965.474330001 | 2094393.0504400001 | 37.730801895176896 | -122.442442510114 | (37.7308018951769, -122.442442510114) | ||||
| 181320 | 181320 | 129489 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2120 Jefferson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999042.28702 | 2121160.24008 | 37.80424517403429 | -122.44756015169901 | (37.8042451740343, -122.447560151699) | ||||
| 59113 | 59113 | 207317 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2146 12th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5992616.43475 | 2100823.70057 | 37.748037210643396 | -122.46831674014 | (37.7480372106434, -122.46831674014) | |||
| 75227 | 75227 | 185264 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2147 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986264.4244 | 2097520.2042 | 37.7385977678327 | -122.490038499473 | (37.7385977678327, -122.490038499473) | |||
| 51665 | 51665 | 185263 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2157 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986253.2809 | 2097519.1429 | 37.738594203049004 | -122.4900769498 | (37.738594203049, -122.4900769498) | |||
| 157438 | 157438 | 177007 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 216 Saint Charles Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5992028.26989 | 2086999.54978 | 37.710045543251205 | -122.469344489883 | (37.7100455432512, -122.469344489883) | |||
| 66099 | 66099 | 185262 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2167 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5986237.8922 | 2097517.551 | 37.738588933455404 | -122.490130038774 | (37.7385889334554, -122.490130038774) | |||
| 61510 | 61510 | 207295 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 217 Colon Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5996039.75572 | 2094297.6973299999 | 37.7303155346371 | -122.45600737215 | (37.7303155346371, -122.45600737215) | |||
| 74649 | 74649 | 207296 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 217 Colon Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5996041.08515 | 2094289.8634799998 | 37.7302941010767 | -122.456002210028 | (37.7302941010767, -122.456002210028) | |||
| 184253 | 184253 | 207297 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 217 Colon Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5996046.36344 | 2094274.51279 | 37.730252254734104 | -122.455982853036 | (37.7302522547341, -122.455982853036) | |||
| 131253 | 131253 | 185261 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2177 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986220.9115 | 2097517.551 | 37.7385879417998 | -122.49018874910401 | (37.7385879417998, -122.490188749104) | |||
| 187515 | 187515 | 207357 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 219 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998605.9960199995 | 2093779.39497 | 37.7290393588582 | -122.44709827877199 | (37.7290393588582, -122.447098278772) | |||
| 165558 | 165558 | 226619 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007856.36673 | 2100270.38915 | 37.747386388365705 | -122.415578321691 | (37.7473863883657, -122.415578321691) | |||
| 154723 | 154723 | 43162 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 221 Madison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 5 | Permit Number 42972 | 6005660.57006 | 2092632.04042 | 37.726289518943 | -122.42262853710301 | (37.726289518943, -122.422628537103) | |
| 150633 | 150633 | 207151 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 223 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994241.91079 | 2105279.16697 | 37.760364530923205 | -122.46301916490299 | (37.7603645309232, -122.463019164903) | |||
| 56436 | 56436 | 207226 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 224 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995369.52282 | 2091446.6873400002 | 37.722448854419795 | -122.45811818710399 | (37.7224488544198, -122.458118187104) | |||
| 58753 | 58753 | 185611 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2241 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986448.3245 | 2100932.1027 | 37.747976665787895 | -122.489653506406 | (37.7479766657879, -122.489653506406) | |||
| 76937 | 76937 | 42890 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2249 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42809 | 5988984.6022 | 2098295.481 | 37.7408849467502 | -122.48069027409402 | (37.7408849467502, -122.480690274094) | |
| 179554 | 179554 | 42889 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2249 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/03/2000 12:00:00 AM | 3 | Permit Number 42809 | 5988969.9668 | 2098294.7493 | 37.7408820870559 | -122.48074082372801 | (37.7408820870559, -122.480740823728) | |
| 40972 | 40972 | 185610 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2251 Quintara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986429.217999999 | 2100931.4203 | 37.7479736765682 | -122.48971952481001 | (37.7479736765682, -122.48971952481) | |||
| 188359 | 188359 | 226618 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007884.76815 | 2100264.95114 | 37.7473730532316 | -122.415479726319 | (37.7473730532316, -122.415479726319) | |||
| 54071 | 54071 | 207232 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226 Thrift St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 6ft | 5994766.53745 | 2089660.64097 | 37.7175101320775 | -122.46007322780301 | (37.7175101320775, -122.460073227803) | |||
| 68986 | 68986 | 185609 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2261 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986412.841 | 2100929.3732 | 37.747967099583 | -122.489776004492 | (37.747967099583, -122.489776004492) | |||
| 62306 | 62306 | 52667 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226@ MARIPOSA Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2006 12:00:00 AM | 4 | Permit Number 48748 | 6013989.6640800005 | 2106012.3733900003 | 37.7634954891429 | -122.39477170574301 | (37.7634954891429, -122.394771705743) | ||
| 59492 | 59492 | 31354 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2324 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34964 | 5992033.25034 | 2099586.3658 | 37.7446061063992 | -122.47024325973 | (37.7446061063992, -122.47024325973) | |
| 188791 | 188791 | 177020 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 235 Vienna St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6004327.3137300005 | 2092022.6110200002 | 37.724540851055 | -122.42719414780599 | (37.724540851055, -122.427194147806) | ||||
| 74258 | 74258 | 207354 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5996818.09015 | 2094943.97322 | 37.732134696764 | -122.453363219655 | (37.732134696764, -122.453363219655) | |||
| 103991 | 103991 | 100461 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5992450.0 | 2097712.0 | 37.7394836593705 | -122.468665877071 | (37.7394836593705, -122.468665877071) | |||||
| 135470 | 135470 | 207277 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 236 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992402.86272 | 2097663.9953099997 | 37.7393491274725 | -122.46882536342 | (37.7393491274725, -122.46882536342) | |||
| 34491 | 34491 | 207157 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5992487.55481 | 2097691.20205 | 37.7394287228632 | -122.468534517269 | (37.7394287228632, -122.468534517269) | |||
| 74830 | 74830 | 207158 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 237 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992472.8250400005 | 2097675.82148 | 37.739385640835295 | -122.468584327098 | (37.7393856408353, -122.468584327098) | |||
| 158421 | 158421 | 207171 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 240 Stillings Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999241.01629 | 2095793.3410200002 | 37.7346054437908 | -122.445047696791 | (37.7346054437908, -122.445047696791) | |||
| 131369 | 131369 | 207156 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2426 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991402.6198 | 2098893.19012 | 37.7426663442825 | -122.472373311184 | (37.7426663442825, -122.472373311184) | |||
| 154947 | 154947 | 207205 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 243 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5997427.42425 | 2094320.33561 | 37.7304572443933 | -122.45121166810499 | (37.7304572443933, -122.451211668105) | |||
| 131761 | 131761 | 207244 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 246 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991705.04474 | 2090167.4544799998 | 37.7187251566245 | -122.47069219949199 | (37.7187251566245, -122.470692199492) | |||
| 178747 | 178747 | 47762 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2462 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/2002 12:00:00 AM | 4 | Permit Number 45541 | 5988312.7876 | 2098561.9922 | 37.741577647038 | -122.48303266006 | (37.741577647038, -122.48303266006) | |
| 162483 | 162483 | 207356 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 247 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998447.51248 | 2093764.7485200001 | 37.7289900868122 | -122.447645112433 | (37.7289900868122, -122.447645112433) | ||||
| 171196 | 171196 | 31366 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2475 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34971 | 5991057.56391 | 2098576.78296 | 37.7417775946723 | -122.473543328283 | (37.7417775946723, -122.473543328283) | |
| 51759 | 51759 | 207273 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2486 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991107.555 | 2098499.64463 | 37.741568687546604 | -122.473364852413 | (37.7415686875466, -122.473364852413) | |||
| 133371 | 133371 | 207206 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 249 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5997427.94217 | 2094345.17262 | 37.730525470566896 | -122.451211668094 | (37.7305254705669, -122.451211668094) | |||
| 23484 | 23484 | 226621 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2498 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008827.83459 | 2103955.23814 | 37.7575587153899 | -122.412479469249 | (37.7575587153899, -122.412479469249) | |||
| 63480 | 63480 | 177019 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 25 Madrid St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004214.26597 | 2093378.8456299999 | 37.728258376811496 | -122.427681523704 | (37.7282583768115, -122.427681523704) | ||||
| 47861 | 47861 | 62489 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 25 Otsego Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1986 12:00:00 AM | 8 | Permit Number 22660 | 6000933.610719999 | 2092903.74949 | 37.726767752305605 | -122.43898882388399 | (37.7267677523056, -122.438988823884) | |
| 185209 | 185209 | 207231 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 250 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5994770.3606900005 | 2090247.29491 | 37.7191211640843 | -122.46010248996099 | (37.7191211640843, -122.460102489961) | |||
| 47869 | 47869 | 129491 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999689.18555 | 2117591.31365 | 37.794482803901296 | -122.445064787505 | (37.7944828039013, -122.445064787505) | |||
| 66041 | 66041 | 129492 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999690.83284 | 2117600.09007 | 37.794506995647 | -122.445059718941 | (37.794506995647, -122.445059718941) | |||
| 175637 | 175637 | 129490 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5999691.42103 | 2117587.23687 | 37.794471737733105 | -122.44505675927401 | (37.7944717377331, -122.445056759274) | |||
| 79917 | 79917 | 1384 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2550X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X2 | 6002245.07965 | 2096962.3294799998 | 37.737986217166096 | -122.43474521929 | (37.7379862171661, -122.43474521929) | |||
| 57514 | 57514 | 226606 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2560 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6002251.74918 | 2096967.99127 | 37.7380021417799 | -122.434722564214 | (37.7380021417799, -122.434722564214) | |||
| 155804 | 155804 | 226585 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 257 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007206.23744 | 2105617.20797 | 37.762030962987296 | -122.41820544911998 | (37.7620309629873, -122.41820544912) | |||
| 11700 | 11700 | 109233 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2570 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x9 | 5986169.5717 | 2097728.0842 | 37.7391630116047 | -122.490381738824 | (37.7391630116047, -122.490381738824) | |||
| 60961 | 60961 | 43315 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 259 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2000 12:00:00 AM | 4 | Permit Number 43078 | 6004448.9414 | 2091752.36291 | 37.72380568677679 | -122.426754460261 | (37.7238056867768, -122.426754460261) | |
| 48088 | 48088 | 31195 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 260 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1995 12:00:00 AM | 6 | Permit Number 34888 | 5992024.42182 | 2086737.21442 | 37.7093250109181 | -122.469338707216 | (37.7093250109181, -122.469338707216) | ||
| 11855 | 11855 | 112294 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2606 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x2 | 5989896.9401 | 2097604.9354 | 37.7390418709124 | -122.47748532406099 | (37.7390418709124, -122.477485324061) | |||
| 34009 | 34009 | 70454 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2631 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/1994 12:00:00 AM | 1 | 5982726.9666 | 2097193.7529 | 37.7374942155975 | -122.502244984058 | (37.7374942155975, -122.502244984058) | ||
| 148538 | 148538 | 42630 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2634 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42686 | 6004473.47116 | 2118249.9245 | 37.7965630841803 | -122.428557534402 | (37.7965630841803, -122.428557534402) | |
| 129591 | 129591 | 185132 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2675 34th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5985816.5603 | 2097133.8948 | 37.7375109017116 | -122.491558549707 | (37.7375109017116, -122.491558549707) | |||
| 137313 | 137313 | 207334 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 27 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999906.0481 | 2095478.3381 | 37.7337784541927 | -122.44272585413799 | (37.7337784541927, -122.442725854138) | |||
| 58505 | 58505 | 32742 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 27 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 4 | 3x3 | Permit Number 37125 | 5996375.5789 | 2089291.73885 | 37.7165896282782 | -122.454484907162 | (37.7165896282782, -122.454484907162) | |
| 40455 | 40455 | 177006 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 271 Teddy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009831.15293 | 2088401.27476 | 37.7149071271443 | -122.40791276406 | (37.7149071271443, -122.40791276406) |
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");