1,985 rows where qSpecies_id = 83 sorted by Longitude

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                    
72283 197167 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 15 Baldwin Ct 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6017931.28632 2093542.2184 37.7294733411139 -122.380272067717 (37.7294733411139, -122.380272067717) 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
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
88753 199943 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1101 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6017830.3585 2092664.2977 37.7270571724447 -122.380559991407 (37.7270571724447, -122.380559991407) 10 3 8 58 1
86714 197166 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 15 Baldwin Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6017812.18648 2093598.15352 37.7296203559852 -122.380687698389 (37.7296203559852, -122.380687698389) 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
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
100935 1700 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 43 Baldwin Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/31/1996 12:00:00 AM 6 3X3   6017768.2322395 2093598.2442303 37.7296181792492 -122.380839660676 (37.7296181792492, -122.380839660676) 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
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
96891 199942 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1151 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6017725.4053 2092742.7421 37.7272667732913 -122.380928267994 (37.7272667732913, -122.380928267994) 10 3 8 58 1
126859 85611 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1150 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017700.249 2092841.4739 37.7275364831055 -122.381022095395 (37.7275364831055, -122.381022095395) 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
105111 197169 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2 Baldwin Ct 6 Sidewalk: Property side : Yard Tree Private 2     11 Width 4ft   6017690.0216 2093651.3665 37.7297597257339 -122.38111373781 (37.7297597257339, -122.38111373781) 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
124667 1688 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 19 Baldwin Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/1993 12:00:00 AM 6 3X3   6017679.592279 2093598.3775556 37.7296136527509 -122.381146110708 (37.7296136527509, -122.381146110708) 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
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
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
92413 85612 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1160 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017578.234449 2092916.188247 37.7277348985577 -122.381449098373 (37.7277348985577, -122.381449098373) 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
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
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
93068 85615 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1200X Quesada Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6017380.895352 2093063.294675 37.7281279271047 -122.382141539059 (37.7281279271047, -122.382141539059) 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
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
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
108572 197165 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 15 Reuel Ct 9 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6017366.51517 2096051.55948 37.7363323183867 -122.382399074074 (37.7363323183867, -122.382399074074) 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
83643 18654 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 85 Reuel Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   02/04/1998 12:00:00 AM 3 3X4   6017364.7700717 2096131.8258237 37.7365526173752 -122.382410690517 (37.7365526173752, -122.382410690517) 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
67812 18652 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 80 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/1999 12:00:00 AM 3     6017340.7956251 2096041.6846084 37.7363037832445 -122.382487311287 (37.7363037832445, -122.382487311287) 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
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
116948 18649 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 70 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/02/1999 12:00:00 AM 3 3X4   6017298.515724 2096054.3606827 37.7363362535881 -122.382634373709 (37.7363362535881, -122.382634373709) 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
81020 197127 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101 Newhall St 13 : Tree Private 2     3 Width 3ft   6017303.08049 2098110.93394 37.7419834431736 -122.382761660942 (37.7419834431736, -122.382761660942) 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
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
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
78628 197149 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 58 Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017152.11734 2094978.18509 37.7333732007951 -122.383065660554 (37.7333732007951, -122.383065660554) 10 3 8 58 1
102961 18641 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 35 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/19/2000 12:00:00 AM 3 3X4   6017167.4480367 2096189.4017782 37.7366998078586 -122.38309692992 (37.7366998078586, -122.38309692992) 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
123643 197146 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 65 Whitney Young Cir 16 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017111.39408 2094922.05635 37.7332168320814 -122.383202548153 (37.7332168320814, -122.383202548153) 10 3 8 58 1
121518 18637 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 25 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/1998 12:00:00 AM 3 3X4   6017121.1361855 2096199.8633465 37.7367259740336 -122.383257779638 (37.7367259740336, -122.383257779638) 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
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
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
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
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
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
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
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
112388 85644 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1275 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016975.0441 2093297.8038 37.728749419657 -122.383560914081 (37.728749419657, -122.383560914081) 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
111293 4924 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 195X Newhall St 13 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 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
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
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
121713 11461 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 41X HAWKINS LN 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/1992 12:00:00 AM 12 3X3   6016935 2095578 37.7350081734808 -122.383858053082 (37.7350081734808, -122.383858053082) 10 3 8 58 1
121993 11462 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 41X HAWKINS LN 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/11/1992 12:00:00 AM 6 3X3   6016935 2095578 37.7350081734808 -122.383858053082 (37.7350081734808, -122.383858053082) 10 3 8 58 1
82901 10614 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 37 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2001 12:00:00 AM 3 3X3   6016916.49156 2095577.99474 37.7350071358711 -122.383922043589 (37.7350071358711, -122.383922043589) 10 3 8 58 1
117962 197145 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 65 Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6016890.6542 2094912.19179 37.7331775451961 -122.383965026682 (37.7331775451961, -122.383965026682) 10 3 8 58 1
108376 11472 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 39X Hawkins Ln 7 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6016881.34744 2095602.56066 37.7350726460825 -122.384045260583 (37.7350726460825, -122.384045260583) 10 3 8 58 1
117118 11470 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 39X Hawkins Ln 5 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6016849.3995 2095607.37924 37.7350841106266 -122.38415605258 (37.7350841106266, -122.38415605258) 10 3 8 58 1
65942 11469 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 39X Hawkins Ln 4 Sidewalk: Curb side : Cutout Tree Private 2   09/25/1992 12:00:00 AM 9 3X3   6016835.01202 2095606.77415 37.735081653692 -122.384205753614 (37.735081653692, -122.384205753614) 10 3 8 58 1
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
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
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
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
90685 11464 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 12 Jakey Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1992 12:00:00 AM 6 3X3   6016788.85852 2095545.67202 37.7349113274992 -122.384361070118 (37.7349113274992, -122.384361070118) 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
115371 11465 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 12 Jakey Ct 3 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1992 12:00:00 AM 6 3X3   6016782.5188136 2095601.0665953 37.7350630793796 -122.384386845805 (37.7350630793796, -122.384386845805) 10 3 8 58 1
74630 197133 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201 Newhall St 5 : Tree Private 2     3 Width 3ft   6016812.93414 2098272.11729 37.7423989281583 -122.384467670355 (37.7423989281583, -122.384467670355) 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
130488 16495 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 305X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1   01/30/2003 12:00:00 AM 3 3x3   6016789.27845 2098277.7028 37.7424129566932 -122.384549854363 (37.7424129566932, -122.384549854363) 10 3 8 58 1
129166 197132 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201 Newhall St 4 : Tree Private 2     2 Width 3ft   6016788.78445 2098277.43468 37.7424121931718 -122.384551543811 (37.7424121931718, -122.384551543811) 10 3 8 58 1
80387 10617 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 74 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1992 12:00:00 AM 6 3X3   6016731.0735863 2095616.8317798 37.7351035225916 -122.384565809833 (37.7351035225916, -122.384565809833) 10 3 8 58 1
86446 197156 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 70 Hawkins Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6016728.211 2095612.50382 37.7350914805753 -122.38457540555 (37.7350914805753, -122.38457540555) 10 3 8 58 1
120604 197153 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 11 Jakey Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6016721.84036 2095568.4819 37.7349702528788 -122.384594365947 (37.7349702528788, -122.384594365947) 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
80776 16494 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 305X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1   01/30/2003 12:00:00 AM 3 3x3   6016769.45238 2098282.55627 37.7424251869258 -122.384618745617 (37.7424251869258, -122.384618745617) 10 3 8 58 1
70513 197128 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 201 Newhall St 3 : Tree Private 2     3 Width 3ft   6016765.19641 2098282.20265 37.7424239805909 -122.384633436999 (37.7424239805909, -122.384633436999) 10 3 8 58 1
77665 197152 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 11 Jakey Ct 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6016707.19345 2095564.59307 37.7349587649184 -122.384644735176 (37.7349587649184, -122.384644735176) 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
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
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
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
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
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

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