290 rows where Police Districts = 7 and qSpecies_id = 6 sorted by PermitNotes

View and edit SQL

Police Districts

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);