1,985 rows where qSpecies_id = 83 sorted by Neighborhoods (old)

View and edit SQL

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) ▼
136459 11468 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 39X Hawkins Ln 3 Sidewalk: Curb side : Cutout Tree Private 2   09/25/1992 12:00:00 AM 6 3X3   6016817.53474 2095601.45988 37.7350660954277 -122.384265809434 (37.7350660954277, -122.384265809434) 10 3 8 58 1
136709 88488 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1600 Quesada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.7324604500235 -122.389636207884 (37.7324604500235, -122.389636207884) 10 3 8 58 1
136753 197134 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 220 Newhall St 1 : Tree Private 2     2 Width 3ft   6016745.12895 2098337.97655 37.7425760145669 -122.384706709273 (37.7425760145669, -122.384706709273) 10 3 8 58 1
137619 18638 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 25 Reuel Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/04/1998 12:00:00 AM 3 3X4   6017121.1361855 2096199.8633465 37.7367259740336 -122.383257779638 (37.7367259740336, -122.383257779638) 10 3 8 58 1
138737 85634 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1690X Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6014848.267124 2094950.029371 37.733168318034 -122.391028811832 (37.733168318034, -122.391028811832) 10 3 8 58 1
139167 199972 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1200 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6017032.2494 2092637.585 37.7269397498685 -122.383317211424 (37.7269397498685, -122.383317211424) 10 3 8 58 1
140235 85629 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1490 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015857.024431 2094199.26405 37.7311627918046 -122.387488877238 (37.7311627918046, -122.387488877238) 10 3 8 58 1
140511 24090 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 125X Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1997 12:00:00 AM 6 3x3   6016342.36416 2095991.2568 37.736110114791 -122.3859358217 (37.736110114791, -122.3859358217) 10 3 8 58 1
142222 88466 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 955X Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/11/2008 12:00:00 AM 4 3x3 Permit Number 51410 6015306.946426 2096847.395831 37.7384035424873 -122.389575486471 (37.7384035424873, -122.389575486471) 10 3 8 58 1
142318 85637 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1177 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017561.518521 2092878.758124 37.7276311998388 -122.381504284348 (37.7276311998388, -122.381504284348) 10 3 8 58 1
142465 6845 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 595X Newhall St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1992 12:00:00 AM 6 3x3   6015936.9719 2097716.00593 37.7408234823092 -122.387457724609 (37.7408234823092, -122.387457724609) 10 3 8 58 1
144390 200748 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1667 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6014912.0282 2094835.2906 37.7328568065588 -122.390800355017 (37.7328568065588, -122.390800355017) 10 3 8 58 1
144681 18636 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 20 Reuel Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/19/2000 12:00:00 AM 3 3X3   6017095.3922155 2096110.4018038 37.736478907812 -122.3833405631 (37.736478907812, -122.3833405631) 10 3 8 58 1
148281 82705 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 67 Jennings Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2009 12:00:00 AM   3x3 Permit Number 52460 6012945.60921507 2089212.94135713 37.7173096765194 -122.397204701992 (37.7173096765194, -122.397204701992) 10 3 8 58 1
150380 197163 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 15 Reuel Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017071.14695 2096120.91017 37.7365064217414 -122.383425121372 (37.7365064217414, -122.383425121372) 10 3 8 58 1
150888 85630 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1518 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015608.4708 2094395.709 37.7316884205401 -122.388361884277 (37.7316884205401, -122.388361884277) 10 3 8 58 1
151215 85623 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1404 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016275.7207 2093898.407 37.7303598794973 -122.386020392504 (37.7303598794973, -122.386020392504) 10 3 8 58 1
151238 197160 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 11 Mabrey Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6016488.26571 2095902.24457 37.7358737783612 -122.385425174944 (37.7358737783612, -122.385425174944) 10 3 8 58 1
151991 27141 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1775 Silver Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6011398.08877 2095346.30396 37.7340643486912 -122.402984937921 (37.7340643486912, -122.402984937921) 10 3 8 58 1
155013 1699 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 42 Baldwin Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/1999 12:00:00 AM 3 3X3   6017775.3254178 2093648.0174938 37.7297552383916 -122.380818597255 (37.7297552383916, -122.380818597255) 10 3 8 58 1
156240 200741 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1667 Quesada Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6014891.7516 2094855.5671 37.7329113566731 -122.390871873557 (37.7329113566731, -122.390871873557) 10 3 8 58 1
157394 87158 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 119 Augusta St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2008 12:00:00 AM 7 3x3 Permit Number 50139 6011083.99361 2095446.91838 37.7343230701451 -122.404077946949 (37.7343230701451, -122.404077946949) 10 3 8 58 1
158007 197164 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 15 Reuel Ct 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017108.57308 2096118.78323 37.7365026499645 -122.383295574057 (37.7365026499645, -122.383295574057) 10 3 8 58 1
158258 85642 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1227 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017224.223609 2093130.194602 37.7283029670068 -122.382687817525 (37.7283029670068, -122.382687817525) 10 3 8 58 1
159990 88487 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1600 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.7324604500235 -122.389636207884 (37.7324604500235, -122.389636207884) 10 3 8 58 1
162226 200738 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1667 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6014840.7331 2094895.4662 37.7330180805666 -122.391051046853 (37.7330180805666, -122.391051046853) 10 3 8 58 1
162397 73566 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1531 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51073 6015551.1974 2096459.91912 37.7373531505315 -122.388703936761 (37.7373531505315, -122.388703936761) 10 3 8 58 1
163192 85614 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1200X Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 5 3x3   6017331.5604 2093113.8652 37.7282640589934 -122.382315610259 (37.7282640589934, -122.382315610259) 10 3 8 58 1
163260 11467 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 39X Hawkins Ln 2 Sidewalk: Curb side : Cutout Tree Private 2   09/25/1992 12:00:00 AM 8 3X3   6016799.4589 2095596.15734 37.7350505362442 -122.384327935502 (37.7350505362442, -122.384327935502) 10 3 8 58 1
165958 101777 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1700 Yosemite Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6014038.07825 2093123.59043 37.7281082970403 -122.393702081811 (37.7281082970403, -122.393702081811) 10 3 8 58 1
166128 10610 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 29 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 6 3X3   6016939.38433 2095525.04578 37.7348630141201 -122.383839208838 (37.7348630141201, -122.383839208838) 10 3 8 58 1
166801 85633 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1590 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015320.4739 2094608.4089 37.7322564888471 -122.389372403809 (37.7322564888471, -122.389372403809) 10 3 8 58 1
167397 85616 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1258 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017082.7023 2093297.2628 37.7287538840188 -122.383188691469 (37.7287538840188, -122.383188691469) 10 3 8 58 1
168996 85626 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1454 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016038.1604 2094077.7893 37.7308392772335 -122.38685418415 (37.7308392772335, -122.38685418415) 10 3 8 58 1
169391 200740 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1667 Quesada Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6014877.3618 2094866.6866 37.7329410901234 -122.390922400079 (37.7329410901234, -122.390922400079) 10 3 8 58 1
171736 85638 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1201X Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017293.1497 2093067.8806 37.7281356725879 -122.382445200849 (37.7281356725879, -122.382445200849) 10 3 8 58 1
173196 24167 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 110X Whitney Young Cir 18 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2011 12:00:00 AM 2 3x3   6016346.0952597 2096044.1423309 37.736255534298 -122.385926606914 (37.736255534298, -122.385926606914) 10 3 8 58 1
173937 197122 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2 Napoleon St 4 : Tree Private 2     5 Width 4ft   6013973.73168 2100142.08459 37.7473760542581 -122.394415755007 (37.7473760542581, -122.394415755007) 10 3 8 58 1
174114 85610 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1132 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017745.1516 2092811.7191 37.7274572605947 -122.380864797529 (37.7274572605947, -122.380864797529) 10 3 8 58 1
174721 85618 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1314 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016773.2527 2093530.973 37.7293785009559 -122.384274758873 (37.7293785009559, -122.384274758873) 10 3 8 58 1
175370 197130 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400 Newhall St 16 : Tree Private 2     5 Width 3ft   6015893.18708 2097747.64492 37.7409079313583 -122.387611324313 (37.7409079313583, -122.387611324313) 10 3 8 58 1
175922 197154 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 18 Hawkins Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017001.63224 2095478.16332 37.7347377250702 -122.383620731122 (37.7347377250702, -122.383620731122) 10 3 8 58 1
176745 85639 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1201X Quesada Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017307.7565 2093058.1427 37.7281097410693 -122.382394026885 (37.7281097410693, -122.382394026885) 10 3 8 58 1
176763 197157 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 106 Whitney Young Cir 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6016598.78719 2095669.6865 37.7352413346217 -122.385026857123 (37.7352413346217, -122.385026857123) 10 3 8 58 1
176900 88478 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1514 McKinnon Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51430 6015856.3 2095628.5 37.7350871465747 -122.387591057509 (37.7350871465747, -122.387591057509) 10 3 8 58 1
180012 85640 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1201X Quesada Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017322.9044 2093043.5358 37.7280704700942 -122.382340643729 (37.7280704700942, -122.382340643729) 10 3 8 58 1
183966 197150 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 102 Whitney Young Cir 14 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6016678.04362 2095528.85162 37.7348590139212 -122.38474302839 (37.7348590139212, -122.38474302839) 10 3 8 58 1
184497 199941 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1161 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6017637.764 2092806.0386 37.7274357354826 -122.381235645904 (37.7274357354826, -122.381235645904) 10 3 8 58 1
184542 24098 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 5 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.081358 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885) 10 3 8 58 1
185252 1848 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2401 Bay Shore Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6011043.02806 2086938.15421 37.7109574665846 -122.403621108454 (37.7109574665846, -122.403621108454) 10 3 8 309 1
185801 197135 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 901 Newhall St 2 : Tree Private 2     5 Width 3ft   6015262.92854 2096819.74111 37.7383251674823 -122.389725749154 (37.7383251674823, -122.389725749154) 10 3 8 58 1
186339 85654 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1699X Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6014788.408146 2094944.773563 37.7331505648623 -122.391235394882 (37.7331505648623, -122.391235394882) 10 3 8 58 1
189409 16496 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 305X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1   01/30/2003 12:00:00 AM 3 3x3   6016807.79285 2098273.54956 37.7424025765764 -122.384485547297 (37.7424025765764, -122.384485547297) 10 3 8 58 1
189620 197147 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 65 Whitney Young Cir 22 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017204.67342 2094944.70699 37.7332841805136 -122.382881628681 (37.7332841805136, -122.382881628681) 10 3 8 58 1
191969 88491 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1600 Quesada Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51434 6015245.7 2094684.2 37.7324604500235 -122.389636207884 (37.7324604500235, -122.389636207884) 10 3 8 58 1
192309 85631 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1556 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015497.489334 2094466.503619 37.7318766579731 -122.388750513143 (37.7318766579731, -122.388750513143) 10 3 8 58 1
192376 16544 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016074.64629 2097992.47705 37.7415902397879 -122.387000971524 (37.7415902397879, -122.387000971524) 10 3 8 58 1
192496 85645 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1313 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016677.8494 2093524.29 37.7293548752151 -122.384604114815 (37.7293548752151, -122.384604114815) 10 3 8 58 1
1044 139272 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 765 FULTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004185.2644 2111476.3212 37.7779481591061 -122.429071593475 (37.7779481591061, -122.429071593475) 7 9 11 28852 10
1241 140612 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 880 Fillmore St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003492.8085 2111354.3072 37.777573917235 -122.431458329369 (37.777573917235, -122.431458329369) 7 9 11 29492 10
2769 81793 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 435 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5 3x3   6005759.2342 2111006.7416 37.7767477786156 -122.423593274768 (37.7767477786156, -122.423593274768) 7 9 11 28852 10
7946 74150 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 740 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6004499.396 2111088.6935 37.7769016055642 -122.427957272174 (37.7769016055642, -122.427957272174) 7 9 11 28852 10
10522 31312 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 709 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM     Permit Number 34949 6004473.77987727 2110903.29372292 37.7763910940647 -122.428032671161 (37.7763910940647, -122.428032671161) 7 9 11 28852 10
18871 108376 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 995X Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2015 12:00:00 AM 3   Permit Number 775198 6003269.72698 2111024.20368 37.7766548889563 -122.432206462364 (37.7766548889563, -122.432206462364) 15 9 11 29492 10
19624 31313 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 709 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/1995 12:00:00 AM 7   Permit Number 34949 6004462.32974 2110985.15865 37.7766152272516 -122.428078115713 (37.7766152272516, -122.428078115713) 7 9 11 28852 10
19667 7175 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 814 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1993 12:00:00 AM 6 3X3   6003515.423 2111193.7442 37.7771343327183 -122.431368633672 (37.7771343327183, -122.431368633672) 7 9 11 29492 10
23938 237023 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 8 Octavia St 4 : Tree DPW 1   04/15/2017 01:44:00 PM 3 Width 6ft   6005765.01716 2109438.39176 37.7724417955802 -122.423461745458 (37.7724417955802, -122.423461745458) 7 9 11 28852 10
27515 139278 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 725 FULTON ST 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004349.2802 2111499.4808 37.7780210326226 -122.428505855992 (37.7780210326226, -122.428505855992) 7 9 11 28852 10
27967 30728 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 45 Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM     Permit Number 34624 6006303.86733164 2109861.47838862 37.7736338888904 -122.421627862373 (37.7736338888904, -122.421627862373) 7 9 11 28852 10
29821 138936 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 611 Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6004391.0086 2110998.5233 37.7766478878909 -122.428325789109 (37.7766478878909, -122.428325789109) 7 9 11 28852 10
32470 110524 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 995X Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2015 12:00:00 AM 3   Permit Number 775198 6003269.72698 2111024.20368 37.7766548889563 -122.432206462364 (37.7766548889563, -122.432206462364) 15 9 11 29492 10
33160 20136 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 890 Steiner St 1 Sidewalk: Curb side : Cutout Landscaping Private 2   01/11/2011 12:00:00 AM 3 8x4 Permit Number 54087 6003007 2111306 37.777413731872 -122.433135450293 (37.777413731872, -122.433135450293) 15 9 11 29492 10
36615 138937 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 609 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004415.7448 2111001.1974 37.7766566299655 -122.428240409959 (37.7766566299655, -122.428240409959) 7 9 11 28852 10
37445 118287 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 240 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x2.5   6006177 2111293 37.7775573470216 -122.422168438332 (37.7775573470216, -122.422168438332) 7 9 11 28852 10
37742 7193 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 898 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/19/1992 12:00:00 AM 6 3X3   6003489.55797 2111353.68492 37.7775720243799 -122.431469529604 (37.7775720243799, -122.431469529604) 7 9 11 29492 10
39609 8107 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 785 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1998 12:00:00 AM 3 4X4   6004040.71712 2111448.77193 37.7778643322695 -122.429569668288 (37.7778643322695, -122.429569668288) 7 9 11 28852 10
46951 138951 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 713 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6004468.8943 2110977.1298 37.7765935534027 -122.428054834694 (37.7765935534027, -122.428054834694) 7 9 11 28852 10
51039 139399 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 896 STEINER ST 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 0ft   6003012.8594 2111291.1403 37.7773732632111 -122.433114118747 (37.7773732632111, -122.433114118747) 15 9 11 29492 10
51623 109438 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 940 Grove St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3     6003118.8 2111045.9 37.7767059032045 -122.432730112861 (37.7767059032045, -122.432730112861) 15 9 11 29492 10
54267 139271 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 765 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6004149.5758 2111471.3855 37.7779325866279 -122.429194700927 (37.7779325866279, -122.429194700927) 7 9 11 28852 10
56169 109439 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 800x STEINER ST 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3 3.5x6.5   6003118 2111045 37.7767033866571 -122.432732815988 (37.7767033866571, -122.432732815988) 15 9 11 29492 10
59153 100410 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
60223 97605 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 445 Hayes St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/27/2011 12:00:00 AM 2 3x3 Permit Number 768351 6005728.0342 2111001.8882 37.7767326912067 -122.423700859813 (37.7767326912067, -122.423700859813) 7 9 11 28852 10
67502 57721 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 231 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/19/2010 12:00:00 AM     Permit Number 53634 6004597.07146519 2109103.26366214 37.7714556250816 -122.427477905237 (37.7714556250816, -122.427477905237) 7 9 11 28852 10
70975 31336 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 745 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM 9   Permit Number 34951 6004456.33645 2111073.11505 37.776856394839 -122.42810511786 (37.776856394839, -122.42810511786) 7 9 11 28852 10
78779 8084 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 755X Fulton St 3 Sidewalk: Curb side : Cutout Tree DPW 1   12/14/2007 12:00:00 AM 3 3X3   6004115.11785 2111289.80956 37.7774320731857 -122.429300951982 (37.7774320731857, -122.429300951982) 7 9 11 28852 10
88172 31311 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 709 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/12/1995 12:00:00 AM     Permit Number 34949 6004473.77987727 2110903.29372292 37.7763910940647 -122.428032671161 (37.7763910940647, -122.428032671161) 7 9 11 28852 10
88388 139267 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 785 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004042.8897 2111456.1989 37.7778848479076 -122.429562682385 (37.7778848479076, -122.429562682385) 7 9 11 28852 10
88877 109440 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 800x STEINER ST 2 Sidewalk: Curb side : Cutout Tree Private 2   02/18/2015 12:00:00 AM 3 6.5x3.5   6003118 2111045 37.7767033866571 -122.432732815988 (37.7767033866571, -122.432732815988) 15 9 11 29492 10
90800 8083 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 755X Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/14/1998 12:00:00 AM 6 3X3   6004278.93609 2111494.41804 37.7780031505288 -122.428748840382 (37.7780031505288, -122.428748840382) 7 9 11 28852 10
92180 138832 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 745 BUCHANAN ST 4 Sidewalk: Curb side : Yard Tree Private 2     9 Width 0ft   6004455.5234 2111072.8991 37.7768557558926 -122.428107915053 (37.7768557558926, -122.428107915053) 7 9 11 28852 10
94091 244319 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 331 Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/02/2017 04:00:00 PM 3 Width 0ft   6005497.6412 2110517.1934 37.7753888290162 -122.424463374134 (37.7753888290162, -122.424463374134) 7 9 11 28852 10
96679 142043 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 401 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6005850.7541 2111017.8349 37.776783403594 -122.423277468562 (37.776783403594, -122.423277468562) 7 9 11 28852 10
98292 139277 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 725 FULTON ST 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004315.8695 2111494.5451 37.778005589649 -122.428621083615 (37.778005589649, -122.428621083615) 7 9 11 28852 10
100200 237022 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 8 Octavia St 3 : Tree DPW 1   04/15/2017 01:40:00 PM 3 Width 6ft   6005770.13323 2109412.50366 37.772371001847 -122.423442207693 (37.772371001847, -122.423442207693) 7 9 11 28852 10
102932 237024 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 8 Octavia St 5 : Tree DPW 1   04/15/2017 01:48:00 PM 3 Width 6ft   6005763.84021 2109451.72322 37.772478334131 -122.423466764586 (37.772478334131, -122.423466764586) 7 9 11 28852 10
104496 10234 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 47 Haight St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/29/2011 12:00:00 AM 3 4x4   6005872.37024 2109570.63288 37.7728109564944 -122.423099801515 (37.7728109564944, -122.423099801515) 7 9 11 28852 10
115665 100415 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 201x Linden St 6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 767727 6006435 2110776 37.7761523386864 -122.421239206856 (37.7761523386864, -122.421239206856) 7 9 11 28852 10
116196 139287 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 894 STEINER ST 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 0ft   6003017.2906 2111263.9995 37.7772989926884 -122.433096850145 (37.7772989926884, -122.433096850145) 15 9 11 29492 10
121737 33691 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 625 Ivy St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1996 12:00:00 AM     Permit Number 37764 6004364.86581498 2110979.96495009 37.776595451913 -122.428414901604 (37.776595451913, -122.428414901604) 7 9 11 28852 10

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