Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189106 | 189106 | 240859 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 99 Albion St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005815.33313 | 2106780.6392099997 | 37.7651470814965 | -122.423098753019 | (37.7651470814965, -122.423098753019) | |||
| 188923 | 188923 | 179577 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 700 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001127.46159 | 2089574.9646 | 37.7176386901633 | -122.438080342229 | (37.7176386901633, -122.438080342229) | |||
| 188903 | 188903 | 240963 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 95 Eagle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999830.95947 | 2104453.5747700003 | 37.758418016707395 | -122.44362999832501 | (37.7584180167074, -122.443629998325) | |||
| 188838 | 188838 | 41630 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 175 Bluxome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 11 | Permit Number 47987 | 6012549.77298 | 2109959.42064 | 37.77425303017571 | -122.400029064208 | (37.7742530301757, -122.400029064208) | ||
| 188727 | 188727 | 215138 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 810 Darien Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5993949.3025 | 2094130.56753 | 37.729736429686206 | -122.46322217696002 | (37.7297364296862, -122.46322217696) | |||
| 188267 | 188267 | 136535 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2040 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6001921.861880001 | 2115620.94722 | 37.7891998651308 | -122.43719831956999 | (37.7891998651308, -122.43719831957) | |||
| 187552 | 187552 | 179610 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 801 Excelsior Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 5ft | 6004355.20316 | 2091529.3474400002 | 37.723188035096 | -122.427062621069 | (37.723188035096, -122.427062621069) | |||
| 187539 | 187539 | 215183 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 463 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5999025.03283 | 2094940.1697099998 | 37.732250506956504 | -122.44573308543801 | (37.7322505069565, -122.445733085438) | |||
| 187528 | 187528 | 136540 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2960 Broadway | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 5999430.14581 | 2117046.26527 | 37.7929714572124 | -122.44592187379601 | (37.7929714572124, -122.445921873796) | |||
| 187465 | 187465 | 240959 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4600 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000626.9533400005 | 2104669.35433 | 37.759055860855 | -122.440892584345 | (37.759055860855, -122.440892584345) | |||
| 187403 | 187403 | 241003 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 81 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004313.09984 | 2097732.41335 | 37.740217883357396 | -122.427649901744 | (37.7402178833574, -122.427649901744) | |||
| 187382 | 187382 | 245316 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 25 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007435.2237 | 2099895.5199700003 | 37.74633340008 | -122.417008052193 | (37.74633340008, -122.417008052193) | |||
| 186715 | 186715 | 245231 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 24 Dearborn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6005803.549 | 2105901.04894 | 37.762731269549704 | -122.423076986719 | (37.7627312695497, -122.423076986719) | |||
| 186455 | 186455 | 240972 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4220 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6001380.47631 | 2103379.15675 | 37.7555561778914 | -122.438194124461 | (37.7555561778914, -122.438194124461) | |||
| 186372 | 186372 | 245299 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4308 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001090.90021 | 2103332.76548 | 37.755412325040005 | -122.439192241532 | (37.75541232504, -122.439192241532) | |||
| 186270 | 186270 | 215182 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 463 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5999010.27233 | 2094940.09474 | 37.732249458336 | -122.44578411025199 | (37.732249458336, -122.445784110252) | |||
| 186211 | 186211 | 197763 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1405 Minnesota St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6015410.29997 | 2101920.42662 | 37.7523387624307 | -122.389572339186 | (37.7523387624307, -122.389572339186) | ||||
| 185861 | 185861 | 179587 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 320 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 1ft | 6010760.46271 | 2090986.07392 | 37.7220564415258 | -122.404882538894 | (37.7220564415258, -122.404882538894) | |||
| 185769 | 185769 | 215156 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 218 Thrift St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 10ft | 5994824.146269999 | 2089663.55723 | 37.7175214527221 | -122.459874313044 | (37.7175214527221, -122.459874313044) | |||
| 185720 | 185720 | 43209 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 33 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/11/2000 12:00:00 AM | 15 | Permit Number 43000 | 6007755.9781 | 2093953.9574900002 | 37.7300372142398 | -122.41547834314699 | (37.7300372142398, -122.415478343147) | |
| 185236 | 185236 | 43902 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1938 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/2000 12:00:00 AM | 11 | Permit Number 43504 | 6013487.640269999 | 2095982.13361 | 37.735926667475 | -122.395805194058 | (37.735926667475, -122.395805194058) | ||
| 185206 | 185206 | 122033 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 643 18th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 5990312.98085 | 2110983.69674 | 37.7758005234202 | -122.47702420793199 | (37.7758005234202, -122.477024207932) | |||
| 185188 | 185188 | 246493 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 369 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6004155.73552 | 2099822.7018 | 37.745948432677004 | -122.42834294717301 | (37.745948432677, -122.428342947173) | |||
| 184931 | 184931 | 197754 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 477 Morris St | 4 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6011947.90885 | 2110817.9298 | 37.7765767245667 | -122.402171403986 | (37.7765767245667, -122.402171403986) | |||
| 184892 | 184892 | 240856 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 99 Albion St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005817.668380001 | 2106738.2984700003 | 37.7650309556372 | -122.42308766617901 | (37.7650309556372, -122.423087666179) | |||
| 184545 | 184545 | 245273 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 65 Bradford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6009608.20416 | 2098291.4729 | 37.742051034443 | -122.409380928885 | (37.742051034443, -122.409380928885) | |||
| 184397 | 184397 | 31051 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 40 South Hill Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34806 | 6002706.14254 | 2087539.54135 | 37.7121395201911 | -122.43247826105801 | (37.7121395201911, -122.432478261058) | |
| 184073 | 184073 | 41631 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 175 Bluxome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 13 | Permit Number 47987 | 6012575.96802 | 2109987.3858 | 37.7743312765925 | -122.39994041444099 | (37.7743312765925, -122.399940414441) | ||
| 183881 | 183881 | 40575 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1745 Alameda St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011865.567530001 | 2107924.68372 | 37.768627934454706 | -122.402252780039 | (37.7686279344547, -122.402252780039) | |
| 183685 | 183685 | 197762 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 967 Natoma St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6008013.25237 | 2109878.84045 | 37.773777801438605 | -122.41571605105 | (37.7737778014386, -122.41571605105) | |||
| 183238 | 183238 | 215140 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 810 Darien Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993993.45625 | 2094092.4558400002 | 37.7296343278608 | -122.463066769619 | (37.7296343278608, -122.463066769619) | |||
| 183215 | 183215 | 245237 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3690 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6005066.37582 | 2105475.8404599996 | 37.761522121175204 | -122.42559634480101 | (37.7615221211752, -122.425596344801) | |||
| 183207 | 183207 | 31053 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 40 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34806 | 6002711.16213 | 2087562.81668 | 37.7122037138071 | -122.432462573298 | (37.7122037138071, -122.432462573298) | |
| 183179 | 183179 | 245263 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3724 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6004881.16744 | 2102538.46913 | 37.7534463233974 | -122.42602779456399 | (37.7534463233974, -122.426027794564) | |||
| 183148 | 183148 | 66354 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 334 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1990 12:00:00 AM | 13 | Permit Number 29475 | 6003787.88189 | 2089236.55246 | 37.7168604267574 | -122.428860361341 | (37.7168604267574, -122.428860361341) | ||
| 183115 | 183115 | 215158 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 494 Victoria St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5993274.39312 | 2090442.4694700001 | 37.7195709087624 | -122.465287603165 | (37.7195709087624, -122.465287603165) | |||
| 183014 | 183014 | 62605 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 799 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1986 12:00:00 AM | 14 | Permit Number 22913 | 5984493.96165 | 2110453.83892 | 37.774006387575 | -122.49711424322099 | (37.774006387575, -122.497114243221) | ||
| 182671 | 182671 | 65601 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 112 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 12 | Permit Number 28503 | 6004142.9253 | 2093740.45732 | 37.7292472461511 | -122.42795390857201 | (37.7292472461511, -122.427953908572) | |
| 182584 | 182584 | 245280 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3057 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008432.7465699995 | 2106194.80259 | 37.7636858657207 | -122.41400427787799 | (37.7636858657207, -122.414004277878) | |||
| 182559 | 182559 | 142847 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1247 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006787.7441 | 2115244.9809 | 37.7884429519581 | -122.42033623488301 | (37.7884429519581, -122.420336234883) | |||
| 182469 | 182469 | 72146 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 49 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/08/2010 12:00:00 AM | 10 | Permit Number 53889 | 6001152.42683 | 2093652.9422099998 | 37.72883731177971 | -122.43828603338999 | (37.7288373117797, -122.43828603339) | ||
| 182388 | 182388 | 136541 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1234 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6006833.25641 | 2115260.3621400003 | 37.7884877495592 | -122.42017986121701 | (37.7884877495592, -122.420179861217) | |||
| 182352 | 182352 | 40602 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1745 Alameda St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/2003 12:00:00 AM | 15 | Permit Number 47084 | 6011826.18199 | 2107919.61674 | 37.7686118231125 | -122.40238865591999 | (37.7686118231125, -122.40238865592) | |
| 182294 | 182294 | 118242 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3550 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5984520.13494 | 2110427.21229 | 37.773934812271904 | -122.49702174101499 | (37.7739348122719, -122.497021741015) | |||
| 182163 | 182163 | 40601 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1745 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/2003 12:00:00 AM | 13 | Permit Number 47084 | 6011717.76597 | 2107914.2771400004 | 37.768591109019205 | -122.402763284706 | (37.7685911090192, -122.402763284706) | |
| 182161 | 182161 | 197756 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1221 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6009912.73431 | 2109600.17323 | 37.7731192414011 | -122.409125744471 | (37.7731192414011, -122.409125744471) | |||
| 182127 | 182127 | 240884 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 98 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008092.35816 | 2108001.4400299997 | 37.7686273481005 | -122.41530948107 | (37.7686273481005, -122.41530948107) | |||
| 182007 | 182007 | 245330 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 3172 Lucky St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008537.23956 | 2101572.55178 | 37.7510000846975 | -122.413315973652 | (37.7510000846975, -122.413315973652) | |||
| 181789 | 181789 | 240992 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 5 Beaver St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 6002827.983080001 | 2106780.0567 | 37.7649764495376 | -122.43343122047199 | (37.7649764495376, -122.433431220472) | |||
| 181282 | 181282 | 179614 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 822 Felton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008536.27873 | 2093186.38698 | 37.7279734580912 | -122.412726495035 | (37.7279734580912, -122.412726495035) | |||
| 181220 | 181220 | 245259 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 538 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003074.06542 | 2098932.15521 | 37.7434419331045 | -122.432019631103 | (37.7434419331045, -122.432019631103) | |||
| 181047 | 181047 | 136527 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 85 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 5997345.31461 | 2114006.64352 | 37.784506200849 | -122.452915959821 | (37.784506200849, -122.452915959821) | |||
| 180899 | 180899 | 33863 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 281 Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1997 12:00:00 AM | 9 | Permit Number 37859 | 6011402.4962 | 2111360.8969400004 | 37.7780371282385 | -122.404096375858 | (37.7780371282385, -122.404096375858) | ||
| 180810 | 180810 | 240868 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1720 Dolores St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6005263.319490001 | 2098343.70068 | 37.7419500432577 | -122.424407889836 | (37.7419500432577, -122.424407889836) | |||
| 180786 | 180786 | 197769 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1301 Minnesota St | 54 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015357.64937 | 2102415.32545 | 37.7536947305524 | -122.389788979575 | (37.7536947305524, -122.389788979575) | ||||
| 180610 | 180610 | 225142 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Albion St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005928.78135 | 2106387.03173 | 37.764072729797704 | -122.422678389203 | (37.7640727297977, -122.422678389203) | |||
| 180602 | 180602 | 117935 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 883 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5982921.78883 | 2109794.0641400004 | 37.772102578170795 | -122.502503724416 | (37.7721025781708, -122.502503724416) | |||
| 180027 | 180027 | 179629 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 49 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002062.61368 | 2087462.58557 | 37.711891703015795 | -122.43469698207599 | (37.7118917030158, -122.434696982076) | |||
| 179749 | 179749 | 81424 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 936 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 7 | 6008224.91775 | 2115730.6565 | 37.7898573783726 | -122.415398222545 | (37.7898573783726, -122.415398222545) | ||
| 179712 | 179712 | 197751 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 477 Morris St | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 3ft | 6011923.70688 | 2110840.70923 | 37.7766379207291 | -122.40225672807101 | (37.7766379207291, -122.402256728071) | |||
| 179707 | 179707 | 245252 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1090 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010233.59348 | 2102899.19356 | 37.754737843387204 | -122.407543309979 | (37.7547378433872, -122.407543309979) | |||
| 179693 | 179693 | 54942 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 238 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/13/1972 12:00:00 AM | 12 | Permit Number 10820 | 6012686.68001 | 2087364.92959 | 37.7122209852769 | -122.397970139226 | (37.7122209852769, -122.397970139226) | ||
| 179597 | 179597 | 240847 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 450 Florida St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6009178.560769999 | 2106298.18475 | 37.7640115893856 | -122.41143203245599 | (37.7640115893856, -122.411432032456) | ||||
| 178786 | 178786 | 197766 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1150x Tennessee St | 13 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 8ft | 6015570.19786 | 2103483.2933099996 | 37.756638928352 | -122.38912849679701 | (37.756638928352, -122.389128496797) | |||
| 178621 | 178621 | 197778 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 601 Wisconsin St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6012724.983580001 | 2104673.0292 | 37.759747548338105 | -122.399051845593 | (37.7597475483381, -122.399051845593) | |||
| 178429 | 178429 | 197802 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 816 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011487.83724 | 2109458.15845 | 37.7728174145236 | -122.403667236476 | (37.7728174145236, -122.403667236476) | |||
| 178366 | 178366 | 245254 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 301 Precita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008492.70058 | 2100199.90908 | 37.7472286140288 | -122.41337293221399 | (37.7472286140288, -122.413372932214) | |||
| 178231 | 178231 | 197812 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 958 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013362.4474599995 | 2089433.04688 | 37.7179372398964 | -122.39577929089899 | (37.7179372398964, -122.395779290899) | |||
| 177569 | 177569 | 245251 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 206 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6005413.81717 | 2102430.30031 | 37.7531794064144 | -122.42417808424601 | (37.7531794064144, -122.424178084246) | |||
| 177418 | 177418 | 240849 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 450 Florida St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6009178.7151 | 2106293.81333 | 37.7639995951253 | -122.411431189821 | (37.7639995951253, -122.411431189821) | ||||
| 177350 | 177350 | 245364 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 508 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002316.12303 | 2105190.5394 | 37.7605829681381 | -122.435087919184 | (37.7605829681381, -122.435087919184) | |||
| 177307 | 177307 | 179571 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 5998627.15829 | 2088384.3655400001 | 37.7142270651918 | -122.446637110039 | (37.7142270651918, -122.446637110039) | |||
| 177299 | 177299 | 240864 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1706 Dolores St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6005262.73764 | 2098352.29949 | 37.741973620782105 | -122.424410513158 | (37.7419736207821, -122.424410513158) | |||
| 177250 | 177250 | 40579 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1745 Alameda St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/2003 12:00:00 AM | 14 | Permit Number 47084 | 6011781.78779 | 2107916.60765 | 37.7686010824916 | -122.402542001114 | (37.7686010824916, -122.402542001114) | |
| 177166 | 177166 | 240997 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 52 Landers St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004455.87708 | 2107460.86758 | 37.7669380156921 | -122.42784925625 | (37.7669380156921, -122.42784925625) | |||
| 177071 | 177071 | 241001 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 244 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004097.47892 | 2108736.71295 | 37.7704208966318 | -122.429179880544 | (37.7704208966318, -122.429179880544) | |||
| 177037 | 177037 | 246965 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 250x Noe St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 6002901.60437 | 2106802.37956 | 37.7650419192671 | -122.433178178236 | (37.7650419192671, -122.433178178236) | |||
| 176996 | 176996 | 140926 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 156 PARKER AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5996927.3146 | 2113363.8851 | 37.7827173938201 | -122.454315645143 | (37.7827173938201, -122.454315645143) | |||
| 176858 | 176858 | 245277 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2394 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008165.09675 | 2104533.2431900003 | 37.7591085701264 | -122.414812397888 | (37.7591085701264, -122.414812397888) | |||
| 176782 | 176782 | 40001 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 881 Innes Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/1999 12:00:00 AM | 12 | Permit Number 41257 | 6019355.96693 | 2094318.55144 | 37.7316835059849 | -122.375400541805 | (37.7316835059849, -122.375400541805) | |
| 176603 | 176603 | 136555 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Cedar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6006874.57787 | 2114487.0344700003 | 37.7863667101899 | -122.419981995093 | (37.7863667101899, -122.419981995093) | |||
| 176427 | 176427 | 245309 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 375 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008624.96128 | 2096979.1626400002 | 37.7383925788445 | -122.41268793120399 | (37.7383925788445, -122.412687931204) | |||
| 176388 | 176388 | 197801 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 816 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011521.16357 | 2109490.57736 | 37.772908291013295 | -122.403554237551 | (37.7729082910133, -122.403554237551) | |||
| 176047 | 176047 | 240880 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2318 22nd St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6011232.06922 | 2103723.4899 | 37.757057017796505 | -122.40414829911998 | (37.7570570177965, -122.40414829912) | ||||
| 175940 | 175940 | 245232 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 51 Dearborn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 6ft | 6005861.26231 | 2105689.81649 | 37.76215453162229 | -122.422862363516 | (37.7621545316223, -122.422862363516) | |||
| 175591 | 175591 | 240971 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 4220 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6001400.39717 | 2103377.8991 | 37.7555538576506 | -122.438125141985 | (37.7555538576506, -122.438125141985) | |||
| 175340 | 175340 | 179595 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2109 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006095.08243 | 2086183.72557 | 37.7086083294779 | -122.420668888264 | (37.7086083294779, -122.420668888264) | |||
| 175006 | 175006 | 117660 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 5110 Anza St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5982774.78235 | 2111734.38287 | 37.7774214897517 | -122.503155904898 | (37.7774214897517, -122.503155904898) | |||
| 174824 | 174824 | 179570 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 190 Foote Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5998636.2181400005 | 2088373.4694599998 | 37.714197664554796 | -122.44660501232599 | (37.7141976645548, -122.446605012326) | |||
| 174725 | 174725 | 142846 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1249 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006785.3377 | 2115265.4346 | 37.7884989771715 | -122.42034601298501 | (37.7884989771715, -122.420346012985) | |||
| 174714 | 174714 | 245333 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 2902 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009404.67525 | 2102788.2206099997 | 37.754386703088606 | -122.41040211178499 | (37.7543867030886, -122.410402111785) | |||
| 174680 | 174680 | 51534 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 772 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 10 | Permit Number 47835 | 6012007.91318 | 2110835.16017 | 37.776627384285796 | -122.40196504194901 | (37.7766273842858, -122.401965041949) | ||
| 174525 | 174525 | 47838 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 636 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 3 | 3x3 | Permit Number 45600 | 5981355.1062900005 | 2111406.4182700003 | 37.7764374450216 | -122.508042597219 | (37.7764374450216, -122.508042597219) |
| 174497 | 174497 | 142854 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1234 POLK ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006834.6673 | 2115255.4083 | 37.7884742270331 | -122.42017462803001 | (37.7884742270331, -122.42017462803) | |||
| 174416 | 174416 | 215165 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 240 Manor Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5993883.88024 | 2094060.55173 | 37.729540414347795 | -122.463443268118 | (37.7295404143478, -122.463443268118) | |||
| 174290 | 174290 | 240855 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 151 Albion St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6005930.39356 | 2106374.49675 | 37.7640384026622 | -122.422671922196 | (37.7640384026622, -122.422671922196) | |||
| 174276 | 174276 | 240955 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 518 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002315.70152 | 2105170.15732 | 37.7605269799449 | -122.435087919195 | (37.7605269799449, -122.435087919195) | |||
| 173932 | 173932 | 51717 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 175@ 6th ST Bluxome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2005 12:00:00 AM | 12 | Permit Number 47987 | 6012600.34291 | 2110009.8582599997 | 37.774394339765294 | -122.399857674991 | (37.7743943397653, -122.399857674991) | ||
| 173915 | 173915 | 197777 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1555 Mariposa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012626.2473 | 2106084.84783 | 37.763618587443105 | -122.399492447726 | (37.7636185874431, -122.399492447726) | |||
| 173499 | 173499 | 40576 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1745 Alameda St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 16 | Permit Number 42197 | 6011845.3055300005 | 2107921.74272 | 37.7686187280976 | -122.40232265826201 | (37.7686187280976, -122.402322658262) |
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");