Data source: data.sfgov.org
This data as json, CSV (advanced)
qLegalStatus ✖
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
147063 | 147063 | 189996 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1809 19th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6012291.07861 | 2105130.95435 | 37.7609807203027 | -122.400584686038 | (37.7609807203027, -122.400584686038) | |||
147255 | 147255 | 225182 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007750.95097 | 2106539.82911 | 37.764594912141206 | -122.416386843697 | (37.7645949121412, -122.416386843697) | |||
148331 | 148331 | 190003 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1750 22nd St | 14 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6012781.6725699995 | 2103797.8962 | 37.7573477838951 | -122.398794366977 | (37.7573477838951, -122.398794366977) | ||||
148481 | 148481 | 225146 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1706 Dolores St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6005275.161069999 | 2098395.65522 | 37.7420933673216 | -122.424370639893 | (37.7420933673216, -122.424370639893) | |||
148722 | 148722 | 225150 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 21 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007236.93234 | 2099402.00378 | 37.744967159016596 | -122.417658748554 | (37.7449671590166, -122.417658748554) | |||
149483 | 149483 | 225211 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 83 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6006284.028469999 | 2099592.34977 | 37.74543613838021 | -122.42096723475402 | (37.7454361383802, -122.420967234754) | |||
150087 | 150087 | 225171 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 106 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006678.67564 | 2099088.45084 | 37.7440747833339 | -122.419566860849 | (37.7440747833339, -122.419566860849) | |||
150193 | 150193 | 206044 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 275 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5991926.36894 | 2090353.75557 | 37.7192494901497 | -122.46994073500099 | (37.7192494901497, -122.469940735001) | |||
150411 | 150411 | 225204 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 423 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003555.12848 | 2103300.5441900003 | 37.7554637680609 | -122.430667894334 | (37.7554637680609, -122.430667894334) | |||
150545 | 150545 | 225149 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 369 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6008818.14298 | 2097106.89478 | 37.7387541440918 | -122.41202902491999 | (37.7387541440918, -122.41202902492) | |||
151815 | 151815 | 201673 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010274.35746 | 2109764.89142 | 37.773591771276706 | -122.4078864553 | (37.7735917712767, -122.4078864553) | ||||
152589 | 152589 | 32693 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3732 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1996 12:00:00 AM | 1 | Permit Number 37102 | 6004859.3884 | 2102538.49197 | 37.7534451551954 | -122.42610311279199 | (37.7534451551954, -122.426103112792) | ||
152776 | 152776 | 225194 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3160 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007219.63733 | 2103836.19178 | 37.757141458734395 | -122.418032839538 | (37.7571414587344, -122.418032839538) | |||
152995 | 152995 | 225179 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007756.33933 | 2106453.2465 | 37.764357479442 | -122.41636207364799 | (37.764357479442, -122.416362073648) | |||
153266 | 153266 | 190024 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1400 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015540.58409 | 2108410.35977 | 37.7701659469215 | -122.389575008383 | (37.7701659469215, -122.389575008383) | |||
153857 | 153857 | 201507 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018590.61876 | 2094904.2906900002 | 37.733249683412296 | -122.37808717738599 | (37.7332496834123, -122.378087177386) | |||
154165 | 154165 | 246301 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3998 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 6002344.4551 | 2105927.1578 | 37.7626071523851 | -122.435042615882 | (37.7626071523851, -122.435042615882) | |||
154762 | 154762 | 190008 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013001.004319999 | 2104770.77292 | 37.7600313087249 | -122.39810407704901 | (37.7600313087249, -122.398104077049) | |||
155078 | 155078 | 32061 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3641 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1995 12:00:00 AM | 7 | Permit Number 35437 | 6004606.11173 | 2105983.62755 | 37.762890365909 | -122.4272243812 | (37.762890365909, -122.4272243812) | |
156182 | 156182 | 189998 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1950 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6011839.98262 | 2105629.53813 | 37.7623245520575 | -122.402179893599 | (37.7623245520575, -122.402179893599) | |||
157709 | 157709 | 225159 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3189 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007127.86585 | 2103790.91823 | 37.75701198242339 | -122.41834701140301 | (37.7570119824234, -122.418347011403) | |||
157715 | 157715 | 225155 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 104 Franconia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6010008.90641 | 2099846.42229 | 37.7463430291237 | -122.40810505891199 | (37.7463430291237, -122.408105058912) | |||
158218 | 158218 | 190007 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700 Arkansas St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012984.44615 | 2103792.30277 | 37.7573437216454 | -122.398092698838 | (37.7573437216454, -122.398092698838) | ||||
158705 | 158705 | 190031 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1301 Minnesota St | 76 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015368.80756 | 2102249.49615 | 37.753240017127 | -122.389738810018 | (37.753240017127, -122.389738810018) | ||||
159626 | 159626 | 206047 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 575 Rockdale Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5997894.62452 | 2097851.39191 | 37.7401794193521 | -122.449850874237 | (37.7401794193521, -122.449850874237) | |||
159709 | 159709 | 201681 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6010219.21458 | 2109785.59098 | 37.7736455201492 | -122.408078663801 | (37.7736455201492, -122.408078663801) | ||||
160516 | 160516 | 190020 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015584.43667 | 2107642.2623 | 37.768059350697996 | -122.38936967519699 | (37.768059350698, -122.389369675197) | |||
160931 | 160931 | 126014 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2322 North Point St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 8ft | 5999611.42315 | 2120546.01877 | 37.8025911966964 | -122.445546423945 | (37.8025911966964, -122.445546423945) | |||
162917 | 162917 | 206039 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 280 Brighton Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996261.11762 | 2091797.78089 | 37.723464064001895 | -122.455061523695 | (37.7234640640019, -122.455061523695) | |||
163882 | 163882 | 190016 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6015575.880530001 | 2107804.1814599996 | 37.7685034709891 | -122.38941057906099 | (37.7685034709891, -122.389410579061) | |||
165711 | 165711 | 225191 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007257.73573 | 2103878.07853 | 37.7572586143179 | -122.41790404944099 | (37.7572586143179, -122.417904049441) | |||
166068 | 166068 | 225181 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007752.17494 | 2106512.16868 | 37.7645190318645 | -122.41638065094801 | (37.7645190318645, -122.416380650948) | |||
166097 | 166097 | 201509 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018596.778580001 | 2094899.20439 | 37.73323605689679 | -122.378065528029 | (37.7332360568968, -122.378065528029) | |||
166308 | 166308 | 225184 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007748.54808 | 2106641.05965 | 37.764872732518704 | -122.416402325519 | (37.7648727325187, -122.416402325519) | |||
166477 | 166477 | 201674 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010278.21151 | 2109773.9479799997 | 37.773616854257604 | -122.407873762259 | (37.7736168542576, -122.407873762259) | ||||
166960 | 166960 | 126011 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 7ft | 5999243.15513 | 2117721.3039700002 | 37.7948142553315 | -122.446617458939 | (37.7948142553315, -122.446617458939) | |||
167510 | 167510 | 100330 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 555 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3x3 | 6013394.216680001 | 2111677.27832 | 37.7790169225246 | -122.39722844584601 | (37.7790169225246, -122.397228445846) | |||
168817 | 168817 | 206042 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994983.67365 | 2091204.0797700002 | 37.7217605339977 | -122.45943440879101 | (37.7217605339977, -122.459434408791) | |||
170506 | 170506 | 225177 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 858 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007943.221609999 | 2102943.9382 | 37.754732232531794 | -122.41546723204901 | (37.7547322325318, -122.415467232049) | |||
171439 | 171439 | 126013 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 7ft | 5999233.22196 | 2117805.48778 | 37.795044834292895 | -122.44665788886499 | (37.7950448342929, -122.446657888865) | |||
171539 | 171539 | 190001 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 790 De Haro St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6012095.84153 | 2104748.83564 | 37.759920616576 | -122.401233077439 | (37.759920616576, -122.401233077439) | ||||
171827 | 171827 | 225158 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3203 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6007618.37358 | 2102060.04095 | 37.7522869875715 | -122.416528039931 | (37.7522869875715, -122.416528039931) | |||
172254 | 172254 | 190033 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 651 Missouri St | 30 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6013606.61157 | 2104092.53416 | 37.7582027253025 | -122.39596202861901 | (37.7582027253025, -122.395962028619) | |||
172815 | 172815 | 225154 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 104 Franconia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6010002.80385 | 2099859.8218 | 37.7463794795488 | -122.40812710578999 | (37.7463794795488, -122.40812710579) | |||
172905 | 172905 | 190028 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1500 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6015555.80017 | 2108152.70829 | 37.7694593361018 | -122.389504379223 | (37.7694593361018, -122.389504379223) | |||
173741 | 173741 | 206038 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 280 Brighton Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5996260.86716 | 2091785.79325 | 37.72343113441671 | -122.45506152366998 | (37.7234311344167, -122.45506152367) | |||
174222 | 174222 | 190012 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 6ft | 6012453.688019999 | 2108575.49646 | 37.770447730615295 | -122.400264221637 | (37.7704477306153, -122.400264221637) | |||
176416 | 176416 | 225206 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3816 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6004315.95235 | 2101927.5657 | 37.751736964897106 | -122.427938900685 | (37.7517369648971, -122.427938900685) | |||
176830 | 176830 | 225187 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007244.27543 | 2104007.62921 | 37.7576135731224 | -122.417959784028 | (37.7576135731224, -122.417959784028) | |||
176930 | 176930 | 225167 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 338 Hoffman Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000621.34497 | 2101755.16217 | 37.7510538776544 | -122.44070294699699 | (37.7510538776544, -122.440702946997) | |||
177844 | 177844 | 190013 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 888 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 8ft | 6012319.46536 | 2108768.17498 | 37.7709692969125 | -122.40074203953002 | (37.7709692969125, -122.40074203953) | |||
178754 | 178754 | 190010 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 499 Arkansas St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6013000.60503 | 2104793.1604 | 37.7600927575897 | -122.398107028633 | (37.7600927575897, -122.398107028633) | |||
178979 | 178979 | 206041 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994962.333219999 | 2091204.5266599997 | 37.7217605340024 | -122.459508208932 | (37.7217605340024, -122.459508208932) | |||
180166 | 180166 | 225199 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3290 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008287.23317 | 2104481.08405 | 37.7589722149231 | -122.41438629998899 | (37.7589722149231, -122.414386299989) | |||
181010 | 181010 | 126016 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009654.60353 | 2115055.05542 | 37.7880825923961 | -122.410403896944 | (37.7880825923961, -122.410403896944) | |||
181029 | 181029 | 126020 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009058.631990001 | 2114632.0881 | 37.786887798972295 | -122.412435952882 | (37.7868877989723, -122.412435952882) | |||
181059 | 181059 | 190017 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015580.20075 | 2107759.76126 | 37.7683817423455 | -122.389392533258 | (37.7683817423455, -122.389392533258) | |||
181288 | 181288 | 225164 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2861 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007651.46889 | 2106744.64503 | 37.7651516941295 | -122.416745437549 | (37.7651516941295, -122.416745437549) | |||
181426 | 181426 | 201513 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1001 Innes Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6018634.55292 | 2094871.3359599998 | 37.7331616173072 | -122.377932996723 | (37.7331616173072, -122.377932996723) | |||
181433 | 181433 | 190032 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 651 Missouri St | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 6013600.610230001 | 2104091.57262 | 37.7581997512359 | -122.395982716627 | (37.7581997512359, -122.395982716627) | |||
181963 | 181963 | 104417 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 335 Marina Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2013 12:00:00 AM | 12 | Permit Number 770730 | 6001763.35391 | 2121819.4095799997 | 37.8062102070855 | -122.438190954371 | (37.8062102070855, -122.438190954371) | ||
182331 | 182331 | 225163 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2859 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007679.26286 | 2106746.83875 | 37.7651592807999 | -122.416649460099 | (37.7651592807999, -122.416649460099) | |||
182738 | 182738 | 117701 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 4021 Clement St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 5983015.82317 | 2113078.8166099996 | 37.7811270768141 | -122.502421605789 | (37.7811270768141, -122.502421605789) | |||
182780 | 182780 | 190018 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1530 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6015579.842180001 | 2107724.78714 | 37.7682856911689 | -122.38939133086399 | (37.7682856911689, -122.389391330864) | |||
183184 | 183184 | 225180 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 240 Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007753.3624 | 2106482.72591 | 37.7644382556423 | -122.416374458236 | (37.7644382556423, -122.416374458236) | |||
183433 | 183433 | 206043 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 621 Holloway Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5994997.50397 | 2091203.21567 | 37.721758956587294 | -122.459386538764 | (37.7217589565873, -122.459386538764) | |||
183572 | 183572 | 201671 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 401 08th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010268.2107 | 2109746.2247 | 37.7735401726656 | -122.407906401378 | (37.7735401726656, -122.407906401378) | ||||
183926 | 183926 | 225156 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 104 Franconia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6010015.03813 | 2099834.46528 | 37.746310541115896 | -122.408083012937 | (37.7463105411159, -122.408083012937) | |||
187574 | 187574 | 31676 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 335 Marina Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Permit Number 770730 | 6001735.33868 | 2121814.4309799997 | 37.806194943810894 | -122.438287548749 | (37.8061949438109, -122.438287548749) | |||
188409 | 188409 | 126023 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 560 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009008.4198 | 2114630.0994700002 | 37.7868795207321 | -122.412609535497 | (37.7868795207321, -122.412609535497) | |||
188481 | 188481 | 126021 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 550 Geary St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009038.2153900005 | 2114627.76765 | 37.7868747902962 | -122.412506284359 | (37.7868747902962, -122.412506284359) | |||
10585 | 10585 | 27651 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2700 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982420.6256 | 2096461.5972 | 37.73546591249 | -122.503249937577 | (37.73546591249, -122.503249937577) | ||
10607 | 10607 | 27653 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2900X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5981776.6997 | 2096484.8387 | 37.7354918543068 | -122.505477915571 | (37.7354918543068, -122.505477915571) | ||
11897 | 11897 | 27649 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2500 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/06/1999 12:00:00 AM | 12 | 4X4 | 5982997.5613 | 2096369.9984 | 37.7352483041994 | -122.501248513045 | (37.7352483041994, -122.501248513045) | ||
12298 | 12298 | 27647 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2300 Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 4X4 | 5983545.7870000005 | 2096052.8205 | 37.7344095981993 | -122.499329695326 | (37.7344095981993, -122.499329695326) | |||
17378 | 17378 | 29984 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1622X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005923.58357 | 2099590.01571 | 37.7454094051301 | -122.422213431617 | (37.7454094051301, -122.422213431617) | ||
17470 | 17470 | 29703 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1488X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005875.752859999 | 2100395.2692 | 37.7476177497694 | -122.42243602910901 | (37.7476177497694, -122.422436029109) | |||
17649 | 17649 | 30005 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 795X San Jose Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005615.08127 | 2098546.14287 | 37.7425257613504 | -122.423205996259 | (37.7425257613504, -122.423205996259) | ||
17658 | 17658 | 29711 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534X Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005892.92513 | 2100118.18846 | 37.7468579179619 | -122.422356964326 | (37.7468579179619, -122.422356964326) | |||
17666 | 17666 | 16203 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998659.38581 | 2094694.1828400001 | 37.731554201452106 | -122.446979509806 | (37.7315542014521, -122.446979509806) | ||
17832 | 17832 | 16310 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997364.820830001 | 2094712.7517799998 | 37.7315311410332 | -122.45145638890499 | (37.7315311410332, -122.451456388905) | ||
18341 | 18341 | 29708 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005897.61494 | 2100055.38982 | 37.746685751754605 | -122.422336286217 | (37.7466857517546, -122.422336286217) | |||
18826 | 18826 | 16271 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997920.42958 | 2094705.3029200002 | 37.731542488687204 | -122.449535014353 | (37.7315424886872, -122.449535014353) | ||
19207 | 19207 | 546 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2884 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6009527.2979999995 | 2102212.4790000003 | 37.752812718682996 | -122.409937408543 | (37.752812718683, -122.409937408543) | |||
19514 | 19514 | 16309 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 18 | 5 | 5997384.824659999 | 2094713.0859599998 | 37.7315332040811 | -122.45138725623801 | (37.7315332040811, -122.451387256238) | ||
19536 | 19536 | 29706 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005915.3087 | 2099718.0441099997 | 37.745760475271204 | -122.422251139273 | (37.7457604752712, -122.422251139273) | |||
19578 | 19578 | 29700 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1488X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005880.5001300005 | 2100335.27269 | 37.747453280849 | -122.422415350984 | (37.747453280849, -122.422415350984) | |||
19777 | 19777 | 16245 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997958.54401 | 2094705.63588 | 37.7315455832604 | -122.44940326996401 | (37.7315455832604, -122.449403269964) | ||
19998 | 19998 | 30014 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 738X San Jose Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005753.20487 | 2098967.8779700003 | 37.7436915444264 | -122.422758369527 | (37.7436915444264, -122.422758369527) | ||
20337 | 20337 | 29707 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1594X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005916.90216 | 2099727.1189900003 | 37.74578548271 | -122.422246273943 | (37.74578548271, -122.422246273943) | |||
20510 | 20510 | 16215 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 501X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998684.93347 | 2094693.5890400002 | 37.7315540305774 | -122.446891144221 | (37.7315540305774, -122.446891144221) | ||
20789 | 20789 | 29999 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 681X San Jose Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005890.72277 | 2099411.68829 | 37.7449179049514 | -122.422314391296 | (37.7449179049514, -122.422314391296) | ||
21427 | 21427 | 16246 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 601X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5997938.93286 | 2094706.04445 | 37.731545583255 | -122.44947109863001 | (37.731545583255, -122.44947109863) | ||
21577 | 21577 | 30015 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 738X San Jose Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005757.33905 | 2098980.75435 | 37.7437271333024 | -122.422744989392 | (37.7437271333024, -122.422744989392) | ||
21753 | 21753 | 7651 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 3309 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6008514.76673 | 2099315.4507400002 | 37.7448013267216 | -122.413234094881 | (37.7448013267216, -122.413234094881) | |||
21879 | 21879 | 29710 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534X Guerrero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6005894.4456400005 | 2100106.5973900002 | 37.7468261772965 | -122.422350883111 | (37.7468261772965, -122.422350883111) | |||
21912 | 21912 | 29701 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1488X Guerrero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005878.92208 | 2100344.0622799997 | 37.7474773260372 | -122.42242143222201 | (37.7474773260372, -122.422421432222) | |||
22067 | 22067 | 16311 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 3 | 5 | 5997346.34886 | 2094713.5127 | 37.7315321725506 | -122.45152030461901 | (37.7315321725506, -122.451520304619) | ||
22275 | 22275 | 29704 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1488X Guerrero St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 6 | 6005876.958869999 | 2100402.60074 | 37.7476379485377 | -122.422432379649 | (37.7476379485377, -122.422432379649) | |||
27590 | 27590 | 225203 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1534x Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 6005899.22105 | 2100030.8366400003 | 37.746618424914296 | -122.422328988218 | (37.7466184249143, -122.422328988218) |
JSON shape: default, array, newline-delimited
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");