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) ▼
63378 6645 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 495X Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/16/1992 12:00:00 AM 6 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
63506 197158 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 106 Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6016583.16711 2095682.22839 37.7352749081106 -122.385081735533 (37.7352749081106, -122.385081735533) 10 3 8 58 1
63941 16550 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 500X Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1   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
64663 24178 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2001 12:00:00 AM 4 4x3   6016619.18629 2095310.93644 37.7342574070589 -122.384931343733 (37.7342574070589, -122.384931343733) 10 3 8 58 1
64888 85655 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1699X Quesada Ave 2 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
65144 83299 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 25 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52357 6014332.78372 2094054.31321 37.7306802456855 -122.392748350748 (37.7306802456855, -122.392748350748) 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
66623 85652 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1519 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015655.7374 2094284.1377 37.7313846871586 -122.388190689138 (37.7313846871586, -122.388190689138) 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
68298 256028 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1376 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6016144 2093317 37.7287561605437 -122.386435251043 (37.7287561605437, -122.386435251043) 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
70828 88492 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1600 Quesada Ave 6 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
70918 16558 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 500X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   12/27/1997 12:00:00 AM 3 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
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
72759 200043 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1598 Lane St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015271.0088 2094675.4616 37.7324378594728 -122.389548098564 (37.7324378594728, -122.389548098564) 10 3 8 58 1
73012 1709 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 7X Bass Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2006 12:00:00 AM 5 3x3   6016610.5210337 2095134.7434862 37.7337731370994 -122.384949031469 (37.7337731370994, -122.384949031469) 10 3 8 58 1
73172 202037 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 75 Crane St 1 : Tree Private 2     2 Width 3ft   6012270.31182 2090901.9422 37.7219097135375 -122.399657426574 (37.7219097135375, -122.399657426574) 10 3 8 58 1
74210 24149 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 100X Whitney Young Cir 9 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006836 -122.385890729183 (37.736379006836, -122.385890729183) 10 3 8 58 1
74283 88489 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1600 Quesada Ave 3 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
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
75271 16549 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400X Newhall St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6015994.10911 2097882.11034 37.7412827355083 -122.38727174751 (37.7412827355083, -122.38727174751) 10 3 8 58 1
75929 88490 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1600 Quesada Ave 4 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
76146 16542 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6016097.47551 2098025.0219 37.741680865376 -122.386924304309 (37.741680865376, -122.386924304309) 10 3 8 58 1
77507 24151 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 100X Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006836 -122.385890729183 (37.736379006836, -122.385890729183) 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
78444 94879 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 83 Ledyard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 4 3x3 Permit Number 767655 6011819 2094865 37.7327662839989 -122.401495893184 (37.7327662839989, -122.401495893184) 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
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
80757 16526 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 375 Newhall St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1992 12:00:00 AM 3 3X3   6016351.58796 2098272.95822 37.7423757148758 -122.386062939968 (37.7423757148758, -122.386062939968) 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
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
82089 36825 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1220 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM 5   Permit Number 49072 6014545.9992 2090648.9983 37.7213417726319 -122.391773212862 (37.7213417726319, -122.391773212862) 10 3 8 58 1
82155 197139 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 139 Venus St 1 : Tree Private 2     6 Width 2ft   6012870.02823 2094155.13741 37.7308757367127 -122.397812425111 (37.7308757367127, -122.397812425111) 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
83069 85627 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1466 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015977.8277 2094121.4228 37.7309557454266 -122.387065808076 (37.7309557454266, -122.387065808076) 10 3 8 58 1
83082 16560 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 702X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/03/1992 12:00:00 AM 12 3X3   6015615.61867 2097370.07413 37.7398558207833 -122.388544712683 (37.7398558207833, -122.388544712683) 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
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
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
87443 88469 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 921 Ingerson Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51423 6014544.1 2089500.7 37.7181886666833 -122.391699531232 (37.7181886666833, -122.391699531232) 10 3 8 58 1
88620 85660 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1615 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015165.828645 2094663.285506 37.7323985938789 -122.389910883982 (37.7323985938789, -122.389910883982) 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
89508 98309 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 401X Newhall St 1 Front Yard : Tree Private 2     6 3x3   6016081.14502 2097910.94016 37.7413667159929 -122.386972815546 (37.7413667159929, -122.386972815546) 10 3 8 58 1
89759 85659 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1623 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015103.6745 2094694.6627 37.7324813021879 -122.390127958436 (37.7324813021879, -122.390127958436) 10 3 8 58 1
90386 85650 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1419 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016182.7975 2093891.6734 37.7303362472247 -122.386341174586 (37.7303362472247, -122.386341174586) 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
90740 112843 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1415 EVANS AVE 1 Front Yard : Yard Tree Private 2           6016481 2097724 37.7408755487739 -122.385577218432 (37.7408755487739, -122.385577218432) 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
92503 8232 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1500X Galvez Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1   11/13/1992 12:00:00 AM 6 3x3   6016396.247314 2097296.3974116 37.7396967491289 -122.385840466933 (37.7396967491289, -122.385840466933) 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
95338 24072 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 161X Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6016395.7853594 2095946.5828375 37.735990405317 -122.385748008424 (37.735990405317, -122.385748008424) 10 3 8 58 1
96544 197151 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 99 Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6016637.91847 2095129.63156 37.7337606161438 -122.384853953468 (37.7337606161438, -122.384853953468) 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
97184 85648 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1357 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016534.0204 2093632.0271 37.7296427448929 -122.385108853227 (37.7296427448929, -122.385108853227) 10 3 8 58 1
97427 16561 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 702X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6015590.52894 2097333.28077 37.7397534032962 -122.388628895503 (37.7397534032962, -122.388628895503) 10 3 8 58 1
99225 16557 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 500X Newhall St 8 Sidewalk: Curb side : Cutout Tree Private 2   12/23/1997 12:00:00 AM 3 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
100166 24177 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 95X Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 4 3X3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
100411 200236 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 921 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6014551.0541 2089524.7802 37.7182551721999 -122.391677176393 (37.7182551721999, -122.391677176393) 10 3 8 58 1
100588 24094 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 1 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
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
102002 200042 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1598 Lane St 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6015283.1003 2094689.2019 37.7324762579969 -122.389507254289 (37.7324762579969, -122.389507254289) 10 3 8 58 1
102681 97759 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1699X Quesada Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6014853.3 2094854.4 37.7329060184543 -122.391004730192 (37.7329060184543, -122.391004730192) 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
103323 88464 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 955X Newhall St 2 Sidewalk: Curb side : Cutout Tree Private 2   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
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
106149 200739 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1667 Quesada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6014860.3556 2094879.7682 37.7329760658991 -122.390982109379 (37.7329760658991, -122.390982109379) 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
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
110946 24179 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whitney Young Cir 12 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/1990 12:00:00 AM 12 5x3   6016625.58798 2095312.02915 37.7342607615082 -122.384909286932 (37.7342607615082, -122.384909286932) 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
111401 197137 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1611 Kirkwood Ave 1 : Tree Private 2     5 Width 4ft   6015105.04683 2096793.47619 37.7382442932251 -122.390269796717 (37.7382442932251, -122.390269796717) 10 3 8 58 1
111504 24186 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 55X Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 4x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 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
114475 85624 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1422 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016199.7661 2093954.969 37.7305109836044 -122.38628692243 (37.7305109836044, -122.38628692243) 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
115424 24171 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 95X Whitney Young Cir 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
116216 197138 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2617 Quint St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 6 Width 3ft Permit Number 51436 6011420.8914 2093882.28273 37.7300457263229 -122.402803173234 (37.7300457263229, -122.402803173234) 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
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
117222 24194 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 55X Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2008 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 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
118427 85621 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1356 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016575.2959 2093679.014 37.7297740447744 -122.384969430386 (37.7297740447744, -122.384969430386) 10 3 8 58 1
119645 197126 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 31 Apparel Way 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 8ft   6011547.96771 2097644.33103 37.7403826130582 -122.402628305469 (37.7403826130582, -122.402628305469) 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
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
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
123317 24106 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 13 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
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
124563 85657 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1651 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6014964.3549 2094799.316 37.7327609307407 -122.3906169338 (37.7327609307407, -122.3906169338) 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
126674 200040 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1598 Lane St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015299.5887 2094715.0337 37.7325481011108 -122.389452052823 (37.7325481011108, -122.389452052823) 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
128338 60409 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1448 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM 5 3x3 Permit Number 52503 6016089.8742 2094040.62 37.7307400809012 -122.386672808634 (37.7307400809012, -122.386672808634) 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
130419 197121 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 2 Napoleon St 3 : Tree Private 2     3 Width 4ft   6014057.88074 2100147.50711 37.747395620823 -122.39412515077 (37.747395620823, -122.39412515077) 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
131634 36824 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1220 Fitzgerald Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/02/2006 12:00:00 AM     Permit Number 49072 6014575.87209861 2090621.86928293 37.7212689399964 -122.391668053968 (37.7212689399964, -122.391668053968) 10 3 8 58 1
131856 85651 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1467 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015942.8131 2094070.7863 37.7308147687334 -122.387183329829 (37.7308147687334, -122.387183329829) 10 3 8 58 1
134247 85649 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1399 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016350.3286 2093764.5437 37.7299964462298 -122.385753133703 (37.7299964462298, -122.385753133703) 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)
);