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) ▼
449 252970 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whipple Ave 2 Sidewalk: Curb side : Yard Tree Private 2   04/26/2019 12:00:00 AM 3                        
2762 46200 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   2 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
3450 52146 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 145 Hawes St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2005 12:00:00 AM     Permit Number 48337                    
3492 30592 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 269 Walter St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
7715 260428 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 745 Silliman St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/17/2019 12:00:00 AM 3                        
9907 30593 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 269 Walter St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/26/1995 12:00:00 AM     Permit Number 34561                    
13512 259080 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1001 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2019 12:00:00 AM 3                        
15478 252965 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 115X Whipple Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 02:04:00 PM 3                        
15527 19972 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 100 STAIRWAY44 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 36                      
19620 46201 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83   1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2001 12:00:00 AM     Permit Number 44518                    
328 197129 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400 Newhall St 11 : Tree Private 2     5 Width 3ft   6015974.4503 2097856.83037 37.7412122331485 -122.387337958305 (37.7412122331485, -122.387337958305) 10 3 8 58 1
611 10613 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 34 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1993 12:00:00 AM 18 3X3   6016953.5018076 2095595.9312574 37.7350584319022 -122.383795333225 (37.7350584319022, -122.383795333225) 10 3 8 58 1
670 197144 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 67 Jennings Ct 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6012875.71849 2089235.92195 37.7173688854414 -122.397447893917 (37.7173688854414, -122.397447893917) 10 3 8 58 1
691 199940 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1177 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6017562.0246 2092865.5482 37.7275949559017 -122.381501616556 (37.7275949559017, -122.381501616556) 10 3 8 58 1
971 16508 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 325 Newhall St 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016639.93914 2098306.03692 37.7424824967653 -122.385068203435 (37.7424824967653, -122.385068203435) 10 3 8 58 1
1561 24107 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 14 Sidewalk: Curb side : Cutout Tree Private 2   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
1601 39981 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 45 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM 6   Permit Number 41239 6014242.19126 2094737.80253 37.7325519363025 -122.39310935122 (37.7325519363025, -122.39310935122) 10 3 8 58 1
2621 202038 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 75 Crane St 2 : Tree Private 2     2 Width 3ft   6012275.87253 2090920.17769 37.7219600944649 -122.399639484201 (37.7219600944649, -122.399639484201) 10 3 8 58 1
2641 262546 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 131 Apollo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/18/2020 12:00:00 AM       6012643 2094250 37.731123564074 -122.398603958182 (37.731123564074, -122.398603958182) 10 3 8 58 1
4044 11466 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 39X Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   09/25/1992 12:00:00 AM 3 3X3   6016784.96757 2095560.66167 37.7349522709331 -122.384375566285 (37.7349522709331, -122.384375566285) 10 3 8 58 1
5604 197168 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2 Baldwin Ct 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017908.19776 2093591.9406 37.729608594643 -122.380355342249 (37.729608594643, -122.380355342249) 10 3 8 58 1
5684 83143 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6016637.51216 2095504.68596 37.7347904181313 -122.384881478104 (37.7347904181313, -122.384881478104) 10 3 8 58 1
6129 85658 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1643 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015004.908 2094769.8823 37.7326823614983 -122.3904746745 (37.7326823614983, -122.3904746745) 10 3 8 58 1
7988 24147 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 100X Whitney Young Cir 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016689.05107 2095205.54183 37.7339718785836 -122.384682457242 (37.7339718785836, -122.384682457242) 10 3 8 58 1
9184 88476 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1531 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51429 6015551.7 2096433.9 37.7372817351758 -122.388700383218 (37.7372817351758, -122.388700383218) 10 3 8 58 1
9223 60407 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1430 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1982 12:00:00 AM 6   Permit Number 19988 6016156.6712 2093985.1354 37.7305914290757 -122.386438011678 (37.7305914290757, -122.386438011678) 10 3 8 58 1
9288 85617 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1274 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017015.0778 2093348.1164 37.7288897808137 -122.383426014631 (37.7288897808137, -122.383426014631) 10 3 8 58 1
9955 71391 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1531 Kirkwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6015562.7322 2096452.7948 37.7373342278764 -122.388663558077 (37.7373342278764, -122.388663558077) 10 3 8 58 1
9959 71411 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1556 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015495.2506 2094478.7004 37.7319100238031 -122.388759104128 (37.7319100238031, -122.388759104128) 10 3 8 58 1
10805 38591 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1615 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/17/1998 12:00:00 AM 3   Permit Number 40546 6015135.7246 2094671.1157 37.7324184244611 -122.390015508372 (37.7324184244611, -122.390015508372) 10 3 8 58 1
12336 85628 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1470 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015957.8963 2094137.5833 37.7309990152261 -122.387135841638 (37.7309990152261, -122.387135841638) 10 3 8 58 1
13481 261122 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 56 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 5x5   6014135.16378 2094796.13766 37.7327061665323 -122.393483454939 (37.7327061665323, -122.393483454939) 10 3 8 58 1
13556 264663 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1078 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/10/2020 12:00:00 AM   3x3   6014476.86082 2089998.27904 37.7195511879651 -122.391966726039 (37.7195511879651, -122.391966726039) 10 3 8 58 1
13606 264731 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1515 Van Dyke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014824 2093132 37.7281750296252 -122.390985688648 (37.7281750296252, -122.390985688648) 10 3 8 58 1
14166 197170 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1510X Galvez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6016200.17093 2097456.77974 37.740126273917 -122.386529601766 (37.740126273917, -122.386529601766) 10 3 8 58 1
14804 264658 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2845X Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2020 04:59:00 PM   3X3   6014746.9934 2090564.9462 37.7211221378179 -122.391072554716 (37.7211221378179, -122.391072554716) 10 3 8 58 1
15928 197140 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 53 Pomona St 2 : Tree Private 2     3 Width 5ft   6014151.58684 2094423.96338 37.7316851643341 -122.39340063984 (37.7316851643341, -122.39340063984) 10 3 8 58 1
17354 88467 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 119 Augusta St   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51421 6011176 2095454 37.7343476550611 -122.403760347511 (37.7343476550611, -122.403760347511) 10 3 8 58 1
17729 197162 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 123 Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6016438.8167 2095743.2053 37.735434352517 -122.385585060917 (37.735434352517, -122.385585060917) 10 3 8 58 1
18976 44337 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1386 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2001 12:00:00 AM 10   Permit Number 43722 6016111.02072 2094370.93672 37.7316482354559 -122.386622725671 (37.7316482354559, -122.386622725671) 10 3 8 58 1
19617 78383 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1490 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015869.5519 2094203.8416 37.7311760546893 -122.387445886397 (37.7311760546893, -122.387445886397) 10 3 8 58 1
20758 38463 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1160 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/20/1998 12:00:00 AM 4   Permit Number 40473 6017671.3057 2092861.7612 37.7275905904586 -122.38112356357 (37.7275905904586, -122.38112356357) 10 3 8 58 1
21156 16551 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 500X Newhall St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/1998 12:00:00 AM 3 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
21171 197125 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 31 Apparel Way 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 8ft   6011537.38847 2097577.661 37.7401989607078 -122.402660197209 (37.7401989607078, -122.402660197209) 10 3 8 58 1
21693 197124 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2 Napoleon St 12 : Tree Private 2     3 Width 4ft   6013733.0286 2100130.55294 37.7473310072149 -122.395247287949 (37.7473310072149, -122.395247287949) 10 3 8 58 1
22287 1701 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 46 Baldwin Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/04/2015 02:11:00 PM 3 3X3   6017792.761567 2093643.6318374 37.7297441585391 -122.380758013182 (37.7297441585391, -122.380758013182) 10 3 8 58 1
22372 18655 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 85 Reuel Ct 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/1999 12:00:00 AM 3 3X4   6017364.7700717 2096131.8258237 37.7365526173752 -122.382410690517 (37.7365526173752, -122.382410690517) 10 3 8 58 1
24416 81916 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2009 12:00:00 AM 8 3x3 Permit Number 52300 6013111.49661 2094334.18979 37.7313808220717 -122.396990173153 (37.7313808220717, -122.396990173153) 10 3 8 58 1
24442 24127 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 140X Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6016343.6401634 2095980.6654178 37.7360811036021 -122.385930671948 (37.7360811036021, -122.385930671948) 10 3 8 58 1
25176 85636 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1161 Quesada Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017631.370144 2092826.687243 37.7274920796749 -122.381259184857 (37.7274920796749, -122.381259184857) 10 3 8 58 1
27277 18635 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 20 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 0 3X3   6017095.3922155 2096110.4018038 37.736478907812 -122.3833405631 (37.736478907812, -122.3833405631) 10 3 8 58 1
27684 24086 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 141X Whitney Young Cir 8 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6016393.5495733 2095983.6738742 37.7360921261264 -122.385758322913 (37.7360921261264, -122.385758322913) 10 3 8 58 1
27982 85620 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1344 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016632.8917 2093635.0593 37.729656539473 -122.384767252586 (37.729656539473, -122.384767252586) 10 3 8 58 1
28575 54817 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1414 Underwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2007 12:00:00 AM 5 3x3 Permit Number 49953 6015568.3491 2093032.3958 37.7279428116622 -122.388405474303 (37.7279428116622, -122.388405474303) 10 3 8 58 1
28724 197143 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 67 Jennings Ct 6 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012876.39378 2089220.96781 37.7173278619583 -122.397444511578 (37.7173278619583, -122.397444511578) 10 3 8 58 1
29386 8257 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1525 GALVEZ AVE 4 Sidewalk: Curb side : Cutout Tree DPW 1   11/13/1992 12:00:00 AM 6 3x3   6016246 2097351 37.7398383611722 -122.386363768789 (37.7398383611722, -122.386363768789) 10 3 8 58 1
29832 197131 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400 Newhall St 17 : Tree Private 2     5 Width 3ft   6015885.54456 2097735.33833 37.740873716654 -122.38763689115 (37.740873716654, -122.38763689115) 10 3 8 58 1
30035 53150 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1499@ LANE Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/02/2006 12:00:00 AM     Permit Number 49076 6015286.17606683 2093519.24782482 37.7292639697355 -122.389414946979 (37.7292639697355, -122.389414946979) 10 3 8 58 1
31031 1693 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 26 Baldwin Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/31/1996 12:00:00 AM 3 3X3   6017694.7378197 2093654.8040295 37.7297694248505 -122.381097672052 (37.7297694248505, -122.381097672052) 10 3 8 58 1
32894 85619 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1338 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016653.5768 2093624.593 37.7296289450877 -122.384695012523 (37.7296289450877, -122.384695012523) 10 3 8 58 1
33561 52155 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1431 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/31/2005 12:00:00 AM 8   Permit Number 48347 6016125.1581 2093936.3843 37.7304558237734 -122.386543560163 (37.7304558237734, -122.386543560163) 10 3 8 58 1
33810 85643 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1235 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017171.4256 2093155.5219 37.7283695937915 -122.382872106202 (37.7283695937915, -122.382872106202) 10 3 8 58 1
37453 16492 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 305X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1992 12:00:00 AM 3 3X3   6016524.6681965 2098330.497802 37.7425432844059 -122.385468484111 (37.7425432844059, -122.385468484111) 10 3 8 58 1
40124 85656 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1699X Quesada Ave 3 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
40192 85647 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1351 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016557.1838 2093613.7118 37.7295937360014 -122.385027498588 (37.7295937360014, -122.385027498588) 10 3 8 58 1
40510 197161 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 130 Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6016392.6723 2096037.13258 37.7362388644345 -122.385765080913 (37.7362388644345, -122.385765080913) 10 3 8 58 1
40566 197148 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 65 Whitney Young Cir 24 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017233.10687 2094952.3109 37.7333066302946 -122.382783854412 (37.7333066302946, -122.382783854412) 10 3 8 58 1
40672 199666 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1901 Keith St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6015268.2608 2093490.7724 37.7291847886233 -122.389474894337 (37.7291847886233, -122.389474894337) 10 3 8 58 1
40942 53148 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1499@ LANE Thomas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/02/2006 12:00:00 AM     Permit Number 49076 6015286.17606683 2093519.24782482 37.7292639697355 -122.389414946979 (37.7292639697355, -122.389414946979) 10 3 8 58 1
42041 13319 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 14 Mabrey Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1992 12:00:00 AM 7 3X3   6016463.59576 2095940.92929 37.7359786339072 -122.385513164614 (37.7359786339072, -122.385513164614) 10 3 8 58 1
42075 85613 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1190 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017458.1534 2093022.4369 37.728020006278 -122.38187161186 (37.728020006278, -122.38187161186) 10 3 8 58 1
42781 200039 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1598 Lane St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015308.9321 2094726.026 37.7325788017835 -122.38942051753 (37.7325788017835, -122.38942051753) 10 3 8 58 1
44076 88494 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 2617 Quint St   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51436 6011452 2093927 37.7301702475564 -122.402698769845 (37.7301702475564, -122.402698769845) 10 3 8 58 1
44842 85625 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1430 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016164.799973 2093969.832807 37.7305498611727 -122.386408842499 (37.7305498611727, -122.386408842499) 10 3 8 58 1
45441 24145 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 100X Whitney Young Cir 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016696.89665 2095171.76192 37.7338795595807 -122.384652980151 (37.7338795595807, -122.384652980151) 10 3 8 58 1
45531 85641 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1215 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017274.7558 2093081.4055 37.7281717932443 -122.382509730509 (37.7281717932443, -122.382509730509) 10 3 8 58 1
46191 42714 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 419 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM 11   Permit Number 42727 6013037.06698 2094313.85012 37.731320830081 -122.397246066263 (37.731320830081, -122.397246066263) 10 3 8 58 1
47357 18650 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 75 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/1999 12:00:00 AM 3 3X4   6017333.6171273 2096134.4813377 37.7365581880217 -122.382518585342 (37.7365581880217, -122.382518585342) 10 3 8 58 1
47740 85646 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1321 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016609.4363 2093572.233 37.7294827335965 -122.38484396609 (37.7294827335965, -122.38484396609) 10 3 8 58 1
48144 85622 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1360 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016552.9396 2093696.0654 37.7298196279301 -122.385047906896 (37.7298196279301, -122.385047906896) 10 3 8 58 1
48659 16518 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 330 Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   6016409.9700879 2098376.06541 37.7426620571468 -122.385868255606 (37.7426620571468, -122.385868255606) 10 3 8 58 1
49059 85653 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1541 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015555.708 2094360.5338 37.7315889126514 -122.388541843069 (37.7315889126514, -122.388541843069) 10 3 8 58 1
49125 197155 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 36 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6016950.76983 2095599.67173 37.7350685514743 -122.383805039094 (37.7350685514743, -122.383805039094) 10 3 8 58 1
50390 197136 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 901 Newhall St 4 : Tree Private 2     6 Width 3ft   6015282.23394 2096844.32451 37.7383937389821 -122.38966071649 (37.7383937389821, -122.38966071649) 10 3 8 58 1
50430 197123 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2 Napoleon St 9 : Tree Private 2     4 Width 4ft   6013823.14287 2100134.69381 37.7473473883884 -122.39493596693 (37.7473473883884, -122.39493596693) 10 3 8 58 1
51886 11463 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 12 Jakey Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1992 12:00:00 AM 6 3X3   6016797.65257 2095521.33822 37.7348449980066 -122.384328971504 (37.7348449980066, -122.384328971504) 10 3 8 58 1
52624 1689 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 20 Baldwin Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2015 03:07:00 PM 3 3X3   6017662.0080572 2093645.216342 37.7297412922242 -122.381210157278 (37.7297412922242, -122.381210157278) 10 3 8 58 1
53144 200726 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1660 Quesada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6014855.123 2094958.2582 37.7331912931628 -122.391005683963 (37.7331912931628, -122.391005683963) 10 3 8 58 1
53220 200041 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1598 Lane St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015290.2453 2094700.1942 37.7325068367942 -122.389483319509 (37.7325068367942, -122.389483319509) 10 3 8 58 1
53874 197142 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 67 Jennings Ct 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6012879.12382 2089210.84364 37.7173002150142 -122.397434365426 (37.7173002150142, -122.397434365426) 10 3 8 58 1
54499 85635 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1101 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017893.31364 2092631.421507 37.7269703746724 -122.380340070254 (37.7269703746724, -122.380340070254) 10 3 8 58 1
55456 24180 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whitney Young Cir 13 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6016621.33395 2095295.74377 37.7342158098126 -122.384922860422 (37.7342158098126, -122.384922860422) 10 3 8 58 1
56120 200038 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1598 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6015316.6267 2094740.3159 37.7326184655785 -122.389394912765 (37.7326184655785, -122.389394912765) 10 3 8 58 1
57262 18634 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 15 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/04/1998 12:00:00 AM 3 3X4   6017078.2420673 2096202.8624203 37.7367318383598 -122.383406293435 (37.7367318383598, -122.383406293435) 10 3 8 58 1
57953 1698 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 39 Baldwin Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/03/1992 12:00:00 AM 12 3X3   6017750.7960904 2093602.6298867 37.72962925906 -122.380900244658 (37.72962925906, -122.380900244658) 10 3 8 58 1
58251 85632 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1582 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015365.5421 2094575.4322 37.7321684400373 -122.38921428964 (37.7321684400373, -122.38921428964) 10 3 8 58 1
59260 197159 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 122 Whitney Young Cir 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6016446.71962 2095806.95269 37.7356098273254 -122.385562178561 (37.7356098273254, -122.385562178561) 10 3 8 58 1
60469 6847 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 595X Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2002 12:00:00 AM 3 3x3   6015962.97666 2097752.78836 37.7409259196071 -122.387370374337 (37.7409259196071, -122.387370374337) 10 3 8 58 1
61107 24109 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 16 Sidewalk: Curb side : Cutout Tree Private 2   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
62229 199665 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1901 Keith St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6015244.0778 2093456.6965 37.7290898821684 -122.389556118834 (37.7290898821684, -122.389556118834) 10 3 8 58 1

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