trees
202 rows where Zip Codes = 28861 and qSpecies_id = 6 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10786 | 95722 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 24139 | 95719 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 25141 | 95718 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 53300 | 95720 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 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 | ||||
| 84749 | 95721 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 950 Avalon Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767471 | 6005194.4 | 2092000.5 | 37.7245291361369 | -122.424195170047 | (37.7245291361369, -122.424195170047) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 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 | ||||
| 111712 | 253162 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 323 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004481 | 2091226 | 37.7223622223708 | -122.426606175157 | (37.7223622223708, -122.426606175157) | 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 | |||||
| 134136 | 84680 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/2007 12:00:00 AM | 3x3 | Permit Number 49721 | 5996259.49937321 | 2091420.61840977 | 37.722428372357 | -122.45503987717 | (37.722428372357, -122.45503987717) | 9 | 8 | 4 | 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 | |||
| 163948 | 42105 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 305 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2008 12:00:00 AM | 3x3 | Permit Number 51455 | 5999382.77994639 | 2094344.80390055 | 37.730636191214 | -122.444453504412 | (37.730636191214, -122.444453504412) | 9 | 7 | 4 | 28861 | 40 | ||
| 164972 | 59404 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2016 12:00:00 AM | Permit Number 770892 | 6003547.68037437 | 2095024.45734525 | 37.7327391275899 | -122.430103282559 | (37.7327391275899, -122.430103282559) | 9 | 7 | 5 | 28861 | 25 | |||
| 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 | |||||
| 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 | ||
| 194121 | 52944 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 20 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2006 12:00:00 AM | Permit Number 48931 | 6000207.27773758 | 2093260.71462594 | 37.727706542786 | -122.441525334084 | (37.727706542786, -122.441525334084) | 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 | |
| 30949 | 176888 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 13 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6002306.40089 | 2092528.29831 | 37.7258148612434 | -122.434216303453 | (37.7258148612434, -122.434216303453) | 9 | 7 | 6 | 28861 | 25 | |||
| 65213 | 176887 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 13 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6002286.64114 | 2092541.40018 | 37.7258497144844 | -122.434285547657 | (37.7258497144844, -122.434285547657) | 9 | 7 | 6 | 28861 | 25 | |||
| 65853 | 116538 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 1 | Median : Yard | Tree | DPW 1 | 1 | 3x3 | 6001578.10158 | 2088233.43486 | 37.7139807660769 | -122.436426724612 | (37.7139807660769, -122.436426724612) | 9 | 7 | 6 | 28861 | 5 | |||
| 148114 | 227117 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 129 Rousseau St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6003535.84775 | 2095026.78251 | 37.7327448417949 | -122.430144356698 | (37.7327448417949, -122.430144356698) | 9 | 7 | 5 | 28861 | 25 | |||
| 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 | ||
| 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 | |
| 184989 | 207009 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 451 Hearst Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5998610.96321 | 2094365.8508 | 37.7306499124634 | -122.447123295197 | (37.7306499124634, -122.447123295197) | 9 | 7 | 4 | 28861 | 40 | |||
| 26675 | 207018 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 466 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997114.73821 | 2093838.00202 | 37.7291149630685 | -122.452257872798 | (37.7291149630685, -122.452257872798) | 9 | 7 | 4 | 28861 | 40 | |||
| 80751 | 176890 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 18 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003663.21456 | 2093989.9827 | 37.7299052360341 | -122.429630099158 | (37.7299052360341, -122.429630099158) | 9 | 7 | 6 | 28861 | 5 | |||
| 113520 | 207008 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 451 Hearst Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998589.10288 | 2094366.3057 | 37.730649912467 | -122.447198902106 | (37.730649912467, -122.447198902106) | 9 | 7 | 4 | 28861 | 40 | |||
| 113846 | 207017 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 466 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5997128.21176 | 2093837.95674 | 37.7291156105912 | -122.452211290622 | (37.7291156105912, -122.452211290622) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |||
| 144424 | 116545 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 1 | Median : Yard | Tree | DPW 1 | 2 | 3x3 | 6001537.05763 | 2088100.5912 | 37.7136136745151 | -122.436559085032 | (37.7136136745151, -122.436559085032) | 9 | 7 | 6 | 28861 | 5 | |||
| 167819 | 176886 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 119 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002169.33644 | 2093633.71931 | 37.7288423165165 | -122.434769138285 | (37.7288423165165, -122.434769138285) | 9 | 7 | 6 | 28861 | 25 | |||
| 639 | 261347 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 1269 | 262440 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 1415 | 171287 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 339 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003711.94249 | 2092708.61039 | 37.7263896332495 | -122.429370301207 | (37.7263896332495, -122.429370301207) | 9 | 7 | 6 | 28861 | 5 | ||
| 1481 | 172310 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 63 Seville St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | Width 3ft | 6001999.53893 | 2087418.49495 | 37.7117670587831 | -122.434911834617 | (37.7117670587831, -122.434911834617) | 9 | 7 | 6 | 28861 | 5 | ||
| 1882 | 170658 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 399X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 4x6 | 6000800.50336 | 2092551.29112 | 37.7257924078835 | -122.439423717141 | (37.7257924078835, -122.439423717141) | 9 | 7 | 6 | 28861 | 25 | ||
| 2654 | 108556 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 62 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | Permit Number 773715 | 6001062.72482 | 2093636.21513 | 37.7287862806562 | -122.43859494063 | (37.7287862806562, -122.43859494063) | 9 | 7 | 6 | 28861 | 25 |
| 2939 | 262442 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 3013 | 109184 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 5 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774827 | 6002270 | 2092514.4 | 37.7257746335194 | -122.434341145327 | (37.7257746335194, -122.434341145327) | 9 | 7 | 6 | 28861 | 25 |
| 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 | ||
| 10461 | 170660 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2020 12:00:00 AM | 3 | Width 3ft | 6000886.10189 | 2092489.73569 | 37.7256282618212 | -122.439123400224 | (37.7256282618212, -122.439123400224) | 9 | 7 | 6 | 28861 | 25 | ||
| 12847 | 171236 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 39 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003761.27522 | 2093172.4115 | 37.7276659205371 | -122.429232817353 | (37.7276659205371, -122.429232817353) | 9 | 7 | 6 | 28861 | 5 | ||
| 13199 | 261348 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 13726 | 80104 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 425 Brazil Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 52309 | 6003144.80516 | 2091503.70271 | 37.7230491006299 | -122.43124489935 | (37.7230491006299, -122.43124489935) | 9 | 7 | 6 | 28861 | 5 | ||
| 13775 | 68397 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 88 Lyell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/02/2020 12:00:00 AM | 3 | Permit Number 785230 | 6003105.95459 | 2094517.30646 | 37.7313215783119 | -122.43159424368 | (37.7313215783119, -122.43159424368) | 9 | 7 | 5 | 28861 | 25 | |
| 14207 | 176903 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 290 Maynard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005283.95555 | 2093790.15237 | 37.7294481843731 | -122.424012796049 | (37.7294481843731, -122.424012796049) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |
| 14410 | 170659 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 399X San Juan Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | 6x4 | 6000830.95965 | 2092528.01217 | 37.7257302224446 | -122.439316764384 | (37.7257302224446, -122.439316764384) | 9 | 7 | 6 | 28861 | 25 | ||
| 14976 | 160069 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:26:00 AM | 3 | Width 0ft | 6000296.79811 | 2090527.78789 | 37.7202076512361 | -122.441019880684 | (37.7202076512361, -122.441019880684) | 9 | 7 | 6 | 28861 | 25 | ||
| 15013 | 170657 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 399X San Juan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000770.58972 | 2092571.08998 | 37.7258450685777 | -122.439528544816 | (37.7258450685777, -122.439528544816) | 9 | 7 | 6 | 28861 | 25 | ||
| 15290 | 25338 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 780859 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 15310 | 262443 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 15346 | 262448 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 145 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/09/2019 12:00:00 AM | 3 | 3x3 | 6001496 | 2093037 | 37.7271656105126 | -122.43705419947 | (37.7271656105126, -122.43705419947) | 9 | 7 | 6 | 28861 | 25 | |
| 15599 | 262439 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 99 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 4ft | 6001119 | 2093653 | 37.728835569179 | -122.438401596107 | (37.728835569179, -122.438401596107) | 9 | 7 | 6 | 28861 | 25 | ||
| 16027 | 261349 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 3300x Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/13/2020 12:00:00 AM | 3 | 3X3 | Permit Number 784323 | 5994476 | 2087151 | 37.7106025369579 | -122.460895688785 | (37.7106025369579, -122.460895688785) | 9 | 8 | 6 | 28861 | 24 | |
| 17357 | 116552 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 8 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001598.03525 | 2088202.06693 | 37.7138957693564 | -122.436355582838 | (37.7138957693564, -122.436355582838) | 9 | 7 | 6 | 28861 | 5 | |||
| 17874 | 170661 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 301X San Juan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2019 12:00:00 AM | 3 | Width 3ft | 6000920.86362 | 2092466.57168 | 37.7255666366796 | -122.439001572678 | (37.7255666366796, -122.439001572678) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |
| 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 | ||
| 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 | ||
| 29210 | 176917 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 9 | Median : Yard | Tree | DPW 1 | 3 | 6001514.03799 | 2088123.65893 | 37.7136757052349 | -122.436640299224 | (37.7136757052349, -122.436640299224) | 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 | ||
| 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 | ||
| 33674 | 27102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 669 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2009 12:00:00 AM | 3 | 3X3 | 6005822.11431 | 2093583.57584 | 37.7289113394767 | -122.422137656546 | (37.7289113394767, -122.422137656546) | 9 | 7 | 6 | 28861 | 5 | ||
| 35156 | 26976 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 504X Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2007 12:00:00 AM | 3 | 3x3 | 6004631.39194 | 2093482.01374 | 37.7285652398765 | -122.426246843332 | (37.7285652398765, -122.426246843332) | 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 | ||
| 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 | ||
| 42520 | 27117 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 415 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/03/2009 12:00:00 AM | 3 | 3X3 | 6004172.1589 | 2093507.51269 | 37.7286092859714 | -122.427836253857 | (37.7286092859714, -122.427836253857) | 9 | 7 | 6 | 28861 | 5 | ||
| 44017 | 116540 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 3 | Median : Yard | Tree | DPW 1 | 3 | 3x3 | 6001555.50616 | 2088195.95431 | 37.7138765688354 | -122.436502141754 | (37.7138765688354, -122.436502141754) | 9 | 7 | 6 | 28861 | 5 | |||
| 46761 | 27182 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 214 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/03/2015 07:50:00 AM | 3 | 2X3 | 6002674.64617 | 2093876.57211 | 37.7295378108224 | -122.433039593603 | (37.7295378108224, -122.433039593603) | 9 | 7 | 6 | 28861 | 25 | ||
| 47209 | 165132 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781230 | 5995776.8676 | 2094560.79185 | 37.7310228361347 | -122.456935228771 | (37.7310228361347, -122.456935228771) | 9 | 7 | 4 | 28861 | 40 |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 |
| 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 |
| 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 | ||
| 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 | ||
| 75681 | 227160 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 236 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003812.10722 | 2095285.7669 | 37.7334715974377 | -122.429207719083 | (37.7334715974377, -122.429207719083) | 2 | 7 | 5 | 28861 | 25 | |||
| 76214 | 37822 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 10 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:46:00 AM | 3 | 3x3 | Permit Number 40134 | 6003933.77466 | 2090481.79158 | 37.7202878374987 | -122.428444787301 | (37.7202878374987, -122.428444787301) | 9 | 7 | 6 | 28861 | 5 |
| 76315 | 27177 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 241 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2005 12:00:00 AM | 3 | 2X3 | 6002847.37275 | 2093824.85102 | 37.7294055924915 | -122.432438768257 | (37.7294055924915, -122.432438768257) | 9 | 7 | 6 | 28861 | 25 | ||
| 76325 | 253875 | Planning Code 138.1 required 2 | Lagunaria patersonii :: Primrose Tree 6 | 274 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 777423 | 6003013.5236 | 2093666.24958 | 37.728979528994 | -122.431853049446 | (37.728979528994, -122.431853049446) | 9 | 7 | 6 | 28861 | 25 | |
| 80180 | 160063 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1000 Cayuga Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2017 11:07:00 AM | 3 | Width 0ft | 6000471.59074 | 2090857.95331 | 37.7211241647202 | -122.440439349407 | (37.7211241647202, -122.440439349407) | 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 | ||
| 82967 | 25763 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1682 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/20/2015 06:02:00 PM | 3 | 2X3 | 6004184.86566 | 2087196.38583 | 37.711281031873 | -122.427342931648 | (37.711281031873, -122.427342931648) | 9 | 7 | 6 | 28861 | 5 | ||
| 84190 | 253150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 450X Moscow St | 3 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/11/2017 09:41:00 AM | 3 | 3x3 | 6003965.72194 | 2090553.13154 | 37.7204855291627 | -122.428339438009 | (37.7204855291627, -122.428339438009) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | ||
| 92269 | 165133 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 929 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781230 | 5995820.38989 | 2094571.40487 | 37.731054476063 | -122.456785533051 | (37.731054476063, -122.456785533051) | 9 | 7 | 4 | 28861 | 40 |
| 93865 | 109578 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 10X Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775018 | 6002262.55573 | 2092599.72242 | 37.7260084870829 | -122.434372977031 | (37.7260084870829, -122.434372977031) | 9 | 7 | 6 | 28861 | 25 |
| 94734 | 207019 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 234 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5998513.62611 | 2093807.4558 | 37.7291111292533 | -122.447419626323 | (37.7291111292533, -122.447419626323) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | ||
| 99068 | 176488 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 295 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/11/2017 09:25:00 AM | 3 | Width 2ft | 6004452.71642 | 2090718.28415 | 37.7209665468512 | -122.4266678079 | (37.7209665468512, -122.4266678079) | 9 | 7 | 6 | 28861 | 5 | ||
| 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 | ||
| 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 | ||
| 101773 | 176894 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 La Grande Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005238.00808 | 2092009.90059 | 37.7245574102793 | -122.424045090732 | (37.7245574102793, -122.424045090732) | 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) );