400 rows where qSpecies_id = 43 sorted by PlantDate

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)
84 254457 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 1055X Duncan St 2 Side Yard : Yard Tree Private 2                              
1543 259573 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 298 Public Park 3 Unaccepted Street : Cutout Tree Private 2       5x10   5994238 2098707 37.7423188086517 -122.462555955845 (37.7423188086517, -122.462555955845) 1 8 4 59 40
3187 70368 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1442 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5983113.9936 2105313.3819 37.7598111971708 -122.501507359539 (37.7598111971708, -122.501507359539) 1 8 3 56 35
3986 116680 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 100 Esmeralda Ave 19 Unaccepted Street : Yard Tree DPW 1           6006917.38983 2098966.37493 37.7437530336215 -122.41873278304 (37.7437530336215, -122.41873278304) 2 7 7 28859 2
7624 246397 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999315.6516 2108414.4782 37.769264264093 -122.445696997639 (37.769264264093, -122.445696997639) 15 5 11 29492 9
9754 82920 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1734 43rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     5982872.9956 2103302.6049 37.7542760130661 -122.502192036803 (37.7542760130661, -122.502192036803) 1 8 3 56 35
10339 73455 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 24 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6009841.50181 2111066.87201 37.777142462881 -122.409475680552 (37.777142462881, -122.409475680552) 8 2 9 28853 34
10370 72596 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1551 26th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     5988056.3788 2104735.0481 37.7585122851486 -122.484371869742 (37.7585122851486, -122.484371869742) 1 8 3 56 35
13763 72614 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1586 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   6     5987797.3449 2104500.8291 37.7578540967372 -122.485250528016 (37.7578540967372, -122.485250528016) 1 8 3 56 35
25595 247352 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 717 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6003091.9924 2109593.0641 37.7727152549133 -122.432719040926 (37.7727152549133, -122.432719040926) 15 5 11 29492 9
29364 183465 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2530 27th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 0ft   5988020.0365 2098057.021 37.7401740893942 -122.484007860756 (37.7401740893942, -122.484007860756) 1 8 3 29491 35
32117 183413 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2350 Wawona St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5985629.7915 2097026.6067 37.737205400625 -122.492196390733 (37.737205400625, -122.492196390733) 1 8 3 29491 35
32393 246393 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1318 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999383.4853 2108424.4716 37.7692955761214 -122.445463083857 (37.7692955761214, -122.445463083857) 15 5 11 29492 9
36106 182248 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1454 34th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     4 Width 0ft   5985596.8527 2105324.6327 37.7599875985541 -122.492921320569 (37.7599875985541, -122.492921320569) 1 8 3 56 35
36889 207426 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 404 Baden St 1 Side Yard : Yard Tree Private 2     3     6000774.5178 2095253.08109 37.7332094216698 -122.439707159174 (37.7332094216698, -122.439707159174) 9 7 5 63 40
37916 233997 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1027 Douglass St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6001336.17311 2100800.0445 37.7484720346532 -122.438162590655 (37.7484720346532, -122.438162590655) 2 4 5 28862 22
41386 121194 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 255x Red Rock Way 1 Front Yard : Yard Tree Private 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
49210 114656 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 10 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6001274.7016 2113900.9823 37.78444047533 -122.439314075739 (37.78444047533, -122.439314075739) 15 6 11 29490 13
49579 114652 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6001448.056 2113923.3749 37.7845118231904 -122.438715935573 (37.7845118231904, -122.438715935573) 15 6 11 29490 13
58011 246391 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1302 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999418.9163 2108430.2253 37.7693133969257 -122.445340943975 (37.7693133969257, -122.445340943975) 15 5 11 29492 9
63515 207425 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 359 Byxbee St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 10ft   5991937.91081 2090925.40696 37.7208197721094 -122.469942439193 (37.7208197721094, -122.469942439193) 9 8 6 64 24
64436 114654 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Post St 8 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6001378.1104 2113915.8269 37.7844871189173 -122.438957381866 (37.7844871189173, -122.438957381866) 15 6 11 29490 13
65565 246392 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1310 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999402.5635 2108427.4999 37.7693049801732 -122.445397311319 (37.7693049801732, -122.445397311319) 15 5 11 29492 9
68367 14603 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1265 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 3X3   5999439.61797 2108531.98026 37.7695939720606 -122.44527665521 (37.7695939720606, -122.44527665521) 15 5 11 29492 9
68850 187339 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2200 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5985079.354 2099690.9452 37.7444887635366 -122.494295807794 (37.7444887635366, -122.494295807794) 1 8 3 29491 35
74396 121619 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 1465 Rhode Island St 1 Front Yard : Yard Tree Private 2           6012073 2101555 37.7511497699027 -122.401087656443 (37.7511497699027, -122.401087656443) 10 3 8 28856 29
75154 23668 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 315 Virginia Ave 3 Median : Cutout Tree DPW 1     3 12   6006939.5968988 2098278.7889768 37.7418663267774 -122.418607247372 (37.7418663267774, -122.418607247372) 2 7 7 28859 2
79658 141253 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 45 PARKER AVE 3 Sidewalk: Curb side : Yard Tree Private 2     2 Width 0ft   5996809.5439 2114265.4407 37.7851860717648 -122.454788237668 (37.7851860717648, -122.454788237668) 11 6 1 54 31
86065 29418 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2601X Ingalls St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6015194.8940554 2091164.3100784 37.7227927176508 -122.389566117231 (37.7227927176508, -122.389566117231) 10 3 8 58 1
89187 251679 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 5 Dwight St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011495 2091622 37.7238435952898 -122.402388102511 (37.7238435952898, -122.402388102511) 10 3 7 309 28
91288 106921 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 112-118 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6007680.5 2107244.2 37.7665249882726 -122.416680417976 (37.7665249882726, -122.416680417976) 8 4 7 28853 19
91821 246394 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999365.9212 2108422.0489 37.7692879212962 -122.445523662753 (37.7692879212962, -122.445523662753) 15 5 11 29492 9
99430 184739 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1301 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984690.4501 2106251.0591 37.7624782581791 -122.496124432854 (37.7624782581791, -122.496124432854) 1 8 3 56 35
102213 99920 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1740 Jones St 7 Sidewalk: Property side : Cutout Tree Private 2           6008334 2118406 37.7972093435845 -122.415210266144 (37.7972093435845, -122.415210266144) 5 1 10 308 21
106912 246396 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5999332.61 2108417.5065 37.769273547251 -122.445638557414 (37.769273547251, -122.445638557414) 15 5 11 29492 9
106945 140845 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 527 EUCLID AVE 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5996698.8799 2113809.925 37.7839289983891 -122.455138170133 (37.7839289983891, -122.455138170133) 11 6 1 54 31
124314 246395 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1320 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5999349.2656 2108419.0206 37.7692786554823 -122.445581055639 (37.7692786554823, -122.445581055639) 15 5 11 29492 9
139804 191035 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 30 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6009859.31671 2111047.24968 37.7770895827422 -122.409412667772 (37.7770895827422, -122.409412667772) 8 2 9 28853 34
150043 246390 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1267 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     2 Width 0ft   5999435.2691 2108467.7761 37.7694174354079 -122.445287080875 (37.7694174354079, -122.445287080875) 15 5 11 29492 9
161440 9987 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 2x2   6005339.0167972 2108804.8168432 37.7706780982219 -122.424890239466 (37.7706780982219, -122.424890239466) 8 2 5 28853 19
161625 126462 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1990 Beach St 4 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6000762.32542 2120990.48851 37.8038772290062 -122.441595650935 (37.8038772290062, -122.441595650935) 13 9 1 57 17
163727 184740 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1301 Sunset Blvd 6 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984699.9431 2106237.7689 37.7624423230543 -122.496090619994 (37.7624423230543, -122.496090619994) 1 8 3 56 35
166774 141601 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1882 GROVE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5998863.8341 2110436.3604 37.77479003056 -122.447405354515 (37.77479003056, -122.447405354515) 15 5 11 29492 16
172638 126461 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1990 Beach St 6 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6000743.63592 2120987.57838 37.8038681737437 -122.441660117946 (37.8038681737437, -122.441660117946) 13 9 1 57 17
172758 102442 Undocumented 4 Dodonaea viscosa :: Hop Bush 43 4145 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6008344 2095883 37.735366982035 -122.413581854524 (37.735366982035, -122.413581854524) 10 7 7 28859 2
177763 255250 Significant Tree 6 Dodonaea viscosa :: Hop Bush 43 209x Willow St 5 Sidewalk: Property side : Yard Tree Private 2       3x3   6006475 2113325 37.7831535286214 -122.421281886667 (37.7831535286214, -122.421281886667) 7 9 11 28858 41
180365 141254 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 45 PARKER AVE 4 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5996808.5286 2114260.026 37.7851711462005 -122.454791358921 (37.7851711462005, -122.454791358921) 11 6 1 54 31
180644 248448 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 136 Belvedere St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5998284.3672 2107976.1331 37.768001745714 -122.449232557107 (37.768001745714, -122.449232557107) 15 5 11 29492 9
64957 9986 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2007 12:00:00 AM 8 2x2   6005339.0167972 2108804.8168432 37.7706780982219 -122.424890239466 (37.7706780982219, -122.424890239466) 8 2 5 28853 19
60108 39693 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1475 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41078 6015709.80747314 2094943.53448428 37.7331982540931 -122.388049755187 (37.7331982540931, -122.388049755187) 10 3 8 58 1
74322 39707 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 738 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41092 5997200.32170515 2095026.51323817 37.7323832338006 -122.452047720375 (37.7323832338006, -122.452047720375) 9 7 4 59 40
101538 39689 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 56 Bay View St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/05/1999 12:00:00 AM     Permit Number 41074 6013706.29242939 2094956.2180602 37.7331218759444 -122.394977388495 (37.7331218759444, -122.394977388495) 10 3 8 58 1
67646 39064 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 238 Capp St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/2003 12:00:00 AM     Permit Number 40776 6007140.57976269 2105924.49860202 37.7628710155664 -122.418454324135 (37.7628710155664, -122.418454324135) 8 4 7 28859 19
100539 39065 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 238 Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/11/2003 12:00:00 AM     Permit Number 40776 6007140.57976269 2105924.49860202 37.7628710155664 -122.418454324135 (37.7628710155664, -122.418454324135) 8 4 7 28859 19
67615 69146 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2479 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/18/1994 12:00:00 AM     Permit Number 33181 5983616.53937475 2098288.7238606 37.7405529339472 -122.499250248288 (37.7405529339472, -122.499250248288) 1 8 3 29491 35
155194 55092 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 535 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2017 12:00:00 AM 3   Permit Number 779353 5990916.44075 2111744.45268 37.7779243407011 -122.474992253786 (37.7779243407011, -122.474992253786) 11 6 2 54 26
47019 39910 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
77186 39908 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
86961 39907 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
89820 39905 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1600 Divisadero St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/25/1999 12:00:00 AM     Permit Number 41187 6001194.58559448 2113861.70061497 37.7843280584248 -122.439588431897 (37.7843280584248, -122.439588431897) 15 6 11 29490 13
183661 79350 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1946 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/25/2011 12:00:00 AM 3 3x3 Permit Number 767118 5983237.8759 2101878.6369 37.7503876245198 -122.500824911735 (37.7503876245198, -122.500824911735) 1 8 3 29491 35
49935 40037 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM     Permit Number 41276 6017092.11727915 2093635.28500983 37.7296825468656 -122.383179660981 (37.7296825468656, -122.383179660981) 10 3 8 58 1
85527 40036 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM     Permit Number 41276 6017092.11727915 2093635.28500983 37.7296825468656 -122.383179660981 (37.7296825468656, -122.383179660981) 10 3 8 58 1
90253 40035 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM     Permit Number 41276 6017092.11727915 2093635.28500983 37.7296825468656 -122.383179660981 (37.7296825468656, -122.383179660981) 10 3 8 58 1
119829 40038 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM     Permit Number 41276 6017092.11727915 2093635.28500983 37.7296825468656 -122.383179660981 (37.7296825468656, -122.383179660981) 10 3 8 58 1
149710 40034 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1190 Palou Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/03/1999 12:00:00 AM     Permit Number 41276 6017092.11727915 2093635.28500983 37.7296825468656 -122.383179660981 (37.7296825468656, -122.383179660981) 10 3 8 58 1
4468 40059 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41292 6016382.10864513 2092767.10585329 37.7272594375757 -122.385573778693 (37.7272594375757, -122.385573778693) 10 3 8 58 1
36083 40050 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1439 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41287 6015928.43712332 2093739.41771764 37.729904100557 -122.387209925263 (37.729904100557, -122.387209925263) 10 3 8 58 1
47665 40058 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41292 6016382.10864513 2092767.10585329 37.7272594375757 -122.385573778693 (37.7272594375757, -122.385573778693) 10 3 8 58 1
72685 40051 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1439 Revere Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41287 6015928.43712332 2093739.41771764 37.729904100557 -122.387209925263 (37.729904100557, -122.387209925263) 10 3 8 58 1
129093 40069 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1410 Thomas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41295 6015766.58727052 2093225.96783558 37.7284853051097 -122.387733653848 (37.7284853051097, -122.387733653848) 10 3 8 58 1
146130 40068 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1410 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41295 6015766.58727052 2093225.96783558 37.7284853051097 -122.387733653848 (37.7284853051097, -122.387733653848) 10 3 8 58 1
147085 40061 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41292 6016382.10864513 2092767.10585329 37.7272594375757 -122.385573778693 (37.7272594375757, -122.385573778693) 10 3 8 58 1
151562 40060 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1298 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41292 6016382.10864513 2092767.10585329 37.7272594375757 -122.385573778693 (37.7272594375757, -122.385573778693) 10 3 8 58 1
182131 40049 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1435 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/19/1999 12:00:00 AM     Permit Number 41286 6015948.92421606 2093724.14562026 37.7298633009427 -122.38713803352 (37.7298633009427, -122.38713803352) 10 3 8 58 1
190034 69279 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1935 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/09/1994 12:00:00 AM     Permit Number 33350 5991240.95366227 2102241.42925325 37.7518503834746 -122.473176432428 (37.7518503834746, -122.473176432428) 1 8 4 29491 12
94076 31013 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1016 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/13/1995 12:00:00 AM     Permit Number 34783 6002340.84086344 2087450.93520516 37.7118755052494 -122.433734519918 (37.7118755052494, -122.433734519918) 9 7 6 28861 5
29636 69317 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2122 Lawton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1994 12:00:00 AM 6   Permit Number 33397 5987643.2305 2104427.6901 37.7576442978234 -122.485778145282 (37.7576442978234, -122.485778145282) 1 8 3 56 35
20564 35401 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 527 30th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38856 6003213.78352736 2098311.09733417 37.7417445720019 -122.431492193982 (37.7417445720019, -122.431492193982) 2 7 5 63 7
122187 35402 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 531 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38857 6003188.18562105 2098310.25744294 37.7417408149917 -122.431580643052 (37.7417408149917, -122.431580643052) 2 7 5 63 7
142598 35422 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 527 Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/16/1998 12:00:00 AM     Permit Number 38873 6002518.46166442 2099137.02773671 37.7439729506581 -122.433955407599 (37.7439729506581, -122.433955407599) 2 7 5 63 22
107910 51637 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 189 Margaret Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2005 12:00:00 AM     Permit Number 47927 5996660.05636895 2089154.42395132 37.7162289049692 -122.453491707846 (37.7162289049692, -122.453491707846) 9 8 6 28861 24
22627 31126 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 19 Foerster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34843 5998070.7770048 2093598.16198917 37.7285111411981 -122.448935514449 (37.7285111411981, -122.448935514449) 9 7 4 28861 40
27476 31110 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 415 Edna St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM     Permit Number 34838 5998740.33351858 2094135.45298345 37.7300246851321 -122.446659473393 (37.7300246851321, -122.446659473393) 9 7 4 28861 40
31634 31124 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 15 Foerster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34842 5998070.62548996 2093588.33279569 37.7284841438842 -122.448935330498 (37.7284841438842, -122.448935330498) 9 7 4 28861 40
36936 31125 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 15 Foerster St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34842 5998070.62548996 2093588.33279569 37.7284841438842 -122.448935330498 (37.7284841438842, -122.448935330498) 9 7 4 28861 40
54982 31111 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 415 Edna St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1995 12:00:00 AM     Permit Number 34838 5998740.33351858 2094135.45298345 37.7300246851321 -122.446659473393 (37.7300246851321, -122.446659473393) 9 7 4 28861 40
146965 31139 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 419 Hearst Ave 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34852 5998635.87955939 2094356.6234018 37.7306259997996 -122.447036492148 (37.7306259997996, -122.447036492148) 9 7 4 28861 40
155289 31184 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 700 Shields St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM     Permit Number 34882 5992197.59450604 2089880.36663556 37.7179653541743 -122.468968787075 (37.7179653541743, -122.468968787075) 9 8 6 64 24
114946 35548 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 25 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38924 6005398.06539258 2103564.19233402 37.7562919206066 -122.424313197508 (37.7562919206066, -122.424313197508) 2 4 5 28859 19
137219 35519 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 90 Alvarado St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38920 6005793.71652674 2102887.49607432 37.7544562030797 -122.422896805421 (37.7544562030797, -122.422896805421) 2 4 5 28859 19
148447 35550 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 50 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38925 6005353.87687584 2103421.76830911 37.7558983622011 -122.424455886685 (37.7558983622011, -122.424455886685) 2 4 5 28859 19
163982 35510 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3478 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38912 6005194.49677521 2103146.93967049 37.7551347452856 -122.424987522768 (37.7551347452856, -122.424987522768) 2 4 5 28859 19
180479 35494 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3763 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38905 6005241.37948762 2104264.99377415 37.758207308358 -122.424904929122 (37.758207308358, -122.424904929122) 2 4 5 28859 19
183856 35549 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 50 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/1998 12:00:00 AM     Permit Number 38925 6005353.87687584 2103421.76830911 37.7558983622011 -122.424455886685 (37.7558983622011, -122.424455886685) 2 4 5 28859 19
169743 37845 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 132 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/02/2005 12:00:00 AM     Permit Number 40137 6010294.81147281 2099208.35616527 37.7446070428057 -122.40707146066 (37.7446070428057, -122.40707146066) 2 7 7 28859 2
94534 42120 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 630 Mangels Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/06/2002 12:00:00 AM     Permit Number 42417 5997254.13334531 2095296.10071131 37.7331265386983 -122.451881123727 (37.7331265386983, -122.451881123727) 9 7 4 59 40
59456 44816 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2745 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 4   Permit Number 43908 5986280.5132 2105006.9468 37.7591552772781 -122.490533528729 (37.7591552772781, -122.490533528729) 1 8 3 56 35
71470 44817 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2745 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 4   Permit Number 43908 5986315.8836 2105009.2662 37.7591637116246 -122.490411373273 (37.7591637116246, -122.490411373273) 1 8 3 56 35
79954 44818 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 2745 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2001 12:00:00 AM 4   Permit Number 43908 5986255.58 2105005.7872 37.7591506369625 -122.490619673159 (37.7591506369625, -122.490619673159) 1 8 3 56 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)
);