trees
290 rows where Police Districts = 7 and qSpecies_id = 6 sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8 | 264824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6012032 | 2089425 | 37.7178410421308 | -122.400377527521 | (37.7178410421308, -122.400377527521) | 10 | 7 | 8 | 309 | 39 | |||
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 | ||
2299 | 27284 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 636 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/04/2009 12:00:00 AM | 3 | 3X3 | 6005588.17954 | 2093528.26307 | 37.7287462653044 | -122.422942457136 | (37.7287462653044, -122.422942457136) | 9 | 7 | 7 | 309 | 5 | ||
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 | ||
3652 | 248155 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010048.23979 | 2099492.44346 | 37.7453732829604 | -122.40794409015 | (37.7453732829604, -122.40794409015) | 2 | 7 | 7 | 28859 | 2 | |||
5588 | 227150 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 808 Crescent Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008185.20329 | 2095640.92661 | 37.7346933830922 | -122.414113755053 | (37.7346933830922, -122.414113755053) | 2 | 7 | 7 | 28859 | 2 | |||
7686 | 116544 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 7 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001586.02621 | 2088182.95127 | 37.7138425996209 | -122.436395723209 | (37.7138425996209, -122.436395723209) | 9 | 7 | 6 | 28861 | 5 | |||
9404 | 176900 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005606.72127 | 2092829.97134 | 37.7268299557374 | -122.422828750447 | (37.7268299557374, -122.422828750447) | 9 | 7 | 7 | 309 | 5 | |||
9408 | 259103 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 625 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010501.76504 | 2086856.29359 | 37.7107024439005 | -122.405486089504 | (37.7107024439005, -122.405486089504) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||
12813 | 207010 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 305 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999351.3193 | 2094355.62728 | 37.7306641145479 | -122.444563045861 | (37.7306641145479, -122.444563045861) | 9 | 7 | 4 | 28861 | 40 | |||
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 | ||
12906 | 27193 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 284 Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2009 12:00:00 AM | 6 | 3X3 | 6003096.09594 | 2093601.65823 | 37.7288068562446 | -122.431562981455 | (37.7288068562446, -122.431562981455) | 9 | 7 | 6 | 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 | |||
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 | ||
15168 | 259102 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 619 Visitacion Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6010517.89431 | 2086850.21293 | 37.7106866494876 | -122.405429914879 | (37.7106866494876, -122.405429914879) | 9 | 7 | 8 | 309 | 39 | |||
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 | ||
16773 | 70408 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 266 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6006531.16259 | 2092699.03842 | 37.7265225593592 | -122.419623688079 | (37.7265225593592, -122.419623688079) | 9 | 7 | 7 | 309 | 5 | |||
17284 | 81630 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 50 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5999996.8419 | 2093367.66723 | 37.7279882186648 | -122.44226048643 | (37.7279882186648, -122.44226048643) | 9 | 7 | 6 | 28861 | 25 | |||
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 | ||
17906 | 219682 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 250 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2019 12:00:00 AM | 3 | 3x3 | 6008245.78846 | 2097431.26822 | 37.7396126728914 | -122.414030905009 | (37.7396126728914, -122.414030905009) | 2 | 7 | 7 | 28859 | 2 | ||
18371 | 27202 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003502.33889 | 2093475.71167 | 37.7284840526724 | -122.430149591636 | (37.7284840526724, -122.430149591636) | 9 | 7 | 6 | 28861 | 5 | ||
19808 | 207047 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 654 Joost Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5997739.24902 | 2095008.66176 | 37.7323650733825 | -122.450183245677 | (37.7323650733825, -122.450183245677) | 9 | 7 | 4 | 59 | 40 | |||
19865 | 227149 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 530 Crescent Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007719.36141 | 2095678.53729 | 37.7347704774588 | -122.415726995823 | (37.7347704774588, -122.415726995823) | 2 | 7 | 7 | 28859 | 2 | |||
21651 | 27207 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003623.95003 | 2093470.28644 | 37.7284760433174 | -122.429728788952 | (37.7284760433174, -122.429728788952) | 9 | 7 | 6 | 28861 | 5 | ||
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 | |||
25424 | 176901 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005600.43917 | 2092849.05844 | 37.7268820102711 | -122.422851823466 | (37.7268820102711, -122.422851823466) | 9 | 7 | 7 | 309 | 5 | |||
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 | |||
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 | ||
29101 | 176889 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004392.5622 | 2091665.65248 | 37.7235644112504 | -122.426943181195 | (37.7235644112504, -122.426943181195) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||||
29761 | 176907 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 769 Silver Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006492.03782 | 2093629.408 | 37.7290749477448 | -122.419824929392 | (37.7290749477448, -122.419824929392) | 9 | 7 | 7 | 309 | 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 | ||
30613 | 227099 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010635.77556 | 2100089.10311 | 37.7470444571367 | -122.405954501114 | (37.7470444571367, -122.405954501114) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
31662 | 27080 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 799X Silver Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2009 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.72947 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | 9 | 7 | 7 | 309 | 5 | ||
31769 | 227126 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1689 Noe St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 4ft | 6003395.21055 | 2098417.4445 | 37.742046857971 | -122.430872467617 | (37.742046857971, -122.430872467617) | 2 | 7 | 5 | 63 | 22 | |||
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 | ||
36462 | 227586 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 494 Arlington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6003707.36504 | 2095900.15245 | 37.7351526308975 | -122.429613645169 | (37.7351526308975, -122.429613645169) | 2 | 7 | 5 | 63 | 7 | |||
37676 | 176896 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005242.33299 | 2091887.73518 | 37.7242222149627 | -122.424021456542 | (37.7242222149627, -122.424021456542) | 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 | ||
39385 | 227113 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 201 Ogden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007896.8692 | 2096132.1903 | 37.736026086627 | -122.415145389863 | (37.736026086627, -122.415145389863) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
44532 | 227109 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 72 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008318.15108 | 2098296.22562 | 37.741991719651 | -122.41384187381 | (37.741991719651, -122.41384187381) | 2 | 7 | 7 | 28859 | 2 | |||
45396 | 227112 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 82 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007863.71848 | 2099963.32211 | 37.7465436642568 | -122.41553116305 | (37.7465436642568, -122.41553116305) | 2 | 7 | 7 | 28859 | 2 | |||
45819 | 207011 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 16 Circular Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001351.22893 | 2094512.68179 | 37.7312092646733 | -122.437660309391 | (37.7312092646733, -122.437660309391) | 9 | 7 | 4 | 63 | 40 | |||
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 | ||
47657 | 207016 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 409 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5998750.98669 | 2094179.12135 | 37.7301451967391 | -122.446625784855 | (37.7301451967391, -122.446625784855) | 9 | 7 | 4 | 28861 | 40 | |||
48472 | 207040 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5996029.16987 | 2093727.86128 | 37.7287502942706 | -122.456002788314 | (37.7287502942706, -122.456002788314) | 9 | 7 | 4 | 28861 | 40 | |||
49312 | 227087 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009571.14847 | 2096096.9094 | 37.7360231620273 | -122.409354219042 | (37.7360231620273, -122.409354219042) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
53980 | 207012 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 16 Circular Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001339.26796 | 2094505.80603 | 37.731189705325 | -122.437701168268 | (37.731189705325, -122.437701168268) | 9 | 7 | 4 | 63 | 40 | |||
55754 | 176898 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 167 Madison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6005619.38027 | 2092788.13013 | 37.7267157831975 | -122.422782016296 | (37.7267157831975, -122.422782016296) | 9 | 7 | 7 | 309 | 5 | |||
55846 | 227161 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Leese St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005575.79788 | 2096114.93647 | 37.7358479983778 | -122.423169051236 | (37.7358479983778, -122.423169051236) | 2 | 7 | 7 | 28859 | 2 | |||
56393 | 176895 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 70 La Grande Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005265.09064 | 2091962.62602 | 37.7244291336757 | -122.42394810962 | (37.7244291336757, -122.42394810962) | 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 | ||
57763 | 207044 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 755 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998014.32968 | 2095894.50831 | 37.7348131350024 | -122.44929603208 | (37.7348131350024, -122.44929603208) | 9 | 7 | 4 | 59 | 40 | |||
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 | ||
58866 | 116551 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1002x Naples St | 7 | Median : Yard | Tree | DPW 1 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.436608560332 | (37.713721490625, -122.436608560332) | 9 | 7 | 6 | 28861 | 5 | |||
62739 | 227079 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 7ft | 6006194.41732 | 2099504.07308 | 37.7451886989034 | -122.421270828796 | (37.7451886989034, -122.421270828796) | 2 | 7 | 5 | 28859 | 2 | |||
64767 | 227098 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009270.38668 | 2099790.72722 | 37.7461487242839 | -122.410654850958 | (37.7461487242839, -122.410654850958) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
65352 | 176897 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 338 Oxford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6006634.64196 | 2092369.41813 | 37.7256233218417 | -122.419242591383 | (37.7256233218417, -122.419242591383) | 9 | 7 | 7 | 309 | 5 | |||
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 | |||
69235 | 116543 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1041x Naples St | 6 | Median : Yard | Tree | DPW 1 | 5 | 3x3 | 6001574.84931 | 2088164.89401 | 37.7137923832878 | -122.43643306305 | (37.7137923832878, -122.43643306305) | 9 | 7 | 6 | 28861 | 5 | |||
70068 | 207041 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1414 Plymouth Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995889.45634 | 2093373.14104 | 37.727768297568 | -122.456460143934 | (37.727768297568, -122.456460143934) | 9 | 7 | 4 | 28861 | 40 | |||
72338 | 227121 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 791 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6001433.87774 | 2099966.59062 | 37.7461891245209 | -122.437765046244 | (37.7461891245209, -122.437765046244) | 2 | 7 | 5 | 63 | 22 | |||
74921 | 227129 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 291 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6001319.20971 | 2096463.36674 | 37.7365635736601 | -122.437910673444 | (37.7365635736601, -122.437910673444) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
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 | ||
77256 | 227128 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 248 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004363.96226 | 2096949.74054 | 37.7380717187222 | -122.427418297528 | (37.7380717187222, -122.427418297528) | 2 | 7 | 5 | 63 | 7 | |||
78745 | 176904 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 68 Cambridge St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6006443.50632 | 2094472.10137 | 37.7313860651023 | -122.420052485745 | (37.7313860651023, -122.420052485745) | 9 | 7 | 7 | 28861 | 5 | |||
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 | ||||
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 | ||
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 | |||
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 | ||
81845 | 227152 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 105 Manchester St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6008289 | 2099369 | 37.7449356835318 | -122.414018543543 | (37.7449356835318, -122.414018543543) | 2 | 7 | 7 | 28859 | 2 | |||
81876 | 227086 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 6009619.77164 | 2096165.81934 | 37.7362150980513 | -122.409190969587 | (37.7362150980513, -122.409190969587) | 10 | 7 | 7 | 28859 | 2 | |||
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 | ||
83192 | 227092 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 30 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 9ft | 6009197.49082 | 2095788.04823 | 37.7351541534232 | -122.410624304588 | (37.7351541534232, -122.410624304588) | 10 | 7 | 7 | 28859 | 2 | |||
83985 | 227091 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 29 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6009293.03444 | 2095834.73547 | 37.735287702767 | -122.410297269721 | (37.735287702767, -122.410297269721) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |
86875 | 227097 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1650 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009272.78227 | 2099754.56661 | 37.7460495695343 | -122.410644014106 | (37.7460495695343, -122.410644014106) | 2 | 7 | 7 | 28859 | 2 | |||
87197 | 27205 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003575.96193 | 2093472.33897 | 37.7284789616109 | -122.429894832577 | (37.7284789616109, -122.429894832577) | 9 | 7 | 6 | 28861 | 5 | ||
87299 | 27282 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 710 Silver Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6006026.1077 | 2093547.18457 | 37.7288229208214 | -122.421429852322 | (37.7288229208214, -122.421429852322) | 9 | 7 | 7 | 309 | 5 | ||
89299 | 227085 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 100 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009638.60709 | 2096225.80995 | 37.7363808745699 | -122.409130079214 | (37.7363808745699, -122.409130079214) | 10 | 7 | 7 | 28859 | 2 | |||
91908 | 27212 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 302 Silver Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1999 12:00:00 AM | 6 | 3X3 | 6003753.294 | 2093466.82209 | 37.7284738543786 | -122.429281393342 | (37.7284738543786, -122.429281393342) | 9 | 7 | 6 | 28861 | 5 | ||
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 |
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) );