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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 169842 | 169842 | 219181 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 431 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 5999211.06214 | 2094946.2543900001 | 37.7322778337559 | -122.445090379531 | (37.7322778337559, -122.445090379531) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 131234 | 131234 | 228502 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 157 Randall St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6004514.7040099995 | 2097528.46975 | 37.739669302297294 | -122.426938314049 | (37.7396693022973, -122.426938314049) | |||
| 136265 | 136265 | 228501 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004538.94965 | 2097529.04935 | 37.7396722646649 | -122.426854524238 | (37.7396722646649, -122.426854524238) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |
| 121398 | 121398 | 60428 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 427 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1992 12:00:00 AM | Permit Number 30410 | 6003803.88116194 | 2098922.41171053 | 37.7434565282269 | -122.429495418306 | (37.7434565282269, -122.429495418306) | ||
| 135498 | 135498 | 228476 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 427 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003772.71447 | 2098922.9201 | 37.7434561594686 | -122.42960322110599 | (37.7434561594686, -122.429603221106) | |||
| 114509 | 114509 | 37417 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1406 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/16/2004 12:00:00 AM | Permit Number 39895 | 6001966.85277742 | 2099994.31437339 | 37.746295538854795 | -122.435924071348 | (37.7462955388548, -122.435924071348) | ||
| 130323 | 130323 | 228477 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 432 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003665.88299 | 2100131.59167 | 37.74676884190679 | -122.43005882127599 | (37.7467688419068, -122.430058821276) | |||
| 58955 | 58955 | 37026 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 432 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39636 | 6003698.16480104 | 2100138.36684077 | 37.746789273196796 | -122.429947677166 | (37.7467892731968, -122.429947677166) | ||
| 91452 | 91452 | 48986 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 372 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/2005 12:00:00 AM | Permit Number 46173 | 6004094.60882476 | 2100160.1254271 | 37.7468714608035 | -122.428578362797 | (37.7468714608035, -122.428578362797) | ||
| 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) | ||
| 60791 | 60791 | 228485 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 4158 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002879.00201 | 2100672.89334 | 37.7482105324925 | -122.432818439532 | (37.7482105324925, -122.432818439532) | |||
| 100348 | 100348 | 71197 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3966 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 3x3 | Permit Number 53734 | 6004099.24997097 | 2100745.29337187 | 37.7484784588463 | -122.42860401950001 | (37.7484784588463, -122.4286040195) | |
| 47929 | 47929 | 228459 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006042.870080001 | 2100850.33706 | 37.748876688223795 | -122.421890467095 | (37.7488766882238, -122.421890467095) | |||
| 85659 | 85659 | 43634 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3632 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/2000 12:00:00 AM | Permit Number 43284 | 6006090.90673928 | 2100856.20266776 | 37.7488955027959 | -122.42172477262301 | (37.7488955027959, -122.421724772623) | ||
| 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) | |||
| 161401 | 161401 | 228484 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000983.78885 | 2101507.81072 | 37.750395343677795 | -122.439431853304 | (37.7503953436778, -122.439431853304) | |||
| 87419 | 87419 | 32861 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 27 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37208 | 6000989.97871227 | 2101553.81963673 | 37.7505220253917 | -122.439413745994 | (37.7505220253917, -122.439413745994) | ||
| 56243 | 56243 | 228489 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001576.285680001 | 2101774.2319 | 37.751160574113605 | -122.437402036675 | (37.7511605741136, -122.437402036675) | |||
| 143377 | 143377 | 32828 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4242 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/30/1996 12:00:00 AM | Permit Number 37186 | 6001621.17563554 | 2101776.13913042 | 37.7511683628484 | -122.43724693926201 | (37.7511683628484, -122.437246939262) | ||
| 51149 | 51149 | 228500 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1230 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6002502.463830001 | 2101939.70334 | 37.7516675300559 | -122.434211046008 | (37.7516675300559, -122.434211046008) | |||
| 68617 | 68617 | 228483 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 950 Corbett Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5999780.4847 | 2102039.74605 | 37.751787354827 | -122.44363115936198 | (37.751787354827, -122.443631159362) | |||
| 122853 | 122853 | 87378 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 950 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 3x3 | Permit Number 50360 | 5999753.9 | 2102061.4 | 37.7518452950477 | -122.44372464805299 | (37.7518452950477, -122.443724648053) | ||
| 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) | |||
| 113736 | 113736 | 32823 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4257 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | Permit Number 37181 | 6001484.39499205 | 2102303.82093127 | 37.75260947422421 | -122.43775772935 | (37.7526094742242, -122.43775772935) | ||
| 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) | |
| 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) | ||
| 117935 | 117935 | 48637 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) | ||
| 138636 | 138636 | 48636 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2002 12:00:00 AM | 10 | 3x3 | Permit Number 45930 | 5994015.63459985 | 2103366.68968447 | 37.7551003254336 | -122.463662936643 | (37.7551003254336, -122.463662936643) |
| 70920 | 70920 | 219180 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994012.85069 | 2103371.98784 | 37.7551147123942 | -122.463672948647 | (37.7551147123942, -122.463672948647) | |||
| 178475 | 178475 | 219179 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1785 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5994014.03321 | 2103382.75983 | 37.7551443576498 | -122.46366964095199 | (37.7551443576498, -122.463669640952) | |||
| 26787 | 26787 | 228493 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3748 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003428.54428 | 2103628.48028 | 37.7563570304699 | -122.431129066663 | (37.7563570304699, -122.431129066663) | |||
| 146861 | 146861 | 228492 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3746 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003450.5613 | 2103629.24333 | 37.756360373235204 | -122.431052978634 | (37.7563603732352, -122.431052978634) | |||
| 75156 | 75156 | 35578 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 1001 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38947 | 6006352.71975705 | 2103759.98649975 | 37.7568833861691 | -122.421025568698 | (37.7568833861691, -122.421025568698) | ||
| 63250 | 63250 | 228464 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005334.7155 | 2104318.69082 | 37.7583600194211 | -122.424585951974 | (37.7583600194211, -122.424585951974) | |||
| 89601 | 89601 | 35493 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3746 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38903 | 6005339.71347882 | 2104322.52965211 | 37.7583708422124 | -122.42456893980601 | (37.7583708422124, -122.424568939806) | ||
| 85917 | 85917 | 35327 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 248 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2016 12:00:00 AM | Permit Number 775509 | 6006668.16520495 | 2104669.17235853 | 37.759397576581 | -122.41999915657499 | (37.759397576581, -122.419999156575) | ||
| 186493 | 186493 | 228463 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 246 San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006676.82806 | 2104669.9679099997 | 37.7594002490446 | -122.419969252575 | (37.7594002490446, -122.419969252575) | |||
| 139885 | 139885 | 91116 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 3838 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/2009 12:00:00 AM | 3 | 4x4 | Permit Number 52006 | 6004047.0 | 2104828.0 | 37.7596856536801 | -122.429075753932 | (37.7596856536801, -122.429075753932) |
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |||
| 24406 | 24406 | 228482 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 105 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006464.96947 | 2105462.2206200003 | 37.7615636518725 | -122.42075820894699 | (37.7615636518725, -122.420758208947) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 90135 | 90135 | 93237 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 576 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004202.7 | 2105545.3 | 37.76166400108121 | -122.428588395846 | (37.7616640010812, -122.428588395846) | ||
| 78149 | 78149 | 93301 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 589X Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2008 12:00:00 AM | 3 | 3x3 | 6004575.9 | 2105667.0 | 37.7620192734995 | -122.427306317148 | (37.7620192734995, -122.427306317148) | ||
| 88787 | 88787 | 93236 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 544 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004223.0 | 2105723.0 | 37.762153071666496 | -122.428530853207 | (37.7621530716665, -122.428530853207) | ||
| 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) | |||
| 169717 | 169717 | 228491 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 544 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004217.2996 | 2105758.4451200003 | 37.762250072909104 | -122.428553095368 | (37.7622500729091, -122.428553095368) | |||
| 84002 | 84002 | 32443 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4167 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | Permit Number 36965 | 6001261.23901245 | 2105800.41566985 | 37.762197583242795 | -122.438779978808 | (37.7621975832428, -122.438779978808) | ||
| 153340 | 153340 | 32442 | Permitted Site 1 | Hymenosporum flavum :: Sweet Shade 91 | 4167 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 11 | Permit Number 36965 | 6001246.93122 | 2105801.18273 | 37.7621988754027 | -122.43882951888901 | (37.7621988754027, -122.438829518889) | |
| 53257 | 53257 | 228494 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004270.96724 | 2105879.99485 | 37.7625868564077 | -122.42837614294201 | (37.7625868564077, -122.428376142942) | |||
| 186052 | 186052 | 228495 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004273.17296 | 2105900.1551200002 | 37.762642336504705 | -122.42836995111999 | (37.7626423365047, -122.42836995112) | |||
| 23433 | 23433 | 228490 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 512 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004210.50257 | 2105904.81342 | 37.762651580625 | -122.428587037577 | (37.762651580625, -122.428587037577) | |||
| 144149 | 144149 | 93235 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 512 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/01/2008 12:00:00 AM | 3 | 3x3 | 6004170.4 | 2105921.7 | 37.7626956775589 | -122.428726941839 | (37.7626956775589, -122.428726941839) | ||
| 50889 | 50889 | 228496 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 505 Church St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004270.1448800005 | 2105926.96043 | 37.762715766133 | -122.428382334783 | (37.762715766133, -122.428382334783) |
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");