395 rows where qSpecies_id = 35 sorted by Police Districts

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)
150758 27296 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 3 Median : Cutout Tree Fire Dept 16   06/10/1999 12:00:00 AM 6 5X5   5982703.46074 2112397.79309 37.7792388274313 -122.50345176232 (37.7792388274313, -122.50345176232) 11 6 2 55 26
151464 27298 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 5 Median : Cutout Tree Fire Dept 16   06/10/1999 12:00:00 AM 6 5X5   5982658.07107 2112395.9042 37.7792309725957 -122.503608641413 (37.7792309725957, -122.503608641413) 11 6 2 55 26
153963 24789 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7700 Geary Blvd 1 Median : Cutout Tree DPW 1     6 4X4   5983110.07731 2112460.67779 37.7794353864392 -122.502049785013 (37.7794353864392, -122.502049785013) 11 6 2 55 26
161640 27299 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 6 Median : Cutout Tree Fire Dept 16   06/10/1999 12:00:00 AM 6 5X5   5982630.17797 2112395.09735 37.7792271172593 -122.503705073784 (37.7792271172593, -122.503705073784) 11 6 2 55 26
175352 27294 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 7800X Geary Blvd 1 Median : Cutout Tree Fire Dept 16   02/12/2001 12:00:00 AM 6 5X5   5982752.16339 2112399.44122 37.7792462157513 -122.503283404585 (37.7792462157513, -122.503283404585) 11 6 2 55 26
1053 211003 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996800.72253 2099394.55039 37.7443539050009 -122.453744529511 (37.7443539050009, -122.453744529511) 1 7 4 59 40
1190 107158 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 101x Elsie St 1 Unaccepted Street : Yard Tree Private 2     20     6007300 2098759 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614) 2 7 7 28859 2
2117 111271 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X BOSWORTH ST 9 Front Yard : Yard Tree DPW 1     42     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
20168 211040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 52 Burnside Ave 11 Sidewalk: Property side : Yard Tree Private 2     24     6001161.45161 2095717.92279 37.7345077855016 -122.438402718629 (37.7345077855016, -122.438402718629) 9 7 5 63 7
32345 211008 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700x Bosworth St 2 Median : Yard Tree DPW 1     33 Width 10ft   6002060.33003 2095430.49234 37.7337696552405 -122.435274449372 (37.7337696552405, -122.435274449372) 9 7 5 63 40
36557 211039 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 52 Burnside Ave 10 Sidewalk: Property side : Yard Tree Private 2     23     6001157.31367 2095726.26325 37.7345304511011 -122.438417622186 (37.7345304511011, -122.438417622186) 9 7 5 63 7
37212 111553 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 31 Front Yard : Yard Tree DPW 1     12     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
39027 211036 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 61 Burnside Ave 3 Sidewalk: Property side : Yard Tree Private 2     14     6001192.69302 2095737.41742 37.7345630902121 -122.438296103083 (37.7345630902121, -122.438296103083) 2 7 5 63 7
39660 111514 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x BOSWORTH ST 9 Front Yard : Yard Tree DPW 1     12     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
41737 115997 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20X Park St 2 Median : Yard Tree DPW 1   08/30/2016 09:25:00 AM 3     6004982.6 2096420.1 37.7366524147431 -122.425241679782 (37.7366524147431, -122.425241679782) 2 7 5 28859 2
45135 111279 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X BOSWORTH ST 17 Front Yard : Yard Tree DPW 1     24     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
49925 211004 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5996822.63607 2099410.87592 37.7443999871842 -122.453669936126 (37.7443999871842, -122.453669936126) 1 7 4 59 40
49956 211007 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 600x Bosworth St 8 Median : Yard Tree DPW 1     26 Width 10ft   6002197.80666 2095393.39137 37.7336755906519 -122.43479650017 (37.7336755906519, -122.43479650017) 9 7 5 63 40
66177 109347 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 59x BURNSIDE AVE 1 Median : Yard Tree DPW 1     14     6001229.7 2095779.3 37.7346801948558 -122.438171157158 (37.7346801948558, -122.438171157158) 2 7 5 63 7
68490 243115 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 18 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001841.69539 2098643.31719 37.7425789076843 -122.436260181872 (37.7425789076843, -122.436260181872) 2 7 5 63 7
69254 111516 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x BOSWORTH ST 11 Front Yard : Yard Tree DPW 1     14     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
69447 111507 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x BOSWORTH ST 2 Front Yard : Yard Tree DPW 1     18     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
69893 211037 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 61 Burnside Ave 4 Sidewalk: Property side : Yard Tree Private 2     16     6001183.29295 2095747.84811 37.7345911958118 -122.438329349227 (37.7345911958118, -122.438329349227) 2 7 5 63 7
77378 211002 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5996779.38475 2099373.51377 37.744294920285 -122.453816791818 (37.744294920285, -122.453816791818) 1 7 4 59 40
83122 2045 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X Bosworth St 2 Median : Cutout Tree DPW 1     24 10   6002154.6210393 2095431.8532492 37.7337787461998 -122.434948555048 (37.7337787461998, -122.434948555048) 2 7 5 63 7
83823 211035 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 61 Burnside Ave 1 Sidewalk: Property side : Yard Tree Private 2     20     6001198.5187 2095714.51341 37.7345005324595 -122.438274321504 (37.7345005324595, -122.438274321504) 2 7 5 63 7
87630 243112 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 15 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001806.81928 2098684.11193 37.7426889388393 -122.436383692077 (37.7426889388393, -122.436383692077) 2 7 5 63 7
96104 234476 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 784 Duncan St 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 6ft   6001432.63511 2099723.41327 37.7455213464352 -122.437751929628 (37.7455213464352, -122.437751929628) 2 7 5 63 22
96483 4970 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5200X Diamond Heights Blvd 6 Median : Cutout Tree DPW 1   01/09/2018 12:00:00 AM 3 12   6000842.33366 2099520.2529 37.7449299333661 -122.439778532074 (37.7449299333661, -122.439778532074) 2 7 5 63 7
97385 112912 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 480X BEACON ST 2 Sidewalk: Property side : Yard Tree DPW 1     30     6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
101189 111558 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 36 Front Yard : Yard Tree DPW 1     15     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
113773 111508 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x BOSWORTH ST 3 Front Yard : Yard Tree DPW 1     18     6001905 2095492 37.7339297189054 -122.435815869962 (37.7339297189054, -122.435815869962) 9 7 5 63 7
113834 243114 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 17 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001830.21459 2098656.61242 37.7426147609522 -122.436300830338 (37.7426147609522, -122.436300830338) 2 7 5 63 7
115061 243111 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 13 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001795.3662 2098698.75734 37.7427285009166 -122.436424341429 (37.7427285009166, -122.436424341429) 2 7 5 63 7
122378 101036 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1010X Portola Dr 10 Front Yard : Yard Tree DPW 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
127523 243106 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 9 Median : Yard Tree DPW 1   01/09/2018 12:00:00 AM 3     6001667.33897 2098826.57882 37.7430721930381 -122.436876170699 (37.7430721930381, -122.436876170699) 2 7 5 63 7
129439 4367 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 973 Chenery St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6001101.12966 2096102.69208 37.7355608412513 -122.438638832041 (37.7355608412513, -122.438638832041) 2 7 5 63 7
135146 243113 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 16 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001816.52967 2098672.65474 37.7426580318326 -122.436349296602 (37.7426580318326, -122.436349296602) 2 7 5 63 7
137465 234473 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 99 Elsie St 2 Sidewalk: Curb side : Pot Tree Private 2     16     6007295.70063 2098744.01488 37.7431637754778 -122.417408915989 (37.7431637754778, -122.417408915989) 2 7 7 28859 2
138421 243116 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 19 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001856.44522 2098624.22352 37.7425273189785 -122.436207815256 (37.7425273189785, -122.436207815256) 2 7 5 63 7
145424 211006 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 600x Portola Dr 1 Median : Cutout Tree DPW 1     6 Width 4ft   5997174.86391 2099677.95775 37.7451535147355 -122.452471281937 (37.7451535147355, -122.452471281937) 1 7 4 59 40
146907 243109 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 10 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001750.32805 2098751.0187 37.7428694390712 -122.436583810118 (37.7428694390712, -122.436583810118) 2 7 5 63 7
147440 111557 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 35 Front Yard : Yard Tree DPW 1     12     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
147596 234475 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 378 Highland Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6007368.44216 2096501.62636 37.7370107660349 -122.416998547241 (37.7370107660349, -122.416998547241) 2 7 7 28859 2
150320 111555 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 33 Front Yard : Yard Tree DPW 1     24     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
155300 178177 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 167 Vienna St 1 Sidewalk: Property side : Yard Tree Private 2     10     6004561.94872 2092421.12411 37.7256483463685 -122.426411406667 (37.7256483463685, -122.426411406667) 9 7 6 28861 5
160462 2028 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 600X Bosworth St 5 Median : Cutout Tree DPW 1     12 10   6002398.10054 2095366.8333155 37.7336140379052 -122.434102128474 (37.7336140379052, -122.434102128474) 2 7 5 63 7
161876 211038 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 52 Burnside Ave 1 Sidewalk: Property side : Yard Tree Private 2     36     6001171.81546 2095754.02956 37.7346075158123 -122.438369473392 (37.7346075158123, -122.438369473392) 2 7 5 63 7
162497 211001 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Portola Dr 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5996755.51144 2099350.67627 37.7442308453761 -122.45389769125 (37.7442308453761, -122.45389769125) 1 7 4 59 40
162963 243101 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 1 Median : Yard Tree DPW 1   01/09/2018 12:00:00 AM 3     6001501.83115 2098971.73396 37.7434613467555 -122.437458843264 (37.7434613467555, -122.437458843264) 2 7 5 63 7
165137 101040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1010X Portola Dr 14 Front Yard : Yard Tree DPW 1   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
165450 243102 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 6 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001583.44665 2098902.15724 37.7432749451763 -122.437171657349 (37.7432749451763, -122.437171657349) 2 7 5 63 7
166211 211005 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 800x Portola Dr 2 Median : Cutout Tree DPW 1     7 Width 4ft   5996562.64616 2099171.26049 37.7437271539842 -122.454551615288 (37.7437271539842, -122.454551615288) 1 7 4 59 40
170250 234474 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 72 Santa Marina St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006078.82979 2097595.56477 37.7399418481504 -122.421534992063 (37.7399418481504, -122.421534992063) 2 7 7 28859 2
171251 111554 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 900x BOSWORTH ST 32 Front Yard : Yard Tree DPW 1     26     6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
175848 111265 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700X BOSWORTH ST 3 Front Yard : Yard Tree DPW 1     20     6002150 2095428 37.7337679036822 -122.434964255854 (37.7337679036822, -122.434964255854) 2 7 5 63 7
183595 101034 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1010X Portola Dr 8 Front Yard : Yard Tree DPW 1           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621) 1 7 4 59 40
189067 243103 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 8 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001619.86426 2098870.33574 37.7431896408852 -122.437043457211 (37.7431896408852, -122.437043457211) 2 7 5 63 7
189697 234478 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 398 Surrey St 2 Sidewalk: Property side : Yard Tree Private 2     30 Width 5ft   6001098.40077 2096167.19905 37.7357378071451 -122.43865288754 (37.7357378071451, -122.43865288754) 2 7 5 63 7
194257 4968 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5200X Diamond Heights Blvd 4 Median : Cutout Tree DPW 1   12/03/2018 12:00:00 AM 3 12   6000815.91312 2099549.13893 37.7450077436274 -122.439871959934 (37.7450077436274, -122.439871959934) 2 7 5 63 7
194284 4966 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5200X Diamond Heights Blvd 2 Median : Cutout Tree DPW 1   12/03/2018 12:00:00 AM 3 12   6000791.48606 2099581.9209 37.7450963646197 -122.439958774198 (37.7450963646197, -122.439958774198) 2 7 5 63 7
267 178174 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 5 Sidewalk: Curb side : Yard Tree Private 2     2     5988358.3694 2089791.63303 37.717499145949 -122.482232652541 (37.717499145949, -122.482232652541) 1 8 4 64 14
450 178165 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 20 Median : Cutout Tree Private 2     5 Width 0ft   5992928.58802 2087852.90738 37.7124406464989 -122.466294818667 (37.7124406464989, -122.466294818667) 9 8 4 64 24
5669 185954 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984829.7049 2101412.004 37.7491997090577 -122.495285928093 (37.7491997090577, -122.495285928093) 1 8 3 29491 35
6387 114260 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 800x BROTHERHOOD WAY 1 Front Yard : Cutout Tree Private 2     7     5990271 2088582 37.7142888575797 -122.475533361779 (37.7142888575797, -122.475533361779) 1 8 4 64 14
6708 256455 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 2901 Sunset Blvd 4 Median : Yard Tree Private 2       3x3   5984945 2095183 37.7321032922905 -122.494428131787 (37.7321032922905, -122.494428131787) 1 8 4 64 35
7563 187388 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Sunset Blvd 74 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985049.5619 2100144.9354 37.7457335539505 -122.49443228067 (37.7457335539505, -122.49443228067) 1 8 3 29491 35
9866 178155 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 10 : Tree Private 2     6 Width 0ft   5993366.44396 2087810.43567 37.7123492834548 -122.464778384525 (37.7123492834548, -122.464778384525) 9 8 4 64 24
10548 211015 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 78 : Tree Private 2     3 Width 0ft   5991307.93934 2093199.2311 37.7270266932138 -122.472285706431 (37.7270266932138, -122.472285706431) 9 8 4 64 40
11755 186875 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985206.2214 2096387.7822 37.7354265885186 -122.493613787113 (37.7354265885186, -122.493613787113) 1 8 3 29491 35
11838 94234 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 22 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 14   Permit Number 53611 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
12887 185307 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 32 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984973.1253 2097316.8359 37.7379638824881 -122.494488141215 (37.7379638824881, -122.494488141215) 1 8 3 29491 35
14478 211030 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 165 : Tree Private 2     4 Width 0ft   5991183.72988 2091349.85826 37.7219415855123 -122.472580317121 (37.7219415855123, -122.472580317121) 9 8 4 64 40
15433 186081 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1901 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984821.8866 2101948.8735 37.7506733477582 -122.495352551899 (37.7506733477582, -122.495352551899) 1 8 3 29491 35
17565 181385 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984917.5854 2104501.8427 37.7576886993488 -122.495209866912 (37.7576886993488, -122.495209866912) 1 8 3 56 35
18682 91505 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 21 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 35
19643 105261 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 619 GONZALEZ DR   Sidewalk: Curb side : Yard Tree Private 2     3     5988914.8 2089258.8 37.7160684695332 -122.48027037241 (37.7160684695332, -122.48027037241) 1 8 4 64 14
20336 211013 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 44 Sidewalk: Curb side : Yard Tree Private 2     3 Width 0ft   5991332.59313 2093509.69784 37.727880584217 -122.472223101034 (37.727880584217, -122.472223101034) 9 8 4 64 40
22467 211031 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2375 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   5992617.61467 2099318.2887 37.7439038024205 -122.468203163863 (37.7439038024205, -122.468203163863) 1 8 4 29491 40
23338 114378 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 842X GONZALEZ DR 3 Sidewalk: Curb side : Yard Tree Private 2     2     5988421 2089827 37.7175998975755 -122.482018759302 (37.7175998975755, -122.482018759302) 1 8 4 64 14
23395 185955 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2001 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984875.9978 2101408.1817 37.7491919243755 -122.495125567093 (37.7491919243755, -122.495125567093) 1 8 3 29491 35
23532 211021 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 78 : Tree Private 2     6 Width 0ft   5991241.40021 2092233.42701 37.7243709844069 -122.472445349599 (37.7243709844069, -122.472445349599) 9 8 4 64 40
25077 178166 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 21 : Tree Private 2     5 Width 0ft   5992891.51235 2087851.51661 37.7124346884767 -122.466422861421 (37.7124346884767, -122.466422861421) 9 8 4 64 24
27670 178138 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 9 : Tree Private 2     7 Width 0ft   5992224.93754 2087880.30275 37.7124752425212 -122.468728820297 (37.7124752425212, -122.468728820297) 9 8 4 64 24
27896 211024 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 94 : Tree Private 2     6 Width 0ft   5991236.61569 2092101.43513 37.7240082905392 -122.472452270761 (37.7240082905392, -122.472452270761) 9 8 4 64 40
30409 185563 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2201 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984887.6667 2099768.5458 37.7446906142612 -122.494964334306 (37.7446906142612, -122.494964334306) 1 8 3 29491 35
30677 178169 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 24 : Tree Private 2     6 Width 0ft   5992786.91057 2087851.54482 37.7124287295635 -122.466784396099 (37.7124287295635, -122.466784396099) 9 8 4 64 24
33869 186381 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1801 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984844.8943 2102435.3563 37.7520104429492 -122.495308863381 (37.7520104429492, -122.495308863381) 1 8 3 56 35
34002 211012 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 35 : Tree Private 2     3 Width 0ft   5991334.38006 2093575.3838 37.7280610448729 -122.472221709761 (37.7280610448729, -122.472221709761) 9 8 4 64 40
37951 178151 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 4 : Tree Private 2     3 Width 0ft   5993597.52442 2087641.38278 37.7118984245322 -122.463967443352 (37.7118984245322, -122.463967443352) 9 8 4 64 24
38569 181557 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984875.8554 2106073.5142 37.7620016277453 -122.495470098326 (37.7620016277453, -122.495470098326) 1 8 3 56 35
38732 186685 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1401 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984734.6622 2105357.4834 37.7600273389586 -122.495905599978 (37.7600273389586, -122.495905599978) 1 8 3 56 35
40897 21491 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2792X Sunset Blvd 14 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985060.3629888 2096294.4798015 37.7351618711636 -122.49411119238 (37.7351618711636, -122.49411119238) 1 8 3 29491 35
41763 114139 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 34 Sidewalk: Property side : Yard Tree Private 2     36     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
41826 187121 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2600 Sunset Blvd 57 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985174.7424 2097328.4139 37.7380074703554 -122.493791914706 (37.7380074703554, -122.493791914706) 1 8 3 29491 35
42301 87834 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 10 Sidewalk: Curb side : Cutout Tree Private 2   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
43976 178156 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 11 : Tree Private 2     5 Width 0ft   5993327.47852 2087822.82752 37.712381061909 -122.464913959129 (37.712381061909, -122.464913959129) 9 8 4 64 24
44422 94231 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 9 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 24   Permit Number 53611 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
47104 187385 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2200 Sunset Blvd 71 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985037.3743 2100116.159 37.7456538284953 -122.494472302074 (37.7456538284953, -122.494472302074) 1 8 3 29491 35
49277 211023 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 83 : Tree Private 2     5 Width 0ft   5991239.95465 2092188.59606 37.7242478060794 -122.472447079879 (37.7242478060794, -122.472447079879) 9 8 4 64 40

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