202 rows where Zip Codes = 28861 and qSpecies_id = 6

View and edit SQL

Zip Codes

  • 28861 · 202
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)
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
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
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
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
12664 45661 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 315 London St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/06/2001 12:00:00 AM 6   Permit Number 44357 6002302.86118 2091870.52112 37.7240085522374 -122.434181537449 (37.7240085522374, -122.434181537449) 9 7 6 28861 5
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
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
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
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
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
21610 83554 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 117X Peru Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003920.58239 2093359.59743 37.7281889086723 -122.428695428367 (37.7281889086723, -122.428695428367) 9 7 6 28861 5
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
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
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
27543 83558 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 483 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 7 3x3 Permit Number 52321 6001949.50225 2090800.06366 37.7210492547906 -122.435326507535 (37.7210492547906, -122.435326507535) 9 7 6 28861 5
27595 63507 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 574 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/1987 12:00:00 AM 4   Permit Number 24113 6001588.8915 2090307.92108 37.7196774559426 -122.436537823274 (37.7196774559426, -122.436537823274) 9 7 6 28861 5
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
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
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
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
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
34235 207024 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 85 Williar Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5997067.34432 2090557.59428 37.7201050223995 -122.452185117661 (37.7201050223995, -122.452185117661) 9 8 6 28861 24
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
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
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
41858 83563 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 422 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2012 12:00:00 AM 5 3x3 Permit Number 769753 6002333.87212 2090986.92404 37.7215841526661 -122.434011205875 (37.7215841526661, -122.434011205875) 9 7 6 28861 5
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
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
48782 83518 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 117X Peru Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 5 3x3 Permit Number 769748 6003951.4498 2093338.17621 37.7281318376981 -122.428587192249 (37.7281318376981, -122.428587192249) 9 7 6 28861 5
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
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
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
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
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
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
67542 95712 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 642 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM 5 3x3 Permit Number 767468 6003074.18539 2089625.7401 37.7178886288451 -122.431355025819 (37.7178886288451, -122.431355025819) 9 7 6 28861 5
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
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
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
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
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
77796 83657 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 7 Lisbon St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM 7   Permit Number 769748 6003905.60089 2093401.91906 37.728304266518 -122.428750235745 (37.728304266518, -122.428750235745) 9 7 6 28861 5
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
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
84495 52937 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 436@THERESA Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/2006 12:00:00 AM 9   Permit Number 48924 6002078.69882 2093873.61529 37.7294958700207 -122.435099629266 (37.7294958700207, -122.435099629266) 9 7 6 28861 25
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
84873 69398 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 1174 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/1994 12:00:00 AM 6   Permit Number 33502 6001210.49529 2087131.44104 37.7109340401325 -122.43761843606 (37.7109340401325, -122.43761843606) 9 7 6 28861 5
85730 43321 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 283 Athens St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2007 12:00:00 AM 5 3x3 Permit Number 49915 6004368.56572 2091597.24704 37.7233752280736 -122.427021263027 (37.7233752280736, -122.427021263027) 9 7 6 28861 5
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
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
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
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
92790 37817 DPW Maintained 1 Lagunaria patersonii :: Primrose Tree 6 450X Moscow St 5 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003961.27408 2090526.10251 37.7204110616965 -122.428352887393 (37.7204110616965, -122.428352887393) 9 7 6 28861 5

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