400 rows where qSpecies_id = 43 sorted by PermitNotes

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
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
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
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
67090 90956 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 4645 Balboa St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/12/2008 12:00:00 AM 3 3x3   5981155.43871 2110931.20899 37.7751208933778 -122.508698002643 (37.7751208933778, -122.508698002643) 11 6 2 55 26
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
173394 64645 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 855 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/06/1997 12:00:00 AM     Permit Number 25560 5994845.99503562 2093786.0882856 37.7288421898975 -122.460097287553 (37.7288421898975, -122.460097287553) 9 7 4 28861 40
115816 67467 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 4078 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1999 12:00:00 AM     Permit Number 30982 6003350.50488606 2101289.69360575 37.7499308522406 -122.431232018452 (37.7499308522406, -122.431232018452) 2 4 5 28862 22
100897 68054 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1881 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/23/1993 12:00:00 AM     Permit Number 31791 5993737.20481548 2102706.11474697 37.7532705090115 -122.46457785688 (37.7532705090115, -122.46457785688) 1 8 4 56 12
34181 68180 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 75 Rossi Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1993 12:00:00 AM     Permit Number 31952 5996329.36645327 2111693.70801186 37.7780972208044 -122.456263479509 (37.7780972208044, -122.456263479509) 11 6 2 54 16
59370 68249 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 3531 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32050 6001184.87724579 2120700.92595518 37.8031062325164 -122.440112611548 (37.8031062325164, -122.440112611548) 13 9 1 57 17
160336 68399 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 10 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32230 5993170.65048654 2093114.37273837 37.7269013208382 -122.465840234227 (37.7269013208382, -122.465840234227) 9 8 4 59 40
12226 68412 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 33 Pinehurst Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32249 5993232.78328668 2093269.41121212 37.7273306024275 -122.465636703092 (37.7273306024275, -122.465636703092) 9 8 4 59 40
178201 68496 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1822 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32372 5993466.35859208 2103074.11595722 37.7542653280544 -122.465541223192 (37.7542653280544, -122.465541223192) 1 8 4 56 12
68189 68517 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 146 Quintara St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32397 5993053.91795071 2101210.30087773 37.7491239746497 -122.466832052807 (37.7491239746497, -122.466832052807) 1 8 4 29491 12
162238 68548 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 542 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32435 5982266.27393695 2112076.97528737 37.7783322447781 -122.504940366327 (37.7783322447781, -122.504940366327) 11 6 2 55 26
41684 68560 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 520 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/18/1993 12:00:00 AM     Permit Number 32450 5981950.36786377 2112213.67297772 37.7786889858471 -122.506043321809 (37.7786889858471, -122.506043321809) 11 6 2 55 26
93886 68599 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1939 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/1993 12:00:00 AM     Permit Number 32502 5991241.84953509 2102215.30732714 37.7517787113613 -122.473171429533 (37.7517787113613, -122.473171429533) 1 8 4 29491 12
23688 68883 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 59 Carr St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1993 12:00:00 AM     Permit Number 32855 6013060.20442694 2090777.05783105 37.721610806199 -122.396918198144 (37.721610806199, -122.396918198144) 10 3 8 58 1
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
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
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
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
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
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
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
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
63942 31145 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 419 Hearst Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/21/2006 12:00:00 AM   3x3 Permit Number 34852 5998635.87955939 2094356.6234018 37.7306259997996 -122.447036492148 (37.7306259997996, -122.447036492148) 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
131078 31826 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35286 6009467.18551703 2109171.58635448 37.7719174714901 -122.410636689386 (37.7719174714901, -122.410636689386) 8 2 9 28853 34
172252 31827 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35286 6009467.18551703 2109171.58635448 37.7719174714901 -122.410636689386 (37.7719174714901, -122.410636689386) 8 2 9 28853 34
139708 31829 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 222 Dore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35288 6009542.64532801 2109092.58934898 37.7717047944846 -122.410370088519 (37.7717047944846, -122.410370088519) 8 2 9 28853 34
156451 31830 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 222 Dore St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/19/1995 12:00:00 AM     Permit Number 35288 6009542.64532801 2109092.58934898 37.7717047944846 -122.410370088519 (37.7717047944846, -122.410370088519) 8 2 9 28853 34
169396 33344 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 760 Darien Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/14/1996 12:00:00 AM     Permit Number 37481 5993727.41255463 2094297.74009538 37.730182659203 -122.464001399226 (37.730182659203, -122.464001399226) 9 8 4 59 40
161378 34346 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 255 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38104 6004828.12803067 2098393.70147146 37.7420627492496 -122.425916201102 (37.7420627492496, -122.425916201102) 2 7 5 63 7
14912 34353 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 11 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38109 6004890.69932117 2098315.24737801 37.7418508681298 -122.425694266568 (37.7418508681298, -122.425694266568) 2 7 5 63 7
94256 34355 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 84 Chenery St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/11/2003 12:00:00 AM     Permit Number 38111 6004874.55521399 2097707.40817778 37.7401809675376 -122.425706834494 (37.7401809675376, -122.425706834494) 2 7 5 63 7
14374 34363 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1846 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38119 6004556.0268692 2098000.12862747 37.7409667067108 -122.426829018524 (37.7409667067108, -122.426829018524) 2 7 5 63 7
13812 34364 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1862 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38120 6004563.40220029 2097868.81083057 37.7406065549579 -122.426794167737 (37.7406065549579, -122.426794167737) 2 7 5 63 7
45134 34388 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 100 Mateo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38136 6003730.56187145 2096520.40051304 37.7368570045518 -122.429577666227 (37.7368570045518, -122.429577666227) 2 7 5 63 7
142202 34398 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 141 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/22/2016 12:00:00 AM 3   Permit Number 38145 6002598.06465628 2096836.91119738 37.7376618812243 -122.433515816831 (37.7376618812243, -122.433515816831) 2 7 5 63 7
50923 34400 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 156 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38147 6002471.83146577 2097061.86671715 37.738272394243 -122.433968340214 (37.738272394243, -122.433968340214) 2 7 5 63 7
125415 34401 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 157 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38148 6002541.2507672 2096900.64630627 37.7378336595187 -122.433716803341 (37.7378336595187, -122.433716803341) 2 7 5 63 7
29221 34402 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 160 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38149 6002458.41825324 2097080.12272084 37.7383217597979 -122.434016021054 (37.7383217597979, -122.434016021054) 2 7 5 63 7
63600 34404 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 171 Moffitt St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38152 6002491.04646095 2096956.56807226 37.7379843589135 -122.433894379886 (37.7379843589135, -122.433894379886) 2 7 5 63 7
26194 34414 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 205 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38161 6004190.49432582 2097526.98545022 37.7396468892769 -122.428059186764 (37.7396468892769, -122.428059186764) 2 7 5 63 7
136510 34429 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 204 Surrey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38173 6002089.34387418 2096139.54747106 37.7357182050796 -122.435224839434 (37.7357182050796, -122.435224839434) 2 7 5 63 7
30149 34482 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 840 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/15/1997 12:00:00 AM     Permit Number 38209 6008945.03028541 2119415.9766962 37.8000168102383 -122.413167394928 (37.8000168102383, -122.413167394928) 3 1 10 308 32
180904 34527 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2856 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/22/1997 12:00:00 AM     Permit Number 38237 6001046.30881699 2116265.48327203 37.7909197844571 -122.440273859259 (37.7909197844571, -122.440273859259) 13 6 1 29490 27
189659 34528 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 2856 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1997 12:00:00 AM     Permit Number 38237 6001046.30881699 2116265.48327203 37.7909197844571 -122.440273859259 (37.7909197844571, -122.440273859259) 13 6 1 29490 27
83598 34569 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 212 Prentiss St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM     Permit Number 38277 6008791.12126389 2097614.61295509 37.7401467112036 -122.41215832665 (37.7401467112036, -122.41215832665) 10 7 7 28859 2
140509 34630 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1766 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 3   Permit Number 38311 5988776.9552 2103320.2277 37.7546695008183 -122.481776191509 (37.7546695008183, -122.481776191509) 1 8 3 56 35
193773 34629 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1766 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 6   Permit Number 38311 5988774.7652 2103307.0873 37.7546332934455 -122.481782802584 (37.7546332934455, -122.481782802584) 1 8 3 56 35
103016 34646 Permitted Site 7 Dodonaea viscosa :: Hop Bush 43 1596 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/1997 12:00:00 AM     Permit Number 38325 5987803.91965419 2104439.10360026 37.7576849982837 -122.48522326103 (37.7576849982837, -122.48522326103) 1 8 3 56 35
17683 34648 DPW Maintained 1 Dodonaea viscosa :: Hop Bush 43 1591 27th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/28/1997 12:00:00 AM 5   Permit Number 38327 5987753.8097 2104490.816 37.7578240672557 -122.485400354271 (37.7578240672557, -122.485400354271) 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)
);