3,709 rows where qSpecies_id = 9 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) ▼
1005 39481 Permitted Site 7 Olea europaea :: Olive Tree 9 0 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 40941                    
2927 35280 Permitted Site 7 Olea europaea :: Olive Tree 9   1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
4304 17630 DPW Maintained 1 Olea europaea :: Olive Tree 9 150 Phelps St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 10M                      
6966 35281 Permitted Site 7 Olea europaea :: Olive Tree 9   5 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
10720 39483 Permitted Site 7 Olea europaea :: Olive Tree 9 0 19th St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 40941                    
13401 35284 Permitted Site 7 Olea europaea :: Olive Tree 9   3 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
14355 35285 Permitted Site 7 Olea europaea :: Olive Tree 9   4 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
15594 19769 DPW Maintained 1 Olea europaea :: Olive Tree 9 100 STAIRWAY16 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 30ST                      
16339 39482 Permitted Site 7 Olea europaea :: Olive Tree 9 0 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/1998 12:00:00 AM     Permit Number 40941                    
17767 35283 Permitted Site 7 Olea europaea :: Olive Tree 9   2 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1998 12:00:00 AM     Permit Number 38758                    
17923 19768 DPW Maintained 1 Olea europaea :: Olive Tree 9 100 STAIRWAY16 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 30ST                      
18560 19875 DPW Maintained 1 Olea europaea :: Olive Tree 9 100 STAIRWAY33 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 25ST                      
2096 3697 DPW Maintained 1 Olea europaea :: Olive Tree 9 401X Cargo Way 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016390.48971 2099364.75407 37.7453757156112 -122.3860045182 (37.7453757156112, -122.3860045182) 10 3 8 58 1
6307 83045 DPW Maintained 1 Olea europaea :: Olive Tree 9 100X Cargo Way 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6018793.96585 2097631.53768 37.7407493718785 -122.377573338964 (37.7407493718785, -122.377573338964) 10 3 8 58 1
6952 264732 DPW Maintained 1 Olea europaea :: Olive Tree 9 1965 Quint St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012227 2095019 37.7332118929398 -122.40009613746 (37.7332118929398, -122.40009613746) 10 3 8 58 1
11542 194238 DPW Maintained 1 Olea europaea :: Olive Tree 9 6 Hillview Ct 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 7ft   6016710.45664 2095786.72783 37.7355688829898 -122.384648921526 (37.7355688829898, -122.384648921526) 10 3 8 58 1
13702 83044 DPW Maintained 1 Olea europaea :: Olive Tree 9 100X Cargo Way 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF   2     6018777.54715 2097643.31156 37.7407807960029 -122.377630926146 (37.7407807960029, -122.377630926146) 10 3 8 58 1
15140 83033 DPW Maintained 1 Olea europaea :: Olive Tree 9 100X Cargo Way 3 Sidewalk: Curb side : Cutout Tree Port 6     1     6018894.74802 2097554.01331 37.7405420574702 -122.377219490814 (37.7405420574702, -122.377219490814) 10 3 8 58 1
15702 66427 DPW Maintained 1 Olea europaea :: Olive Tree 9 95 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/1991 12:00:00 AM 8   Permit Number 29569 6012980.71061 2090558.71757 37.7210068625643 -122.397177686318 (37.7210068625643, -122.397177686318) 10 3 8 58 1
16959 71390 DPW Maintained 1 Olea europaea :: Olive Tree 9 1530 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6015584.85469 2096508.00591 37.7374870523836 -122.388590922526 (37.7374870523836, -122.388590922526) 10 3 8 58 1
16998 109968 DPW Maintained 1 Olea europaea :: Olive Tree 9 1019 Hollister Ave 2 Front Yard : Yard Tree Private 2   03/13/2015 12:00:00 AM 3 12x17   6014729.1 2089712.4 37.7187802209924 -122.391074848752 (37.7187802209924, -122.391074848752) 10 3 8 58 1
17950 79191 DPW Maintained 1 Olea europaea :: Olive Tree 9 1750 Fitzgerald Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6011751.02985 2092731.77406 37.7269050958844 -122.401581006276 (37.7269050958844, -122.401581006276) 10 3 8 58 1
19850 194218 DPW Maintained 1 Olea europaea :: Olive Tree 9 1121 Jamestown Ave 17 Sidewalk: Curb side : Yard Tree Private 2     30     6013410.02884 2090031.5953 37.7195833814573 -122.395656735769 (37.7195833814573, -122.395656735769) 10 3 8 58 1
20943 54784 DPW Maintained 1 Olea europaea :: Olive Tree 9 201 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 3 3x3 Permit Number 50703 6012788.79472 2087552.61474 37.7127420182918 -122.397630353754 (37.7127420182918, -122.397630353754) 10 3 8 309 1
23789 3563 DPW Maintained 1 Olea europaea :: Olive Tree 9 101 Cargo Way 9 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6018859.49817 2097478.39151 37.7403324731777 -122.377336126574 (37.7403324731777, -122.377336126574) 10 3 8 58 1
24701 194230 DPW Maintained 1 Olea europaea :: Olive Tree 9 58 Hawkins Ln 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 4ft   6016826.40406 2095640.34928 37.7351733683505 -122.384237852219 (37.7351733683505, -122.384237852219) 10 3 8 58 1
32116 3557 DPW Maintained 1 Olea europaea :: Olive Tree 9 101 Cargo Way 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 2 3X3   6018758.22153 2097553.75967 37.7405338394733 -122.377691534151 (37.7405338394733, -122.377691534151) 10 3 8 58 1
34785 22523 DPW Maintained 1 Olea europaea :: Olive Tree 9 6600 03rd St 3 Median : Cutout Tree DPW 1     12 3X3   6012847.5284056 2089784.7633559 37.7188743244909 -122.397583806576 (37.7188743244909, -122.397583806576) 10 3 8 58 1
35082 65502 DPW Maintained 1 Olea europaea :: Olive Tree 9 144 Venus St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/19/1989 12:00:00 AM 11   Permit Number 28386 6012831.84072 2094190.06058 37.7309695018215 -122.397946895354 (37.7309695018215, -122.397946895354) 10 3 8 58 1
35295 22437 DPW Maintained 1 Olea europaea :: Olive Tree 9 6025 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6013597.3212 2091386.3105 37.7233135750036 -122.39510416905 (37.7233135750036, -122.39510416905) 10 3 8 58 1
36260 194193 DPW Maintained 1 Olea europaea :: Olive Tree 9 1601 Kansas St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 9ft   6011834.44242 2100473.73914 37.748167551187 -122.401836621487 (37.748167551187, -122.401836621487) 10 3 8 58 1
36534 3559 DPW Maintained 1 Olea europaea :: Olive Tree 9 101 Cargo Way 5 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6018791.21625 2097528.24687 37.7404656043104 -122.377575679878 (37.7404656043104, -122.377575679878) 10 3 8 58 1
38488 51294 Permitted Site 7 Olea europaea :: Olive Tree 9 1217 Shafter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/2004 12:00:00 AM     Permit Number 47666 6016937.80385774 2092637.74842389 37.7269349786738 -122.383643722332 (37.7269349786738, -122.383643722332) 10 3 8 58 1
39036 194228 DPW Maintained 1 Olea europaea :: Olive Tree 9 9 Hawkins Ln 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   6016962.87933 2095412.73629 37.7345559334103 -122.38375016066 (37.7345559334103, -122.38375016066) 10 3 8 58 1
42155 109967 DPW Maintained 1 Olea europaea :: Olive Tree 9 1019 Hollister Ave 1 Front Yard : Yard Tree Private 2   03/13/2015 12:00:00 AM 3 12x17   6014729.1 2089712.4 37.7187802209924 -122.391074848752 (37.7187802209924, -122.391074848752) 10 3 8 58 1
43038 194194 DPW Maintained 1 Olea europaea :: Olive Tree 9 1888 Illinois St 1 : Tree Private 2     10 Width 4ft   6016264.99223 2100427.37243 37.7482865000228 -122.386512551535 (37.7482865000228, -122.386512551535) 10 3 8 58 1
44203 3575 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 10 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
45116 83043 DPW Maintained 1 Olea europaea :: Olive Tree 9 100X Cargo Way 9 Sidewalk: Curb side : Cutout Tree Port 6   03/18/2017 02:49:00 PM 3     6018760.27201 2097656.07243 37.7408148829885 -122.377691543139 (37.7408148829885, -122.377691543139) 10 3 8 58 1
48057 3562 DPW Maintained 1 Olea europaea :: Olive Tree 9 101 Cargo Way 8 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6018842.999 2097491.0611 37.7403663524293 -122.377394053707 (37.7403663524293, -122.377394053707) 10 3 8 58 1
50411 200525 DPW Maintained 1 Olea europaea :: Olive Tree 9 1465 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6016241.3617 2095551.4547 37.7348969165843 -122.386254379093 (37.7348969165843, -122.386254379093) 10 3 8 58 1
51618 1962 DPW Maintained 1 Olea europaea :: Olive Tree 9 36 Bertha Ln 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017618.4307655 2095033.1830576 37.7335499703731 -122.381457291596 (37.7335499703731, -122.381457291596) 10 3 8 58 1
52467 194231 DPW Maintained 1 Olea europaea :: Olive Tree 9 62 Hawkins Ln 1 Sidewalk: Property side : Yard Tree Private 2     11 Width 5ft   6016795.73668 2095634.4055 37.7351553522317 -122.384343467669 (37.7351553522317, -122.384343467669) 10 3 8 58 1
52842 22433 DPW Maintained 1 Olea europaea :: Olive Tree 9 6000 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/03/1992 12:00:00 AM 3 3X3   6013569.5341 2091525.6902 37.7236947383504 -122.395209983132 (37.7236947383504, -122.395209983132) 10 3 8 58 1
54162 3576 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 11 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3x3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
54899 194214 DPW Maintained 1 Olea europaea :: Olive Tree 9 1030 Le Conte Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6013004.48576 2089699.06872 37.7186477627738 -122.397035257987 (37.7186477627738, -122.397035257987) 10 3 8 58 1
55741 104461 DPW Maintained 1 Olea europaea :: Olive Tree 9 1601X Kansas St 1 Sidewalk: Property side : Cutout Tree DPW 1     4 3x6   6011834.44242 2100473.73914 37.748167551187 -122.401836621487 (37.748167551187, -122.401836621487) 10 3 8 58 1
57830 67676 Permitted Site 7 Olea europaea :: Olive Tree 9 1970 Carroll Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/2007 12:00:00 AM     Permit Number 49654 6012165.49957843 2093485.91293956 37.7289989246829 -122.400201126902 (37.7289989246829, -122.400201126902) 10 3 8 58 1
59776 1967 Permitted Site 7 Olea europaea :: Olive Tree 9 55 Bertha Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X4   6017714.6010769 2094983.7665226 37.7334195913803 -122.381121365124 (37.7334195913803, -122.381121365124) 10 3 8 58 1
60263 41526 Permitted Site 7 Olea europaea :: Olive Tree 9 1036 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/20/2000 12:00:00 AM     Permit Number 42066 6018440.91849108 2095073.89345371 37.7337071281629 -122.378616510061 (37.7337071281629, -122.378616510061) 10 3 8 58 1
60988 194221 DPW Maintained 1 Olea europaea :: Olive Tree 9 1080 Key Ave 1 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   6012968.46094 2090076.8184 37.7196829822717 -122.397186255957 (37.7196829822717, -122.397186255957) 10 3 8 58 1
62809 194219 DPW Maintained 1 Olea europaea :: Olive Tree 9 1121 Jamestown Ave 18 Sidewalk: Curb side : Yard Tree Private 2     12     6013415.40609 2090027.00023 37.7195710634281 -122.395637826651 (37.7195710634281, -122.395637826651) 10 3 8 58 1
65335 22455 Permitted Site 7 Olea europaea :: Olive Tree 9 6146X 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/1996 12:00:00 AM 12 3X3   6013520.36476 2091382.05626 37.7232976138509 -122.395369896984 (37.7232976138509, -122.395369896984) 10 3 8 58 1
73931 3554 DPW Maintained 1 Olea europaea :: Olive Tree 9 201X Cargo Way 64 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6016626.76696 2099218.04074 37.7449859443431 -122.38517728139 (37.7449859443431, -122.38517728139) 10 3 8 58 1
74424 22518 DPW Maintained 1 Olea europaea :: Olive Tree 9 6518 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6012926.62983 2089906.00338 37.7192116295963 -122.397318879858 (37.7192116295963, -122.397318879858) 10 3 8 58 1
76952 194195 DPW Maintained 1 Olea europaea :: Olive Tree 9 9 Pomona St 1 : Tree Private 2     2 Width 6ft   6014203.67115 2094680.19203 37.7323916096872 -122.393238495663 (37.7323916096872, -122.393238495663) 10 3 8 58 1
77445 85384 Permitted Site 7 Olea europaea :: Olive Tree 9 1970 Carroll Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2007 12:00:00 AM     Permit Number 49654 6012142.9 2093507.8 37.7290577618583 -122.40028079247 (37.7290577618583, -122.40028079247) 10 3 8 58 1
77732 194235 DPW Maintained 1 Olea europaea :: Olive Tree 9 19 Hillview Ct 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 7ft   6016602.67648 2095728.95529 37.7354042899791 -122.385017538329 (37.7354042899791, -122.385017538329) 10 3 8 58 1
79435 22512 DPW Maintained 1 Olea europaea :: Olive Tree 9 6424 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6013020.80961 2090093.5041 37.719731712041 -122.397006473368 (37.719731712041, -122.397006473368) 10 3 8 58 1
79438 194241 DPW Maintained 1 Olea europaea :: Olive Tree 9 4 Mabrey Ct 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 6ft   6016531.12407 2095935.7497 37.7359681478157 -122.385279329202 (37.7359681478157, -122.385279329202) 10 3 8 58 1
79849 85381 Permitted Site 7 Olea europaea :: Olive Tree 9 1970 Carroll Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2007 12:00:00 AM     Permit Number 49654 6012142.9 2093507.8 37.7290577618583 -122.40028079247 (37.7290577618583, -122.40028079247) 10 3 8 58 1
83326 194225 DPW Maintained 1 Olea europaea :: Olive Tree 9 9 Jakey Ct 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6016755.26705 2095536.04747 37.7348830429134 -122.384476538576 (37.7348830429134, -122.384476538576) 10 3 8 58 1
83483 55069 DPW Maintained 1 Olea europaea :: Olive Tree 9 1410 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1972 12:00:00 AM 11   Permit Number 10963 6015495.8002 2094978.5728 37.7332826032428 -122.388792087955 (37.7332826032428, -122.388792087955) 10 3 8 58 1
84135 3566 DPW Maintained 1 Olea europaea :: Olive Tree 9 101X Cargo Way 12 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6018911.95106 2097439.80241 37.7402294045724 -122.377152086609 (37.7402294045724, -122.377152086609) 10 3 8 58 1
84537 3565 DPW Maintained 1 Olea europaea :: Olive Tree 9 101X Cargo Way 11 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6018894.06666 2097453.02118 37.740264715549 -122.377214841296 (37.740264715549, -122.377214841296) 10 3 8 58 1
84720 85383 Permitted Site 7 Olea europaea :: Olive Tree 9 1970 Carroll Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2007 12:00:00 AM     Permit Number 49654 6012142.9 2093507.8 37.7290577618583 -122.40028079247 (37.7290577618583, -122.40028079247) 10 3 8 58 1
85424 22513 DPW Maintained 1 Olea europaea :: Olive Tree 9 6424 03rd St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6013017.34088 2090082.06317 37.7197001044495 -122.39701766186 (37.7197001044495, -122.39701766186) 10 3 8 58 1
85570 194220 DPW Maintained 1 Olea europaea :: Olive Tree 9 6524 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6012914.00103 2089890.00071 37.7191669863524 -122.397361411494 (37.7191669863524, -122.397361411494) 10 3 8 58 1
90118 194240 DPW Maintained 1 Olea europaea :: Olive Tree 9 17 Mabrey Ct 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 4ft   6016449.38039 2095875.60267 37.7357984736048 -122.385557761994 (37.7357984736048, -122.385557761994) 10 3 8 58 1
90691 3567 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 2 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
93472 13320 DPW Maintained 1 Olea europaea :: Olive Tree 9 16 Mabrey Ct 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/09/1992 12:00:00 AM 6 3X3   6016446.48412 2095922.18028 37.7359262061134 -122.385571020705 (37.7359262061134, -122.385571020705) 10 3 8 58 1
96506 97264 Significant Tree 6 Olea europaea :: Olive Tree 9 300 Newhall St 1 Front Yard : Yard Tree Private 2   09/09/2011 12:00:00 AM     Permit Number 768179 6016549.1 2098591.6 37.7432615694897 -122.385402196424 (37.7432615694897, -122.385402196424) 10 3 8 58 1
100457 1984 DPW Maintained 1 Olea europaea :: Olive Tree 9 106 Bertha Ln 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/16/1997 12:00:00 AM 3 3X4   6017854.9793307 2094779.8205714 37.732867343787 -122.380621861717 (37.732867343787, -122.380621861717) 10 3 8 58 1
104805 194236 DPW Maintained 1 Olea europaea :: Olive Tree 9 17 Hillview Ct 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 7ft   6016647.59382 2095743.55851 37.7354468719595 -122.384863257848 (37.7354468719595, -122.384863257848) 10 3 8 58 1
105856 3574 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 9 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
106687 194217 DPW Maintained 1 Olea europaea :: Olive Tree 9 1121 Jamestown Ave 16 Sidewalk: Curb side : Yard Tree Private 2     27     6013395.77535 2090042.77857 37.7196132956026 -122.395706788434 (37.7196132956026, -122.395706788434) 10 3 8 58 1
106856 194237 DPW Maintained 1 Olea europaea :: Olive Tree 9 11 Hillview Ct 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6016697.0495 2095760.45578 37.735496003732 -122.384693446039 (37.735496003732, -122.384693446039) 10 3 8 58 1
107369 3707 DPW Maintained 1 Olea europaea :: Olive Tree 9 401X Cargo Way 12 Sidewalk: Curb side : Cutout Tree DPW 1   06/07/1996 12:00:00 AM 3 3X3   6016577.53961 2099225.88923 37.7450047713688 -122.385348049088 (37.7450047713688, -122.385348049088) 10 3 8 58 1
108650 12193 Permitted Site 7 Olea europaea :: Olive Tree 9 1465 La Salle Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6016272.6778818 2095480.4561364 37.7347037020974 -122.386141159163 (37.7347037020974, -122.386141159163) 10 3 8 58 1
114525 10604 DPW Maintained 1 Olea europaea :: Olive Tree 9 18 Hawkins Ln 1 Sidewalk: Curb side : Cutout Tree Private 2   10/27/1992 12:00:00 AM 6 3X3   6017010.86457 2095475.59177 37.7347311744022 -122.383588632512 (37.7347311744022, -122.383588632512) 10 3 8 58 1
117765 31670 Permitted Site 7 Olea europaea :: Olive Tree 9 305 Wheeler Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 35178 6012134.6965622 2087196.99456235 37.7117291112295 -122.399866184073 (37.7117291112295, -122.399866184073) 10 3 8 309 1
120372 64528 Permitted Site 7 Olea europaea :: Olive Tree 9 1450 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1988 12:00:00 AM     Permit Number 25410 6015863.28704 2094893.11504234 37.7330683144881 -122.387515613747 (37.7330683144881, -122.387515613747) 10 3 8 58 1
122685 194229 DPW Maintained 1 Olea europaea :: Olive Tree 9 7 Hawkins Ln 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 5ft   6016979.33181 2095396.89704 37.7345133514147 -122.383692175976 (37.7345133514147, -122.383692175976) 10 3 8 58 1
126692 51293 Permitted Site 7 Olea europaea :: Olive Tree 9 1211 Shafter St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/26/2004 12:00:00 AM     Permit Number 47665 6016968.484021 2092614.87789536 37.726873876443 -122.383536069104 (37.726873876443, -122.383536069104) 10 3 8 58 1
127202 12216 DPW Maintained 1 Olea europaea :: Olive Tree 9 1523 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/25/1992 12:00:00 AM 15 3X3   6015935.5625 2095820.8342 37.735619647499 -122.387330428498 (37.735619647499, -122.387330428498) 10 3 8 58 1
129712 111972 DPW Maintained 1 Olea europaea :: Olive Tree 9 240 Bridgeview Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2015 12:00:00 AM 1 3x3   6012967.33594 2095411.30766 37.7343303393552 -122.39756408274 (37.7343303393552, -122.39756408274) 10 3 8 58 1
130025 3550 DPW Maintained 1 Olea europaea :: Olive Tree 9 201X Cargo Way 60 Sidewalk: Curb side : Cutout Tree DPW 1   03/16/1990 12:00:00 AM 6 3X3   6018708.52549 2097590.55589 37.7406321362531 -122.377865918974 (37.7406321362531, -122.377865918974) 10 3 8 58 1
130480 194223 DPW Maintained 1 Olea europaea :: Olive Tree 9 1080 Key Ave 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   6012938.89979 2090098.87174 37.7197418905657 -122.397289984657 (37.7197418905657, -122.397289984657) 10 3 8 58 1
132901 194216 DPW Maintained 1 Olea europaea :: Olive Tree 9 1121 Jamestown Ave 14 Sidewalk: Curb side : Yard Tree Private 2     5     6013384.67345 2090050.69381 37.7196344116892 -122.395745718284 (37.7196344116892, -122.395745718284) 10 3 8 58 1
133701 194224 DPW Maintained 1 Olea europaea :: Olive Tree 9 11 Jakey Ct 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 3ft   6016749.98334 2095555.73275 37.7349368025769 -122.384496177064 (37.7349368025769, -122.384496177064) 10 3 8 58 1
134856 18557 DPW Maintained 1 Olea europaea :: Olive Tree 9 1700X Quesada Ave 12 Median : Cutout Tree DPW 1     12 19   6014589.42489 2095117.74479 37.7336144637386 -122.391935430178 (37.7336144637386, -122.391935430178) 10 3 8 58 1
136827 194192 DPW Maintained 1 Olea europaea :: Olive Tree 9 1601 Kansas St 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 9ft   6011834.44242 2100473.73914 37.748167551187 -122.401836621487 (37.748167551187, -122.401836621487) 10 3 8 58 1
138217 22519 Permitted Site 7 Olea europaea :: Olive Tree 9 6520X 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6012970.43876 2089969.7044 37.719388978809 -122.397171912348 (37.719388978809, -122.397171912348) 10 3 8 58 1
139464 194233 DPW Maintained 1 Olea europaea :: Olive Tree 9 78 Hawkins Ln 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   6016686.67059 2095602.00775 37.7350603631446 -122.384718296107 (37.7350603631446, -122.384718296107) 10 3 8 58 1
141615 1951 DPW Maintained 1 Olea europaea :: Olive Tree 9 22 Bertha Ln 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017592.1686028 2095111.1070948 37.7337624844256 -122.38155350563 (37.7337624844256, -122.38155350563) 10 3 8 58 1
143377 22114 DPW Maintained 1 Olea europaea :: Olive Tree 9 3650X 03rd St 3 Median : Cutout Tree DPW 1     3 5X5   6015872.24057 2098764.87252 37.7436998694469 -122.38775470774 (37.7436998694469, -122.38775470774) 10 3 8 58 1
144619 22376 DPW Maintained 1 Olea europaea :: Olive Tree 9 5538 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6014077.5103 2092853.4647 37.7273687774645 -122.393546865436 (37.7273687774645, -122.393546865436) 10 3 8 58 1
145738 12932 DPW Maintained 1 Olea europaea :: Olive Tree 9 6540X 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6012937.6533 2089925.98182 37.7192671001169 -122.39728217588 (37.7192671001169, -122.39728217588) 10 3 8 58 1
146341 3568 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 3 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
149621 3555 DPW Maintained 1 Olea europaea :: Olive Tree 9 101X Cargo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3X3   6018831.8 2097475.1 37.7403219094469 -122.377431668566 (37.7403219094469, -122.377431668566) 10 3 8 58 1
150545 3564 DPW Maintained 1 Olea europaea :: Olive Tree 9 101 Cargo Way 10 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 6 3X3   6018876.34975 2097465.88877 37.7402990714478 -122.377276992562 (37.7402990714478, -122.377276992562) 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)
);