200 rows where Police Districts = 8 and qSpecies_id = 35 sorted by qAddress

View and edit SQL

Police Districts

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)
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
63516 178176 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 3 Sidewalk: Curb side : Yard Tree Private 2     3     5989163.89955 2089384.56057 37.7164282485354 -122.479418571325 (37.7164282485354, -122.479418571325) 1 8 4 64 14
93553 178171 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 8 Sidewalk: Curb side : Yard Tree Private 2     2     5988123.04078 2089845.83927 37.7176342915553 -122.483050036443 (37.7176342915553, -122.483050036443) 1 8 4 64 14
95623 178173 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 4 Sidewalk: Curb side : Yard Tree Private 2     2     5988347.73388 2089792.82325 37.717501795356 -122.482269501364 (37.717501795356, -122.482269501364) 1 8 4 64 14
137776 178172 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 7 Sidewalk: Curb side : Yard Tree Private 2     2     5988133.68649 2089845.13121 37.7176329668754 -122.483013187625 (37.7176329668754, -122.483013187625) 1 8 4 64 14
170489 178175 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Gonzalez Dr 2 Sidewalk: Curb side : Yard Tree Private 2     6     5989026.35056 2089515.50206 37.7167797908382 -122.47990357931 (37.7167797908382, -122.47990357931) 1 8 4 64 14
144446 178170 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 0 Serrano Dr 4 Sidewalk: Curb side : Yard Tree Private 2     4     5989035.58475 2090454.34239 37.7193581480518 -122.479940326497 (37.7193581480518, -122.479940326497) 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
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
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
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
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
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
49587 178167 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 22 : Tree Private 2     5 Width 0ft   5992858.09731 2087851.49534 37.7124327018762 -122.466538351485 (37.7124327018762, -122.466538351485) 9 8 4 64 24
52379 178161 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 16 : Tree Private 2     6 Width 0ft   5993106.56964 2087853.50799 37.7124525633948 -122.465679708459 (37.7124525633948, -122.465679708459) 9 8 4 64 24
71095 178152 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 7 : Tree Private 2     5 Width 0ft   5993523.09133 2087729.02455 37.7121347780763 -122.464231061624 (37.7121347780763, -122.464231061624) 9 8 4 64 24
75099 178157 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 12 : Tree Private 2     7 Width 0ft   5993292.82373 2087832.959 37.712406882332 -122.465034470985 (37.712406882332, -122.465034470985) 9 8 4 64 24
84561 178158 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 13 : Tree Private 2     5 Width 0ft   5993255.20411 2087840.25906 37.7124247572585 -122.465165024673 (37.7124247572585, -122.465165024673) 9 8 4 64 24
122237 178153 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 8 : Tree Private 2     7 Width 0ft   5993495.89449 2087748.40295 37.7121864189299 -122.464326467118 (37.7121864189299, -122.464326467118) 9 8 4 64 24
133124 178162 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 17 : Tree Private 2     5 Width 0ft   5993072.48922 2087856.39417 37.7124585223038 -122.465797709423 (37.7124585223038, -122.465797709423) 9 8 4 64 24
134318 178164 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 19 : Tree Private 2     5 Width 0ft   5993000.50065 2087852.84302 37.71244461881 -122.46604626403 (37.71244461881, -122.46604626403) 9 8 4 64 24
157706 178159 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 14 : Tree Private 2     5 Width 0ft   5993218.97583 2087844.63687 37.7124346884772 -122.465290557432 (37.7124346884772, -122.465290557432) 9 8 4 64 24
167203 178168 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 23 : Tree Private 2     5 Width 0ft   5992821.74753 2087850.08942 37.712426743882 -122.466663884229 (37.712426743882, -122.466663884229) 9 8 4 64 24
174956 178160 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 15 : Tree Private 2     6 Width 0ft   5993144.35627 2087854.16093 37.7124565357104 -122.465549154771 (37.7124565357104, -122.465549154771) 9 8 4 64 24
178432 178154 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 9 : Tree Private 2     7 Width 0ft   5993415.34716 2087786.98511 37.7122877131728 -122.464607659932 (37.7122877131728, -122.464607659932) 9 8 4 64 24
182755 178163 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 18 : Tree Private 2     5 Width 0ft   5993033.97644 2087855.75659 37.7124545499972 -122.465930773993 (37.7124545499972, -122.465930773993) 9 8 4 64 24
194461 265095 Property Tree 8 Pinus canariensis :: Canary Island Pine 35 1100 Junipero Serra Blvd 1 Side Yard : Cutout Tree Private 2       10x10   5991104 2090006 37.7182470667789 -122.472757983106 (37.7182470667789, -122.472757983106) 9 8 4 64 40
66990 98838 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1101X Portola Dr 7 Sidewalk: Property side : Yard Tree DPW 1   04/11/2013 12:00:00 AM 3     5994967.95791 2097979.30417 37.740362747151 -122.459979297607 (37.740362747151, -122.459979297607) 9 8 4 59 40
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
61085 114124 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 17 Sidewalk: Property side : Yard Tree Private 2     12     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
75828 114138 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 32 Sidewalk: Property side : Yard Tree Private 2   02/16/2016 12:00:00 AM 3     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
108114 114123 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 16 Sidewalk: Property side : Yard Tree Private 2     18     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
142428 114137 Undocumented 4 Pinus canariensis :: Canary Island Pine 35 1200X JUNIPERO SERRA BLVD 33 Sidewalk: Property side : Yard Tree Private 2     26     5991123 2089585 37.7170922039834 -122.472661630304 (37.7170922039834, -122.472661630304) 1 8 4 64 14
67047 186733 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1250 Sunset Blvd 2 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984855.8629 2106397.0571 37.7628888152225 -122.495563108047 (37.7628888152225, -122.495563108047) 1 8 3 56 35
72264 184348 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1251 Sunset Blvd 14 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984683.9949 2106431.9954 37.7629746803622 -122.496160108596 (37.7629746803622, -122.496160108596) 1 8 3 56 35
75630 184347 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1251 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984658.9334 2106421.3632 37.7629440193232 -122.496246001897 (37.7629440193232, -122.496246001897) 1 8 3 56 35
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
104823 181540 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984863.0454 2105869.1102 37.7614396414651 -122.495499326148 (37.7614396414651, -122.495499326148) 1 8 3 56 35
119256 181538 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Sunset Blvd 16 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984897.5768 2105857.4141 37.761409549185 -122.495379035532 (37.761409549185, -122.495379035532) 1 8 3 56 35
95893 184801 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1301 Sunset Blvd 62 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984720.8276 2105758.3732 37.7611272600096 -122.49598302149 (37.7611272600096, -122.49598302149) 1 8 3 56 35
76251 181473 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400 Sunset Blvd 33 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984918.4628 2105275.6702 37.7598134657238 -122.49526389807 (37.7598134657238, -122.49526389807) 1 8 3 56 35
190105 181519 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400 Sunset Blvd 79 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984899.8047 2105606.7824 37.7607215150149 -122.49535284581 (37.7607215150149, -122.49535284581) 1 8 3 56 35
193293 181513 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1400 Sunset Blvd 73 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984909.8299 2105563.3396 37.7606028201969 -122.495314969775 (37.7606028201969, -122.495314969775) 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
169756 186691 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1401 Sunset Blvd 48 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984728.0673 2105259.502 37.7597579231437 -122.495921180027 (37.7597579231437, -122.495921180027) 1 8 3 56 35
172979 186699 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1401 Sunset Blvd 56 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984730.9983 2105175.3386 37.7595270055976 -122.495904834542 (37.7595270055976, -122.495904834542) 1 8 3 56 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
93290 181384 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984945.4334 2104486.2478 37.75764751046 -122.49511240858 (37.75764751046, -122.49511240858) 1 8 3 56 35
99999 181379 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1500 Sunset Blvd 12 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984933.4588 2104463.134 37.7575833453331 -122.495152116603 (37.7575833453331, -122.495152116603) 1 8 3 56 35
153819 186620 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1501 Sunset Blvd 91 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984755.0749 2104355.2681 37.7572767304033 -122.495761074715 (37.7572767304033, -122.495761074715) 1 8 3 56 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
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
53868 91504 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 18 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
72849 91503 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 15 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
125671 91502 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 12 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
185823 94235 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 9 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 27   Permit Number 53611 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
132634 94230 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Everglade Sloat Blvd 9 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 12   Permit Number 53611 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 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
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
62197 94233 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 15 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 12   Permit Number 53611 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 35
134883 87835 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 11 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
139760 94232 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 12 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
88636 186468 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 56 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984781.1405 2103769.7876 37.7556706898247 -122.495627747424 (37.7556706898247, -122.495627747424) 1 8 3 56 35
88779 186421 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 9 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984727.9626 2104153.7573 37.756721849906 -122.495839973726 (37.756721849906, -122.495839973726) 1 8 3 56 35
89742 186435 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984740.5243 2104016.8346 37.7563466338471 -122.495786431621 (37.7563466338471, -122.495786431621) 1 8 3 56 35
153020 186456 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 44 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984777.372 2103875.7247 37.7559613430639 -122.495648593467 (37.7559613430639, -122.495648593467) 1 8 3 56 35
186740 186440 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1601 Sunset Blvd 28 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984767.7413 2103960.7256 37.7561941679911 -122.495688168642 (37.7561941679911, -122.495688168642) 1 8 3 56 35
123530 186167 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1700 Sunset Blvd 52 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984926.5892 2103481.0156 37.7548863180592 -122.495103454208 (37.7548863180592, -122.495103454208) 1 8 3 56 35
146921 186247 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1701 Sunset Blvd 58 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984819.3113 2103171.6078 37.7540304886989 -122.495451627268 (37.7540304886989, -122.495451627268) 1 8 3 56 35
156752 186238 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1701 Sunset Blvd 49 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984762.5292 2103340.0793 37.7544897398871 -122.495660416165 (37.7544897398871, -122.495660416165) 1 8 3 56 35
163252 186251 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1701 Sunset Blvd 62 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984830.2927 2103110.5403 37.7538634572036 -122.495409148018 (37.7538634572036, -122.495409148018) 1 8 3 56 35
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
69193 186380 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1801 Sunset Blvd 47 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984843.2782 2102467.9478 37.7520998356184 -122.495316855331 (37.7520998356184, -122.495316855331) 1 8 3 56 35
61408 186038 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Sunset Blvd 33 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984981.8854 2102120.1374 37.7511529582795 -122.494811896529 (37.7511529582795, -122.494811896529) 1 8 3 29491 35
92103 186040 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1900 Sunset Blvd 35 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5985014.7934 2102133.6877 37.7511920899125 -122.49469909774 (37.7511920899125, -122.49469909774) 1 8 3 29491 35
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
97315 186080 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1901 Sunset Blvd 26 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984851.2986 2101988.3321 37.7507834123081 -122.495253753816 (37.7507834123081, -122.495253753816) 1 8 3 29491 35
106659 111575 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1x SUNSET BLVD OFF RAMP 7 Median : Cutout Tree DPW 1     5 3x3   5984955 2095624 37.7333147463652 -122.494426056577 (37.7333147463652, -122.494426056577) 1 8 4 64 35
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
51083 178139 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 10 : Tree Private 2     6 Width 0ft   5992188.74587 2087889.24466 37.7124977039766 -122.468854559004 (37.7124977039766, -122.468854559004) 9 8 4 64 24
66301 178130 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 1 : Tree Private 2     7 Width 0ft   5992655.54446 2087848.4586 37.7124126730818 -122.4672382093 (37.7124126730818, -122.4672382093) 9 8 4 64 24
68619 178132 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 3 : Tree Private 2     6 Width 0ft   5992585.12632 2087848.18621 37.7124078599039 -122.467481573927 (37.7124078599039, -122.467481573927) 9 8 4 64 24
82846 178140 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 11 : Tree Private 2     6 Width 0ft   5992153.76433 2087899.91411 37.712524978625 -122.468976240883 (37.712524978625, -122.468976240883) 9 8 4 64 24
87580 178149 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 20 : Tree Private 2     4 Width 0ft   5991654.66793 2087995.14516 37.712757610756 -122.470708188538 (37.712757610756, -122.470708188538) 9 8 4 64 24
88271 178133 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 4 : Tree Private 2     6 Width 0ft   5992553.46677 2087849.43624 37.7124094643071 -122.467591088862 (37.7124094643071, -122.467591088862) 9 8 4 64 24
88362 178135 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 6 : Tree Private 2     5 Width 0ft   5992385.69997 2087851.79588 37.7124062555186 -122.468171108404 (37.7124062555186, -122.468171108404) 9 8 4 64 24
90257 178131 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 2 : Tree Private 2     5 Width 0ft   5992618.59421 2087849.23546 37.7124126730667 -122.467365975965 (37.7124126730667, -122.467365975965) 9 8 4 64 24
90962 178141 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 12 Median : Yard Tree Private 2 DPW   5 Width 0ft   5992021.87667 2087934.24208 37.7126116138994 -122.469434578544 (37.7126116138994, -122.469434578544) 9 8 4 64 24
111520 178143 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 14 : Tree Private 2     5 Width 0ft   5991964.10718 2087949.4813 37.7126501183836 -122.4696353549 (37.7126501183836, -122.4696353549) 9 8 4 64 24
117654 178148 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 19 : Tree Private 2     5 Width 0ft   5991783.61367 2087988.33952 37.7127463800143 -122.470262019583 (37.7127463800143, -122.470262019583) 9 8 4 64 24
121908 178144 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 15 : Tree Private 2     4 Width 0ft   5991934.88004 2087954.77106 37.7126629535013 -122.469736757058 (37.7126629535013, -122.469736757058) 9 8 4 64 24
142106 178147 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 18 : Tree Private 2     4 Width 0ft   5991814.6494 2087985.34878 37.712739962461 -122.47015453352 (37.712739962461, -122.47015453352) 9 8 4 64 24
145727 178137 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 8 : Tree Private 2     5 Width 0ft   5992316.61451 2087859.09194 37.7124222985339 -122.468410417129 (37.7124222985339, -122.468410417129) 9 8 4 64 24
159200 178136 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 7 : Tree Private 2     5 Width 0ft   5992351.13254 2087854.27594 37.7124110686957 -122.468290763208 (37.7124110686957, -122.468290763208) 9 8 4 64 24
160793 178142 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 13 : Tree Private 2     5 Width 0ft   5991993.89623 2087943.01111 37.7126340744777 -122.469531924782 (37.7126340744777, -122.469531924782) 9 8 4 64 24
170410 178146 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 17 : Tree Private 2     4 Width 0ft   5991839.8077 2087981.8975 37.7127319405071 -122.47006732805 (37.7127319405071, -122.47006732805) 9 8 4 64 24
182192 178134 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 5 Side Yard : Yard Tree DPW 1     5 Width 0ft   5992424.40969 2087850.98169 37.7124062555176 -122.468037257827 (37.7124062555176, -122.468037257827) 9 8 4 64 24
184676 178150 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 21 : Tree Private 2     4 Width 0ft   5991622.99627 2087995.81221 37.7127576107372 -122.470817703474 (37.7127576107372, -122.470817703474) 9 8 4 64 24
184903 178145 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 16 : Tree Private 2     4 Width 0ft   5991905.80045 2087967.06921 37.7126950404068 -122.469838159212 (37.7126950404068, -122.469838159212) 9 8 4 64 24
101060 185902 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2000 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985031.1855 2101301.2352 37.7489073626901 -122.494581050501 (37.7489073626901, -122.494581050501) 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)
);