Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantDate, DBH, PlotSize, PermitNotes
qSiteInfo ✖
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69135 | 69135 | 32234 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1598 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 2 | Permit Number 35550 | 6008744.76884 | 2099374.8804200003 | 37.744977417571796 | -122.41244298828 | (37.7449774175718, -122.41244298828) | ||
175327 | 175327 | 32981 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 558 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 7 | Permit Number 37294 | 6013791.869419999 | 2104484.1784 | 37.759288400371204 | -122.39534875755699 | (37.7592884003712, -122.395348757557) | |
145134 | 145134 | 39190 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1435 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | Permit Number 40843 | 6007766.05804405 | 2101299.52134892 | 37.7502070771658 | -122.415963470624 | (37.7502070771658, -122.415963470624) | ||
97429 | 97429 | 45173 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1528 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/23/2001 12:00:00 AM | Permit Number 44021 | 6010431.85887632 | 2100611.56059168 | 37.748467604177705 | -122.40669644419201 | (37.7484676041777, -122.406696444192) | ||
114721 | 114721 | 47290 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2100 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2002 12:00:00 AM | 3x3 | Permit Number 45232 | 6009541.72996085 | 2104990.45798185 | 37.7604412326322 | -122.41008360325701 | (37.7604412326322, -122.410083603257) | |
67423 | 67423 | 49806 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1164SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46601 | 6014134.35886 | 2105751.7151200003 | 37.762787822535 | -122.394252998377 | (37.762787822535, -122.394252998377) | ||
51695 | 51695 | 49809 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1546ARKANSAS 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46602 | 6012971.722709999 | 2105685.57554 | 37.762541524281204 | -122.398269533421 | (37.7625415242812, -122.398269533421) | |
115743 | 115743 | 49813 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 279 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | Permit Number 46605 | 6012936.15174933 | 2105762.41112227 | 37.7627505163476 | -122.398397952764 | (37.7627505163476, -122.398397952764) | |||
95721 | 95721 | 49921 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325@ 20th ST San Carlos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/02/2003 12:00:00 AM | Permit Number 46679 | 6006742.01796068 | 2104222.31382085 | 37.7581747672784 | -122.419712030585 | (37.7581747672784, -122.419712030585) | ||
16598 | 16598 | 51103 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
16019 | 16019 | 51104 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
15612 | 15612 | 51105 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
16726 | 16726 | 51106 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
15160 | 15160 | 51107 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
13713 | 13713 | 51108 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
14126 | 14126 | 51109 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
13389 | 13389 | 51110 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
16237 | 16237 | 51111 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
14983 | 14983 | 51112 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
14577 | 14577 | 51113 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
16258 | 16258 | 51114 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
16795 | 16795 | 51115 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
16649 | 16649 | 51116 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
29071 | 29071 | 51117 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 7 | Permit Number 47557 | 6012851.53345 | 2108941.1546099996 | 37.7714739218185 | -122.398913731299 | (37.7714739218185, -122.398913731299) | ||
16691 | 16691 | 51118 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
14792 | 14792 | 51119 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
123439 | 123439 | 51120 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012887.75032 | 2108975.98412 | 37.771571573793004 | -122.398790899202 | (37.771571573793, -122.398790899202) | ||
13716 | 13716 | 51121 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
45373 | 45373 | 51122 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 9 | Permit Number 47557 | 6012812.37793 | 2108902.32047 | 37.7713651101465 | -122.399046446937 | (37.7713651101465, -122.399046446937) | ||
41881 | 41881 | 51123 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 10 | Permit Number 47557 | 6012907.31344 | 2108994.69031 | 37.7716240267703 | -122.39872454180401 | (37.7716240267703, -122.398724541804) | ||
60290 | 60290 | 51124 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012694.61425 | 2108791.31053 | 37.7710537387716 | -122.399446004933 | (37.7710537387716, -122.399446004933) | ||
186208 | 186208 | 51125 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012869.40685 | 2108957.05013 | 37.7715185632492 | -122.398853021653 | (37.7715185632492, -122.398853021653) | ||
163998 | 163998 | 51126 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012833.17756 | 2108921.6110400003 | 37.771419236747704 | -122.39897585375 | (37.7714192367477, -122.39897585375) | ||
168732 | 168732 | 51127 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 10 | Permit Number 47557 | 6012791.79876 | 2108883.8380400003 | 37.77131321475821 | -122.39911633417 | (37.7713132147582, -122.39911633417) | ||
186041 | 186041 | 51128 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012773.055380001 | 2108865.31837 | 37.7712613193831 | -122.399179868575 | (37.7712613193831, -122.399179868575) | ||
29546 | 29546 | 51129 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 11 | Permit Number 47557 | 6012752.45555 | 2108845.8204 | 37.771206634319604 | -122.399249755781 | (37.7712066343196, -122.399249755781) | ||
187058 | 187058 | 51130 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 8 | Permit Number 47557 | 6012734.14513 | 2108828.51136 | 37.7711580871187 | -122.399311877367 | (37.7711580871187, -122.399311877367) | ||
48888 | 48888 | 51131 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 1 | Permit Number 47557 | 6012714.573530001 | 2108809.39867 | 37.771104517176596 | -122.39937823472499 | (37.7711045171766, -122.399378234725) | ||
73527 | 73527 | 51132 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 9 | Permit Number 47557 | 6012926.67664 | 2109013.60395 | 37.7716770381823 | -122.39865889041401 | (37.7716770381823, -122.398658890414) | ||
15627 | 15627 | 51133 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
15821 | 15821 | 51134 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
14704 | 14704 | 51135 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
15630 | 15630 | 51136 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
14592 | 14592 | 51137 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
14578 | 14578 | 51138 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
16051 | 16051 | 51139 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
14238 | 14238 | 51140 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
13728 | 13728 | 51141 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
16609 | 16609 | 51142 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
14767 | 14767 | 51143 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
133682 | 133682 | 51482 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Permit Number 47794 | 6014137.24495 | 2110108.95335 | 37.77475199384529 | -122.39454814238199 | (37.7747519938453, -122.394548142382) | |||
176278 | 176278 | 51483 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 47794 | 6014118.18221 | 2110089.57063 | 37.774697713467 | -122.39461272721 | (37.774697713467, -122.39461272721) | |||
107516 | 107516 | 52168 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1064 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2005 12:00:00 AM | Permit Number 48361 | 6009419.47710262 | 2102976.82289251 | 37.754905392409604 | -122.41036423903601 | (37.7549053924096, -122.410364239036) | ||
112386 | 112386 | 61427 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 3514 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767543 | 6006340.52913524 | 2100870.00155072 | 37.7489474646868 | -122.42086255612301 | (37.7489474646868, -122.420862556123) | |
139275 | 139275 | 62892 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 399X 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2012 12:00:00 AM | Permit Number 768779 | 5994971.59272291 | 2112865.01973596 | 37.7812352946386 | -122.461045394767 | (37.7812352946386, -122.461045394767) | |||
166468 | 166468 | 78586 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1172 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 4 | 6012194.44084 | 2102964.2828 | 37.755026127363 | -122.400766695348 | (37.755026127363, -122.400766695348) | ||
107091 | 107091 | 82106 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1442 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767418 | 6003903.93114879 | 2099873.27169394 | 37.746073034264604 | -122.42921725762 | (37.7460730342646, -122.42921725762) | |
183890 | 183890 | 83155 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1714 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52368 | 6014530.43704 | 2094836.5062099998 | 37.7328389648403 | -122.392119708481 | (37.7328389648403, -122.392119708481) | |
42670 | 42670 | 85223 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 1 | : 4 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013205.26566 | 2109218.0492700003 | 37.7722539164092 | -122.397709569661 | (37.7722539164092, -122.397709569661) | ||
180030 | 180030 | 85224 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 13 | Permit Number 49539 | 6013220.65574 | 2109233.19851 | 37.77229636981421 | -122.39765739638901 | (37.7722963698142, -122.397657396389) | ||
68398 | 68398 | 85225 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 9 | Permit Number 49539 | 6013241.67832 | 2109252.65125 | 37.772350953271605 | -122.39758604146999 | (37.7723509532716, -122.39758604147) | ||
26196 | 26196 | 85226 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 9 | Permit Number 49539 | 6013258.86916 | 2109269.0895 | 37.772397046220604 | -122.39752772943599 | (37.7723970462206, -122.397527729436) | ||
160449 | 160449 | 85227 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 10 | Permit Number 49539 | 6013279.22191 | 2109288.33477 | 37.7724510226373 | -122.39745867679702 | (37.7724510226373, -122.397458676797) | ||
43589 | 43589 | 85228 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013295.28168 | 2109303.69122 | 37.7724940821684 | -122.397404201236 | (37.7724940821684, -122.397404201236) | ||
172546 | 172546 | 85229 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 11 | Permit Number 49539 | 6013312.02436 | 2109319.91751 | 37.7725395680802 | -122.39734742435199 | (37.7725395680802, -122.397347424352) | ||
160105 | 160105 | 85230 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 9 | Permit Number 49539 | 6013331.92947 | 2109338.95114 | 37.772592938352396 | -122.397279905049 | (37.7725929383524, -122.397279905049) | ||
187426 | 187426 | 85231 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49539 | 6013350.68536 | 2109356.01998 | 37.772640849735396 | -122.39721622315001 | (37.7726408497354, -122.39721622315) | ||
180028 | 180028 | 85232 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 13 | Permit Number 49539 | 6013368.7851599995 | 2109373.5443 | 37.7726899752046 | -122.397154842615 | (37.7726899752046, -122.397154842615) | ||
31504 | 31504 | 85233 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 12 | Permit Number 49539 | 6013385.079919999 | 2109389.55863 | 37.7727348540654 | -122.397099599979 | (37.7727348540654, -122.397099599979) | ||
71158 | 71158 | 85234 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 7 | Permit Number 49539 | 6013403.64119 | 2109407.9569599996 | 37.772786404996296 | -122.397036684295 | (37.7727864049963, -122.397036684295) | ||
76681 | 76681 | 85235 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 5 | Permit Number 49539 | 6013421.95811 | 2109425.2555 | 37.7728349225156 | -122.39697453664 | (37.7728349225156, -122.39697453664) | ||
90534 | 90534 | 87858 | Koelreuteria paniculata :: Golden Rain Tree 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000340.49747 | 2104887.90927 | 37.7596396402708 | -122.441898968169 | (37.7596396402708, -122.441898968169) | |||||||
162675 | 162675 | 88046 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1547 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51057 | 6015682.046 | 2096712.9906400002 | 37.738055284531896 | -122.388269185596 | (37.7380552845319, -122.388269185596) | |
40737 | 40737 | 88768 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51687 | 6013512.4253 | 2109511.33019 | 37.7730762996632 | -122.39666763312701 | (37.7730762996632, -122.396667633127) | |
168457 | 168457 | 91114 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52002 | 6013611.29629 | 2109661.1066900003 | 37.773493054483 | -122.39633612322399 | (37.773493054483, -122.396336123224) | |
146179 | 146179 | 92223 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 715 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52658 | 6009316.0 | 2104920.0 | 37.7602351164227 | -122.410859325784 | (37.7602351164227, -122.410859325784) | ||
99753 | 99753 | 92865 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 260 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2015 12:00:00 AM | 4x4 | Permit Number 774771 | 6004247.0 | 2098697.0 | 37.7428626784389 | -122.42794716566601 | (37.7428626784389, -122.427947165666) | ||
81996 | 81996 | 95589 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1598 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767379 | 6008735.1 | 2099385.7 | 37.7450065831384 | -122.412477186149 | (37.7450065831384, -122.412477186149) | |
90850 | 90850 | 95804 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1172 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767548 | 6012200.0 | 2102946.0 | 37.7549762368602 | -122.400746185712 | (37.7549762368602, -122.400746185712) | |
28628 | 28628 | 95805 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1180 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767549 | 6012197.65812 | 2102892.33506 | 37.754828754052504 | -122.40075051472701 | (37.7548287540525, -122.400750514727) |
14820 | 14820 | 96729 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1531 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015669.53931 | 2096721.84355 | 37.738078899822995 | -122.388313045518 | (37.738078899823, -122.388313045518) | |||
143417 | 143417 | 96730 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1531 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015658.7 | 2096702.1 | 37.738024087431995 | -122.38834914513201 | (37.738024087432, -122.388349145132) | |||
16167 | 16167 | 107773 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772845 | 6014155.30561 | 2110125.53241 | 37.7747985202595 | -122.394486827531 | (37.7747985202595, -122.394486827531) | |
124248 | 124248 | 115879 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1125X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015016.8 | 2096457.8 | 37.737317699837206 | -122.390551463966 | (37.7373176998372, -122.390551463966) | ||
183780 | 183780 | 119659 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401X Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6012884.61917 | 2108905.3838400003 | 37.7713775468798 | -122.398796774473 | (37.7713775468798, -122.398796774473) | |||
4800 | 4800 | 161279 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 594 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:18:00 PM | 3 | Width 0ft | 6002806.05279 | 2090211.99508 | 37.7194831555901 | -122.43232368828998 | (37.7194831555901, -122.43232368829) | |
62893 | 62893 | 190833 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 703 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011016.09695 | 2105008.53851 | 37.760573404768294 | -122.404985694736 | (37.7605734047683, -122.404985694736) | |||
166088 | 166088 | 190834 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 703 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6011015.81631 | 2105024.6924 | 37.760617744045206 | -122.40498780276 | (37.7606177440452, -122.40498780276) | |||
65354 | 65354 | 190835 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 540 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6011143.20834 | 2097895.22742 | 37.7410489144739 | -122.404045463449 | (37.7410489144739, -122.404045463449) | |||
168558 | 168558 | 190836 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 540 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6011141.49126 | 2097886.93529 | 37.7410260501239 | -122.404050817101 | (37.7410260501239, -122.404050817101) | |||
149364 | 149364 | 190837 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 540 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6011137.802619999 | 2097880.16304 | 37.7410072488818 | -122.404063094656 | (37.7410072488818, -122.404063094656) | |||
48280 | 48280 | 190838 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6015067.58857 | 2111050.6554 | 37.7773893744695 | -122.39139571284599 | (37.7773893744695, -122.391395712846) | |||
129961 | 129961 | 190839 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6015047.6106 | 2111033.73325 | 37.7773418012199 | -122.391463640434 | (37.7773418012199, -122.391463640434) | |||
170689 | 170689 | 190840 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6014957.07587 | 2110944.72485 | 37.777092378742104 | -122.391770606946 | (37.7770923787421, -122.391770606946) | |||
173251 | 173251 | 190841 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6014902.59214 | 2110893.10566 | 37.776947619367206 | -122.39195547427299 | (37.7769476193672, -122.391955474273) | |||
188200 | 188200 | 190842 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014886.13724 | 2110878.3396 | 37.776906161529205 | -122.39201136443998 | (37.7769061615292, -122.39201136444) | |||
50709 | 50709 | 190843 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6014866.38244 | 2110860.17534 | 37.7768551897557 | -122.39207843228901 | (37.7768551897557, -122.392078432289) | |||
44763 | 44763 | 190844 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6014850.8812 | 2110843.4101 | 37.776808295508104 | -122.392130883449 | (37.7768082955081, -122.392130883449) | |||
62300 | 62300 | 190845 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014811.37622 | 2110807.32883 | 37.7767070309344 | -122.39226502002899 | (37.7767070309344, -122.392265020029) | |||
67747 | 67747 | 190846 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014778.17275 | 2110775.57556 | 37.776617999847204 | -122.39237766009899 | (37.7766179998472, -122.392377660099) |
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");