Street_Tree_List

Data source: data.sfgov.org

130 rows where qSpecies = 98 sorted by rowid descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize, PermitNotes

Link rowid ▲ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
187550 185258 Undocumented 2 Shrub :: Shrub 98 2101 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   5986433.4347 2097526.3066 37.7386243913853 -122.489454599165 (37.7386243913853, -122.489454599165)
185026 187377 Undocumented 2 Shrub :: Shrub 98 2200 Sunset Blvd 63 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985052.2703 2100029.8298 37.7454176637381 -122.49441443213001 (37.7454176637381, -122.49441443213)
184478 187025 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 44 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984975.6777 2097882.1396 37.7395162040617 -122.494520977899 (37.7395162040617, -122.494520977899)
183333 187234 Undocumented 2 Shrub :: Shrub 98 2401 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984956.0101 2098625.8109 37.7415569740276 -122.494643790117 (37.7415569740276, -122.494643790117)
182690 181343 Undocumented 2 Shrub :: Shrub 98 2500 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985164.5677 2097705.9234 37.739043415002705 -122.493854905389 (37.7390434150027, -122.493854905389)
181183 184754 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 23 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984657.4145 2106082.8434 37.762014449980704 -122.496226277389 (37.7620144499807, -122.496226277389)
179730 184869 Undocumented 2 Shrub :: Shrub 98 1201 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984640.7069 2106821.7773 37.764042376179205 -122.496338586447 (37.7640423761792, -122.496338586447)
179154 184750 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 17 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984665.0089 2106100.6902 37.7620638971415 -122.496201328503 (37.7620638971415, -122.496201328503)
177379 181571 Undocumented 2 Shrub :: Shrub 98 1200 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984860.385 2106736.0056 37.7638197374851 -122.49557246911101 (37.7638197374851, -122.495572469111)
176597 186340 Undocumented 2 Shrub :: Shrub 98 1801 Sunset Blvd 7 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984827.0787 2102831.0491 37.7530958632805 -122.495399651332 (37.7530958632805, -122.495399651332)
172552 140265 Undocumented 2 Shrub :: Shrub 98 2100X Grove St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     0 Width 0ft   5997671.17 2110272.3417 37.7742714515841 -122.45151917218 (37.7742714515841, -122.45151917218)
172267 186364 Undocumented 2 Shrub :: Shrub 98 1801 Sunset Blvd 31 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984815.8043 2102571.1093 37.7523814800587 -122.495419470402 (37.7523814800587, -122.495419470402)
167803 187122 Undocumented 2 Shrub :: Shrub 98 2600 Sunset Blvd 58 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985165.8082 2097341.5801 37.7380430985113 -122.49382377418101 (37.7380430985113, -122.493823774181)
164218 185692 Undocumented 2 Shrub :: Shrub 98 2101 Sunset Blvd 24 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984851.9348 2100530.8696 37.746781656202295 -122.495144090409 (37.7467816562023, -122.495144090409)
150740 184164 Undocumented 2 Shrub :: Shrub 98 1595 44th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 0ft   5982483.9557 2104274.5677 37.7569218843537 -122.503609385397 (37.7569218843537, -122.503609385397)
150729 186250 Undocumented 2 Shrub :: Shrub 98 1701 Sunset Blvd 61 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984767.3503 2103112.4152 37.753864919503 -122.495626952484 (37.753864919503, -122.495626952484)
148012 185313 Undocumented 2 Shrub :: Shrub 98 2601 Sunset Blvd 38 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984983.1747 2097234.3473 37.7377379790483 -122.49444731702299 (37.7377379790483, -122.494447317023)
144925 93163 Permitted Site 1 Shrub :: Shrub 98 201 Upper Ter 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
143940 106932 Undocumented 2 Shrub :: Shrub 98 358 SHOTWELL ST 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332)
143838 89015 Permitted Site 1 Shrub :: Shrub 98 4437 20th St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   09/30/2008 12:00:00 AM   3x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
142952 102268 DPW Maintained 3 Shrub :: Shrub 98 100X Casitas Ave 2 Median : Cutout 11 Tree 1 DPW 2     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065)
142517 102267 DPW Maintained 3 Shrub :: Shrub 98 100X Casitas Ave 1 Median : Cutout 11 Tree 1 DPW 2     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065)
141935 65625 Permitted Site 1 Shrub :: Shrub 98 238 Ney St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/07/1990 12:00:00 AM     Permit Number 28533 6004892.15539073 2094035.47955331 37.73009967019979 -122.42538473936399 (37.7300996701998, -122.425384739364)
140313 99583 Undocumented 2 Shrub :: Shrub 98 650X Brunswick St 23 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 3x6   5998578.4 2086902.6 37.710155688278 -122.44669908653499 (37.710155688278, -122.446699086535)
139595 30143 DPW Maintained 3 Shrub :: Shrub 98 410X Mansell St 5 Median : Cutout 11 Tree 1 DPW 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
139594 30164 DPW Maintained 3 Shrub :: Shrub 98 410X Mansell St 21 Median : Cutout 11 Tree 1 DPW 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
139298 92611 Permitted Site 1 Shrub :: Shrub 98 3856 23rd St   Sidewalk: Property side : Pot 6 Landscaping 2 Private 1   08/31/2009 12:00:00 AM     Permit Number 52924 6004067.0 2102488.0 37.753261698893496 -122.428839761175 (37.7532616988935, -122.428839761175)
139023 37379 Permitted Site 1 Shrub :: Shrub 98 755 Morse St 13 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
131967 181355 Undocumented 2 Shrub :: Shrub 98 2300 Sunset Blvd 53 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5985079.1419 2099429.3232 37.7437704079628 -122.49427726096201 (37.7437704079628, -122.494277260962)
129188 105003 Undocumented 2 Shrub :: Shrub 98 607 CONGO ST   Sidewalk: Property side : Yard 9 Landscaping 2 Private 1           6000094.1 2095817.0 37.73471905904071 -122.44210000591002 (37.7347190590407, -122.44210000591)
128708 114186 Undocumented 2 Shrub :: Shrub 98 2200 HAYES ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997096.0 2109871.0 37.7731365175856 -122.45347979574801 (37.7731365175856, -122.453479795748)
128554 93164 Permitted Site 1 Shrub :: Shrub 98 201 Upper Ter 2 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
128536 19363 DPW Maintained 3 Shrub :: Shrub 98 738 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   5992103.0127542 2089880.5617979001 37.7179604248963 -122.469295726054 (37.7179604248963, -122.469295726054)
127970 4893 DPW Maintained 3 Shrub :: Shrub 98 745X Mansell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 3X3   6009751.8988059005 2090059.5024836997 37.7194558413593 -122.408303589874 (37.7194558413593, -122.408303589874)
126456 116577 Significant Tree 6 Shrub :: Shrub 98 3000x 19TH AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 MTA 6 DPW 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
125354 113803 Permitted Site 1 Shrub :: Shrub 98 806 SHOTWELL ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1     3x3   6007931.0 2103220.0 37.755489548438 -122.41552904166201 (37.755489548438, -122.415529041662)
123231 88829 Permitted Site 1 Shrub :: Shrub 98 4437 20th St   Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1   09/30/2008 12:00:00 AM   8x1 Permit Number 51764 6001659.0 2104076.0 37.757485378077604 -122.43728079846599 (37.7574853780776, -122.437280798466)
122746 30141 DPW Maintained 3 Shrub :: Shrub 98 410X Mansell St 3 Median : Cutout 11 Tree 1 DPW 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
121168 100203 Undocumented 2 Shrub :: Shrub 98 2237 Sutter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 4x4   6001906.0 2114287.0 37.785536286354606 -122.43715765220301 (37.7855362863546, -122.437157652203)
120634 116580 Significant Tree 6 Shrub :: Shrub 98 3000x 19TH AVE 3 Sidewalk: Property side : Cutout 5 Landscaping 2 MTA 6 DPW 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
119638 109607 Private 5 Shrub :: Shrub 98 775 Congo St 1 Front Yard : Yard 7 Landscaping 2 Private 1           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419)
119565 99732 Undocumented 2 Shrub :: Shrub 98 4150 Ocean Ave 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1           5986619.2 2095203.6 37.7322576937009 -122.48864164528798 (37.7322576937009, -122.488641645288)
119560 21130 DPW Maintained 3 Shrub :: Shrub 98 2292X Sunset Blvd 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
118772 104034 Undocumented 2 Shrub :: Shrub 98 722 Wisconsin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6012694.0 2104139.0 37.7582794948464 -122.39912151779 (37.7582794948464, -122.39912151779)
118241 4313 DPW Maintained 3 Shrub :: Shrub 98 727 Chenery St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 DPW 2   08/17/2013 12:00:00 AM   3X3   6002321.2517800005 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497)
114697 104783 Undocumented 2 Shrub :: Shrub 98 50 Walnut St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998501.2 2116298.0 37.790863832623 -122.449082132455 (37.790863832623, -122.449082132455)
111245 99672 DPW Maintained 3 Shrub :: Shrub 98 1250X Shrader St 2 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   3 3x3   5997882.0 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624)
110242 106469 Undocumented 2 Shrub :: Shrub 98 100X HENRY ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 5x5   6002548.0 2107375.0 37.7665941299684 -122.43444215139601 (37.7665941299684, -122.434442151396)
109841 30145 DPW Maintained 3 Shrub :: Shrub 98 410X Mansell St 7 Median : Cutout 11 Tree 1 DPW 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
108499 30139 DPW Maintained 3 Shrub :: Shrub 98 410X Mansell St 1 Median : Cutout 11 Tree 1 DPW 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
107074 30054 DPW Maintained 3 Shrub :: Shrub 98 610X Junipero Serra Blvd 7 Median : Cutout 11 Tree 1 DPW 2           5991361.953164 2093442.6103069999 37.7276980777014 -122.47211671569599 (37.7276980777014, -122.472116715696)
104095 22545 DPW Maintained 3 Shrub :: Shrub 98 7 Topaz Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 2X3   6001395.6747592995 2098711.0868843 37.742739635423206 -122.43780724032301 (37.7427396354232, -122.437807240323)
101049 94198 Permitted Site 1 Shrub :: Shrub 98 355 Ocean Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
100801 30165 DPW Maintained 3 Shrub :: Shrub 98 410X Mansell St 22 Median : Cutout 11 Tree 1 DPW 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
97737 30166 DPW Maintained 3 Shrub :: Shrub 98 410X Mansell St 25 Median : Cutout 11 Tree 1 DPW 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
97043 27143 DPW Maintained 3 Shrub :: Shrub 98 1775 Silver Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12 2X3   6011388.84182 2095356.57174 37.7340920254878 -122.403017629645 (37.7340920254878, -122.403017629645)
94867 15877 DPW Maintained 3 Shrub :: Shrub 98 5508 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   12/15/1997 12:00:00 AM 3 3X3   5999048.25069 2087729.15393 37.7124520473945 -122.445134579389 (37.7124520473945, -122.445134579389)
94733 114528 Undocumented 2 Shrub :: Shrub 98 1 TIOGA AVE 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
94709 117610 Undocumented 2 Shrub :: Shrub 98 391 NEVADA ST 1 Unaccepted Street : Yard 14 Landscaping 2 Private 1       3x3   6008958.0 2096497.0 37.737087351465796 -122.41150238578501 (37.7370873514658, -122.411502385785)
93443 15888 DPW Maintained 3 Shrub :: Shrub 98 5625 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   5998561.46984 2087228.1352400002 37.711048567191604 -122.446781008521 (37.7110485671916, -122.446781008521)
92800 12755 DPW Maintained 3 Shrub :: Shrub 98 1733 Lake St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   02/24/2008 12:00:00 AM 3 3X3   5990033.85435 2114674.56985 37.785918437001705 -122.478259694764 (37.7859184370017, -122.478259694764)
92261 117511 DPW Maintained 3 Shrub :: Shrub 98 2634 37TH AVE 1 Median : Yard 3 Landscaping 2 DPW 2     20 3x3   5984921.0 2097163.0 37.737538439530795 -122.49465702329901 (37.7375384395308, -122.494657023299)
92104 121390 Undocumented 2 Shrub :: Shrub 98 1301x 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993851.0 2106604.0 37.763979651815205 -122.464467327674 (37.7639796518152, -122.464467327674)
91858 9382 DPW Maintained 3 Shrub :: Shrub 98 337 Gold Mine Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     0 3X3   6001129.4629101 2097791.8544146 37.74020049817771 -122.43866187060699 (37.7402004981777, -122.438661870607)
90472 120871 Undocumented 2 Shrub :: Shrub 98 1387 08th Ave 1 Sidewalk: Curb side : Pot 10 Landscaping 2 Private 1           5993606.0 2106068.0 37.762493810072606 -122.465275766733 (37.7624938100726, -122.465275766733)
88899 119673 Undocumented 2 Shrub :: Shrub 98 1207 De Haro St 1 Front Yard : Yard 7 Tree 1 Private 1           6012287.0 2102743.0 37.7544236952833 -122.40043105492799 (37.7544236952833, -122.400431054928)
88223 94197 Permitted Site 1 Shrub :: Shrub 98 355 Ocean Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
87585 121391 Undocumented 2 Shrub :: Shrub 98 1301x 07th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993851.0 2106604.0 37.763979651815205 -122.464467327674 (37.7639796518152, -122.464467327674)
85503 96631 Permitted Site 1 Shrub :: Shrub 98 1212 10th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/24/2015 12:00:00 AM   4x4 Permit Number 776835 5993035.2 2107183.3 37.7655231963247 -122.467331039359 (37.7655231963247, -122.467331039359)
84241 37371 Permitted Site 1 Shrub :: Shrub 98 755 Morse St 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
84132 112917 DPW Maintained 3 Shrub :: Shrub 98 480X BEACON ST 1 Sidewalk: Property side : Yard 9 Tree 1 DPW 2           6002571.0 2098077.0 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676)
84069 30163 DPW Maintained 3 Shrub :: Shrub 98 410X Mansell St 20 Median : Cutout 11 Tree 1 DPW 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
82971 102755 Undocumented 2 Shrub :: Shrub 98 61 Jordan Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 3x3   5996159.1 2114114.4 37.7847340229516 -122.457027629275 (37.7847340229516, -122.457027629275)
82634 26499 DPW Maintained 3 Shrub :: Shrub 98 2710 Harrison St 3 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 4x3   6008889.7812 2102567.01926 37.7537504562032 -122.41216712165199 (37.7537504562032, -122.412167121652)
80823 98972 DPW Maintained 3 Shrub :: Shrub 98 825 Shotwell St 6 Sidewalk: Curb side : Cutout 1 Tree 1 SFUSD 4 DPW for City Agency 2   0 5x5   6008234.2 2102998.9 37.754899496003105 -122.414464835105 (37.7548994960031, -122.414464835105)
79808 37377 Permitted Site 1 Shrub :: Shrub 98 755 Morse St 11 Sidewalk: Property side : Cutout 5 Tree 1 Private 1 FUF 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
79753 107409 Undocumented 2 Shrub :: Shrub 98 125 VILLA TER 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1           5999028.2 2104385.8 37.758186107000796 -122.44640141076401 (37.7581861070008, -122.446401410764)
79695 114527 Undocumented 2 Shrub :: Shrub 98 1 TIOGA AVE 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
79258 114185 Undocumented 2 Shrub :: Shrub 98 2200 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997096.0 2109871.0 37.7731365175856 -122.45347979574801 (37.7731365175856, -122.453479795748)
78136 21133 DPW Maintained 3 Shrub :: Shrub 98 2292X Sunset Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
77017 184752 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 20 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 0ft   5984700.7025 2106093.8553 37.7620472211463 -122.496077375707 (37.7620472211463, -122.496077375707)
73198 187253 Undocumented 2 Shrub :: Shrub 98 2401 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984962.1374 2098459.5582 37.741100847588896 -122.494610350765 (37.7411008475889, -122.494610350765)
71197 186427 Undocumented 2 Shrub :: Shrub 98 1601 Sunset Blvd 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984725.0315 2104075.456 37.7565066846119 -122.495844334494 (37.7565066846119, -122.495844334494)
70454 186363 Undocumented 2 Shrub :: Shrub 98 1801 Sunset Blvd 30 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 0ft   5984829.0026 2102575.9576 37.752395564949104 -122.49537418673401 (37.7523955649491, -122.495374186734)
64376 187053 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984954.1557 2097623.876 37.7388058219757 -122.494576356208 (37.7388058219757, -122.494576356208)
59434 182677 Undocumented 2 Shrub :: Shrub 98 1715 24th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   5988712.8958 2103624.6472 37.755501629655704 -122.482020022938 (37.7555016296557, -122.482020022938)
59344 185312 Undocumented 2 Shrub :: Shrub 98 2601 Sunset Blvd 37 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984965.1696 2097238.5346 37.737748422490604 -122.494509877006 (37.7377484224906, -122.494509877006)
57510 182676 Undocumented 2 Shrub :: Shrub 98 1715 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   5988712.3482 2103638.8826 37.7555406843938 -122.482022959471 (37.7555406843938, -122.482022959471)
57230 181567 Undocumented 2 Shrub :: Shrub 98 1300 Sunset Blvd 62 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984855.7554 2106265.0899 37.7625264639896 -122.49555374589599 (37.7625264639896, -122.495553745896)
55306 187251 Undocumented 2 Shrub :: Shrub 98 2401 Sunset Blvd 34 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984973.9834 2098481.6163 37.7411621065182 -122.494571017919 (37.7411621065182, -122.494571017919)
52950 185897 Undocumented 2 Shrub :: Shrub 98 2000 Sunset Blvd 40 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5985016.2502 2101239.5934 37.7487372369942 -122.494628152274 (37.7487372369942, -122.494628152274)
51786 185555 Undocumented 2 Shrub :: Shrub 98 2201 Sunset Blvd 39 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 0ft   5984902.7901 2099826.3861 37.7448503133319 -122.49491630522101 (37.7448503133319, -122.494916305221)
51487 186362 Undocumented 2 Shrub :: Shrub 98 1801 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 0ft   5984819.5753 2102574.8802 37.7523920547151 -122.49540670794501 (37.7523920547151, -122.495406707945)
50614 184751 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 18 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984675.641 2106097.6525 37.7620561792493 -122.4961643326 (37.7620561792493, -122.4961643326)
47657 184756 Undocumented 2 Shrub :: Shrub 98 1301 Sunset Blvd 29 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984687.2225 2106057.4022 37.761946341588 -122.496121307582 (37.761946341588, -122.496121307582)
44081 56991 Permitted Site 1 Shrub :: Shrub 98 4160 26th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/27/1974 12:00:00 AM     Permit Number 767882 6002854.60493399 2100676.90172362 37.74822015482471 -122.432903090117 (37.7482201548247, -122.432903090117)
42436 187055 Undocumented 2 Shrub :: Shrub 98 2501 Sunset Blvd 74 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984955.8371 2097567.7171 37.738651723125294 -122.49456640389 (37.7386517231253, -122.49456640389)
41030 185311 Undocumented 2 Shrub :: Shrub 98 2601 Sunset Blvd 36 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 0ft   5984965.5883 2097247.7465 37.737773740404 -122.49450910826799 (37.737773740404, -122.494509108268)
40776 181577 Undocumented 2 Shrub :: Shrub 98 1200 Sunset Blvd 59 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 0ft   5984846.2035 2106866.5794 37.76417742600729 -122.49563114953699 (37.7641774260073, -122.495631149537)
36265 181582 Undocumented 2 Shrub :: Shrub 98 1200 Sunset Blvd 72 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 0ft   5984863.0361 2106906.9776 37.7642893338004 -122.49557591115601 (37.7642893338004, -122.495575911156)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 61.339ms · Data source: data.sfgov.org