133 rows where qSpecies_id = 66 sorted by rowid descending

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)
193262 252868 DPW Maintained 1 Shrub :: Shrub 66 15 Foerster St 2 Sidewalk: Curb side : Yard Tree Private 2       Width 3ft   5998080.65269 2093664.7185 37.7286944544712 -122.448906166111 (37.7286944544712, -122.448906166111) 9 7 4 28861 40
193173 186364 DPW Maintained 1 Shrub :: Shrub 66 1801 Sunset Blvd 31 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984815.8043 2102571.1093 37.7523814800587 -122.495419470402 (37.7523814800587, -122.495419470402) 1 8 3 56 35
188674 102267 DPW Maintained 1 Shrub :: Shrub 66 100X Casitas Ave 1 Median : Cutout Tree DPW 1     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
186666 65625 Permitted Site 7 Shrub :: Shrub 66 238 Ney St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/07/1990 12:00:00 AM     Permit Number 28533 6004892.15539073 2094035.47955331 37.7300996701998 -122.425384739364 (37.7300996701998, -122.425384739364) 9 7 6 28861 5
184604 30143 DPW Maintained 1 Shrub :: Shrub 66 410X Mansell St 5 Median : Cutout Tree DPW 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
183891 186250 DPW Maintained 1 Shrub :: Shrub 66 1701 Sunset Blvd 61 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984767.3503 2103112.4152 37.753864919503 -122.495626952484 (37.753864919503, -122.495626952484) 1 8 3 56 35
182004 99583 Undocumented 4 Shrub :: Shrub 66 650X Brunswick St 23 Sidewalk: Curb side : Cutout Tree Private 2     3 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
181787 102268 DPW Maintained 1 Shrub :: Shrub 66 100X Casitas Ave 2 Median : Cutout Tree DPW 1     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065) 9 7 4 59 40
178506 184756 DPW Maintained 1 Shrub :: Shrub 66 1301 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984687.2225 2106057.4022 37.761946341588 -122.496121307582 (37.761946341588, -122.496121307582) 1 8 3 56 35
175412 37379 Permitted Site 7 Shrub :: Shrub 66 755 Morse St 13 Sidewalk: Property side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
172977 185311 DPW Maintained 1 Shrub :: Shrub 66 2601 Sunset Blvd 36 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984965.5883 2097247.7465 37.737773740404 -122.494509108268 (37.737773740404, -122.494509108268) 1 8 3 29491 35
163645 184622 DPW Maintained 1 Shrub :: Shrub 66 1778 40th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5983811.7777 2103069.4322 37.7536908962098 -122.498928317229 (37.7536908962098, -122.498928317229) 1 8 3 56 35
163415 139390 DPW Maintained 1 Shrub :: Shrub 66 432 OCTAVIA ST 5 Sidewalk: Curb side : Cutout Tree Private 2   05/02/2017 03:33:00 PM 3 Width 0ft   6005538.2982 2110931.9956 37.7765300709458 -122.424352241322 (37.7765300709458, -122.424352241322) 7 9 11 28852 10
162770 21130 DPW Maintained 1 Shrub :: Shrub 66 2292X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696 (37.7442358239277, -122.49474388696) 1 8 3 29491 35
161681 4313 DPW Maintained 1 Shrub :: Shrub 66 727 Chenery St 1 Sidewalk: Curb side : Cutout Landscaping DPW 1   08/17/2013 12:00:00 AM   3X3   6002321.25178 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497) 2 7 5 63 7
161563 116580 Significant Tree 6 Shrub :: Shrub 66 3000x 19TH AVE 3 Sidewalk: Property side : Cutout Landscaping MTA 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
158923 187055 DPW Maintained 1 Shrub :: Shrub 66 2501 Sunset Blvd 74 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984955.8371 2097567.7171 37.7386517231253 -122.49456640389 (37.7386517231253, -122.49456640389) 1 8 3 29491 35
158368 30141 DPW Maintained 1 Shrub :: Shrub 66 410X Mansell St 3 Median : Cutout Tree DPW 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
155364 105003 DPW Maintained 1 Shrub :: Shrub 66 607 CONGO ST   Sidewalk: Property side : Yard Landscaping Private 2           6000094.1 2095817 37.7347190590407 -122.44210000591 (37.7347190590407, -122.44210000591) 9 7 4 63 40
155034 185692 DPW Maintained 1 Shrub :: Shrub 66 2101 Sunset Blvd 24 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984851.9348 2100530.8696 37.7467816562023 -122.495144090409 (37.7467816562023, -122.495144090409) 1 8 3 29491 35
154894 104034 Undocumented 4 Shrub :: Shrub 66 722 Wisconsin St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012694 2104139 37.7582794948464 -122.39912151779 (37.7582794948464, -122.39912151779) 10 3 8 28856 29
150872 184164 DPW Maintained 1 Shrub :: Shrub 66 1595 44th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 0ft   5982483.9557 2104274.5677 37.7569218843537 -122.503609385397 (37.7569218843537, -122.503609385397) 1 8 3 56 35
150789 99672 DPW Maintained 1 Shrub :: Shrub 66 1250X Shrader St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
149312 104783 Undocumented 4 Shrub :: Shrub 66 50 Walnut St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998501.2 2116298 37.790863832623 -122.449082132455 (37.790863832623, -122.449082132455) 13 6 1 54 31
147623 187053 DPW Maintained 1 Shrub :: Shrub 66 2501 Sunset Blvd 72 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984954.1557 2097623.876 37.7388058219757 -122.494576356208 (37.7388058219757, -122.494576356208) 1 8 3 29491 35
147554 239154 DPW Maintained 1 Shrub :: Shrub 66 150 Octavia St 6 : Tree DPW 1   04/13/2017 02:47:00 PM 3 Width 4ft   6005701.84613 2109911.12293 37.773736235682 -122.42371387849 (37.773736235682, -122.42371387849) 7 9 11 28852 10
144873 181567 DPW Maintained 1 Shrub :: Shrub 66 1300 Sunset Blvd 62 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984855.7554 2106265.0899 37.7625264639896 -122.495553745896 (37.7625264639896, -122.495553745896) 1 8 3 56 35
144357 187122 DPW Maintained 1 Shrub :: Shrub 66 2600 Sunset Blvd 58 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985165.8082 2097341.5801 37.7380430985113 -122.493823774181 (37.7380430985113, -122.493823774181) 1 8 3 29491 35
143999 244348 DPW Maintained 1 Shrub :: Shrub 66 300 Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/19/2017 02:44:00 PM 3 Width 0ft   6005622.9962 2110384.2841 37.7750309704349 -122.424020287681 (37.7750309704349, -122.424020287681) 7 9 11 28852 10
143620 106469 Undocumented 4 Shrub :: Shrub 66 100X HENRY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 5x5   6002548 2107375 37.7665941299684 -122.434442151396 (37.7665941299684, -122.434442151396) 15 5 5 28862 3
140028 184206 DPW Maintained 1 Shrub :: Shrub 66 1484 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5983432.9268 2105012.9881 37.7590051267749 -122.500382134012 (37.7590051267749, -122.500382134012) 1 8 3 56 35
133338 93163 DPW Maintained 1 Shrub :: Shrub 66 201 Upper Ter 1 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
133282 186340 DPW Maintained 1 Shrub :: Shrub 66 1801 Sunset Blvd 7 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984827.0787 2102831.0491 37.7530958632805 -122.495399651332 (37.7530958632805, -122.495399651332) 1 8 3 56 35
133233 184755 DPW Maintained 1 Shrub :: Shrub 66 1301 Sunset Blvd 25 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984688.1718 2106071.0721 37.7619839309054 -122.496119032944 (37.7619839309054, -122.496119032944) 1 8 3 56 35
131527 187056 DPW Maintained 1 Shrub :: Shrub 66 2501 Sunset Blvd 75 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984980.0493 2097557.2924 37.7386245167659 -122.49448192258 (37.7386245167659, -122.49448192258) 1 8 3 29491 35
129104 30145 DPW Maintained 1 Shrub :: Shrub 66 410X Mansell St 7 Median : Cutout Tree DPW 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
127768 30054 DPW Maintained 1 Shrub :: Shrub 66 610X Junipero Serra Blvd 7 Median : Cutout Tree DPW 1           5991361.953164 2093442.610307 37.7276980777014 -122.472116715696 (37.7276980777014, -122.472116715696) 9 8 4 64 40
126561 244299 DPW Maintained 1 Shrub :: Shrub 66 350 Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/20/2017 11:32:00 AM 3 Width 0ft   6005603.4021 2110525.6921 37.7754181362545 -122.424098126533 (37.7754181362545, -122.424098126533) 7 9 11 28852 10
126370 187377 DPW Maintained 1 Shrub :: Shrub 66 2200 Sunset Blvd 63 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985052.2703 2100029.8298 37.7454176637381 -122.49441443213 (37.7454176637381, -122.49441443213) 1 8 3 29491 35
126230 244349 DPW Maintained 1 Shrub :: Shrub 66 300 Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/19/2017 02:48:00 PM 3 Width 0ft   6005619.6911 2110403.6421 37.7750839362118 -122.424033097665 (37.7750839362118, -122.424033097665) 7 9 11 28852 10
124791 22545 DPW Maintained 1 Shrub :: Shrub 66 7 Topaz Way 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 2X3   6001395.6747593 2098711.0868843 37.7427396354232 -122.437807240323 (37.7427396354232, -122.437807240323) 2 7 5 63 7
123486 99732 DPW Maintained 1 Shrub :: Shrub 66 4150 Ocean Ave 1 Sidewalk: Property side : Cutout Landscaping Private 2           5986619.2 2095203.6 37.7322576937009 -122.488641645288 (37.7322576937009, -122.488641645288) 1 8 4 64 35
120610 181577 DPW Maintained 1 Shrub :: Shrub 66 1200 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984846.2035 2106866.5794 37.7641774260073 -122.495631149537 (37.7641774260073, -122.495631149537) 1 8 3 56 35
120528 184752 DPW Maintained 1 Shrub :: Shrub 66 1301 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984700.7025 2106093.8553 37.7620472211463 -122.496077375707 (37.7620472211463, -122.496077375707) 1 8 3 56 35
118266 244393 DPW Maintained 1 Shrub :: Shrub 66 250 Octavia St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2017 01:35:00 PM 3 Width 0ft   6005645.568 2110235.0213 37.774622405266 -122.423931590501 (37.774622405266, -122.423931590501) 7 9 11 28852 10
116531 30139 DPW Maintained 1 Shrub :: Shrub 66 410X Mansell St 1 Median : Cutout Tree DPW 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
112926 251642 DPW Maintained 1 Shrub :: Shrub 66 2253 Broderick St 4 Sidewalk: Curb side : Cutout Landscaping Private 2       3x3   6000298.51737 2116393.24113 37.7912279703404 -122.442870356286 (37.7912279703404, -122.442870356286) 13 6 1 29490 27
112833 184750 DPW Maintained 1 Shrub :: Shrub 66 1301 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984665.0089 2106100.6902 37.7620638971415 -122.496201328503 (37.7620638971415, -122.496201328503) 1 8 3 56 35
110736 187251 DPW Maintained 1 Shrub :: Shrub 66 2401 Sunset Blvd 34 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984973.9834 2098481.6163 37.7411621065182 -122.494571017919 (37.7411621065182, -122.494571017919) 1 8 3 29491 35
107863 182676 DPW Maintained 1 Shrub :: Shrub 66 1715 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   5988712.3482 2103638.8826 37.7555406843938 -122.482022959471 (37.7555406843938, -122.482022959471) 1 8 3 56 35
105604 23896 DPW Maintained 1 Shrub :: Shrub 66 1581 Webster St 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/24/2017 12:00:00 AM 3 3x3   6003535.3531022 2114132.0136397 37.7852032161945 -122.431509502733 (37.7852032161945, -122.431509502733) 13 9 11 29490 13
102820 186362 DPW Maintained 1 Shrub :: Shrub 66 1801 Sunset Blvd 29 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984819.5753 2102574.8802 37.7523920547151 -122.495406707945 (37.7523920547151, -122.495406707945) 1 8 3 56 35
101202 88829 DPW Maintained 1 Shrub :: Shrub 66 4437 20th St   Sidewalk: Curb side : Cutout Landscaping Private 2   09/30/2008 12:00:00 AM   8x1 Permit Number 51764 6001659 2104076 37.7574853780776 -122.437280798466 (37.7574853780776, -122.437280798466) 2 4 5 28862 3
99453 30165 DPW Maintained 1 Shrub :: Shrub 66 410X Mansell St 22 Median : Cutout Tree DPW 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
98817 181343 DPW Maintained 1 Shrub :: Shrub 66 2500 Sunset Blvd 20 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985164.5677 2097705.9234 37.7390434150027 -122.493854905389 (37.7390434150027, -122.493854905389) 1 8 3 29491 35
96160 94198 Permitted Site 7 Shrub :: Shrub 66 355 Ocean Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
94878 117511 DPW Maintained 1 Shrub :: Shrub 66 2634 37TH AVE 1 Median : Yard Landscaping DPW 1     20 3x3   5984921 2097163 37.7375384395308 -122.494657023299 (37.7375384395308, -122.494657023299) 1 8 3 29491 35
94409 9382 DPW Maintained 1 Shrub :: Shrub 66 337 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     0 3X3   6001129.4629101 2097791.8544146 37.7402004981777 -122.438661870607 (37.7402004981777, -122.438661870607) 2 7 5 63 7
92606 15888 DPW Maintained 1 Shrub :: Shrub 66 5625 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   5998561.46984 2087228.13524 37.7110485671916 -122.446781008521 (37.7110485671916, -122.446781008521) 9 7 6 28861 5
90692 244351 DPW Maintained 1 Shrub :: Shrub 66 300 Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1   04/20/2017 07:17:00 AM 3 Width 0ft   6005616.3861 2110436.6924 37.7751744977295 -122.424046881247 (37.7751744977295, -122.424046881247) 7 9 11 28852 10
88436 114528 Undocumented 4 Shrub :: Shrub 66 1 TIOGA AVE 4 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
87985 237035 DPW Maintained 1 Shrub :: Shrub 66 150 Octavia St 2 : Tree DPW 1   04/12/2017 02:27:00 PM 3 Width 4ft   6005709.86547 2109855.10938 37.7735828886787 -122.423682154918 (37.7735828886787, -122.423682154918) 7 9 11 28852 10
82677 244391 DPW Maintained 1 Shrub :: Shrub 66 250 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2017 01:16:00 PM 3 Width 0ft   6005650.1507 2110201.4148 37.774530388668 -122.423913347785 (37.774530388668, -122.423913347785) 7 9 11 28852 10
80964 15877 DPW Maintained 1 Shrub :: Shrub 66 5508 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/1997 12:00:00 AM 3 3X3   5999048.25069 2087729.15393 37.7124520473945 -122.445134579389 (37.7124520473945, -122.445134579389) 9 7 6 28861 25
79158 30166 DPW Maintained 1 Shrub :: Shrub 66 410X Mansell St 25 Median : Cutout Tree DPW 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
78880 251666 DPW Maintained 1 Shrub :: Shrub 66 76 Denslowe Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5990680 2091936 37.7235218144923 -122.474364317808 (37.7235218144923, -122.474364317808) 9 8 4 64 40
78365 12755 DPW Maintained 1 Shrub :: Shrub 66 1733 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/24/2008 12:00:00 AM 3 3X3   5990033.85435 2114674.56985 37.7859184370017 -122.478259694764 (37.7859184370017, -122.478259694764) 11 6 2 55 26
77702 187253 DPW Maintained 1 Shrub :: Shrub 66 2401 Sunset Blvd 36 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984962.1374 2098459.5582 37.7411008475889 -122.494610350765 (37.7411008475889, -122.494610350765) 1 8 3 29491 35
76533 27143 DPW Maintained 1 Shrub :: Shrub 66 1775 Silver Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 2X3   6011388.84182 2095356.57174 37.7340920254878 -122.403017629645 (37.7340920254878, -122.403017629645) 10 3 8 58 1
75140 251667 DPW Maintained 1 Shrub :: Shrub 66 1090x Eucalyptus Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5988120 2094796 37.7312259936493 -122.483423232518 (37.7312259936493, -122.483423232518) 1 8 4 64 35
73743 244301 DPW Maintained 1 Shrub :: Shrub 66 350 Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1   04/20/2017 11:53:00 AM 3 Width 0ft   6005600.097 2110553.5487 37.7754944371133 -122.424111541162 (37.7754944371133, -122.424111541162) 7 9 11 28852 10
73123 119673 Undocumented 4 Shrub :: Shrub 66 1207 De Haro St 1 Front Yard : Yard Tree Private 2           6012287 2102743 37.7544236952833 -122.400431054928 (37.7544236952833, -122.400431054928) 10 3 8 28856 29
69162 181582 DPW Maintained 1 Shrub :: Shrub 66 1200 Sunset Blvd 72 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5984863.0361 2106906.9776 37.7642893338004 -122.495575911156 (37.7642893338004, -122.495575911156) 1 8 3 56 35
68765 185897 DPW Maintained 1 Shrub :: Shrub 66 2000 Sunset Blvd 40 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5985016.2502 2101239.5934 37.7487372369942 -122.494628152274 (37.7487372369942, -122.494628152274) 1 8 3 29491 35
68664 94197 Permitted Site 7 Shrub :: Shrub 66 355 Ocean Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
67903 181355 DPW Maintained 1 Shrub :: Shrub 66 2300 Sunset Blvd 53 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5985079.1419 2099429.3232 37.7437704079628 -122.494277260962 (37.7437704079628, -122.494277260962) 1 8 3 29491 35
67643 92611 DPW Maintained 1 Shrub :: Shrub 66 3856 23rd St   Sidewalk: Property side : Pot Landscaping Private 2   08/31/2009 12:00:00 AM     Permit Number 52924 6004067 2102488 37.7532616988935 -122.428839761175 (37.7532616988935, -122.428839761175) 2 4 5 28862 22
66991 96631 Permitted Site 7 Shrub :: Shrub 66 1212 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM   4x4 Permit Number 776835 5993035.2 2107183.3 37.7655231963247 -122.467331039359 (37.7655231963247, -122.467331039359) 11 8 11 56 12
66325 187025 DPW Maintained 1 Shrub :: Shrub 66 2501 Sunset Blvd 44 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984975.6777 2097882.1396 37.7395162040617 -122.494520977899 (37.7395162040617, -122.494520977899) 1 8 3 29491 35
65283 186427 DPW Maintained 1 Shrub :: Shrub 66 1601 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984725.0315 2104075.456 37.7565066846119 -122.495844334494 (37.7565066846119, -122.495844334494) 1 8 3 56 35
61810 184751 DPW Maintained 1 Shrub :: Shrub 66 1301 Sunset Blvd 18 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984675.641 2106097.6525 37.7620561792493 -122.4961643326 (37.7620561792493, -122.4961643326) 1 8 3 56 35
59943 100203 DPW Maintained 1 Shrub :: Shrub 66 2237 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4   6001906 2114287 37.7855362863546 -122.437157652203 (37.7855362863546, -122.437157652203) 13 6 11 29490 13
54182 184754 DPW Maintained 1 Shrub :: Shrub 66 1301 Sunset Blvd 23 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984657.4145 2106082.8434 37.7620144499807 -122.496226277389 (37.7620144499807, -122.496226277389) 1 8 3 56 35
53305 187234 DPW Maintained 1 Shrub :: Shrub 66 2401 Sunset Blvd 17 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984956.0101 2098625.8109 37.7415569740276 -122.494643790117 (37.7415569740276, -122.494643790117) 1 8 3 29491 35
51790 37371 Permitted Site 7 Shrub :: Shrub 66 755 Morse St 5 Sidewalk: Property side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
49423 181571 DPW Maintained 1 Shrub :: Shrub 66 1200 Sunset Blvd 30 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984860.385 2106736.0056 37.7638197374851 -122.495572469111 (37.7638197374851, -122.495572469111) 1 8 3 56 35
49069 184753 DPW Maintained 1 Shrub :: Shrub 66 1301 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984707.1578 2106087.4001 37.7620298750768 -122.496054573405 (37.7620298750768, -122.496054573405) 1 8 3 56 35
48266 114185 Undocumented 4 Shrub :: Shrub 66 2200 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
44868 37377 Permitted Site 7 Shrub :: Shrub 66 755 Morse St 11 Sidewalk: Property side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
44729 114527 Undocumented 4 Shrub :: Shrub 66 1 TIOGA AVE 3 Sidewalk: Curb side : Yard Tree Private 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
43758 182677 DPW Maintained 1 Shrub :: Shrub 66 1715 24th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   5988712.8958 2103624.6472 37.7555016296557 -122.482020022938 (37.7555016296557, -122.482020022938) 1 8 3 56 35
43687 117610 DPW Maintained 1 Shrub :: Shrub 66 391 NEVADA ST 1 Unaccepted Street : Yard Landscaping Private 2       3x3   6008958 2096497 37.7370873514658 -122.411502385785 (37.7370873514658, -122.411502385785) 10 7 7 28859 2
41363 102755 Undocumented 4 Shrub :: Shrub 66 61 Jordan Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   5996159.1 2114114.4 37.7847340229516 -122.457027629275 (37.7847340229516, -122.457027629275) 11 6 1 54 31
38858 98972 DPW Maintained 1 Shrub :: Shrub 66 825 Shotwell St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   0 5x5   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
36468 140265 DPW Maintained 1 Shrub :: Shrub 66 2100X Grove St 3 Sidewalk: Curb side : Cutout Landscaping Private 2     0 Width 0ft   5997671.17 2110272.3417 37.7742714515841 -122.45151917218 (37.7742714515841, -122.45151917218) 15 5 2 29492 16
36371 186363 DPW Maintained 1 Shrub :: Shrub 66 1801 Sunset Blvd 30 Sidewalk: Property side : Yard Tree Private 2     9 Width 0ft   5984829.0026 2102575.9576 37.7523955649491 -122.495374186734 (37.7523955649491, -122.495374186734) 1 8 3 56 35
35821 93164 DPW Maintained 1 Shrub :: Shrub 66 201 Upper Ter 2 Sidewalk: Property side : Cutout Landscaping Private 2   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
34922 185312 DPW Maintained 1 Shrub :: Shrub 66 2601 Sunset Blvd 37 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984965.1696 2097238.5346 37.7377484224906 -122.494509877006 (37.7377484224906, -122.494509877006) 1 8 3 29491 35
34209 107409 DPW Maintained 1 Shrub :: Shrub 66 125 VILLA TER 1 Sidewalk: Curb side : Cutout Landscaping Private 2           5999028.2 2104385.8 37.7581861070008 -122.446401410764 (37.7581861070008, -122.446401410764) 2 5 5 28862 3
32529 237036 DPW Maintained 1 Shrub :: Shrub 66 150 Octavia St 4 : Tree DPW 1   04/13/2017 02:42:00 PM 3 Width 4ft   6005705.05318 2109878.39065 37.7736465417793 -122.423700457022 (37.7736465417793, -122.423700457022) 7 9 11 28852 10

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