trees

244 rows where qCaretaker_id = 2 and qSpecies_id = 35 sorted by qAddress descending

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

qCaretaker_id ✖

  • Private · 244 ✖
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)
81883 106311 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 5 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
181784 106310 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 99X Clearfield Dr 4 Sidewalk: Property side : Yard Tree Private 2   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.46484 37.7328958169551 -122.491498163849 (37.7328958169551, -122.491498163849) 1 8 4 64 35
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
126819 257966 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 98X Clearfield Dr 1 Side Yard : Yard Tree Private 2       3x3 Permit Number 782748 5986022 2095487 37.7330009680725 -122.490727117227 (37.7330009680725, -122.490727117227) 1 8 4 64 35
90902 194427 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 905 Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6008110 2110227 37.7747392032863 -122.415406037323 (37.7747392032863, -122.415406037323) 8 2 9 28853 34
138142 115834 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 900X LAKE MERCED BLVD 2 Median : Cutout Tree Private 2   08/30/2016 12:00:00 AM 3 10x100 Permit Number 777492 5987646 2090104 37.7183153647657 -122.484717856844 (37.7183153647657, -122.484717856844) 1 8 4 64 14
78181 98278 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 900 Brotherhood Way 500 Sidewalk: Curb side : Yard Tree Private 2   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.480419123791 (37.7146559434524, -122.480419123791) 1 8 4 64 14
136696 98279 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 900 Brotherhood Way 501 Sidewalk: Curb side : Yard Tree Private 2   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.480419123791 (37.7146559434524, -122.480419123791) 1 8 4 64 14
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
53879 114377 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 842X GONZALEZ DR 2 Sidewalk: Curb side : Yard Tree Private 2     2     5988421 2089827 37.7175998975755 -122.482018759302 (37.7175998975755, -122.482018759302) 1 8 4 64 14
128412 105268 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 842X GONZALEZ DR 1 Sidewalk: Curb side : Yard Tree Private 2     2     5988421 2089827 37.7175998975755 -122.482018759302 (37.7175998975755, -122.482018759302) 1 8 4 64 14
82197 114371 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 821 GONZALEZ DR 2 Sidewalk: Curb side : Yard Tree Private 2     2     5988453 2089765 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
161266 114370 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 821 GONZALEZ DR 1 Sidewalk: Curb side : Yard Tree Private 2     2     5988453 2089765 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
163611 114372 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 821 GONZALEZ DR 3 Sidewalk: Curb side : Yard Tree Private 2     3     5988453 2089765 37.7174315222235 -122.481903612061 (37.7174315222235, -122.481903612061) 1 8 4 64 14
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
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
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
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
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
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
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
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
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
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
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
51793 211027 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 157 : Tree Private 2     4 Width 0ft   5991179.7136 2091396.79999 37.7220702434165 -122.47259762098 (37.7220702434165, -122.47259762098) 9 8 4 64 40
112823 211025 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 95 : Tree Private 2     6 Width 0ft   5991234.71561 2092082.53367 37.7239562818437 -122.472457461651 (37.7239562818437, -122.472457461651) 9 8 4 64 40
123187 211017 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 49 : Tree Private 2     5 Width 0ft   5991258.9422 2092457.39845 37.7249869696545 -122.472401030094 (37.7249869696545, -122.472401030094) 9 8 4 64 40
123901 211026 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 138 : Tree Private 2     4 Width 0ft   5991196.61305 2091604.80622 37.7226423552448 -122.472554361808 (37.7226423552448, -122.472554361808) 9 8 4 64 40
126959 211020 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 74 : Tree Private 2     4 Width 0ft   5991248.48231 2092260.69315 37.7244462603628 -122.472422854829 (37.7244462603628, -122.472422854829) 9 8 4 64 40
133693 211016 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 46 : Tree Private 2     3 Width 0ft   5991242.43895 2092472.66575 37.7250279346749 -122.472459191965 (37.7250279346749, -122.472459191965) 9 8 4 64 40
137297 211019 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 71 : Tree Private 2     3 Width 0ft   5991242.8983 2092280.74938 37.7245010065929 -122.472443619273 (37.7245010065929, -122.472443619273) 9 8 4 64 40
167758 211029 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 162 : Tree Private 2     5 Width 0ft   5991185.525 2091363.77787 37.7219799092267 -122.472575126241 (37.7219799092267, -122.472575126241) 9 8 4 64 40
180575 211022 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 80 : Tree Private 2     3 Width 0ft   5991230.5084 2092239.13983 37.7243860399747 -122.472483416991 (37.7243860399747, -122.472483416991) 9 8 4 64 40
182077 211028 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 160 : Tree Private 2     4 Width 0ft   5991184.3391 2091378.75733 37.7220209704755 -122.472580317131 (37.7220209704755, -122.472580317131) 9 8 4 64 40
191519 211018 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 700 Junipero Serra Blvd 55 : Tree Private 2     3 Width 0ft   5991237.26366 2092440.87353 37.7249403415953 -122.472474765495 (37.7249403415953, -122.472474765495) 9 8 4 64 40
65012 254798 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 22 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
92672 254785 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 8 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
96966 254788 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 11 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
103504 254796 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 19 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
141899 254786 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 9 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
144504 254787 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 10 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
145411 254797 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 21 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
148334 254794 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 20 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
152315 254800 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 23 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
179255 254795 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 700 Brotherhood Way 18 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
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
120683 255712 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 618x Mendell St 6 Front Yard : Yard Tree Private 2       3x3 Permit Number 781846 6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
80290 200146 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 6101 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   6013586.8559 2091305.2042 37.7230902914135 -122.395134667477 (37.7230902914135, -122.395134667477) 10 3 8 58 1
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
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
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
129267 98161 Significant Tree 6 Pinus canariensis :: Canary Island Pine 35 600 Front St   Front Yard : Yard Tree Private 2   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.399449857041 (37.7974274520849, -122.399449857041) 3 1 10 28860 6
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
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
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
186953 173744 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500X Grand View Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000114 2102099 37.7519690677882 -122.442482075417 (37.7519690677882, -122.442482075417) 2 4 5 28862 22
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
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
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
67535 211010 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 27 : Tree Private 2     3 Width 0ft   5991339.10103 2093646.61822 37.7282569100089 -122.472210579766 (37.7282569100089, -122.472210579766) 9 8 4 64 40
106955 211009 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 25 : Tree Private 2     4 Width 0ft   5991341.55983 2093667.80622 37.728315229259 -122.472203623507 (37.728315229259, -122.472203623507) 9 8 4 64 40
160689 211014 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 53 : Tree Private 2     3 Width 0ft   5991322.30761 2093384.47859 37.7275361681597 -122.4722495339 (37.7275361681597, -122.4722495339) 9 8 4 64 40
191418 211011 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Junipero Serra Blvd 34 : Tree Private 2     3 Width 0ft   5991335.35345 2093583.37833 37.7280830521881 -122.472218927265 (37.7280830521881, -122.472218927265) 9 8 4 64 40
71549 234477 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 500 Grand View Ave 4 Front Yard : Yard Tree Private 2     3     5999979.48342 2101750.0189 37.7510031819599 -122.442922193204 (37.7510031819599, -122.442922193204) 2 4 5 28862 22
19548 234472 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 4810 17th St 1 Sidewalk: Property side : Yard Tree Private 2     28 Width 2ft   5998175.60392 2105685.14055 37.7617050378737 -122.449443663887 (37.7617050378737, -122.449443663887) 15 5 11 29492 9
63272 4532 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 3 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6005027.0371 2113673.2533 37.784028006638 -122.42631605912 (37.784028006638, -122.42631605912) 7 9 11 28858 41
127704 4530 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004963.1338 2113665.364 37.7840027322121 -122.426536579485 (37.7840027322121, -122.426536579485) 7 9 11 28858 41
137065 4531 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 45 Cleary Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3X3 Permit Number 781999 6004996.2689 2113667.7308 37.7840111039908 -122.426422112629 (37.7840111039908, -122.426422112629) 7 9 11 28858 41
99863 114934 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 4400x OCEAN AVE 10 Front Yard : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
113218 114925 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 4400x OCEAN AVE 3 Front Yard : Cutout Tree Private 2   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931 2095134 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892) 1 8 4 64 35
52814 211034 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 2 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5995115.07777 2100328.51022 37.7468215422 -122.45964072765 (37.7468215422, -122.45964072765) 1 8 4 59 40
105094 96843 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2           5995136 2100316.9 37.7467908665237 -122.459567540316 (37.7467908665237, -122.459567540316) 1 8 4 59 40
122904 96844 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2           5995136 2100316.9 37.7467908665237 -122.459567540316 (37.7467908665237, -122.459567540316) 1 8 4 59 40
168170 211033 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 417 Dewey Blvd 3 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   5995123.84893 2100332.44688 37.7468328556504 -122.459610683101 (37.7468328556504, -122.459610683101) 1 8 4 59 40
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
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
21134 87016 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 3 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
109718 87015 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 2 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
160963 87014 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 35 Whitfield Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.381653502791 (37.7310090102049, -122.381653502791) 10 3 8 58 1
33716 178129 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 345 Tocoloma Ave 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6012554.38724 2086809.43241 37.7106883309719 -122.398388432799 (37.7106883309719, -122.398388432799) 10 3 8 309 1
116936 100068 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 303 Serrano Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990392 2090762 37.720281613079 -122.47527420247 (37.720281613079, -122.47527420247) 1 8 4 64 40
141879 211032 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 297 Dorantes Ave 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 3ft   5993259.54182 2099680.27875 37.7449347888095 -122.466009845078 (37.7449347888095, -122.466009845078) 1 8 4 29491 40
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
87610 185118 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2850 35th Ave 1 Sidewalk: Property side : Yard Tree Private 2     21 Width 0ft   5985615.0479 2096000.8357 37.7343880441022 -122.492171858431 (37.7343880441022, -122.492171858431) 1 8 3 29491 35
53240 185023 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985046.088 2096329.59 37.7352574390957 -122.494163132435 (37.7352574390957, -122.494163132435) 1 8 3 29491 35
128912 184982 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984985.373 2096691.786 37.7362483795762 -122.494399733702 (37.7362483795762, -122.494399733702) 1 8 3 29491 35
165017 185033 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2701 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985049.8565 2096299.4419 37.7351748809707 -122.494147882197 (37.7351748809707, -122.494147882197) 1 8 3 29491 35
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
55245 186890 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 39 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985200.262 2096503.3044 37.7357434330648 -122.493642900348 (37.7357434330648, -122.493642900348) 1 8 3 29491 35
130337 186855 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 4 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985186.2801 2096278.9071 37.7351264799029 -122.49367471051 (37.7351264799029, -122.49367471051) 1 8 3 29491 35
133423 186893 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985181.9251 2096557.8565 37.7358921458374 -122.493710315825 (37.7358921458374, -122.493710315825) 1 8 3 29491 35
134727 186880 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     14 Width 0ft   5985201.1788 2096460.2128 37.7356251686507 -122.49363655642 (37.7356251686507, -122.49363655642) 1 8 3 29491 35
173124 186878 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 27 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985170.4646 2096439.5838 37.7355667300556 -122.493741225987 (37.7355667300556, -122.493741225987) 1 8 3 29491 35
191503 186889 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2700 Sunset Blvd 38 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985183.3004 2096502.846 37.7357411821318 -122.493701508581 (37.7357411821318, -122.493701508581) 1 8 3 29491 35
54367 253555 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 27 Ceres St 1 Front Yard : Yard Tree Private 2 FUF         6013919.66127 2093997.42296 37.7305010827376 -122.394172607985 (37.7305010827376, -122.394172607985) 10 3 8 58 1
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
60102 185310 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984962.2385 2097256.121 37.7377965384833 -122.494521307154 (37.7377965384833, -122.494521307154) 1 8 3 29491 35
143757 185290 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984983.8028 2097379.2257 37.738135813056 -122.494455822202 (37.738135813056, -122.494455822202) 1 8 3 29491 35
158532 185308 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 33 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985001.1798 2097292.5499 37.7378988415191 -122.494389354717 (37.7378988415191, -122.494389354717) 1 8 3 29491 35

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