trees
957 rows where qCaretaker_id = 2 and qSpecies_id = 6 sorted by Latitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12542 | 262149 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4600 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | |||||||||||||
| 15370 | 50774 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47304 | |||||||||||||||
| 18773 | 255529 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 1555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782018 | ||||||||||
| 79736 | 251742 | Undocumented 4 | Lagunaria patersonii :: Primrose Tree 6 | 300 Naylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002771 | 2086560 | 37.7094535905361 | -122.432184185389 | (37.7094535905361, -122.432184185389) | 9 | 7 | 6 | 28861 | 5 | ||||
| 57255 | 176878 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013154.94381 | 2086496.55313 | 37.7098626625021 | -122.396290845073 | (37.7098626625021, -122.396290845073) | 10 | 3 | 8 | 309 | 1 | |||
| 169305 | 176877 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.7099103976217 | -122.396487432357 | (37.7099103976217, -122.396487432357) | 10 | 3 | 8 | 309 | 1 | |||
| 100552 | 172375 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 216 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 07:37:00 AM | 3 | Width 2ft | 6002574 | 2086750 | 37.7099641176609 | -122.432878614235 | (37.7099641176609, -122.432878614235) | 9 | 7 | 6 | 28861 | 5 | ||
| 127629 | 176876 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6013031.56753 | 2086536.06642 | 37.7099642921874 | -122.396720027609 | (37.7099642921874, -122.396720027609) | 10 | 3 | 8 | 309 | 1 | |||
| 10101 | 180653 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 245 Chicago Way | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/11/2017 07:56:00 AM | 3 | Width 6ft | 6002847.75966 | 2086772.69306 | 37.7100419513527 | -122.431934068713 | (37.7100419513527, -122.431934068713) | 9 | 7 | 6 | 28861 | 5 | ||
| 101851 | 176875 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012929.76757 | 2086570.3757 | 37.7100528322548 | -122.397074274178 | (37.7100528322548, -122.397074274178) | 10 | 3 | 8 | 309 | 1 | |||
| 56826 | 176874 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | 10 | 3 | 8 | 309 | 1 | |||
| 192015 | 108829 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 545 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6012931.90275 | 2086607.74701 | 37.7101555653976 | -122.397069513169 | (37.7101555653976, -122.397069513169) | 10 | 3 | 8 | 309 | 1 | ||
| 37255 | 108775 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 54619 | 108768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 108222 | 108764 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 117917 | 108778 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 134524 | 108772 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 500X Lathrop Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
| 132775 | 180842 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 87 Laura St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 03:54:00 PM | 3 | Width 2ft | 5997291.8877 | 2087045.22216 | 37.710473721248 | -122.451155786013 | (37.710473721248, -122.451155786013) | 9 | 7 | 6 | 28861 | 25 | ||
| 174505 | 108825 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.91674 | 37.7106910734067 | -122.39659568235 | (37.7106910734067, -122.39659568235) | 10 | 3 | 8 | 309 | 1 | |
| 122783 | 159336 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 523 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 10:36:00 AM | 3 | Width 0ft | 5998080.57171 | 2087152.95418 | 37.7108146533454 | -122.448437690352 | (37.7108146533454, -122.448437690352) | 9 | 7 | 6 | 28861 | 25 | ||
| 28544 | 159338 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 517 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:04:00 AM | 3 | Width 0ft | 5998112.9338 | 2087183.20699 | 37.7108995709325 | -122.448328017142 | (37.7108995709325, -122.448328017142) | 9 | 7 | 6 | 28861 | 25 | ||
| 57846 | 159339 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 517 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:12:00 AM | 3 | Width 0ft | 5998126.45786 | 2087195.02696 | 37.7109327990681 | -122.44828212563 | (37.7109327990681, -122.44828212563) | 9 | 7 | 6 | 28861 | 25 | ||
| 84873 | 69398 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1174 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | 6 | Permit Number 33502 | 6001210.49529 | 2087131.44104 | 37.7109340401325 | -122.43761843606 | (37.7109340401325, -122.43761843606) | 9 | 7 | 6 | 28861 | 5 | |
| 51610 | 176885 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 191 Rey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008580.05361 | 2087004.56736 | 37.7110019335603 | -122.412138452652 | (37.7110019335603, -122.412138452652) | 9 | 7 | 8 | 309 | 39 | |||
| 19087 | 261350 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
| 19183 | 261351 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 299 Sagamore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784323 | 5994169 | 2087374 | 37.7111971725927 | -122.461972900974 | (37.7111971725927, -122.461972900974) | 9 | 8 | 6 | 28861 | 24 | |
| 14258 | 261352 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 297 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2020 12:00:00 AM | 3 | 3x3 | Permit Number 780859 | 5994172 | 2087374 | 37.7111973453091 | -122.461962532307 | (37.7111973453091, -122.461962532307) | 9 | 8 | 6 | 28861 | 24 | |
| 141967 | 159345 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:39:00 AM | 3 | Width 0ft | 5998268.07471 | 2087327.6085 | 37.7113049331395 | -122.447802205131 | (37.7113049331395, -122.447802205131) | 9 | 7 | 6 | 28861 | 25 | ||
| 81002 | 159346 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:49:00 AM | 3 | Width 0ft | 5998276.6806 | 2087336.80621 | 37.7113306798385 | -122.44777312285 | (37.7113306798385, -122.44777312285) | 9 | 7 | 6 | 28861 | 25 | ||
| 139614 | 159347 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:27:00 AM | 3 | Width 0ft | 5998288.37354 | 2087349.92963 | 37.7113673820764 | -122.44773365339 | (37.7113673820764, -122.44773365339) | 9 | 7 | 6 | 28861 | 25 | ||
| 171958 | 159348 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 461 Ellington Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2017 11:44:00 AM | 3 | Width 0ft | 5998312.68186 | 2087372.36678 | 37.7114303786888 | -122.447651252104 | (37.7114303786888, -122.447651252104) | 9 | 7 | 6 | 28861 | 25 | ||
| 154340 | 176919 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 140 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6001505.61042 | 2087336.29034 | 37.7115132862848 | -122.436613103724 | (37.7115132862848, -122.436613103724) | 9 | 7 | 6 | 28861 | 5 | |||
| 173908 | 251743 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 143 Cordova St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001773 | 2087479 | 37.7119203272299 | -122.43569914015 | (37.7119203272299, -122.43569914015) | 9 | 7 | 6 | 28861 | 5 | |||||
| 121056 | 251749 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 601 Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002875 | 2087693 | 37.7125704580966 | -122.43190559156 | (37.7125704580966, -122.43190559156) | 9 | 7 | 6 | 28861 | 5 | |||||
| 161307 | 176916 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 380 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6001888.93185 | 2087835.89796 | 37.7129068748214 | -122.435323960636 | (37.7129068748214, -122.435323960636) | 9 | 7 | 6 | 28861 | 5 | |||
| 103230 | 49761 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 366@ REY Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2003 12:00:00 AM | 4 | Permit Number 46555 | 6008949.54261 | 2087928.88077 | 37.713560633393 | -122.41092664676 | (37.713560633393, -122.41092664676) | 9 | 7 | 8 | 309 | 39 | |
| 99461 | 216848 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 258 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 02:39:00 PM | 3 | Width 3ft | 5994378.76562 | 2088424.12647 | 37.7140926462446 | -122.461323980613 | (37.7140926462446, -122.461323980613) | 9 | 8 | 6 | 28861 | 24 | ||
| 88773 | 216845 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 194 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:48:00 AM | 3 | Width 3ft | 5995118.95449 | 2088413.12295 | 37.7141050056202 | -122.458764825742 | (37.7141050056202, -122.458764825742) | 9 | 8 | 6 | 28861 | 24 | ||
| 52445 | 251444 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 244 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 07:40:00 AM | 3 | 3x3 | 5994545 | 2088436 | 37.7141348140673 | -122.460750275072 | (37.7141348140673, -122.460750275072) | 9 | 8 | 6 | 28861 | 24 | ||
| 192989 | 181010 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 215 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:17:00 AM | 3 | Width 4ft | 6001139.6561 | 2088316.90059 | 37.7141850209845 | -122.437948129327 | (37.7141850209845, -122.437948129327) | 9 | 7 | 6 | 28861 | 5 | ||
| 168066 | 181011 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 207 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:21:00 AM | 3 | Width 4ft | 6001121.31583 | 2088326.00254 | 37.7142089699327 | -122.438012171843 | (37.7142089699327, -122.438012171843) | 9 | 7 | 6 | 28861 | 5 | ||
| 194177 | 181017 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:28:00 AM | 3 | Width 4ft | 6001019.31887 | 2088386.79799 | 37.7143700996689 | -122.438369065102 | (37.7143700996689, -122.438369065102) | 9 | 7 | 6 | 28861 | 5 | ||
| 30385 | 181018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 197 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 11:31:00 AM | 3 | Width 4ft | 6001005.57228 | 2088396.04691 | 37.7143947132291 | -122.43841724089 | (37.7143947132291, -122.43841724089) | 9 | 7 | 6 | 28861 | 5 | ||
| 109143 | 181019 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 191 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:36:00 PM | 3 | Width 4ft | 6000981.45407 | 2088409.26942 | 37.7144296473919 | -122.438501549606 | (37.7144296473919, -122.438501549606) | 9 | 7 | 6 | 28861 | 5 | ||
| 117385 | 181020 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 183 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/10/2017 12:41:00 PM | 3 | Width 4ft | 6000952.49174 | 2088426.93011 | 37.7144764921819 | -122.438602919392 | (37.7144764921819, -122.438602919392) | 9 | 7 | 6 | 28861 | 5 | ||
| 57710 | 181021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 179 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2017 12:49:00 PM | 3 | 8x6 | 6000934.69942 | 2088437.13017 | 37.71450348711 | -122.438665147076 | (37.71450348711, -122.438665147076) | 9 | 7 | 6 | 28861 | 5 | ||
| 151427 | 176883 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 4 | Front Yard : Yard | Tree | Private 2 | 1 | 6011048.63475 | 2088252.82193 | 37.7145675926038 | -122.403694172945 | (37.7145675926038, -122.403694172945) | 9 | 7 | 8 | 309 | 39 | ||||
| 172292 | 176884 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 96 Alpha St | 2 | Front Yard : Yard | Tree | Private 2 | 1 | 6011062.55449 | 2088258.87965 | 37.7145850034576 | -122.403646486396 | (37.7145850034576, -122.403646486396) | 9 | 7 | 8 | 309 | 39 | ||||
| 157522 | 207028 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 227 Ramsell St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 5992956.15905 | 2088729.24095 | 37.7148484391912 | -122.46626317241 | (37.7148484391912, -122.46626317241) | 9 | 8 | 6 | 64 | 24 | |||
| 132066 | 207026 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 229 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5994724.72263 | 2088692.24537 | 37.7148487422402 | -122.460147642199 | (37.7148487422402, -122.460147642199) | 9 | 8 | 6 | 28861 | 24 | |||
| 139943 | 115757 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1718 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 772425 | 5998122.34061 | 2088716.21291 | 37.7151093927473 | -122.448405831859 | (37.7151093927473, -122.448405831859) | 9 | 7 | 6 | 28861 | 25 | ||
| 133452 | 181027 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:23:00 PM | 3 | Width 4ft | 6000546.58685 | 2088667.24811 | 37.7151132526545 | -122.440023107188 | (37.7151132526545, -122.440023107188) | 9 | 7 | 6 | 28861 | 5 | ||
| 39381 | 181028 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Rolph St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/05/2017 04:38:00 PM | 3 | Width 4ft | 6000533.08885 | 2088674.46766 | 37.7151323074928 | -122.440070279342 | (37.7151323074928, -122.440070279342) | 9 | 7 | 6 | 28861 | 5 | ||
| 56885 | 207029 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 835 Sargent St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5991723.94975 | 2089189.17612 | 37.7160401362134 | -122.470555641023 | (37.7160401362134, -122.470555641023) | 9 | 8 | 6 | 64 | 24 | |||
| 185300 | 207030 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 835 Sargent St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5991738.49074 | 2089190.01168 | 37.7160432712657 | -122.470505441771 | (37.7160432712657, -122.470505441771) | 9 | 8 | 6 | 64 | 24 | |||
| 72790 | 40470 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 43 Lakeview Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1999 12:00:00 AM | Permit Number 41555 | 5997449.10168169 | 2089159.83978526 | 37.7162889747674 | -122.450764790718 | (37.7162889747674, -122.450764790718) | 9 | 8 | 6 | 28861 | 24 | |||
| 115087 | 207027 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 43 Lakeview Ave | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5997356.56263 | 2089224.02458 | 37.7164599136667 | -122.451089274853 | (37.7164599136667, -122.451089274853) | 9 | 8 | 6 | 28861 | 24 | |||
| 25 | 49783 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 130 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2020 12:00:00 AM | 3 | Permit Number 46568 | 6011944.29976 | 2088937.30454 | 37.7164970376796 | -122.400646428989 | (37.7164970376796, -122.400646428989) | 10 | 7 | 8 | 309 | 39 | |
| 76984 | 176882 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781358 | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | 9 | 7 | 8 | 309 | 39 |
| 67542 | 95712 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 642 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767468 | 6003074.18539 | 2089625.7401 | 37.7178886288451 | -122.431355025819 | (37.7178886288451, -122.431355025819) | 9 | 7 | 6 | 28861 | 5 |
| 12222 | 31158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 600 Head St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Permit Number 785248 | 5993522.80361 | 2089878.90243 | 37.7180378119737 | -122.464388049089 | (37.7180378119737, -122.464388049089) | 9 | 8 | 6 | 64 | 24 | |
| 174741 | 38921 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.7181598049858 | -122.460857119734 | (37.7181598049858, -122.460857119734) | 9 | 8 | 6 | 28861 | 24 | ||
| 61823 | 109689 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 836 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774161 | 6003406.50306 | 2089728.73547 | 37.7181902596385 | -122.430213694415 | (37.7181902596385, -122.430213694415) | 9 | 7 | 6 | 28861 | 5 |
| 194470 | 254768 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 415 Victoria St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781626 | 5993212 | 2089957 | 37.7182343284954 | -122.4654680237 | (37.7182343284954, -122.4654680237) | 9 | 8 | 6 | 64 | 24 |
| 72730 | 251681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 4 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:36:00 PM | 3 | 3x5 | 5996550 | 2089909 | 37.7182944850221 | -122.453926576307 | (37.7182944850221, -122.453926576307) | 9 | 8 | 6 | 28861 | 24 | ||
| 132281 | 254353 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2 Ankeny St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011131.69741 | 2089639.6721 | 37.7183802415409 | -122.403504586485 | (37.7183802415409, -122.403504586485) | 10 | 7 | 8 | 309 | 28 | |
| 49657 | 46433 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777225 | 6011103.47209 | 2089684.58226 | 37.718501979072 | -122.403605308234 | (37.718501979072, -122.403605308234) | 10 | 7 | 8 | 309 | 28 |
| 95475 | 46434 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/2003 12:00:00 AM | 1 | Permit Number 47151 | 6011096.25435 | 2089701.2859 | 37.7185474406786 | -122.40363143174 | (37.7185474406786, -122.40363143174) | 10 | 7 | 8 | 309 | 28 | |
| 82669 | 46431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2St. Ankeny St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2002 12:00:00 AM | 1 | Permit Number 44652 | 6011089.42189 | 2089718.35805 | 37.7185939356546 | -122.403656249429 | (37.7185939356546, -122.403656249429) | 10 | 7 | 8 | 309 | 28 | ||
| 111662 | 252898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 501x Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997879 | 2089997 | 37.7186122227881 | -122.449339142229 | (37.7186122227881, -122.449339142229) | 9 | 8 | 6 | 28861 | 24 | ||||
| 28327 | 162331 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 26 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:09:00 PM | 3 | Width 0ft | 5996526.61739 | 2090076.51041 | 37.7187530886569 | -122.454019490912 | (37.7187530886569, -122.454019490912) | 9 | 8 | 6 | 28861 | 24 | ||
| 189393 | 162332 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 36 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 02:06:00 PM | 3 | Width 0ft | 5996526.7373 | 2090117.21242 | 37.7188648537082 | -122.45402201441 | (37.7188648537082, -122.45402201441) | 9 | 8 | 6 | 28861 | 24 | ||
| 68598 | 109688 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 610 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774167 | 6002866.93373 | 2090069.72294 | 37.719095959684 | -122.432103090885 | (37.719095959684, -122.432103090885) | 9 | 7 | 6 | 28861 | 5 |
| 161792 | 216723 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 51 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/06/2017 08:05:00 AM | 3 | Width 2ft | 5995305.86266 | 2090248.98741 | 37.7191565973781 | -122.458251599737 | (37.7191565973781, -122.458251599737) | 9 | 8 | 6 | 28861 | 24 | ||
| 30581 | 252889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301x Howth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2019 08:45:00 AM | 3 | 3x3 | 5997131 | 2090234 | 37.7192201544045 | -122.451941749186 | (37.7192201544045, -122.451941749186) | 9 | 8 | 6 | 28861 | 24 | ||
| 102650 | 120680 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 522 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2016 12:00:00 AM | 3 | 3x3 | 6003717 | 2090174 | 37.7194304401491 | -122.42917217064 | (37.7194304401491, -122.42917217064) | 9 | 7 | 6 | 28861 | 5 | ||
| 163710 | 108371 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.7196058887813 | -122.43642558878 | (37.7196058887813, -122.43642558878) | 9 | 7 | 6 | 28861 | 5 | ||
| 72364 | 216718 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.459124173263 | (37.7196152839906, -122.459124173263) | 9 | 8 | 6 | 28861 | 24 | ||
| 27595 | 63507 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 574 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1987 12:00:00 AM | 4 | Permit Number 24113 | 6001588.8915 | 2090307.92108 | 37.7196774559426 | -122.436537823274 | (37.7196774559426, -122.436537823274) | 9 | 7 | 6 | 28861 | 5 | ||
| 141360 | 176880 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3333 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6012013.01229 | 2090122.10429 | 37.7197540907522 | -122.400492099948 | (37.7197540907522, -122.400492099948) | 10 | 7 | 8 | 309 | 28 | |||
| 41454 | 253116 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 12:00:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 96295 | 253108 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:41:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 156762 | 253110 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:46:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 172760 | 253118 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 01:35:00 PM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 173524 | 253112 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:51:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 182173 | 253114 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:55:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.7197834059472 | -122.442045963044 | (37.7197834059472, -122.442045963044) | 9 | 7 | 6 | 28861 | 25 | ||
| 143452 | 160073 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:36:00 AM | 3 | Width 0ft | 6000082.99934 | 2090399.7386 | 37.7198438772755 | -122.441749724582 | (37.7198438772755, -122.441749724582) | 9 | 7 | 6 | 28861 | 25 | ||
| 194398 | 162836 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 95 Lee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/2020 12:00:00 AM | 0 | 4x6 | 5996489.45825 | 2090475.5577 | 37.7198466480955 | -122.454176740991 | (37.7198466480955, -122.454176740991) | 9 | 8 | 6 | 28861 | 24 | |
| 101905 | 43742 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 107401 | 43741 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 139435 | 43740 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 144972 | 43739 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 840 Mount Vernon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2000 12:00:00 AM | Permit Number 43376 | 5997079.36624225 | 2090505.78650323 | 37.7199634590291 | -122.452139826069 | (37.7199634590291, -122.452139826069) | 9 | 8 | 6 | 28861 | 24 | |||
| 165323 | 160071 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:31:00 AM | 3 | Width 0ft | 6000209.4859 | 2090450.10808 | 37.7199893866688 | -122.44131611827 | (37.7199893866688, -122.44131611827) | 9 | 7 | 6 | 28861 | 25 | ||
| 186495 | 57147 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 578 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2012 12:00:00 AM | 6 | 4x4 | Permit Number 14422 | 6001353.29798 | 2090440.69811 | 37.7200286411902 | -122.4373616868 | (37.7200286411902, -122.4373616868) | 9 | 7 | 6 | 28861 | 5 |
| 112582 | 207022 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997053.5846 | 2090532.92812 | 37.7200365066592 | -122.452230901246 | (37.7200365066592, -122.452230901246) | 9 | 8 | 6 | 28861 | 24 | |||
| 151234 | 207023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5997061.02366 | 2090546.31892 | 37.7200737008175 | -122.452206152789 | (37.7200737008175, -122.452206152789) | 9 | 8 | 6 | 28861 | 24 | |||
| 34235 | 207024 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5997067.34432 | 2090557.59428 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | 9 | 8 | 6 | 28861 | 24 | |||
| 23429 | 176881 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 3303 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011991.79808 | 2090250.44255 | 37.7201052985 | -122.400574440964 | (37.7201052985, -122.400574440964) | 10 | 7 | 8 | 309 | 28 | |||
| 120285 | 207025 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 85 Williar Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5997075.91635 | 2090573.81293 | 37.7201500460637 | -122.452156656813 | (37.7201500460637, -122.452156656813) | 9 | 8 | 6 | 28861 | 24 | |||
| 177745 | 78252 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 541 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776648 | 6003018.57122 | 2090471.02112 | 37.7202064317688 | -122.431607573443 | (37.7202064317688, -122.431607573443) | 9 | 7 | 6 | 28861 | 5 |
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) );