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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1700 | 1700 | 123453 | Undocumented 2 | Photinia fraseri :: Photinia Tree 153 | 713 02nd Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779827 | 5995319.78488 | 2110672.1771299997 | 37.7752343616797 | -122.459681952866 | (37.7752343616797, -122.459681952866) | |
| 1715 | 1715 | 123454 | Undocumented 2 | Photinia fraseri :: Photinia Tree 153 | 713 02nd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | Permit Number 779827 | 5995320.73299 | 2110668.0352 | 37.7752230435543 | -122.459678373092 | (37.7752230435543, -122.459678373092) | ||
| 2282 | 2282 | 234424 | Undocumented 2 | Photinia fraseri :: Photinia Tree 153 | 360 Church St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | Permit Number 780144 | 6004154.11162 | 2106813.1044400004 | 37.7651423384845 | -122.428846830126 | (37.7651423384845, -122.428846830126) | ||
| 17033 | 17033 | 35806 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 48 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39050 | 6006557.62447631 | 2105882.41132606 | 37.762722619087704 | -122.420467579489 | (37.7627226190877, -122.420467579489) | ||
| 18481 | 18481 | 64981 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 18 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/24/1989 12:00:00 AM | Permit Number 26019 | 6005742.91166727 | 2099374.35600444 | 37.7448070600877 | -122.42282284291599 | (37.7448070600877, -122.422822842916) | ||
| 20486 | 20486 | 31332 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) | ||
| 46388 | 46388 | 31567 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 320 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35107 | 5998580.00875789 | 2112167.37155762 | 37.779526717238 | -122.448511851314 | (37.779526717238, -122.448511851314) | |
| 50100 | 50100 | 34341 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1256 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/17/1999 12:00:00 AM | Permit Number 38098 | 6010025.23435755 | 2101885.23232138 | 37.7519420662896 | -122.40819236735399 | (37.7519420662896, -122.408192367354) | ||
| 55230 | 55230 | 31566 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 308 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35106 | 5998541.7634509 | 2112162.0975268995 | 37.779510049305 | -122.44864377763001 | (37.779510049305, -122.44864377763) | |
| 66688 | 66688 | 31569 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 338 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 1 | Permit Number 35109 | 5998637.37673043 | 2112175.28260536 | 37.7795517188659 | -122.44831396168699 | (37.7795517188659, -122.448313961687) | |
| 77033 | 77033 | 31568 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 332 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 0 | Permit Number 35108 | 5998618.25406489 | 2112172.64558834 | 37.7795433850234 | -122.448379924939 | (37.7795433850234, -122.448379924939) | |
| 77334 | 77334 | 32677 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 899 Howard St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37098 | 6011223.96618851 | 2112626.31921579 | 37.781501706175604 | -122.404803090396 | (37.7815017061756, -122.404803090396) | ||
| 78441 | 78441 | 32503 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 292 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37007 | 6006814.5953718 | 2095750.97368138 | 37.7349184687173 | -122.418860225731 | (37.7349184687173, -122.418860225731) | ||
| 78675 | 78675 | 31903 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 969 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35328 | 6008029.13454048 | 2109879.85819982 | 37.7737814887342 | -122.41566118400699 | (37.7737814887342, -122.415661184007) | ||
| 79824 | 79824 | 67351 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 713 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | Permit Number 30838 | 6009876.15204434 | 2104954.24625098 | 37.7603605418838 | -122.40892443159402 | (37.7603605418838, -122.408924431594) | ||
| 79973 | 79973 | 34395 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 131 Moffitt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38142 | 6002633.1447609 | 2096796.28026011 | 37.7375523083094 | -122.433391625623 | (37.7375523083094, -122.433391625623) | ||
| 81140 | 81140 | 32681 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 899 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37098 | 6011223.96618851 | 2112626.31921579 | 37.781501706175604 | -122.404803090396 | (37.7815017061756, -122.404803090396) | ||
| 81525 | 81525 | 60336 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 127 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19910 | 6002696.65080331 | 2105157.46934555 | 37.7605137659051 | -122.433769484484 | (37.7605137659051, -122.433769484484) | ||
| 82129 | 82129 | 30921 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 150 Holloway Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34737 | 5996375.06568666 | 2091233.55028931 | 37.7219213567264 | -122.454626885388 | (37.7219213567264, -122.454626885388) | ||
| 82297 | 82297 | 68008 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 525 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31733 | 5993230.57991473 | 2090673.1721909 | 37.720201835830395 | -122.465455798615 | (37.7202018358304, -122.465455798615) | ||
| 84942 | 84942 | 66636 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 970 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/1991 12:00:00 AM | Permit Number 29847 | 6010191.25055657 | 2103570.92825011 | 37.7565799066669 | -122.407737106169 | (37.7565799066669, -122.407737106169) | ||
| 86176 | 86176 | 31323 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | ||
| 86555 | 86555 | 31170 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 701 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34870 | 5992182.10994821 | 2088503.70058995 | 37.7141844683459 | -122.468922182021 | (37.7141844683459, -122.468922182021) | ||
| 86935 | 86935 | 31379 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1200 Ulloa St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34979 | 5992487.7099522995 | 2098471.6596411997 | 37.741571670788495 | -122.468590752076 | (37.7415716707885, -122.468590752076) | ||
| 87657 | 87657 | 64956 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 90 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/1989 12:00:00 AM | Permit Number 25987 | 6005330.51370427 | 2099351.30383605 | 37.744720486614 | -122.424247199326 | (37.744720486614, -122.424247199326) | ||
| 88500 | 88500 | 31884 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 142 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35320 | 6008136.56903408 | 2110210.75030883 | 37.7746960787711 | -122.415312978758 | (37.7746960787711, -122.415312978758) | ||
| 89639 | 89639 | 31329 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | ||
| 89733 | 89733 | 30923 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 150 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34737 | 5996375.06568666 | 2091233.55028931 | 37.7219213567264 | -122.454626885388 | (37.7219213567264, -122.454626885388) | ||
| 91116 | 91116 | 60335 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 4075 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/1982 12:00:00 AM | Permit Number 20006 | 6002530.02077701 | 2104700.74933312 | 37.7592502662204 | -122.434313127594 | (37.7592502662204, -122.434313127594) | ||
| 93409 | 93409 | 31883 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 142 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35320 | 6008136.56903408 | 2110210.75030883 | 37.7746960787711 | -122.415312978758 | (37.7746960787711, -122.415312978758) | ||
| 94743 | 94743 | 31327 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | ||
| 95219 | 95219 | 31380 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1200 Ulloa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34979 | 5992487.7099522995 | 2098471.6596411997 | 37.741571670788495 | -122.468590752076 | (37.7415716707885, -122.468590752076) | ||
| 95265 | 95265 | 64935 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 760 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1989 12:00:00 AM | Permit Number 25963 | 6005620.53901807 | 2098700.72854642 | 37.7429505266072 | -122.42319811087 | (37.7429505266072, -122.42319811087) | ||
| 95510 | 95510 | 31885 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 142 10th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35320 | 6008136.56903408 | 2110210.75030883 | 37.7746960787711 | -122.415312978758 | (37.7746960787711, -122.415312978758) | ||
| 95648 | 95648 | 65397 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 129 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/1989 12:00:00 AM | Permit Number 769855 | 6003450.940868701 | 2105044.43183692 | 37.7602461647902 | -122.43115267366001 | (37.7602461647902, -122.43115267366) | |||
| 96736 | 96736 | 31324 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | ||
| 97239 | 97239 | 31368 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 300 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34972 | 5992325.0295125 | 2099143.1296763 | 37.743405957884896 | -122.46920210066001 | (37.7434059578849, -122.46920210066) |
| 97287 | 97287 | 31892 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 999 Natoma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | Permit Number 35322 | 6007970.79373767 | 2109754.69864739 | 37.7734345505501 | -122.415854130267 | (37.7734345505501, -122.415854130267) | ||
| 100053 | 100053 | 34046 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 298 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | 3 | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | |
| 100376 | 100376 | 30912 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 180 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34733 | 5995664.56548736 | 2091086.14312969 | 37.7214758341973 | -122.45707223166299 | (37.7214758341973, -122.457072231663) | ||
| 101455 | 101455 | 34297 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 2880 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38086 | 6010150.01675052 | 2101665.50876097 | 37.7513457403032 | -122.40774535844 | (37.7513457403032, -122.40774535844) | ||
| 101826 | 101826 | 31322 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 2.5x3 | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | |
| 102276 | 102276 | 66645 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 2620 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | 10 | 3x3 | Permit Number 29856 | 6010352.98815253 | 2104015.30815084 | 37.757809127327704 | -122.40720908097299 | (37.7578091273277, -122.407209080973) |
| 102579 | 102579 | 31333 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | ||
| 103062 | 103062 | 38437 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 725 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1998 12:00:00 AM | Permit Number 40463 | 6009320.84267661 | 2104866.82634812 | 37.7600893851951 | -122.410838821684 | (37.7600893851951, -122.410838821684) | ||
| 103280 | 103280 | 56609 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 109 Chaves Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31087 | 5996782.90480666 | 2098550.32582843 | 37.7420348499326 | -122.453745188424 | (37.7420348499326, -122.453745188424) | ||
| 103783 | 103783 | 32685 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 899 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37098 | 6011223.96618851 | 2112626.31921579 | 37.781501706175604 | -122.404803090396 | (37.7815017061756, -122.404803090396) | ||
| 104798 | 104798 | 68005 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 501 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1993 12:00:00 AM | Permit Number 31730 | 5993229.33606132 | 2090506.48528425 | 37.7197440821869 | -122.46544799568998 | (37.7197440821869, -122.46544799569) | ||
| 105942 | 105942 | 105266 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 737 GONZALEZ DR | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.48050136001899 | (37.7173141872637, -122.480501360019) | ||||
| 105946 | 105946 | 31882 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 142 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 6008136.56903408 | 2110210.75030883 | 37.7746960787711 | -122.415312978758 | (37.7746960787711, -122.415312978758) | |||
| 107089 | 107089 | 25511 | DPW Maintained 3 | Photinia fraseri :: Photinia Tree 153 | 2340 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/02/1996 12:00:00 AM | 6 | 3X3 | 6010444.87816 | 2095088.76125 | 37.7333039164127 | -122.406262360289 | (37.7333039164127, -122.406262360289) | ||
| 108001 | 108001 | 38436 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 725 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/2000 12:00:00 AM | Permit Number 43557 | 6009320.84267661 | 2104866.82634812 | 37.7600893851951 | -122.410838821684 | (37.7600893851951, -122.410838821684) | ||
| 108751 | 108751 | 32683 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 899 Howard St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37098 | 6011223.96618851 | 2112626.31921579 | 37.781501706175604 | -122.404803090396 | (37.7815017061756, -122.404803090396) | ||
| 108859 | 108859 | 63697 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1719 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/09/1987 12:00:00 AM | Permit Number 24355 | 5993080.74651115 | 2103769.27356941 | 37.756151802523796 | -122.466925288995 | (37.7561518025238, -122.466925288995) | ||
| 109328 | 109328 | 31386 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1200 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34979 | 5992487.7099522995 | 2098471.6596411997 | 37.741571670788495 | -122.468590752076 | (37.7415716707885, -122.468590752076) | ||
| 109514 | 109514 | 60345 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 252 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19923 | 6002686.26660489 | 2104425.50101172 | 37.7585033678265 | -122.43375308183701 | (37.7585033678265, -122.433753081837) | ||
| 110554 | 110554 | 64936 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 647 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1989 12:00:00 AM | Permit Number 25964 | 6005958.80955295 | 2099650.25200698 | 37.7455767871938 | -122.422095904179 | (37.7455767871938, -122.422095904179) | ||
| 110670 | 110670 | 31381 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1200 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34979 | 5992487.7099522995 | 2098471.6596411997 | 37.741571670788495 | -122.468590752076 | (37.7415716707885, -122.468590752076) | ||
| 111071 | 111071 | 68265 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 389 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32071 | 6009742.13570335 | 2092630.55377665 | 37.7265148648795 | -122.408518603248 | (37.7265148648795, -122.408518603248) | ||
| 111127 | 111127 | 68361 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 600 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/29/1993 12:00:00 AM | Permit Number 32182 | 6009717.95437721 | 2092589.77747592 | 37.7264015474603 | -122.408599322266 | (37.7264015474603, -122.408599322266) | ||
| 111346 | 111346 | 66072 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 538 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1990 12:00:00 AM | Permit Number 29113 | 6014071.12882517 | 2104592.06579407 | 37.7596001633674 | -122.394390489971 | (37.7596001633674, -122.394390489971) | ||
| 111701 | 111701 | 31314 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | ||
| 111803 | 111803 | 31370 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 300 Taraval St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | 3x3 | Permit Number 34972 | 5992325.0295125 | 2099143.1296763 | 37.743405957884896 | -122.46920210066001 | (37.7434059578849, -122.46920210066) |
| 111929 | 111929 | 32680 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 899 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37098 | 6011223.96618851 | 2112626.31921579 | 37.781501706175604 | -122.404803090396 | (37.7815017061756, -122.404803090396) | ||
| 112400 | 112400 | 66771 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 36 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30030 | 6006613.63944033 | 2105885.51922776 | 37.762734309167 | -122.42027406386002 | (37.762734309167, -122.42027406386) | ||
| 113314 | 113314 | 32502 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 292 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | Permit Number 37007 | 6006814.5953718 | 2095750.97368138 | 37.7349184687173 | -122.418860225731 | (37.7349184687173, -122.418860225731) | ||
| 114020 | 114020 | 68007 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 521 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31732 | 5993230.37260583 | 2090645.39103979 | 37.7201255435589 | -122.46545449812099 | (37.7201255435589, -122.465454498121) | ||
| 114234 | 114234 | 60342 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 271 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19918 | 6002743.76300823 | 2104327.47191197 | 37.758237465851394 | -122.43354722809799 | (37.7582374658514, -122.433547228098) | ||
| 114378 | 114378 | 58784 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1494 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1989 12:00:00 AM | Permit Number 25965 | 6005850.84405756 | 2100254.33506162 | 37.747229371611 | -122.42251214955601 | (37.747229371611, -122.422512149556) | ||
| 114547 | 114547 | 67667 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 101 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/05/1992 12:00:00 AM | Permit Number 31269 | 6014176.68683306 | 2094076.04922403 | 37.730731257346 | -122.39328952630899 | (37.730731257346, -122.393289526309) | ||
| 114815 | 114815 | 60344 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 231-235 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19921 | 6002731.37274881 | 2104551.69020493 | 37.758852412428105 | -122.43360610306699 | (37.7588524124281, -122.433606103067) | ||
| 115070 | 115070 | 68266 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 400 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32072 | 6009713.40649943 | 2092546.71615196 | 37.7262830554111 | -122.408612007775 | (37.7262830554111, -122.408612007775) | ||
| 115243 | 115243 | 60339 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 217 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19913 | 6002727.03615793 | 2104630.16660903 | 37.7590676437119 | -122.433626709537 | (37.7590676437119, -122.433626709537) | ||
| 115711 | 115711 | 66769 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 50 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30028 | 6006548.28864897 | 2105881.89334244 | 37.762720670710294 | -122.420499832088 | (37.7627206707103, -122.420499832088) | ||
| 115763 | 115763 | 31316 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 2.5x2 | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | |
| 116240 | 116240 | 31378 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1200 Ulloa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34979 | 5992487.7099522995 | 2098471.6596411997 | 37.741571670788495 | -122.468590752076 | (37.7415716707885, -122.468590752076) | ||
| 116299 | 116299 | 66637 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 964 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/15/1991 12:00:00 AM | Permit Number 29848 | 6010189.39400584 | 2103604.41953391 | 37.756671762309296 | -122.407745888263 | (37.7566717623093, -122.407745888263) | ||
| 116339 | 116339 | 65310 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 40 Lapidge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/1989 12:00:00 AM | Permit Number 28129 | 6005974.84832629 | 2105267.64506883 | 37.7610017564143 | -122.42243951381501 | (37.7610017564143, -122.422439513815) | ||
| 116735 | 116735 | 33313 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1760 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37459 | 6004517.82386146 | 2119140.37015121 | 37.799010529609106 | -122.428467564949 | (37.7990105296091, -122.428467564949) | ||
| 117233 | 117233 | 60338 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 201 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19912 | 6002722.0800544005 | 2104719.85392202 | 37.759313622291295 | -122.43365025993299 | (37.7593136222913, -122.433650259933) | ||
| 117270 | 117270 | 68006 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 512 Victoria St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31731 | 5993281.95654029 | 2090589.44071323 | 37.7199748924323 | -122.465272129333 | (37.7199748924323, -122.465272129333) | ||
| 117793 | 117793 | 32684 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 899 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | 3x3 | Permit Number 37098 | 6011223.96618851 | 2112626.31921579 | 37.781501706175604 | -122.404803090396 | (37.7815017061756, -122.404803090396) | |
| 118085 | 118085 | 60337 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 134 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19911 | 6002647.34294818 | 2105109.72203394 | 37.760379865244396 | -122.433936604552 | (37.7603798652444, -122.433936604552) | ||
| 118124 | 118124 | 105877 | Undocumented 2 | Photinia fraseri :: Photinia Tree 153 | 400X TEHAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6011008.0 | 2112155.0 | 37.780195500287704 | -122.40551702868099 | (37.7801955002877, -122.405517028681) | |||
| 118322 | 118322 | 34296 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 2880 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38086 | 6010150.01675052 | 2101665.50876097 | 37.7513457403032 | -122.40774535844 | (37.7513457403032, -122.40774535844) | ||
| 118800 | 118800 | 56613 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 147 Chaves Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | Permit Number 30986 | 5996711.44908393 | 2098400.54759109 | 37.7416194987031 | -122.453981443659 | (37.7416194987031, -122.453981443659) | ||
| 118902 | 118902 | 33312 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1760 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37459 | 6004517.82386146 | 2119140.37015121 | 37.799010529609106 | -122.428467564949 | (37.7990105296091, -122.428467564949) | ||
| 118998 | 118998 | 32692 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 480 Tehama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37101 | 6010795.31904305 | 2111986.98149561 | 37.7797222664041 | -122.406240951939 | (37.7797222664041, -122.406240951939) | ||
| 119654 | 119654 | 54923 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 375 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32251 | 5992718.00411357 | 2094089.39765086 | 37.7295523769532 | -122.46747588141001 | (37.7295523769532, -122.46747588141) | ||
| 119967 | 119967 | 68268 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 415 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32074 | 6009781.29586625 | 2092503.00404445 | 37.726166833162104 | -122.408374234767 | (37.7261668331621, -122.408374234767) | ||
| 121030 | 121030 | 60340 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 234-238 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19915 | 6002680.69098813 | 2104526.39924408 | 37.7587800937402 | -122.433779576314 | (37.7587800937402, -122.433779576314) | ||
| 121395 | 121395 | 31384 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1200 Ulloa St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34979 | 5992487.7099522995 | 2098471.6596411997 | 37.741571670788495 | -122.468590752076 | (37.7415716707885, -122.468590752076) | ||
| 121446 | 121446 | 31325 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | Permit Number 34950 | 6004943.48429565 | 2111113.32646023 | 37.776994355319296 | -122.426422788886 | (37.7769943553193, -122.426422788886) | ||
| 122130 | 122130 | 30924 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 150 Holloway Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34737 | 5996375.06568666 | 2091233.55028931 | 37.7219213567264 | -122.454626885388 | (37.7219213567264, -122.454626885388) | ||
| 122495 | 122495 | 67554 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 639 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | Permit Number 31103 | 6004301.86723029 | 2110971.16151451 | 37.776567714737794 | -122.42863220433901 | (37.7765677147378, -122.428632204339) | ||
| 122612 | 122612 | 31369 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 300 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | 3x3 | Permit Number 34972 | 5992325.0295125 | 2099143.1296763 | 37.743405957884896 | -122.46920210066001 | (37.7434059578849, -122.46920210066) |
| 122683 | 122683 | 32678 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 899 Howard St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37098 | 6011223.96618851 | 2112626.31921579 | 37.781501706175604 | -122.404803090396 | (37.7815017061756, -122.404803090396) | ||
| 123694 | 123694 | 51621 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 465 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/04/2005 12:00:00 AM | Permit Number 47916 | 6010931.94121292 | 2112045.86318657 | 37.779891582978394 | -122.40577246257 | (37.7798915829784, -122.40577246257) | ||
| 127834 | 127834 | 60341 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 262 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1982 12:00:00 AM | Permit Number 19917 | 6002689.36416873 | 2104369.44645682 | 37.7583496312506 | -122.433738362773 | (37.7583496312506, -122.433738362773) | ||
| 128158 | 128158 | 65797 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 2227 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28765 | 5990377.34556351 | 2100223.38018411 | 37.746259307722504 | -122.476015504555 | (37.7462593077225, -122.476015504555) |
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");