trees
877 rows where qLegalStatus_id = 1 and qSpecies_id = 6 sorted by Police Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1967 | 259348 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450x Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 3117 | 260221 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 3183 | 260224 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 5614 | 259341 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Bacon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 5784 | 260220 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 8715 | 260222 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 11368 | 259340 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 102 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 16718 | 262177 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 Rutland St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
| 17639 | 260223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2201x 22nd Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
| 17693 | 259347 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450x Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 19156 | 259400 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1649 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | ||||||||||||
| 19327 | 262176 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 620 Rutland St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/07/2019 12:00:00 AM | 3 | ||||||||||||
| 4801 | 125249 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1077 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2020 12:00:00 AM | 3 | Width 3ft | 6008457.69643 | 2118247.71377 | 37.7967816796858 | -122.414771036277 | (37.7967816796858, -122.414771036277) | 5 | 1 | 10 | 308 | 21 | ||
| 6798 | 125247 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1085 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782055 | 6008420.1565 | 2118241.89629 | 37.796763597016 | -122.414900521554 | (37.796763597016, -122.414900521554) | 5 | 1 | 10 | 308 | 21 | |
| 42267 | 83686 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52242 | 6009408.29288 | 2117660.17543 | 37.7952218082983 | -122.411440210903 | (37.7952218082983, -122.411440210903) | 3 | 1 | 10 | 28857 | 4 | |
| 49974 | 73594 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/12/2014 12:00:00 AM | 3 | Permit Number 772812 | 6008453.79298 | 2114896.74793 | 37.7875805296608 | -122.414547298434 | (37.7875805296608, -122.414547298434) | 5 | 1 | 10 | 28858 | 21 | |
| 74010 | 129386 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009490.7484 | 2116033.66261 | 37.7907604245028 | -122.411039958651 | (37.7907604245028, -122.411039958651) | 5 | 1 | 10 | 28857 | 21 | |||
| 80490 | 83685 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009407.14931 | 2117677.56911 | 37.7952695029448 | -122.411445397284 | (37.7952695029448, -122.411445397284) | 3 | 1 | 10 | 28857 | 4 | |
| 81222 | 83687 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1250-1262 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009414.65188 | 2117634.89994 | 37.7951527646548 | -122.411416421158 | (37.7951527646548, -122.411416421158) | 3 | 1 | 10 | 28857 | 4 | |
| 81750 | 129385 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 722 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6009662.68842 | 2115877.38276 | 37.7903409582254 | -122.41043401253 | (37.7903409582254, -122.41043401253) | 5 | 1 | 10 | 28857 | 21 | |||
| 102379 | 84816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 736 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53031 | 6008319.93046 | 2115035.61847 | 37.7879543130824 | -122.415020270782 | (37.7879543130824, -122.415020270782) | 5 | 1 | 10 | 28858 | 21 | |
| 127633 | 52071 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009677.58908 | 2117754.14875 | 37.7954949369081 | -122.410515038747 | (37.7954949369081, -122.410515038747) | 3 | 1 | 10 | 28857 | 4 | ||
| 131191 | 71549 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 780 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/18/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772812 | 6008431.05429 | 2114892.38013 | 37.7875672592553 | -122.414625660841 | (37.7875672592553, -122.414625660841) | 5 | 1 | 10 | 28858 | 21 |
| 142268 | 129380 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 730 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008321.92773 | 2115014.63424 | 37.7878968077251 | -122.415011874722 | (37.7878968077251, -122.415011874722) | 5 | 1 | 10 | 28858 | 21 | |||
| 146089 | 52362 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1438ASHINGTON Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 9 | Permit Number 48498 | 6007994.93646 | 2117377.76116 | 37.7943669936906 | -122.416310648633 | (37.7943669936906, -122.416310648633) | 5 | 1 | 10 | 28858 | 21 | |
| 150091 | 129390 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 902 Vallejo St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6009192.86484 | 2118752.75452 | 37.798209676283 | -122.412262888224 | (37.798209676283, -122.412262888224) | 3 | 1 | 10 | 308 | 21 | |||
| 154237 | 60223 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1230 Mason St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52240 | 6009426.59197 | 2117542.6242 | 37.7949000677337 | -122.411368584404 | (37.7949000677337, -122.411368584404) | 3 | 1 | 10 | 28857 | 4 | |
| 194195 | 52070 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 939 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009656.25559 | 2117750.51311 | 37.7954837583147 | -122.410588599703 | (37.7954837583147, -122.410588599703) | 3 | 1 | 10 | 28857 | 4 | ||
| 15133 | 129382 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008704.56308 | 2112447.63135 | 37.7808699297471 | -122.413506401504 | (37.7808699297471, -122.413506401504) | 7 | 10 | 9 | 28852 | 36 | |||
| 20503 | 129384 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008749.2926 | 2112454.62361 | 37.7808916402666 | -122.413352154294 | (37.7808916402666, -122.413352154294) | 7 | 10 | 9 | 28852 | 36 | |||
| 107699 | 129383 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 91 McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008721.10925 | 2112450.33412 | 37.7808782799549 | -122.413449351208 | (37.7808782799549, -122.413449351208) | 7 | 10 | 9 | 28852 | 36 | |||
| 148373 | 129381 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 555 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008630.87446 | 2114175.52263 | 37.7856101663154 | -122.413883591577 | (37.7856101663154, -122.413883591577) | 7 | 10 | 9 | 28852 | 36 | |||
| 48121 | 227587 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 77 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006751.41341 | 2109490.52204 | 37.7726405574578 | -122.420053398542 | (37.7726405574578, -122.420053398542) | 8 | 2 | 9 | 28853 | 19 | |||
| 54965 | 191246 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 22 Rausch St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009574.51886 | 2111002.08454 | 37.776949608681 | -122.410394686976 | (37.776949608681, -122.410394686976) | 8 | 2 | 9 | 28853 | 34 | |||
| 86891 | 41786 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011862.44614 | 2107450.91483 | 37.7673268978362 | -122.402230262809 | (37.7673268978362, -122.402230262809) | 8 | 2 | 8 | 28853 | 20 | |
| 97730 | 41784 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011899.9957 | 2107451.97946 | 37.7673319169733 | -122.40210045827 | (37.7673319169733, -122.40210045827) | 8 | 2 | 8 | 28853 | 20 | |
| 107310 | 88186 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 43 Dore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51193 | 6008751.52799 | 2109978.60624 | 37.7740932089612 | -122.41316928526 | (37.7740932089612, -122.41316928526) | 8 | 2 | 9 | 28853 | 34 | |
| 108082 | 41787 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011846.53611 | 2107450.83181 | 37.7673257817889 | -122.402285287842 | (37.7673257817889, -122.402285287842) | 8 | 2 | 8 | 28853 | 20 | |
| 121138 | 95828 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 174 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767563 | 6010564.55165 | 2110346.83579 | 37.775205897855 | -122.406923649213 | (37.775205897855, -122.406923649213) | 8 | 2 | 9 | 28853 | 34 |
| 140711 | 41785 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 15th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011884.29769 | 2107452.29856 | 37.7673319169518 | -122.402154778231 | (37.7673319169518, -122.402154778231) | 8 | 2 | 8 | 28853 | 20 | |
| 149522 | 106431 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 747 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008848.75367 | 2110684.34026 | 37.7760364460542 | -122.412882870049 | (37.7760364460542, -122.412882870049) | 8 | 2 | 9 | 28853 | 34 | |||
| 170364 | 88187 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 43 Dore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51193 | 6008740.44285 | 2109989.37217 | 37.7741221473478 | -122.413208392271 | (37.7741221473478, -122.413208392271) | 8 | 2 | 9 | 28853 | 34 | |
| 190595 | 88188 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 43-25 Dore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51193 | 6008699.51281 | 2110034.52168 | 37.7742438193359 | -122.413353170509 | (37.7742438193359, -122.413353170509) | 8 | 2 | 9 | 28853 | 34 | |
| 334 | 162296 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010920.41592 | 2090984.45712 | 37.7220609417541 | -122.40432950351 | (37.7220609417541, -122.40432950351) | 10 | 3 | 7 | 309 | 28 | ||
| 887 | 60297 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1101 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/27/1982 12:00:00 AM | 7 | Permit Number 19862 | 6013032.9382 | 2107035.865 | 37.7662525295396 | -122.398152546702 | (37.7662525295396, -122.398152546702) | 14 | 3 | 8 | 28856 | 20 | |
| 1126 | 262542 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1260 Egbert Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 6015016 | 2090665 | 37.7214117898675 | -122.390149655616 | (37.7214117898675, -122.390149655616) | 10 | 3 | 8 | 58 | 1 | |||
| 3177 | 191238 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1600 Newhall St | 8 | : | Tree | Private 2 | 2 | Width 2ft | 6014118.19632 | 2095356.58877 | 37.7342441078693 | -122.393581327137 | (37.7342441078693, -122.393581327137) | 10 | 3 | 8 | 58 | 1 | |||
| 6290 | 259344 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Somerset St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6009725.84271 | 2093690.47402 | 37.7294242696948 | -122.408649667073 | (37.7294242696948, -122.408649667073) | 10 | 3 | 7 | 309 | 28 | ||
| 9738 | 79640 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 168 Orsi Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6012982.50067 | 2092948.34875 | 37.727568405236 | -122.397338990501 | (37.727568405236, -122.397338990501) | 10 | 3 | 8 | 58 | 1 | |||
| 9949 | 162295 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 299 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6010903.85659 | 2090979.54911 | 37.7220465400048 | -122.404386400036 | (37.7220465400048, -122.404386400036) | 10 | 3 | 7 | 309 | 28 | ||
| 10393 | 3666 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 102 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:06:00 PM | 3 | 3X3 | 6017134.48475 | 2098914.37607 | 37.7441802162386 | -122.383400533034 | (37.7441802162386, -122.383400533034) | 10 | 3 | 8 | 58 | 1 | ||
| 11481 | 3673 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 109 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/10/2017 10:21:00 AM | 3 | 3X3 | 6017015.17172 | 2099002.62034 | 37.7444159222737 | -122.383819238476 | (37.7444159222737, -122.383819238476) | 10 | 3 | 8 | 58 | 1 | ||
| 11900 | 3534 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 44 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:10:00 AM | 3 | 3X3 | 6018402.12937 | 2097818.41667 | 37.7412409080406 | -122.378941151133 | (37.7412409080406, -122.378941151133) | 10 | 3 | 8 | 58 | 1 | ||
| 12065 | 88481 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1221 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014818.59944 | 2096228.0421 | 37.7366758342199 | -122.391220684988 | (37.7366758342199, -122.391220684988) | 10 | 3 | 8 | 58 | 1 | |
| 12096 | 83834 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2300X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6013045.53048 | 2096356.5558 | 37.7369301480983 | -122.397360003177 | (37.7369301480983, -122.397360003177) | 10 | 3 | 8 | 58 | 1 | |||
| 12282 | 83440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2230 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6011076.92464 | 2105580.38381 | 37.7621469638337 | -122.404815578978 | (37.7621469638337, -122.404815578978) | 8 | 3 | 8 | 28856 | 29 | |||
| 12682 | 260425 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 508 Dwight St | Unaccepted Street : Yard | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010099.90949 | 2091269.80828 | 37.7227985719868 | -122.407185909529 | (37.7227985719868, -122.407185909529) | 10 | 3 | 7 | 309 | 28 | |||
| 13676 | 262543 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1260 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/18/2020 12:00:00 AM | 6015062.6163 | 2090599.75011 | 37.7212352119804 | -122.389983958896 | (37.7212352119804, -122.389983958896) | 10 | 3 | 8 | 58 | 1 | |||
| 13960 | 27162 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011270.31088 | 2095195.56425 | 37.7336433130742 | -122.40341610708 | (37.7336433130742, -122.40341610708) | 10 | 3 | 8 | 58 | 1 | ||
| 15493 | 259346 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 106 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6011005.88556 | 2093460.4594 | 37.728864306632 | -122.404208230977 | (37.728864306632, -122.404208230977) | 10 | 3 | 7 | 309 | 28 | ||
| 16248 | 264659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 971 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/10/2020 12:00:00 AM | 3x3 | 6014920.44131 | 2089617.70445 | 37.7185308216427 | -122.390406839913 | (37.7185308216427, -122.390406839913) | 10 | 3 | 8 | 58 | 1 | |||
| 17049 | 112023 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 17413 | 112021 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2101x 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 07/23/2015 12:00:00 AM | 3 | 5x5 | 6011761 | 2103726 | 37.75709344993 | -122.402319220858 | (37.75709344993, -122.402319220858) | 10 | 3 | 8 | 28856 | 29 | ||
| 21462 | 201816 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021143.08428 | 2093327.21502 | 37.7290596700622 | -122.369153577473 | (37.7290596700622, -122.369153577473) | 10 | 3 | 8 | 58 | 1 | ||
| 21976 | 26983 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1395 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/30/2009 12:00:00 AM | 3 | 3X3 | 6009622.93574 | 2094432.56882 | 37.7314561402837 | -122.409057769215 | (37.7314561402837, -122.409057769215) | 9 | 3 | 7 | 309 | 28 | ||
| 22726 | 191234 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1600 Newhall St | 1 | : | Tree | Private 2 | 4 | Width 2ft | 6014153.11677 | 2095403.12134 | 37.7343738170818 | -122.393463850493 | (37.7343738170818, -122.393463850493) | 10 | 3 | 8 | 58 | 1 | |||
| 22775 | 27008 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1430 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1999 12:00:00 AM | 3 | 3X3 | 6009940.18408 | 2094497.75014 | 37.7316528813564 | -122.407965571349 | (37.7316528813564, -122.407965571349) | 10 | 3 | 7 | 309 | 28 | ||
| 24569 | 176914 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1300 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009346.09367 | 2094283.90387 | 37.7310324255937 | -122.41000437762 | (37.7310324255937, -122.41000437762) | 9 | 3 | 7 | 309 | 28 | |||
| 25283 | 3523 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2017 11:28:00 AM | 3 | 3X3 | 6018216.35215 | 2097958.49501 | 37.7416152904271 | -122.379593238756 | (37.7416152904271, -122.379593238756) | 10 | 3 | 8 | 58 | 1 | ||
| 25340 | 176908 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1053 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6007885.16277 | 2093698.95374 | 37.7293442892945 | -122.415013692231 | (37.7293442892945, -122.415013692231) | 9 | 3 | 7 | 309 | 28 | |||
| 28445 | 3667 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 103 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:19:00 PM | 3 | 3X3 | 6017116.62756 | 2098928.27448 | 37.7442173915214 | -122.383463247242 | (37.7442173915214, -122.383463247242) | 10 | 3 | 8 | 58 | 1 | ||
| 31518 | 201833 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020733.63229 | 2092847.87799 | 37.7277210345753 | -122.370535976659 | (37.7277210345753, -122.370535976659) | 10 | 3 | 8 | 58 | 1 | |
| 31921 | 191247 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1453 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6016461.47366 | 2096825.22247 | 37.7384066073881 | -122.385582111127 | (37.7384066073881, -122.385582111127) | 10 | 3 | 8 | 58 | 1 | |||
| 33310 | 27006 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1420 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/13/1999 12:00:00 AM | 3 | 3X3 | 6009885.43307 | 2094479.90043 | 37.73160080432 | -122.408153598922 | (37.73160080432, -122.408153598922) | 10 | 3 | 7 | 309 | 28 | ||
| 33446 | 191235 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1600 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6014141.54444 | 2095385.83675 | 37.7343257141509 | -122.393502650848 | (37.7343257141509, -122.393502650848) | 10 | 3 | 8 | 58 | 1 | |||
| 34639 | 93188 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1675 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53196 | 6014934.44131 | 2097265.12572 | 37.7395298812852 | -122.39089262491 | (37.7395298812852, -122.39089262491) | 10 | 3 | 8 | 58 | 1 | |
| 40165 | 191226 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6011107.06002 | 2104648.42845 | 37.7595897074225 | -122.404645742032 | (37.7595897074225, -122.404645742032) | 10 | 3 | 8 | 28856 | 29 | |||
| 44173 | 49818 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1300 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46609 | 6012222.38132 | 2102319.17957 | 37.7532563730854 | -122.400624753529 | (37.7532563730854, -122.400624753529) | 10 | 3 | 8 | 28856 | 29 |
| 46442 | 3681 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100X Cargo Way | 117 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/02/2017 03:27:00 PM | 3 | 3X3 | 6016866.95731 | 2099120.49255 | 37.7447313810499 | -122.384339945926 | (37.7447313810499, -122.384339945926) | 10 | 3 | 8 | 58 | 1 | ||
| 46503 | 201810 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 1 | : | Tree | Private 2 | 1 | Width 6ft | 6021035.70856 | 2093179.80399 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | 10 | 3 | 8 | 58 | 1 | |||
| 52248 | 201838 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020663.4716 | 2092744.71005 | 37.7274339035298 | -122.370771395785 | (37.7274339035298, -122.370771395785) | 10 | 3 | 8 | 58 | 1 | |
| 52628 | 176910 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1390 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009561.38521 | 2094361.93193 | 37.7312587382014 | -122.409265579153 | (37.7312587382014, -122.409265579153) | 10 | 3 | 7 | 309 | 28 | |||
| 53926 | 201827 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 258 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020879.65439 | 2093047.83852 | 37.7282781025329 | -122.370044984594 | (37.7282781025329, -122.370044984594) | 10 | 3 | 8 | 58 | 1 | |
| 54445 | 201812 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 3 | : | Tree | Private 2 | 1 | Width 6ft | 6021065.67541 | 2093224.76894 | 37.7287741263267 | -122.369414113788 | (37.7287741263267, -122.369414113788) | 10 | 3 | 8 | 58 | 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 | |||
| 57077 | 201825 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 232 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020928.29141 | 2093111.19247 | 37.7284547293849 | -122.369881218949 | (37.7284547293849, -122.369881218949) | 10 | 3 | 8 | 58 | 1 | |
| 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 | |||
| 59083 | 88474 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2350 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51428 | 6011695.42869 | 2099760.86607 | 37.7462023967426 | -122.402267215055 | (37.7462023967426, -122.402267215055) | 10 | 3 | 8 | 58 | 1 | |
| 59846 | 201831 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 350 Friedell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | Permit Number 770566 | 6020768.36275 | 2092897.88429 | 37.7278602487283 | -122.370419366967 | (37.7278602487283, -122.370419366967) | 10 | 3 | 8 | 58 | 1 | |
| 60494 | 27052 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1016 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/27/1999 12:00:00 AM | 6 | 3X3 | 6007658.95865 | 2093571.88726 | 37.7289826781912 | -122.415786708996 | (37.7289826781912, -122.415786708996) | 9 | 3 | 7 | 309 | 5 | ||
| 62270 | 176912 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1390 Silver Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009589.47798 | 2094371.19963 | 37.7312857592085 | -122.409169110679 | (37.7312857592085, -122.409169110679) | 10 | 3 | 7 | 309 | 28 | |||
| 63555 | 201813 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Friedell St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 6ft | 6021086.18405 | 2093254.37787 | 37.7288565518864 | -122.369345258092 | (37.7288565518864, -122.369345258092) | 10 | 3 | 8 | 58 | 1 | ||
| 65951 | 191221 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 101 Mississippi St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014015.89789 | 2106592.91783 | 37.7650909952748 | -122.394721628821 | (37.7650909952748, -122.394721628821) | 14 | 3 | 8 | 28856 | 29 | |||
| 66747 | 27158 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1700X Silver Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/28/2011 12:00:00 AM | 3 | 3x3 | 6011192.58379 | 2095136.52795 | 37.7334768701528 | -122.403680681311 | (37.7334768701528, -122.403680681311) | 10 | 3 | 8 | 58 | 1 | ||
| 67683 | 191232 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 2055 Silver Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.398826976382 | (37.7363832218132, -122.398826976382) | 10 | 3 | 8 | 58 | 1 | |||
| 68285 | 27051 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1008 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 6 | 3x3 | 6007619.46607 | 2093557.16905 | 37.7289400449304 | -122.415922196353 | (37.7289400449304, -122.415922196353) | 9 | 3 | 7 | 309 | 5 | ||
| 68376 | 27287 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1036 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/06/2008 12:00:00 AM | 6 | 3X3 | 6007731.14975 | 2093596.42391 | 37.729054108643 | -122.415538874723 | (37.729054108643, -122.415538874723) | 9 | 3 | 7 | 309 | 5 | ||
| 68993 | 27000 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1236 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6008836.56983 | 2094066.26048 | 37.7304062528391 | -122.411750521985 | (37.7304062528391, -122.411750521985) | 9 | 3 | 7 | 309 | 28 | ||
| 70811 | 3516 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201X Cargo Way | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/07/1996 12:00:00 AM | 6 | 3X3 | 6018109.71439 | 2098036.73671 | 37.7418242442879 | -122.379967395395 | (37.7418242442879, -122.379967395395) | 10 | 3 | 8 | 58 | 1 | ||
| 72608 | 201817 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Friedell St | 1 | : | Tree | Private 2 | 07/12/2017 12:00:00 AM | 3 | Width 5ft | 6021101.98762 | 2093338.62944 | 37.7290887577236 | -122.369296441991 | (37.7290887577236, -122.369296441991) | 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) );