Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100280 | 100280 | 6723 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1200X Fairfax Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/2011 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 522 | 522 | 6768 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1275 Fairfax Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 01:41:00 PM | 3 | 3x3 | 6017334.44654 | 2096871.02128 | 37.738580625297 | -122.382566951429 | (37.738580625297, -122.382566951429) | ||
| 16779 | 16779 | 6759 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1275 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2015 12:51:00 PM | 3 | 3x3 | 6017200.097680001 | 2096971.1659799998 | 37.7388481798969 | -122.38303843809099 | (37.7388481798969, -122.383038438091) | ||
| 50045 | 50045 | 190657 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 301 Mendell St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016835.36544 | 2097808.79392 | 37.7411279765664 | -122.38435784693998 | (37.7411279765664, -122.38435784694) | |||
| 112436 | 112436 | 6785 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1360 Fairfax Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 6x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | ||
| 118460 | 118460 | 14967 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 395 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/17/1998 12:00:00 AM | 3 | 3X3 | 6016770.717680001 | 2097736.2935200003 | 37.7409253302671 | -122.384576328932 | (37.7409253302671, -122.384576328932) | ||
| 154238 | 154238 | 190663 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1360 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6016747.40621 | 2097393.1689400002 | 37.7399818904553 | -122.384633036796 | (37.7399818904553, -122.384633036796) | |||
| 46854 | 46854 | 190660 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1395 Fairfax Ave | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6016617.23425 | 2097405.156 | 37.7400076047554 | -122.385083956852 | (37.7400076047554, -122.385083956852) | |||
| 53813 | 53813 | 190675 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1381 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016616.1402 | 2097404.54592 | 37.7400058690806 | -122.385087697166 | (37.7400058690806, -122.385087697166) | |||
| 90692 | 90692 | 6807 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1395 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | ||
| 13712 | 13712 | 6809 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1400X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016539.9784699995 | 2097547.42551 | 37.7403939741954 | -122.385360989424 | (37.7403939741954, -122.385360989424) | ||
| 15227 | 15227 | 6810 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1400X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016518.03729 | 2097563.6173900003 | 37.74043721991 | -122.38543798216999 | (37.74043721991, -122.38543798217) | ||
| 29747 | 29747 | 190661 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1400 Fairfax Ave | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016311.597030001 | 2097718.64456 | 37.7408514692121 | -122.386162583062 | (37.7408514692121, -122.386162583062) | |||
| 14629 | 14629 | 14993 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1445 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2006 12:00:00 AM | 3 | 3X3 | 6016309.01096 | 2097636.9306 | 37.740626956171496 | -122.38616582959 | (37.7406269561715, -122.38616582959) | ||
| 81436 | 81436 | 6830 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 83488 | 83488 | 6826 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 104221 | 104221 | 6822 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 124744 | 124744 | 6820 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 127073 | 127073 | 6827 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 6 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 128886 | 128886 | 6821 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1450X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12/19/2000 12:00:00 AM | 3 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.38617968089301 | (37.740834465841, -122.386179680893) | ||
| 30430 | 30430 | 190662 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1498 Fairfax Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016277.57069 | 2097744.40559 | 37.7409203204163 | -122.386282030116 | (37.7409203204163, -122.386282030116) | |||
| 36751 | 36751 | 190659 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016267.561869999 | 2097668.72921 | 37.740711974479 | -122.38631136240299 | (37.740711974479, -122.386311362403) | |||
| 62047 | 62047 | 190658 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016241.73559 | 2097685.48667 | 37.7407565574799 | -122.386401828788 | (37.7407565574799, -122.386401828788) | |||
| 15782 | 15782 | 6842 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/27/2016 07:14:00 AM | 3 | 3X3 | 6016194.23735 | 2097718.16262 | 37.740843649614206 | -122.38656833917901 | (37.7408436496142, -122.386568339179) | ||
| 107229 | 107229 | 6843 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1445 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2007 12:00:00 AM | 6 | 3X3 | 6016186.0 | 2097583.0 | 37.7404720645711 | -122.38658739858299 | (37.7404720645711, -122.386587398583) | ||
| 15010 | 15010 | 6841 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1461 Fairfax Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016176.35578 | 2097734.0043599997 | 37.7408861578704 | -122.38663127193199 | (37.7408861578704, -122.386631271932) | ||
| 91795 | 91795 | 6840 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1469 FAIRFAX AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 6016172.0 | 2097718.0 | 37.740841972016504 | -122.386645216998 | (37.7408419720165, -122.386645216998) | ||
| 86179 | 86179 | 6837 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1475 FAIRFAX AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/14/2001 12:00:00 AM | 6 | 3X3 | 6016157.0 | 2097767.0 | 37.740975685587394 | -122.386700497992 | (37.7409756855874, -122.386700497992) | ||
| 15580 | 15580 | 100252 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 540 Delancey St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 3x3 | 6015236.96681 | 2113599.67086 | 37.784397795653 | -122.39098797374201 | (37.784397795653, -122.390987973742) | |||
| 165141 | 165141 | 35462 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1016 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/16/1998 12:00:00 AM | 6 | Permit Number 38885 | 6014468.80099 | 2102427.52316 | 37.7536788925865 | -122.39286369422301 | (37.7536788925865, -122.392863694223) | |
| 71808 | 71808 | 190649 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1164 18th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6014097.05519 | 2105748.35032 | 37.7627765099393 | -122.394381783993 | (37.7627765099393, -122.394381783993) | |||
| 105952 | 105952 | 67708 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 57 Stillman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | Permit Number 31319 | 6013961.97114475 | 2112919.16578606 | 37.78245845414779 | -122.395351361788 | (37.7824584541478, -122.395351361788) | ||
| 78873 | 78873 | 94419 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 95770 | 95770 | 94417 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 100907 | 100907 | 94418 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 128623 | 128623 | 94420 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 5800 03rd St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3x3 | Permit Number 53653 | 6013849.0 | 2092184.0 | 37.72551786281171 | -122.39428997927601 | (37.7255178628117, -122.394289979276) | ||
| 156471 | 156471 | 190673 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6013287.80421 | 2111419.1855200003 | 37.7783023338298 | -122.397578465593 | (37.7783023338298, -122.397578465593) | |||
| 188019 | 188019 | 190672 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013276.0134 | 2111408.93876 | 37.778273542017395 | -122.39761853578001 | (37.7782735420174, -122.39761853578) | |||
| 56681 | 56681 | 190671 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013262.027919999 | 2111394.33223 | 37.7782326570475 | -122.397665892288 | (37.7782326570475, -122.397665892288) | |||
| 82415 | 82415 | 49456 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 175 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | |
| 86257 | 86257 | 49459 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 175 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | |
| 127471 | 127471 | 49457 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 175 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/2003 12:00:00 AM | 6 | 3x3 | Permit Number 46389 | 6013251.15232562 | 2111133.20769228 | 37.7775150629692 | -122.397685195261 | (37.7775150629692, -122.397685195261) | |
| 117665 | 117665 | 190670 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013247.06653 | 2111383.52028 | 37.778202136764605 | -122.39771689102 | (37.7782021367646, -122.39771689102) | |||
| 187193 | 187193 | 190669 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6013237.11478 | 2111370.50988 | 37.7781658589921 | -122.39775040518101 | (37.7781658589921, -122.397750405181) | |||
| 59088 | 59088 | 190668 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 151 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013191.282000001 | 2111332.8508900004 | 37.7780599035854 | -122.397906316128 | (37.7780599035854, -122.397906316128) | |||
| 74343 | 74343 | 190667 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013174.92981 | 2111315.77599 | 37.7780121091073 | -122.39796168649099 | (37.7780121091073, -122.397961686491) | |||
| 27224 | 27224 | 190666 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6013164.18283 | 2111305.0882200003 | 37.7779821643861 | -122.397998114425 | (37.7779821643861, -122.397998114425) | |||
| 146693 | 146693 | 190665 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013152.15167 | 2111293.3784 | 37.777949341814 | -122.398038913074 | (37.777949341814, -122.398038913074) | |||
| 55309 | 55309 | 190664 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6013137.75359 | 2111279.19954 | 37.7779096079765 | -122.398087726493 | (37.7779096079765, -122.398087726493) | |||
| 116435 | 116435 | 53916 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 319 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1972 12:00:00 AM | 13 | Permit Number 9628 | 6012951.97966 | 2105523.30262 | 37.762094858908206 | -122.398326431733 | (37.7620948589082, -122.398326431733) | ||
| 35360 | 35360 | 190656 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 358 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012906.49923 | 2105280.1318200002 | 37.7614246319699 | -122.39846666842101 | (37.7614246319699, -122.398466668421) | |||
| 52316 | 52316 | 190655 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 354 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6012900.86657 | 2105367.98453 | 37.7616655423506 | -122.398492314369 | (37.7616655423506, -122.398492314369) | |||
| 174253 | 174253 | 190654 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 330 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6012898.89819 | 2105464.4496299997 | 37.7619303045744 | -122.398505891451 | (37.7619303045744, -122.398505891451) | |||
| 69661 | 69661 | 190652 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 310 Arkansas St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012893.9262 | 2105541.86403 | 37.7621425904374 | -122.39852852018299 | (37.7621425904374, -122.398528520183) | |||
| 172245 | 172245 | 190653 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 320 Arkansas St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012892.66651 | 2105479.7779900003 | 37.7619720457008 | -122.398528520179 | (37.7619720457008, -122.398528520179) | |||
| 38824 | 38824 | 51853 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1639 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2005 12:00:00 AM | 8 | Permit Number 48077 | 6012728.89469 | 2105155.76009 | 37.7610732389628 | -122.39907220261999 | (37.7610732389628, -122.39907220262) | ||
| 80305 | 80305 | 32927 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1550 17th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1996 12:00:00 AM | Permit Number 37253 | 6012721.71993361 | 2106606.28169486 | 37.7650556499946 | -122.39919884037701 | (37.7650556499946, -122.399198840377) | |||
| 48889 | 48889 | 190650 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 501 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6012697.31498 | 2105105.25182 | 37.760932794527704 | -122.39917787837601 | (37.7609327945277, -122.399177878376) | |||
| 162506 | 162506 | 190651 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 501 Wisconsin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012696.96101 | 2105116.13755 | 37.760962664614 | -122.399179866755 | (37.760962664614, -122.399179866755) | |||
| 70029 | 70029 | 129087 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011445.1234 | 2120796.34037 | 37.803946988513104 | -122.40461329806801 | (37.8039469885131, -122.404613298068) | |||
| 39026 | 39026 | 129088 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011425.38411 | 2120792.86026 | 37.803936329766294 | -122.40468136238 | (37.8039363297663, -122.40468136238) | |||
| 147535 | 147535 | 129089 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6011405.84379 | 2120790.43469 | 37.8039285776094 | -122.40474881240601 | (37.8039285776094, -122.404748812406) | |||
| 64722 | 64722 | 129090 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 190 Lombard St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011386.68599 | 2120789.41334 | 37.803924702438394 | -122.404815037597 | (37.8039247024384, -122.404815037597) | |||
| 55117 | 55117 | 190674 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 446 Tehama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010985.96747 | 2112156.82627 | 37.7801992828204 | -122.405593378352 | (37.7801992828204, -122.405593378352) | |||
| 60274 | 60274 | 228460 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2625 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010714.680480001 | 2102241.99741 | 37.7529602452298 | -122.40583328059601 | (37.7529602452298, -122.405833280596) | |||
| 89343 | 89343 | 36994 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 2818 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | Permit Number 39614 | 6009898.14777577 | 2102820.5904951002 | 37.754503234678005 | -122.408697833051 | (37.754503234678, -122.408697833051) | ||
| 160550 | 160550 | 228458 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1332 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009514.46513 | 2101394.10676 | 37.7505649315368 | -122.409924021381 | (37.7505649315368, -122.409924021381) | |||
| 30449 | 30449 | 143026 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2027 POWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009443.5652 | 2120635.2508 | 37.80339260933211 | -122.411528458224 | (37.8033926093321, -122.411528458224) | |||
| 188130 | 188130 | 228457 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009423.8763 | 2106376.9257400003 | 37.7642415505399 | -122.410589115888 | (37.7642415505399, -122.410589115888) | |||
| 57920 | 57920 | 228456 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009403.2734199995 | 2106375.12773 | 37.7642354585115 | -122.410660248687 | (37.7642354585115, -122.410660248687) | |||
| 56231 | 56231 | 228455 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 7 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009383.67351 | 2106374.02164 | 37.7642313225287 | -122.410727961341 | (37.7642313225287, -122.410727961341) | |||
| 149630 | 149630 | 228454 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009362.10361 | 2106372.48972 | 37.7642259068175 | -122.410802457572 | (37.7642259068175, -122.410802457572) | |||
| 73664 | 73664 | 228453 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009339.05918 | 2106371.48119 | 37.7642218454873 | -122.41088209075899 | (37.7642218454873, -122.410882090759) | |||
| 175553 | 175553 | 228486 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 62 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009328.577269999 | 2097075.3639 | 37.7386961926807 | -122.41026195063 | (37.7386961926807, -122.41026195063) | |||
| 110596 | 110596 | 34537 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 62 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | Permit Number 38246 | 6009318.56317763 | 2097091.62254667 | 37.73874027405461 | -122.41029772240299 | (37.7387402740546, -122.410297722403) | ||
| 153175 | 153175 | 228452 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009318.2366 | 2106370.18067 | 37.7642171069559 | -122.41095401853799 | (37.7642171069559, -122.410954018538) | |||
| 160222 | 160222 | 228451 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009297.41402 | 2106368.8801700003 | 37.7642123684355 | -122.411025946309 | (37.7642123684355, -122.411025946309) | |||
| 166771 | 166771 | 228450 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009278.09164 | 2106368.2886 | 37.764209660560205 | -122.41109273536699 | (37.7642096605602, -122.411092735367) | |||
| 68876 | 68876 | 228449 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2701 17th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6009256.91005 | 2106366.76259 | 37.76420428262279 | -122.411165888909 | (37.7642042826228, -122.411165888909) | |||
| 128858 | 128858 | 66456 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 144 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/2008 12:00:00 AM | 3x3 | Permit Number 51700 | 6009019.86661618 | 2097810.11966481 | 37.7406963622889 | -122.41138122330099 | (37.7406963622889, -122.411381223301) | ||
| 113551 | 113551 | 39284 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 142789 | 142789 | 39301 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3000X 17th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/21/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40887 | 6008691.77200643 | 2106524.44270682 | 37.7646055260983 | -122.413131696747 | (37.7646055260983, -122.413131696747) |
| 176976 | 176976 | 34454 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 881 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 14 | Permit Number 38198 | 6008682.269119999 | 2120023.6323700002 | 37.8016705265302 | -122.414119665415 | (37.8016705265302, -122.414119665415) | |
| 68672 | 68672 | 228487 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008652.20159 | 2106330.0546 | 37.764069559682206 | -122.41325481347401 | (37.7640695596822, -122.413254813474) | |||
| 30267 | 30267 | 228488 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2880 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008610.437969999 | 2106311.71269 | 37.7640168522296 | -122.413397964868 | (37.7640168522296, -122.413397964868) | |||
| 188745 | 188745 | 49797 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1145 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 13 | 3x3 | Permit Number 46589 | 6008423.5727699995 | 2115887.46945 | 37.7902991118549 | -122.41472199441999 | (37.7902991118549, -122.41472199442) |
| 161804 | 161804 | 34455 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1711 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 7 | Permit Number 38199 | 6008299.19736 | 2118343.4802 | 37.7970357237711 | -122.415326264207 | (37.7970357237711, -122.415326264207) | |
| 40233 | 40233 | 129086 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1201 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008124.6291 | 2115843.7412 | 37.7901622440508 | -122.41575322364599 | (37.7901622440508, -122.415753223646) | |||
| 146757 | 146757 | 129085 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1201 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008098.74192 | 2115839.1342 | 37.790148139064 | -122.41584246517701 | (37.790148139064, -122.415842465177) | |||
| 100362 | 100362 | 42081 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 254 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42391 | 6008092.42384606 | 2100220.76756697 | 37.7472634047037 | -122.41475853876999 | (37.7472634047037, -122.41475853877) | ||
| 134183 | 134183 | 66597 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1201 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | 14 | Permit Number 29790 | 6008070.415030001 | 2115836.67012 | 37.7901397807808 | -122.415940299715 | (37.7901397807808, -122.415940299715) | |
| 34455 | 34455 | 228481 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 430 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008039.5755 | 2096830.96729 | 37.7379527941736 | -122.414701431422 | (37.7379527941736, -122.414701431422) | |||
| 53848 | 53848 | 66602 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1235 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/29/1992 12:00:00 AM | 13 | Permit Number 29795 | 6008012.17093 | 2115828.0191200003 | 37.7901127525459 | -122.41614120735399 | (37.7901127525459, -122.416141207354) | |
| 87775 | 87775 | 66598 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1243 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1991 12:00:00 AM | Permit Number 29791 | 6007978.50985665 | 2115821.60445069 | 37.79009324672379 | -122.41625721778799 | (37.7900932467238, -122.416257217788) | ||
| 125756 | 125756 | 65015 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 278 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2011 12:00:00 AM | 3 | 2x3 | Permit Number 768137 | 6007725.96636 | 2097829.89859682 | 37.74067801414021 | -122.415856451174 | (37.7406780141402, -122.415856451174) | |
| 33760 | 33760 | 228480 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 602 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007650.87527 | 2096524.2069599999 | 37.7370886509206 | -122.416023645289 | (37.7370886509206, -122.416023645289) | |||
| 107889 | 107889 | 62925 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 602 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776406 | 6007643.77781077 | 2096549.63091103 | 37.7371580604569 | -122.416049984435 | (37.7371580604569, -122.416049984435) | |
| 106437 | 106437 | 73597 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 825 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/2011 12:00:00 AM | 3x3 | Permit Number 767161 | 6007569.13590268 | 2104853.84433691 | 37.7599553630185 | -122.416896234376 | (37.7599553630185, -122.416896234376) | ||
| 94980 | 94980 | 49194 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) | |||
| 107014 | 107014 | 49199 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 140 South Van Ness Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2003 12:00:00 AM | Permit Number 46294 | 6007260.95069382 | 2109000.07567236 | 37.7713226032013 | -122.41825607172701 | (37.7713226032013, -122.418256071727) |
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");