trees
144 rows where qSpecies_id = 120 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17849 | 19929 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 100 STAIRWAY37 | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x5 | |||||||||||||
| 17897 | 254369 | Planning Code 138.1 required 2 | Citrus spp :: Lemon: Orange: Lime 120 | 590X Orizaba Ave | 2 | Back Yard : Yard | Tree | Private 2 | 02/06/2018 12:00:00 AM | 3 | Permit Number 778929 | ||||||||||||
| 18229 | 19930 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 100 STAIRWAY37 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x5 | |||||||||||||
| 138338 | 31828 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 219 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 3 | Permit Number 35287 | 6009577.38465 | 2109112.56676 | 37.7717615951562 | -122.41025133326 | (37.7717615951562, -122.41025133326) | 8 | 2 | 9 | 28853 | 34 | |
| 163533 | 225252 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 1331 Stevenson St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6006271.29436 | 2108923.54997 | 37.7710567254041 | -122.421673906749 | (37.7710567254041, -122.421673906749) | 8 | 2 | 9 | 28853 | 19 | |||
| 575 | 190079 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 800 19th St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6015106.31857 | 2105340.09052 | 37.761711568763 | -122.390862535375 | (37.761711568763, -122.390862535375) | 10 | 3 | 8 | 28856 | 29 | |||
| 26307 | 190068 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 800 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015109.8223 | 2105343.63825 | 37.7617215044683 | -122.390850665232 | (37.7617215044683, -122.390850665232) | 10 | 3 | 8 | 28856 | 29 | |||
| 48400 | 190083 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 1301 Rhode Island St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6012013.66835 | 2102301.71899 | 37.753196787611 | -122.40134530296 | (37.753196787611, -122.40134530296) | 10 | 3 | 8 | 28856 | 29 | |||
| 57636 | 190080 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 582 Rhode Island St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6011756.74978 | 2105674.08319 | 37.7624422166492 | -122.402470898934 | (37.7624422166492, -122.402470898934) | 8 | 3 | 8 | 28856 | 29 | ||||
| 97267 | 190069 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 128 Texas St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 5ft | 6013688.61467 | 2106365.60612 | 37.7644486455077 | -122.395837700057 | (37.7644486455077, -122.395837700057) | 14 | 3 | 8 | 28856 | 29 | |||
| 112440 | 190071 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 760 De Haro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 3ft | 6012081.41801 | 2104921.52686 | 37.7603939837179 | -122.401295097398 | (37.7603939837179, -122.401295097398) | 10 | 3 | 8 | 28856 | 29 | |||
| 123887 | 190070 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 700 Carolina St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6012378.79541 | 2104578.47096 | 37.7594686146117 | -122.400242505711 | (37.7594686146117, -122.400242505711) | 10 | 3 | 8 | 28856 | 29 | |||
| 125634 | 190067 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 1150x Tennessee St | 12 | Median : Yard | Tree | DPW 1 | 1 | Width 8ft | 6015567.2875 | 2103497.11447 | 37.7566767169834 | -122.389139526978 | (37.7566767169834, -122.389139526978) | 10 | 3 | 8 | 28856 | 29 | |||
| 191866 | 58937 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 1348 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/28/1980 12:00:00 AM | 7 | Permit Number 18215 | 6011961.76354 | 2102089.22377 | 37.7526104260448 | -122.401509868082 | (37.7526104260448, -122.401509868082) | 10 | 3 | 8 | 28856 | 29 | ||
| 50637 | 126048 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 1206 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6006555.84912 | 2120122.9781 | 37.8018236396965 | -122.421485125542 | (37.8018236396965, -122.421485125542) | 5 | 9 | 1 | 28858 | 32 | |||
| 6808 | 225221 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 1451 Florida St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009585.79933 | 2100771.19731 | 37.7488585578771 | -122.409633380284 | (37.7488585578771, -122.409633380284) | 2 | 4 | 7 | 28859 | 19 | |||
| 35500 | 225230 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 78 Norwich St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6008943.95734 | 2099481.30361 | 37.7452808083559 | -122.411761746402 | (37.7452808083559, -122.411761746402) | 2 | 7 | 7 | 28859 | 2 | ||||
| 38545 | 225242 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 185 Banks St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008658.18183 | 2097712.26928 | 37.7404073938969 | -122.412624880635 | (37.7404073938969, -122.412624880635) | 10 | 7 | 7 | 28859 | 2 | |||
| 44847 | 225227 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2700 22nd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6009911.03097 | 2103403.5616 | 37.756104664524 | -122.408694403538 | (37.756104664524, -122.408694403538) | 2 | 4 | 7 | 28859 | 19 | |||
| 48051 | 246615 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 199 Ripley St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6009291.89152 | 2099148.30675 | 37.7443859847297 | -122.410535133206 | (37.7443859847297, -122.410535133206) | 2 | 7 | 7 | 28859 | 2 | |||
| 62318 | 24589 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 627 Cortland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/1996 12:00:00 AM | 6 | 3X3 | 6007837.64514 | 2097223.79022 | 37.7390200520275 | -122.415427408268 | (37.7390200520275, -122.415427408268) | 2 | 7 | 7 | 28859 | 2 | ||
| 63570 | 225253 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2620 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010308.48538 | 2103425.73891 | 37.7561878113393 | -122.407321429266 | (37.7561878113393, -122.407321429266) | 10 | 4 | 7 | 28859 | 19 | |||
| 83663 | 234867 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 80 Crescent Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 5ft | 6005731.08333 | 2095841.16207 | 37.7351050369683 | -122.422612718897 | (37.7351050369683, -122.422612718897) | 2 | 7 | 7 | 28859 | 2 | |||
| 91120 | 225234 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 923 Alabama St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 1 | Width 3ft | 6009156.14091 | 2103778.6804 | 37.7570923467526 | -122.411331576386 | (37.7570923467526, -122.411331576386) | 2 | 4 | 7 | 28859 | 19 | |||
| 96548 | 225258 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 127 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008308.74724 | 2097822.25905 | 37.7406897837182 | -122.41384087018 | (37.7406897837182, -122.41384087018) | 2 | 7 | 7 | 28859 | 2 | |||
| 106303 | 225260 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 519 Anderson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007845.42972 | 2096352.85409 | 37.7366290901675 | -122.415338853806 | (37.7366290901675, -122.415338853806) | 2 | 7 | 7 | 28859 | 2 | |||
| 110809 | 225246 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 121 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005601.9435 | 2096425.27708 | 37.7367015997901 | -122.423100707241 | (37.7367015997901, -122.423100707241) | 2 | 7 | 7 | 28859 | 2 | |||
| 112700 | 225257 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 519 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007846.92658 | 2096365.88824 | 37.7366649632181 | -122.415334600937 | (37.7366649632181, -122.415334600937) | 2 | 7 | 7 | 28859 | 2 | |||
| 114224 | 225231 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 78 Norwich St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6008954.26866 | 2099481.98448 | 37.7452832563214 | -122.411726139547 | (37.7452832563214, -122.411726139547) | 2 | 7 | 7 | 28859 | 2 | ||||
| 119409 | 225243 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 107 Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007392.00183 | 2097678.37759 | 37.7402431902648 | -122.417000443041 | (37.7402431902648, -122.417000443041) | 2 | 7 | 7 | 28859 | 2 | |||
| 121736 | 248083 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 31 Montcalm St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6010653.71359 | 2100266.61885 | 37.747532879848 | -122.405904975443 | (37.747532879848, -122.405904975443) | 2 | 7 | 7 | 28859 | 2 | ||||
| 133635 | 225228 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 3738 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6005391.93811 | 2104322.40887 | 37.7583734597889 | -122.424388315175 | (37.7583734597889, -122.424388315175) | 2 | 4 | 5 | 28859 | 19 | |||
| 139017 | 225233 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 77 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009174.38134 | 2097041.33218 | 37.7385941043387 | -122.410792686457 | (37.7385941043387, -122.410792686457) | 10 | 7 | 7 | 28859 | 2 | |||
| 156059 | 225229 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 78 Norwich St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6008929.6185 | 2099480.70471 | 37.7452783595073 | -122.411811285588 | (37.7452783595073, -122.411811285588) | 2 | 7 | 7 | 28859 | 2 | ||||
| 182951 | 28790 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2741 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008967.4905 | 2102492.051 | 37.7535489702196 | -122.411893087006 | (37.7535489702196, -122.411893087006) | 2 | 4 | 7 | 28859 | 19 | |||
| 182959 | 225226 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 400 Prospect Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6006231.66625 | 2097599.69124 | 37.7399617950961 | -122.421006839088 | (37.7399617950961, -122.421006839088) | 2 | 7 | 7 | 28859 | 2 | ||||
| 183796 | 225235 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 915 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6009422.29998 | 2103692.31974 | 37.7568701440604 | -122.410404995017 | (37.7568701440604, -122.410404995017) | 2 | 4 | 7 | 28859 | 19 | |||
| 185105 | 225244 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 3246 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6007871.93073 | 2105631.804 | 37.7621084881381 | -122.415904101093 | (37.7621084881381, -122.415904101093) | 8 | 4 | 7 | 28859 | 19 | |||
| 186825 | 225225 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 400 Prospect Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6006245.45264 | 2097624.33483 | 37.7400302380064 | -122.420960920629 | (37.7400302380064, -122.420960920629) | 2 | 7 | 7 | 28859 | 2 | ||||
| 26998 | 175853 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 190 Foote Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998657.74222 | 2088350.87676 | 37.7141368596094 | -122.446528992614 | (37.7141368596094, -122.446528992614) | 9 | 7 | 6 | 28861 | 25 | |||
| 46606 | 175868 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 775 Italy Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6000760.37333 | 2089426.49895 | 37.7172101532979 | -122.43933856122 | (37.7172101532979, -122.43933856122) | 9 | 7 | 6 | 28861 | 5 | ||||
| 82838 | 175862 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 252 Otsego Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 7ft | 6000342.31141 | 2091776.18145 | 37.7236380477278 | -122.440952068202 | (37.7236380477278, -122.440952068202) | 9 | 7 | 6 | 28861 | 25 | |||
| 84555 | 206056 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 334 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5997879.17976 | 2093831.33114 | 37.7291404093781 | -122.449614668195 | (37.7291404093781, -122.449614668195) | 9 | 7 | 4 | 28861 | 40 | ||||
| 88118 | 175857 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 200 Concord St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5999895.81831 | 2087081.09884 | 37.7107209745665 | -122.442158644517 | (37.7107209745665, -122.442158644517) | 9 | 7 | 6 | 28861 | 5 | |||
| 88579 | 175866 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 771 London St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6000758.69857 | 2089409.69112 | 37.7171639074676 | -122.439343145965 | (37.7171639074676, -122.439343145965) | 9 | 7 | 6 | 28861 | 5 | ||||
| 89114 | 206060 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 131 Louisburg St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5997844.78053 | 2090972.81557 | 37.7212896282861 | -122.449527699244 | (37.7212896282861, -122.449527699244) | 9 | 8 | 6 | 28861 | 24 | |||
| 107302 | 175860 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 251 De Long St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 5993744.6321 | 2086800.75375 | 37.7095987330548 | -122.463398037591 | (37.7095987330548, -122.463398037591) | 9 | 8 | 6 | 28861 | 25 | |||
| 116849 | 175867 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 775 Italy Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6000771.54844 | 2089421.64361 | 37.7171974575738 | -122.439299586413 | (37.7171974575738, -122.439299586413) | 9 | 7 | 6 | 28861 | 5 | ||||
| 127317 | 69404 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 1222 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 3 | Permit Number 33508 | 6001053.31789 | 2087351.84237 | 37.711530275369 | -122.438177455546 | (37.711530275369, -122.438177455546) | 9 | 7 | 6 | 28861 | 5 | |
| 133238 | 175854 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 13 Liebig St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5995905.68343 | 2086266.21958 | 37.7082552961019 | -122.455890498056 | (37.7082552961019, -122.455890498056) | 9 | 7 | 6 | 28861 | 25 | |||
| 133257 | 206057 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 44 Edna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998773.00694 | 2093133.20748 | 37.7272746201039 | -122.446474441566 | (37.7272746201039, -122.446474441566) | 9 | 7 | 4 | 28861 | 40 | |||
| 135388 | 175865 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 771 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6000753.76708 | 2089411.77455 | 37.7171693474543 | -122.439360341001 | (37.7171693474543, -122.439360341001) | 9 | 7 | 6 | 28861 | 5 | ||||
| 136718 | 175856 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 166 Newton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6001031.73098 | 2087649.99539 | 37.712347709655 | -122.438273411393 | (37.712347709655, -122.438273411393) | 9 | 7 | 6 | 28861 | 5 | |||
| 138134 | 175855 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 667 London St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6001081.32138 | 2089927.90496 | 37.7186051609818 | -122.438265098081 | (37.7186051609818, -122.438265098081) | 9 | 7 | 6 | 28861 | 5 | ||||
| 146839 | 50845 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 500 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2004 12:00:00 AM | 2 | Permit Number 47372 | 6003311.92044 | 2090509.19364 | 37.7203278681182 | -122.430596285807 | (37.7203278681182, -122.430596285807) | 9 | 7 | 6 | 28861 | 5 | ||
| 152543 | 206058 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 95 Marston Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5998836.80822 | 2093173.97163 | 37.727390192897 | -122.446256812799 | (37.727390192897, -122.446256812799) | 9 | 7 | 4 | 28861 | 40 | ||||
| 163338 | 225245 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 10 Marsily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004214.66521 | 2095536.99141 | 37.7341841842374 | -122.427833856256 | (37.7341841842374, -122.427833856256) | 2 | 7 | 5 | 28861 | 25 | |||
| 171975 | 206059 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 236 Thrift St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5994663.87302 | 2089661.14259 | 37.7175056039773 | -122.460428125473 | (37.7175056039773, -122.460428125473) | 9 | 8 | 6 | 28861 | 24 | |||
| 181484 | 175861 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 791 Cayuga Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6001276.34794 | 2092342.96014 | 37.7252474475028 | -122.437763846535 | (37.7252474475028, -122.437763846535) | 9 | 7 | 6 | 28861 | 25 | |||
| 193823 | 175863 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 247 Mount Vernon Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998698.59679 | 2089580.08907 | 37.7175143291959 | -122.446476163739 | (37.7175143291959, -122.446476163739) | 9 | 7 | 6 | 28861 | 25 | ||||
| 8016 | 225239 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 3900 22nd St | 6 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6002410.77248 | 2102995.61481 | 37.7545616068455 | -122.434603620768 | (37.7545616068455, -122.434603620768) | 2 | 4 | 5 | 28862 | 22 | |||
| 64891 | 225238 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 3911 21st St | 2 | Side Yard : Yard | Tree | Private 2 | 6 | 6002335.3278 | 2103527.77418 | 37.7560185058709 | -122.434902583282 | (37.7560185058709, -122.434902583282) | 2 | 4 | 5 | 28862 | 22 | ||||
| 96723 | 225250 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 200 Corbin Pl | 5 | Side Yard : Yard | Tree | Private 2 | 3 | Width 3ft | 6000060.09993 | 2105713.56645 | 37.761890709215 | -122.442928012745 | (37.761890709215, -122.442928012745) | 15 | 5 | 5 | 28862 | 3 | |||
| 113655 | 225256 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 4490 24th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6000086.96186 | 2101693.35826 | 37.7508537326323 | -122.442546455561 | (37.7508537326323, -122.442546455561) | 2 | 4 | 5 | 28862 | 22 | |||
| 119431 | 225259 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 500 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6003000.58316 | 2103896.97694 | 37.7570699976911 | -122.432628282396 | (37.7570699976911, -122.432628282396) | 2 | 4 | 5 | 28862 | 3 | |||
| 133207 | 225249 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 69 Levant St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000369.03811 | 2106325.1376 | 37.7635875410605 | -122.441903416934 | (37.7635875410605, -122.441903416934) | 15 | 5 | 5 | 28862 | 3 | |||
| 153373 | 225240 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 3900 22nd St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6002407.65588 | 2102995.11688 | 37.7545600627224 | -122.43461436318 | (37.7545600627224, -122.43461436318) | 2 | 4 | 5 | 28862 | 22 | |||
| 162525 | 225248 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 310 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6003531.80374 | 2106438.35336 | 37.764078120337 | -122.430972492892 | (37.764078120337, -122.430972492892) | 15 | 4 | 5 | 28862 | 3 | |||
| 192956 | 225247 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 4316 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001799.39624 | 2101199.83847 | 37.7495961080861 | -122.436589388616 | (37.7495961080861, -122.436589388616) | 2 | 4 | 5 | 28862 | 22 | |||
| 3523 | 261664 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2251 Jackson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003429.10066 | 2116873.98532 | 37.7927259513035 | -122.432072977999 | (37.7927259513035, -122.432072977999) | 13 | 9 | 1 | 29490 | 27 | ||||
| 22506 | 126047 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2323 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6003572.6784 | 2115908.92509 | 37.7900842809225 | -122.431507266666 | (37.7900842809225, -122.431507266666) | 13 | 9 | 1 | 29490 | 27 | |||
| 150462 | 139566 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2003 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6001238.1316 | 2112803.1201 | 37.7814239450757 | -122.439361873414 | (37.7814239450757, -122.439361873414) | 15 | 5 | 11 | 29490 | 41 | |||
| 182605 | 5270 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2035X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6001239.67806 | 2112801.79902 | 37.7814204057326 | -122.439356428701 | (37.7814204057326, -122.439356428701) | 15 | 5 | 11 | 29490 | 41 | |||
| 62324 | 247214 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 800 Duboce Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6001844.10288 | 2108295.66302 | 37.769082062429 | -122.436942721436 | (37.769082062429, -122.436942721436) | 15 | 5 | 5 | 29492 | 9 | |||
| 42326 | 175870 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 24 Tomaso Ct | 2 | : | Tree | Private 2 | 4 | Width 2ft | 6009222.04341 | 2086480.39707 | 37.7095986701246 | -122.409882595915 | (37.7095986701246, -122.409882595915) | 9 | 7 | 8 | 309 | 39 | |||
| 75303 | 175864 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 718 Peru Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6005308.28574 | 2092430.82907 | 37.7257171553171 | -122.423832066491 | (37.7257171553171, -122.423832066491) | 9 | 7 | 6 | 309 | 5 | |||
| 83978 | 43276 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 693 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 6 | Permit Number 44929 | 6008720.42562 | 2090858.40059 | 37.7215916341374 | -122.411925450907 | (37.7215916341374, -122.411925450907) | 9 | 3 | 7 | 309 | 28 | |
| 129042 | 175869 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 24 Tomaso Ct | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6009229.76902 | 2086501.99732 | 37.7096584129814 | -122.409857418496 | (37.7096584129814, -122.409857418496) | 9 | 7 | 8 | 309 | 39 | |||
| 130158 | 175858 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 830 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6011166.96244 | 2090902.7335 | 37.7218503196318 | -122.403471501708 | (37.7218503196318, -122.403471501708) | 10 | 3 | 7 | 309 | 28 | |||
| 166524 | 175859 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 24 Tomaso Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009231.22784 | 2086501.97671 | 37.7096584381474 | -122.409852375082 | (37.7096584381474, -122.409852375082) | 9 | 7 | 8 | 309 | 39 | |||
| 185097 | 51057 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 985 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2004 12:00:00 AM | 3 | Permit Number 47526 | 6011681.98147 | 2090386.14525 | 37.7204606269314 | -122.401654911669 | (37.7204606269314, -122.401654911669) | 10 | 7 | 8 | 309 | 28 | ||
| 75922 | 124266 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 1 03rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 5994874.78871 | 2115033.38727 | 37.7871834762672 | -122.461537538969 | (37.7871834762672, -122.461537538969) | 11 | 6 | 1 | 54 | 11 | ||||
| 123291 | 124268 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 5 03rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 5994869.20256 | 2114987.30692 | 37.7870566305859 | -122.461553523605 | (37.7870566305859, -122.461553523605) | 11 | 6 | 1 | 54 | 11 | ||||
| 2875 | 78160 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 759 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5985680.33145 | 2110726.12873 | 37.7748234709799 | -122.493030509145 | (37.7748234709799, -122.493030509145) | 11 | 6 | 2 | 55 | 26 | |||
| 18768 | 70590 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 4532 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5984535.20919 | 2111789.62528 | 37.7776764899148 | -122.497070180867 | (37.7776764899148, -122.497070180867) | 11 | 6 | 2 | 55 | 26 | |||
| 7230 | 126043 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2220 Beach St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5999570.11986 | 2120888.49857 | 37.8035291958836 | -122.4457139973 | (37.8035291958836, -122.4457139973) | 13 | 9 | 1 | 57 | 17 | |||
| 26489 | 126039 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 99 Moulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002938.43109 | 2119403.29701 | 37.7996429564285 | -122.433951590696 | (37.7996429564285, -122.433951590696) | 13 | 9 | 1 | 57 | 17 | |||
| 61931 | 126042 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2800 Lyon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 2ft | 5999171.85712 | 2118415.39341 | 37.7967159671222 | -122.44691412909 | (37.7967159671222, -122.44691412909) | 13 | 9 | 1 | 57 | 17 | |||
| 68824 | 126037 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 99 Moulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6002876.52339 | 2119394.71062 | 37.7996158670293 | -122.434165199478 | (37.7996158670293, -122.434165199478) | 13 | 9 | 1 | 57 | 17 | |||
| 79747 | 126046 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2100 Jefferson St | 4 | Front Yard : Yard | Tree | Private 2 | 4 | 5999077.01355 | 2121162.9453 | 37.804254586342 | -122.447440173138 | (37.804254586342, -122.447440173138) | 13 | 9 | 1 | 57 | 17 | ||||
| 141357 | 126040 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2390 Bay St | 1 | Side Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 5999373.78481 | 2120164.23699 | 37.8015293572512 | -122.446341287942 | (37.8015293572512, -122.446341287942) | 13 | 9 | 1 | 57 | 17 | |||
| 145242 | 126045 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2100 Jefferson St | 2 | Front Yard : Yard | Tree | Private 2 | 2 | 5999106.15864 | 2121169.1947 | 37.8042734109522 | -122.447339764733 | (37.8042734109522, -122.447339764733) | 13 | 9 | 1 | 57 | 17 | ||||
| 145549 | 126041 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 45 Prado St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6000916.29737 | 2121252.94807 | 37.8046066439378 | -122.441081664106 | (37.8046066439378, -122.441081664106) | 13 | 9 | 1 | 57 | 17 | |||
| 150548 | 126044 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2220 Beach St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5999556.07167 | 2120885.84287 | 37.8035211019658 | -122.445762420414 | (37.8035211019658, -122.445762420414) | 13 | 9 | 1 | 57 | 17 | |||
| 158651 | 126050 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2743 Baker St | 2 | : | Tree | Private 2 | 2 | Width 1ft | 5999540.91098 | 2118277.28381 | 37.7963578318958 | -122.445627186668 | (37.7963578318958, -122.445627186668) | 13 | 9 | 1 | 57 | 17 | |||
| 168768 | 126049 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 3115 Divisadero St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 2ft | 6000414.49884 | 2118997.86085 | 37.7983861817261 | -122.442656162079 | (37.7983861817261, -122.442656162079) | 13 | 9 | 1 | 57 | 17 | |||
| 185753 | 126038 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 99 Moulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002916.41675 | 2119400.10918 | 37.799632954156 | -122.434027540244 | (37.799632954156, -122.434027540244) | 13 | 9 | 1 | 57 | 17 | |||
| 21551 | 190082 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 1700 Armstrong Ave | 8 | Side Yard : Yard | Tree | Private 2 | 4 | 6013888.29247 | 2092890.09747 | 37.7274588480349 | -122.394203559964 | (37.7274588480349, -122.394203559964) | 10 | 3 | 8 | 58 | 1 | ||||
| 32105 | 190087 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 12 Waterville St | 1 | : | Tree | Private 2 | 12 | Width 2ft | 6011435.89726 | 2096093.38597 | 37.7361177895881 | -122.402906748152 | (37.7361177895881, -122.402906748152) | 10 | 3 | 8 | 58 | 1 | |||
| 55187 | 190077 | DPW Maintained 1 | Citrus spp :: Lemon: Orange: Lime 120 | 2058 Quesada Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6012836.12636 | 2096465.16932 | 37.7372167170704 | -122.398091628637 | (37.7372167170704, -122.398091628637) | 10 | 3 | 8 | 58 | 1 |
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) );