trees
252 rows where qSpecies_id = 195 sorted by Zip Codes
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166680 | 14638 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 600X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 4x4 | 6006218.48413 | 2112159.25458 | 37.7799382114304 | -122.422086486016 | (37.7799382114304, -122.422086486016) | 7 | 9 | 11 | 28852 | 41 | |||
| 1597 | 190959 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011525.3711 | 2109592.00933 | 37.773187034992 | -122.403546820846 | (37.773187034992, -122.403546820846) | 14 | 2 | 9 | 28853 | 34 | |||
| 8950 | 74227 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 796 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | 6011650.43252 | 2109615.42877 | 37.7732583242335 | -122.403115862114 | (37.7732583242335, -122.403115862114) | 14 | 2 | 9 | 28853 | 34 | |||
| 38137 | 190955 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 577 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011602.79384 | 2109609.35058 | 37.7732389744272 | -122.403280224009 | (37.7732389744272, -122.403280224009) | 14 | 2 | 9 | 28853 | 34 | |||
| 48724 | 190957 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011496.47934 | 2109620.41486 | 37.7732634162043 | -122.403648760805 | (37.7732634162043, -122.403648760805) | 14 | 2 | 9 | 28853 | 34 | |||
| 49024 | 121763 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
| 54844 | 190960 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011539.8139 | 2109577.65401 | 37.7731484252993 | -122.403495850865 | (37.7731484252993, -122.403495850865) | 14 | 2 | 9 | 28853 | 34 | |||
| 63800 | 190956 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 577 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011592.10905 | 2109620.43241 | 37.7732688058471 | -122.403317964073 | (37.7732688058471, -122.403317964073) | 14 | 2 | 9 | 28853 | 34 | |||
| 79652 | 190958 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011508.79909 | 2109607.32506 | 37.7732281627925 | -122.403605223729 | (37.7732281627925, -122.403605223729) | 14 | 2 | 9 | 28853 | 34 | |||
| 94430 | 32623 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 39 Boardman Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 6 | Permit Number 37079 | 6011706.39653 | 2110130.09648 | 37.7746746089772 | -122.402958479854 | (37.7746746089772, -122.402958479854) | 14 | 2 | 9 | 28853 | 34 | |
| 119429 | 121764 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
| 134751 | 121762 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |||||
| 177645 | 121761 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 580 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/03/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779456 | 6011520 | 2109619 | 37.7732608451695 | -122.403567299641 | (37.7732608451695, -122.403567299641) | 14 | 2 | 9 | 28853 | 34 | |
| 33144 | 190953 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 28 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 5ft | 6013222.07397 | 2116219.26645 | 37.7914785844106 | -122.398142697526 | (37.7914785844106, -122.398142697526) | 12 | 2 | 9 | 28855 | 6 | |||
| 4066 | 57816 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 953 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | 3 | Permit Number 48159 | 6012187.5358 | 2104146.00992 | 37.7582705054092 | -122.400873595956 | (37.7582705054092, -122.400873595956) | 10 | 3 | 8 | 28856 | 29 | ||
| 38068 | 121794 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 953 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6012184.33668 | 2104198.44513 | 37.7584143024936 | -122.400888343944 | (37.7584143024936, -122.400888343944) | 10 | 3 | 8 | 28856 | 29 | ||||
| 77319 | 190951 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 50 Southern Heights Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 7ft | 6012249.68745 | 2104070.76225 | 37.7580673584483 | -122.400653360983 | (37.7580673584483, -122.400653360983) | 10 | 3 | 8 | 28856 | 29 | |||
| 104716 | 251395 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2101 26th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012226 | 2101445 | 37.7508562677445 | -122.400550836744 | (37.7508562677445, -122.400550836744) | 10 | 3 | 8 | 28856 | 29 | |||||
| 107483 | 190950 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 50 Southern Heights Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6012271.11353 | 2104059.64338 | 37.7580380234458 | -122.400578478917 | (37.7580380234458, -122.400578478917) | 10 | 3 | 8 | 28856 | 29 | |||
| 115156 | 190954 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6015962.97968 | 2113739.68127 | 37.7848224915123 | -122.388485974355 | (37.7848224915123, -122.388485974355) | 6 | 2 | 9 | 28856 | 6 | |||
| 130064 | 190952 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 50 Southern Heights Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6012228.79731 | 2104083.07063 | 37.7580999894276 | -122.400726473151 | (37.7580999894276, -122.400726473151) | 10 | 3 | 8 | 28856 | 29 | |||
| 141166 | 67529 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 662 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | 13 | Permit Number 31067 | 6013257.86111 | 2104004.0948 | 37.7579404811792 | -122.397161966172 | (37.7579404811792, -122.397161966172) | 10 | 3 | 8 | 28856 | 29 | |
| 143942 | 121793 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 953 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6012186.53897 | 2104166.90751 | 37.7583278299834 | -122.400878511655 | (37.7583278299834, -122.400878511655) | 10 | 3 | 8 | 28856 | 29 | ||||
| 26344 | 110134 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2569x Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6006173.03027 | 2119632.97781 | 37.8004566315382 | -122.422775015965 | (37.8004566315382, -122.422775015965) | 13 | 9 | 1 | 28858 | 32 | |||
| 89658 | 35238 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1240 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | 6 | Permit Number 38734 | 6006976.68497 | 2119487.90738 | 37.8001036152424 | -122.419983741574 | (37.8001036152424, -122.419983741574) | 5 | 1 | 1 | 28858 | 32 | |
| 99344 | 110133 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2569x Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6006170.47373 | 2119650.67093 | 37.800505068104 | -122.422785120739 | (37.800505068104, -122.422785120739) | 13 | 9 | 1 | 28858 | 32 | |||
| 160820 | 256315 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006234 | 2121009 | 37.8042382772915 | -122.422661874451 | (37.8042382772915, -122.422661874451) | 5 | 9 | 1 | 28858 | 32 | ||||
| 168660 | 35259 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 15 North View Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38745 | 6006261.16028369 | 2120974.78404058 | 37.8041458613164 | -122.422565451189 | (37.8041458613164, -122.422565451189) | 5 | 9 | 1 | 28858 | 32 | ||
| 170278 | 126410 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1920 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004771.88158 | 2116049.56275 | 37.790538331527 | -122.427368142329 | (37.790538331527, -122.427368142329) | 13 | 9 | 1 | 28858 | 27 | |||
| 193935 | 126409 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1920 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6004775.53242 | 2116016.61179 | 37.7904480629696 | -122.42735316234 | (37.7904480629696, -122.42735316234) | 13 | 9 | 1 | 28858 | 27 | |||
| 4288 | 229242 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 490 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007221.53898 | 2104492.64849 | 37.7589440445439 | -122.418072800033 | (37.7589440445439, -122.418072800033) | 2 | 4 | 7 | 28859 | 19 | |||
| 10791 | 34213 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 137 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38029 | 6010403.59737914 | 2099053.11250995 | 37.7441868646564 | -122.406684360495 | (37.7441868646564, -122.406684360495) | 2 | 7 | 7 | 28859 | 2 | ||
| 12410 | 261246 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 17 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007045 | 2095545 | 37.7343658809731 | -122.418049036994 | (37.7343658809731, -122.418049036994) | 2 | 7 | 7 | 28859 | 2 | ||||
| 12752 | 152623 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 3027 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 5x5 | 6009408.70461 | 2100990.44079 | 37.7494506265482 | -122.410261253678 | (37.7494506265482, -122.410261253678) | 2 | 4 | 7 | 28859 | 19 | |||
| 30154 | 41098 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.7416006455553 | -122.41705911631 | (37.7416006455553, -122.41705911631) | 2 | 7 | 7 | 28859 | 2 | |||
| 31208 | 41097 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.7416006455553 | -122.41705911631 | (37.7416006455553, -122.41705911631) | 2 | 7 | 7 | 28859 | 2 | ||
| 46565 | 223273 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 336 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008607.35266 | 2097091.32906 | 37.7386995750301 | -122.412756741042 | (37.7386995750301, -122.412756741042) | 10 | 7 | 7 | 28859 | 2 | |||
| 51050 | 34215 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 123 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38031 | 6010471.85076762 | 2099030.12086895 | 37.7441275531286 | -122.40644673425 | (37.7441275531286, -122.40644673425) | 2 | 7 | 7 | 28859 | 2 | ||
| 56851 | 32527 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 6 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37029 | 6007006.64286664 | 2095736.82242552 | 37.7348904242515 | -122.418195245649 | (37.7348904242515, -122.418195245649) | 2 | 7 | 7 | 28859 | 2 | ||
| 57218 | 248032 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 123 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6010451.01277 | 2099046.16811 | 37.7441704496095 | -122.40651991836 | (37.7441704496095, -122.40651991836) | 2 | 7 | 7 | 28859 | 2 | |||
| 65423 | 223270 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 3525 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6005390.76115 | 2106030.87632 | 37.7630644422991 | -122.424513909989 | (37.7630644422991, -122.424513909989) | 8 | 4 | 5 | 28859 | 19 | |||
| 68791 | 41099 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/1999 12:00:00 AM | Permit Number 41846 | 6007385.16398243 | 2098172.89678414 | 37.7416006455553 | -122.41705911631 | (37.7416006455553, -122.41705911631) | 2 | 7 | 7 | 28859 | 2 | |||
| 70744 | 248036 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 146 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6010366.79338 | 2099106.98901 | 37.7443327385694 | -122.406815417622 | (37.7443327385694, -122.406815417622) | 2 | 7 | 7 | 28859 | 2 | |||
| 71621 | 223672 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 3458 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007183.77853 | 2104422.94003 | 37.7587505158433 | -122.4181984515 | (37.7587505158433, -122.4181984515) | 2 | 4 | 7 | 28859 | 19 | |||
| 78243 | 223282 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 10 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005802.51447 | 2097630.08724 | 37.7400210550278 | -122.422492829383 | (37.7400210550278, -122.422492829383) | 2 | 7 | 7 | 28859 | 2 | |||
| 85318 | 34306 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38094 | 6010824.33318422 | 2102458.44647529 | 37.7535606982702 | -122.405469321452 | (37.7535606982702, -122.405469321452) | 10 | 4 | 8 | 28859 | 19 | ||
| 90186 | 34210 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38026 | 6010548.9850675 | 2099059.00866257 | 37.7442111875512 | -122.406182054391 | (37.7442111875512, -122.406182054391) | 2 | 7 | 7 | 28859 | 2 | ||
| 90758 | 63833 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 91 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/1987 12:00:00 AM | Permit Number 24521 | 6009354.9233329 | 2096920.48394154 | 37.7382724026701 | -122.410159926388 | (37.7382724026701, -122.410159926388) | 10 | 7 | 7 | 28859 | 2 | ||
| 94405 | 223670 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007488.19675 | 2098176.28509 | 37.7416157445795 | -122.416703102889 | (37.7416157445795, -122.416703102889) | 2 | 7 | 7 | 28859 | 2 | |||
| 98482 | 32057 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 3525 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2003 12:00:00 AM | 4 | Permit Number 46894 | 6005365.81768 | 2106030.42117 | 37.7630617839077 | -122.424600148687 | (37.7630617839077, -122.424600148687) | 8 | 4 | 5 | 28859 | 19 | ||
| 105289 | 248035 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 132 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6010441.24954 | 2099079.47689 | 37.7442613620763 | -122.406556024359 | (37.7442613620763, -122.406556024359) | 2 | 7 | 7 | 28859 | 2 | |||
| 106454 | 223274 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 91 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009343.02898 | 2096929.97476 | 37.738297795694 | -122.410201721249 | (37.738297795694, -122.410201721249) | 10 | 7 | 7 | 28859 | 2 | |||
| 112444 | 51444 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 336 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2004 12:00:00 AM | Permit Number 47763 | 6008602.30832967 | 2097174.95707039 | 37.7389289161491 | -122.412780092695 | (37.7389289161491, -122.412780092695) | 10 | 7 | 7 | 28859 | 2 | ||
| 116129 | 34214 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 135 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38030 | 6010413.34787543 | 2099049.82798569 | 37.7441783915997 | -122.406650413823 | (37.7441783915997, -122.406650413823) | 2 | 7 | 7 | 28859 | 2 | ||
| 117841 | 34211 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 132 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38027 | 6010446.19872622 | 2099093.63297516 | 37.7443005084973 | -122.406539908391 | (37.7443005084973, -122.406539908391) | 2 | 7 | 7 | 28859 | 2 | ||
| 126247 | 223281 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 16 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005792.08982 | 2097609.55014 | 37.7399640766707 | -122.422527414631 | (37.7399640766707, -122.422527414631) | 2 | 7 | 7 | 28859 | 2 | |||
| 127293 | 248031 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 135 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6010398.33522 | 2099063.65948 | 37.7442155299264 | -122.406703299111 | (37.7442155299264, -122.406703299111) | 2 | 7 | 7 | 28859 | 2 | |||
| 132829 | 52142 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 16 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/2005 12:00:00 AM | Permit Number 48323 | 6005795.19032335 | 2097640.79736733 | 37.7400500494445 | -122.422518914141 | (37.7400500494445, -122.422518914141) | 2 | 7 | 7 | 28859 | 2 | ||
| 136207 | 223271 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1301 York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010084.63709 | 2101573.03413 | 37.7510881652043 | -122.407964929261 | (37.7510881652043, -122.407964929261) | 2 | 4 | 7 | 28859 | 19 | |||
| 144690 | 223668 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 10 Gladys St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005828.64048 | 2097671.05304 | 37.740135011734 | -122.422405406283 | (37.740135011734, -122.422405406283) | 2 | 7 | 7 | 28859 | 2 | |||
| 155057 | 248033 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 110 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6010558.59528 | 2099039.59827 | 37.7441584283672 | -122.406147456957 | (37.7441584283672, -122.406147456957) | 2 | 7 | 7 | 28859 | 2 | |||
| 155490 | 32528 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 17 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | Permit Number 37030 | 6007054.5480271 | 2095691.64868794 | 37.7347690834472 | -122.418026418979 | (37.7347690834472, -122.418026418979) | 2 | 7 | 7 | 28859 | 2 | ||
| 155813 | 34212 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 146 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38028 | 6010380.78922037 | 2099115.666634 | 37.7443573485467 | -122.406767634166 | (37.7443573485467, -122.406767634166) | 2 | 7 | 7 | 28859 | 2 | ||
| 158500 | 223667 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 10 Gladys St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005813.9989 | 2097648.11236 | 37.7400711958267 | -122.422454401347 | (37.7400711958267, -122.422454401347) | 2 | 7 | 7 | 28859 | 2 | |||
| 162640 | 248034 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6010483.27046 | 2099064.93889 | 37.7442237946989 | -122.406409700143 | (37.7442237946989, -122.406409700143) | 2 | 7 | 7 | 28859 | 2 | |||
| 163873 | 223671 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007506.0274 | 2098173.94158 | 37.7416103126682 | -122.41664128438 | (37.7416103126682, -122.41664128438) | 2 | 7 | 7 | 28859 | 2 | |||
| 166095 | 223269 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 1260 Utah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010823.03156 | 2102440.75531 | 37.7535120494589 | -122.405472576922 | (37.7535120494589, -122.405472576922) | 10 | 4 | 8 | 28859 | 19 | |||
| 178037 | 100278 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 3460X 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007182 | 2104415 | 37.7587286142457 | -122.418204039558 | (37.7587286142457, -122.418204039558) | 2 | 4 | 7 | 28859 | 19 | |||
| 185012 | 258221 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 6 Porter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006999 | 2095654 | 37.73466258188 | -122.418215799693 | (37.73466258188, -122.418215799693) | 2 | 7 | 7 | 28859 | 2 | ||||
| 185240 | 223275 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 57 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6007321.82644 | 2099172.60178 | 37.7443420492586 | -122.417348945606 | (37.7443420492586, -122.417348945606) | 2 | 7 | 7 | 28859 | 2 | |||
| 186749 | 100279 | Undocumented 4 | Cupaniopsis anacardioides :: Carrotwood 195 | 3460X 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007182 | 2104415 | 37.7587286142457 | -122.418204039558 | (37.7587286142457, -122.418204039558) | 2 | 4 | 7 | 28859 | 19 | |||
| 187114 | 223669 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007464.47007 | 2098181.71647 | 37.741629323436 | -122.416785526654 | (37.741629323436, -122.416785526654) | 2 | 7 | 7 | 28859 | 2 | |||
| 191494 | 240691 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 2762 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780708 | 6010175.82861 | 2102832.96538 | 37.7545527620063 | -122.407738408027 | (37.7545527620063, -122.407738408027) | 2 | 4 | 7 | 28859 | 19 | |
| 192687 | 33995 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 120 Faith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/1997 12:00:00 AM | Permit Number 38457 | 6010502.26399862 | 2099074.74698805 | 37.7442517881202 | -122.40634471521 | (37.7442517881202, -122.40634471521) | 2 | 7 | 7 | 28859 | 2 | ||
| 24863 | 32759 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 100x THRIFT ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486 | 2089629 | 37.7174646081384 | -122.457584103658 | (37.7174646081384, -122.457584103658) | 9 | 8 | 6 | 28861 | 24 | ||
| 35958 | 206795 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 106 Thrift St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5995838.02992 | 2089647.40678 | 37.717535364348 | -122.456368636129 | (37.717535364348, -122.456368636129) | 9 | 8 | 6 | 28861 | 24 | |||
| 49359 | 34810 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 101 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | Permit Number 38445 | 5999074.40253363 | 2089202.20922089 | 37.7164982153246 | -122.445150028238 | (37.7164982153246, -122.445150028238) | 9 | 7 | 6 | 28861 | 25 | ||
| 57302 | 176081 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 127 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5999102.55094 | 2089159.5285 | 37.7163826304266 | -122.445049667216 | (37.7163826304266, -122.445049667216) | 9 | 7 | 6 | 28861 | 25 | |||
| 111346 | 32757 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 100x THRIFT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486 | 2089629 | 37.7174646081384 | -122.457584103658 | (37.7174646081384, -122.457584103658) | 9 | 8 | 6 | 28861 | 24 | ||
| 113293 | 206796 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 106 Thrift St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995821.50453 | 2089648.19184 | 37.7175365712383 | -122.456425813227 | (37.7175365712383, -122.456425813227) | 9 | 8 | 6 | 28861 | 24 | |||
| 119639 | 206793 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 106 Thrift St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5995874.19015 | 2089646.87055 | 37.7175359677985 | -122.456243608772 | (37.7175359677985, -122.456243608772) | 9 | 8 | 6 | 28861 | 24 | |||
| 126447 | 67504 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 477 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/16/1992 12:00:00 AM | Permit Number 31033 | 5997603.60235184 | 2094078.4650037 | 37.729803210873 | -122.450585167202 | (37.729803210873, -122.450585167202) | 9 | 7 | 4 | 28861 | 40 | ||
| 132035 | 32760 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 100x THRIFT ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 8 | 3x3 | Permit Number 37135 | 5995486 | 2089629 | 37.7174646081384 | -122.457584103658 | (37.7174646081384, -122.457584103658) | 9 | 8 | 6 | 28861 | 24 |
| 154150 | 206794 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 106 Thrift St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5995856.77369 | 2089647.23467 | 37.7175359677947 | -122.456303835451 | (37.7175359677947, -122.456303835451) | 9 | 8 | 6 | 28861 | 24 | |||
| 193080 | 32758 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 100x THRIFT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | Permit Number 37135 | 5995486 | 2089629 | 37.7174646081384 | -122.457584103658 | (37.7174646081384, -122.457584103658) | 9 | 8 | 6 | 28861 | 24 | ||
| 31487 | 39517 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 3964 25TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 8 | Permit Number 40967 | 6004074 | 2101323 | 37.7500632777197 | -122.428732510654 | (37.7500632777197, -122.428732510654) | 2 | 4 | 5 | 28862 | 22 | |
| 41463 | 223677 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002838.68018 | 2100959.36112 | 37.7489948186629 | -122.432978334495 | (37.7489948186629, -122.432978334495) | 2 | 4 | 5 | 28862 | 22 | |||
| 47841 | 39518 | Permitted Site 7 | Cupaniopsis anacardioides :: Carrotwood 195 | 3964 25TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 10 | Permit Number 40967 | 6004074 | 2101323 | 37.7500632777197 | -122.428732510654 | (37.7500632777197, -122.428732510654) | 2 | 4 | 5 | 28862 | 22 | |
| 87562 | 223683 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 3952 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004110.66083 | 2101326.75882 | 37.7500756733741 | -122.42860600337 | (37.7500756733741, -122.42860600337) | 2 | 4 | 5 | 28862 | 22 | |||
| 92307 | 223674 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003026.25386 | 2100972.90795 | 37.7490426526966 | -122.432330671519 | (37.7490426526966, -122.432330671519) | 2 | 4 | 5 | 28862 | 22 | |||
| 112365 | 223676 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002874.24252 | 2100962.2133 | 37.749004667153 | -122.432855563559 | (37.749004667153, -122.432855563559) | 2 | 4 | 5 | 28862 | 22 | |||
| 135713 | 223680 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002752.1891 | 2100957.04892 | 37.748983563648 | -122.433277255656 | (37.748983563648, -122.433277255656) | 2 | 4 | 5 | 28862 | 22 | |||
| 139981 | 223675 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002987.60532 | 2100970.11932 | 37.7490328042407 | -122.43246411922 | (37.7490328042407, -122.43246411922) | 2 | 4 | 5 | 28862 | 22 | |||
| 140978 | 223682 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 3952 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004131.52495 | 2101329.89232 | 37.7500854579739 | -122.428534077398 | (37.7500854579739, -122.428534077398) | 2 | 4 | 5 | 28862 | 22 | |||
| 141790 | 223679 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002778.97625 | 2100958.54485 | 37.7489891907177 | -122.433184732513 | (37.7489891907177, -122.433184732513) | 2 | 4 | 5 | 28862 | 22 | |||
| 155793 | 223673 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003155.02499 | 2100979.47197 | 37.7490679767212 | -122.431885848858 | (37.7490679767212, -122.431885848858) | 2 | 4 | 5 | 28862 | 22 | |||
| 166036 | 223681 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002667.71298 | 2100952.64567 | 37.7489666806705 | -122.433569059575 | (37.7489666806705, -122.433569059575) | 2 | 4 | 5 | 28862 | 22 | |||
| 169699 | 223272 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 90 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6004552.00541 | 2101644.43892 | 37.7509729161719 | -122.427102433147 | (37.7509729161719, -122.427102433147) | 2 | 4 | 5 | 28862 | 22 | |||
| 193310 | 223678 | DPW Maintained 1 | Cupaniopsis anacardioides :: Carrotwood 195 | 300 Clipper St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6002810.88553 | 2100958.91047 | 37.7489920046987 | -122.43307441627 | (37.7489920046987, -122.43307441627) | 2 | 4 | 5 | 28862 | 22 | |||
| 193423 | 108885 | Private 9 | Cupaniopsis anacardioides :: Carrotwood 195 | 707 NOE ST | 5 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6003152.4 | 2104071.5 | 37.7575578048507 | -122.432115704961 | (37.7575578048507, -122.432115704961) | 2 | 4 | 5 | 28862 | 3 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );