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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | ||||
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) | |||
142770 | 142770 | 105263 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 759 GONZALEZ DR | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 5988771.3 | 2089745.5 | 37.7173964863294 | -122.48080198209499 | (37.7173964863294, -122.480801982095) | ||||
171341 | 171341 | 69149 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 3800 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/18/1994 12:00:00 AM | 2 | Permit Number 33184 | 5984258.76944929 | 2098185.8676223997 | 37.7403081745186 | -122.4970221092 | (37.7403081745186, -122.4970221092) | |
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
128425 | 128425 | 30934 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 910 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34747 | 5995945.63998 | 2089982.79066164 | 37.7184624266242 | -122.456020912886 | (37.7184624266242, -122.456020912886) | ||
129473 | 129473 | 30922 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 150 Holloway Ave | 3 | 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) | ||
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) | ||
140568 | 140568 | 31166 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 554 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34867 | 5993026.28689327 | 2090884.13081641 | 37.7207692924347 | -122.46617728812099 | (37.7207692924347, -122.466177288121) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |
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) | ||
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) | ||
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) | |
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) | ||
137295 | 137295 | 31315 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 6 | 2.5x2 | Permit Number 34950 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) |
139183 | 139183 | 31326 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 2.5x2 | Permit Number 34950 | 6004711.0 | 2111132.0 | 37.777032483526895 | -122.427228354699 | (37.7770324835269, -122.427228354699) | |
143276 | 143276 | 31317 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 500 Ivy St | 21 | 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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) |
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) | ||
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) | ||
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) |
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) | ||
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) | ||
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) |
138485 | 138485 | 31382 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 1200 Ulloa St | 3 | 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) | ||
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) | ||
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) | |
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) | |
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) | ||
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) | ||
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) | |
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) | ||
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) |
141547 | 141547 | 66646 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 958 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/05/1991 12:00:00 AM | Permit Number 29857 | 6010187.53745627 | 2103637.91079685 | 37.756763617892396 | -122.407754670373 | (37.7567636178924, -122.407754670373) | ||
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) | ||
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) | ||
142861 | 142861 | 65959 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 2427 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/1990 12:00:00 AM | Permit Number 28981 | 5987945.98610397 | 2098777.22918631 | 37.742147280127895 | -122.484316701472 | (37.7421472801279, -122.484316701472) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | |||
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) | |
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) | ||
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) | ||
139806 | 139806 | 34298 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 2880 25th St | 2 | 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) | ||
140696 | 140696 | 34295 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 2872 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38085 | 6010184.92031581 | 2101667.41024603 | 37.7513529152303 | -122.407624791386 | (37.7513529152303, -122.407624791386) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
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) | ||
142116 | 142116 | 68322 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 68 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32137 | 6006464.26620293 | 2105877.23148989 | 37.7627031349161 | -122.420790105401 | (37.7627031349161, -122.420790105401) | ||
144107 | 144107 | 68267 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 401 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32073 | 6009763.09904775 | 2092562.0344626 | 37.726327899253604 | -122.40844130243 | (37.7263278992536, -122.40844130243) | ||
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) | ||
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) | ||
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) | ||
141996 | 141996 | 38438 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 725 Florida St | 3 | 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) | ||
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) | ||
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) | ||
138610 | 138610 | 66765 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 18 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30022 | 6006733.48270777 | 2105892.16850842 | 37.7627593187766 | -122.41986003954901 | (37.7627593187766, -122.419860039549) | ||
140839 | 140839 | 66770 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 56 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30029 | 6006520.28116696 | 2105880.33939159 | 37.762714825524995 | -122.420596589874 | (37.762714825525, -122.420596589874) | ||
145616 | 145616 | 66768 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 64 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/12/1991 12:00:00 AM | Permit Number 30027 | 6006482.93785761 | 2105878.26745712 | 37.762707031821 | -122.42072560023199 | (37.762707031821, -122.420725600232) | ||
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) | ||
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) | ||
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) | ||
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) | ||
141944 | 141944 | 36684 | Permitted Site 1 | Photinia fraseri :: Photinia Tree 153 | 3425 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/09/2006 12:00:00 AM | Permit Number 49046 | 6006750.72599795 | 2104934.92825062 | 37.7601319316605 | -122.41973247701999 | (37.7601319316605, -122.41973247702) | ||
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) | ||
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) | ||
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) | ||
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) |
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");