Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92514 | 92514 | 30573 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 164 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | Permit Number 34550 | 6004481.83420946 | 2108792.73976924 | 37.7705964833806 | -122.42785438691001 | (37.7705964833806, -122.42785438691) | ||
| 162119 | 162119 | 30574 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 6 | Permit Number 34551 | 6004467.68034 | 2108789.06417 | 37.7705855903724 | -122.427903083363 | (37.7705855903724, -122.427903083363) | |
| 52581 | 52581 | 30766 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1595 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34647 | 6014606.5276 | 2093671.0453 | 37.729643069645704 | -122.391775180038 | (37.7296430696457, -122.391775180038) | |
| 25423 | 25423 | 30768 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1639 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34648 | 6014552.699 | 2093014.6387 | 37.727837721051294 | -122.391915390574 | (37.7278377210513, -122.391915390574) | |
| 73597 | 73597 | 30774 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 548 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 4 | 4.5x12 | Permit Number 34652 | 6014028.90307 | 2112230.33243 | 37.7805707972354 | -122.39507154151501 | (37.7805707972354, -122.395071541515) |
| 119263 | 119263 | 31008 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 127132 | 127132 | 31009 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 101 Morse St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34782 | 6000957.44438381 | 2087943.44267066 | 37.7131492251602 | -122.438551179992 | (37.7131492251602, -122.438551179992) | ||
| 64613 | 64613 | 31046 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 146 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34803 | 6000734.07095 | 2088520.9414400002 | 37.714722198640004 | -122.439364601993 | (37.71472219864, -122.439364601993) | |
| 178309 | 178309 | 31056 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 9 Toyon Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 7 | Permit Number 34808 | 6003244.645880001 | 2086572.31488 | 37.7095142480656 | -122.430548065039 | (37.7095142480656, -122.430548065039) | |
| 96508 | 96508 | 31080 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34818 | 6005439.37562614 | 2108486.56772635 | 37.769809930745 | -122.42452045534901 | (37.769809930745, -122.424520455349) | ||
| 79541 | 79541 | 31081 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34818 | 6005439.37562614 | 2108486.56772635 | 37.769809930745 | -122.42452045534901 | (37.769809930745, -122.424520455349) | ||
| 123857 | 123857 | 31090 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 109007 | 109007 | 31091 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 78060 | 78060 | 31092 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 107 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34826 | 6007750.16699625 | 2107319.28125593 | 37.766735061881704 | -122.416444770373 | (37.7667350618817, -122.416444770373) | ||
| 187669 | 187669 | 31093 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 105 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 8 | Permit Number 34826 | 6007741.23443 | 2107311.13584 | 37.7667121941381 | -122.416475089665 | (37.7667121941381, -122.416475089665) | |
| 26128 | 26128 | 31225 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2491 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34912 | 5987341.6863 | 2098360.1236 | 37.740966813188 | -122.486375538404 | (37.740966813188, -122.486375538404) | |
| 31859 | 31859 | 31232 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2551 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34918 | 5991386.50478 | 2098046.67038 | 37.7403410850744 | -122.472367334291 | (37.7403410850744, -122.472367334291) | |
| 125483 | 125483 | 31233 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2551 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34918 | 5991384.46211768 | 2098059.72003712 | 37.740376797876 | -122.47237534801901 | (37.740376797876, -122.472375348019) | ||
| 59734 | 59734 | 31234 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2558 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 6 | Permit Number 34919 | 5991432.5751 | 2098011.68272 | 37.740247684195204 | -122.472205493211 | (37.7402476841952, -122.472205493211) | |
| 150061 | 150061 | 31235 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2558 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34919 | 5991433.59287 | 2097992.23332 | 37.740194340008394 | -122.47220055682699 | (37.7401943400084, -122.472200556827) | |
| 158191 | 158191 | 31239 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2666 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 7 | Permit Number 34923 | 5991460.800919999 | 2097279.0781900003 | 37.738237772244396 | -122.47205451591199 | (37.7382377722444, -122.472054515912) | |
| 57345 | 57345 | 31240 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2522 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34924 | 5991117.01739 | 2098221.31702 | 37.740805019224204 | -122.47331184006599 | (37.7408050192242, -122.473311840066) | |
| 176285 | 176285 | 31243 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2526 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34926 | 5991119.14799 | 2098201.16942 | 37.740749822448294 | -122.47330300423401 | (37.7407498224483, -122.473303004234) | |
| 83339 | 83339 | 31245 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097800.52101 | 37.739632092076 | -122.47432756819299 | (37.739632092076, -122.474327568193) | ||
| 85443 | 85443 | 31246 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098068.1280099996 | 37.7403663457385 | -122.474378513531 | (37.7403663457385, -122.474378513531) | ||
| 88180 | 88180 | 31247 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990804.27301 | 2098092.3640099997 | 37.7404328330574 | -122.47438377383499 | (37.7404328330574, -122.474383773835) | ||
| 89371 | 89371 | 31248 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990803.26301 | 2098117.61001 | 37.740502093576005 | -122.474389107834 | (37.740502093576, -122.474389107834) | ||
| 115780 | 115780 | 31249 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990802.25301 | 2098150.9350099997 | 37.74059353695289 | -122.474395031258 | (37.7405935369529, -122.474395031258) | ||
| 128920 | 128920 | 31250 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990801.243009999 | 2098168.10201 | 37.7406406146101 | -122.474399775861 | (37.7406406146101, -122.474399775861) | ||
| 95229 | 95229 | 31251 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990805.283009999 | 2098048.9410099997 | 37.740313663161395 | -122.47437711373101 | (37.7403136631614, -122.474377113731) | ||
| 93590 | 93590 | 31252 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097887.3670099997 | 37.7398703149271 | -122.47434786892599 | (37.7398703149271, -122.474347868926) | ||
| 109317 | 109317 | 31253 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991074.90901 | 2097829.80601 | 37.7397275918836 | -122.47342888420499 | (37.7397275918836, -122.473428884205) | ||
| 77579 | 77579 | 31254 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991075.91901 | 2097809.61001 | 37.7396721973209 | -122.47342391940201 | (37.7396721973209, -122.473423919402) | ||
| 104347 | 104347 | 31255 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991076.92901 | 2097788.40301 | 37.739614026809996 | -122.473418880884 | (37.73961402681, -122.473418880884) | ||
| 109275 | 109275 | 31256 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990815.38101 | 2097761.1370099997 | 37.739524012219796 | -122.474321202908 | (37.7395240122198, -122.474321202908) | ||
| 79052 | 79052 | 31257 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990814.37101 | 2097777.29501 | 37.739568319433104 | -122.47432587378599 | (37.7395683194331, -122.474325873786) | ||
| 98419 | 98419 | 31258 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990812.351009999 | 2097840.9150099996 | 37.739742886616796 | -122.474337499296 | (37.7397428866168, -122.474337499296) | ||
| 95327 | 95327 | 31259 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990811.34201 | 2097863.1310099997 | 37.7398038276004 | -122.474342608694 | (37.7398038276004, -122.474342608694) | ||
| 102756 | 102756 | 31260 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990807.30201 | 2098024.7050099997 | 37.740247234298 | -122.47436836476001 | (37.740247234298, -122.47436836476) | ||
| 112100 | 112100 | 31261 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097905.54401 | 37.7399202243074 | -122.474349195013 | (37.7399202243074, -122.474349195013) | ||
| 109096 | 109096 | 31262 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990810.33201 | 2097920.69201 | 37.7399618168302 | -122.474350300123 | (37.7399618168302, -122.474350300123) | ||
| 174171 | 174171 | 31263 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34928 | 5991077.35619 | 2098024.94282 | 37.7402635293324 | -122.473434652395 | (37.7402635293324, -122.473434652395) | |
| 115267 | 115267 | 31264 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990809.32201 | 2097939.87901 | 37.740014440896104 | -122.47435519202601 | (37.7400144408961, -122.474355192026) | ||
| 144186 | 144186 | 31265 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990808.3120099995 | 2097955.0260099997 | 37.740055972157705 | -122.474359789198 | (37.7400559721577, -122.474359789198) | ||
| 140936 | 140936 | 31266 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990808.3120099995 | 2097974.21301 | 37.740108654737206 | -122.47436118898099 | (37.7401086547372, -122.474361188981) | ||
| 92475 | 92475 | 31267 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5990813.36101 | 2097821.7280099997 | 37.739690262547796 | -122.47433260742399 | (37.7396902625478, -122.474332607424) | ||
| 50096 | 50096 | 31268 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991067.840009999 | 2098080.24601 | 37.7404148266578 | -122.47347158803001 | (37.7404148266578, -122.47347158803) | ||
| 59792 | 59792 | 31269 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34928 | 5991078.20537 | 2097980.39351 | 37.740141257507794 | -122.47342846774299 | (37.7401412575078, -122.473428467743) | |
| 90204 | 90204 | 31270 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991068.85001 | 2098107.5120099997 | 37.7404897505974 | -122.473470084178 | (37.7404897505974, -122.473470084178) | ||
| 55695 | 55695 | 31271 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34928 | 5991077.63514 | 2098038.16928 | 37.740299861958206 | -122.47343465238998 | (37.7402998619582, -122.47343465239) | |
| 174030 | 174030 | 31272 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991082.4572 | 2097854.85146 | 37.7397967973808 | -122.473404612326 | (37.7397967973808, -122.473404612326) | |
| 27869 | 27869 | 31273 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991084.11448 | 2097836.49496 | 37.7397464910963 | -122.473397543673 | (37.7397464910963, -122.473397543673) | |
| 90597 | 90597 | 31274 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991074.90901 | 2097865.1510099997 | 37.739824640211 | -122.473431461565 | (37.739824640211, -122.473431461565) | ||
| 27935 | 27935 | 31275 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991083.96236 | 2097817.15833 | 37.739693388847606 | -122.47339665963001 | (37.7396933888476, -122.47339665963) | |
| 83518 | 83518 | 31276 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991076.92901 | 2097878.2790099997 | 37.7398608033144 | -122.473425434618 | (37.7398608033144, -122.473425434618) | ||
| 25960 | 25960 | 31277 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34928 | 5991087.0554599995 | 2097794.191 | 37.739630505545705 | -122.47338429037902 | (37.7396305055457, -122.473384290379) | |
| 147454 | 147454 | 31278 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34928 | 5991081.40761 | 2097877.77569 | 37.739859680672204 | -122.47340991294901 | (37.7398596806722, -122.473409912949) | |
| 81182 | 81182 | 31279 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991074.90901 | 2097846.97401 | 37.739774730819605 | -122.473430136096 | (37.7397747308196, -122.473430136096) | ||
| 120170 | 120170 | 31280 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2555 17th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34928 | 5991068.85001 | 2098095.39401 | 37.740456477673796 | -122.473469200507 | (37.7404564776738, -122.473469200507) | ||
| 113938 | 113938 | 31281 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2558 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/2003 12:00:00 AM | Permit Number 34929 | 5991128.30074427 | 2097998.4698012 | 37.7401937911776 | -122.473256578017 | (37.7401937911776, -122.473256578017) | ||
| 18542 | 18542 | 31283 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2574 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/30/2016 12:00:00 AM | 3 | Permit Number 778680 | 5991125.83447 | 2097900.24985 | 37.7399239615173 | -122.47325794369199 | (37.7399239615173, -122.473257943692) | |
| 69685 | 69685 | 31286 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2591 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 4 | Permit Number 34934 | 5990775.57693 | 2097788.90474 | 37.7395979491861 | -122.47446085258001 | (37.7395979491861, -122.47446085258) | |
| 29420 | 29420 | 31287 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34935 | 5990781.283369999 | 2097640.71217 | 37.7391913809888 | -122.474430310711 | (37.7391913809888, -122.474430310711) | |
| 129199 | 129199 | 31288 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34935 | 5990776.38908487 | 2097684.22291122 | 37.7393105667717 | -122.474450407194 | (37.7393105667717, -122.474450407194) | ||
| 96997 | 96997 | 31289 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34935 | 5990776.38908487 | 2097684.22291122 | 37.7393105667717 | -122.474450407194 | (37.7393105667717, -122.474450407194) | ||
| 140421 | 140421 | 31290 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34935 | 5990776.38908487 | 2097684.22291122 | 37.7393105667717 | -122.474450407194 | (37.7393105667717, -122.474450407194) | ||
| 103476 | 103476 | 31291 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2601 18th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | Permit Number 34935 | 5990776.38908487 | 2097684.22291122 | 37.7393105667717 | -122.474450407194 | (37.7393105667717, -122.474450407194) | ||
| 168831 | 168831 | 31292 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2607 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34936 | 5990782.2972800005 | 2097618.99301 | 37.7391318044827 | -122.47442522055401 | (37.7391318044827, -122.474425220554) | |
| 59992 | 59992 | 31294 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2634 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 5 | Permit Number 34938 | 5990833.43787 | 2097461.0446 | 37.738701081392705 | -122.474236879142 | (37.7387010813927, -122.474236879142) | |
| 59079 | 59079 | 31295 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2670 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/04/1995 12:00:00 AM | 3 | Permit Number 34939 | 5990841.428590001 | 2097225.71709 | 37.7380553951316 | -122.474192084818 | (37.7380553951316, -122.474192084818) | |
| 68029 | 68029 | 31353 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2363 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 8 | Permit Number 34963 | 5992611.652290001 | 2099388.8635 | 37.7440972384981 | -122.46822891325701 | (37.7440972384981, -122.468228913257) | |
| 134105 | 134105 | 31359 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2439 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 6 | Permit Number 34967 | 5991359.58224 | 2098806.0443 | 37.7424245732342 | -122.472515769209 | (37.7424245732342, -122.472515769209) | |
| 186415 | 186415 | 31371 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 537 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | 4 | Permit Number 34973 | 5991501.22289 | 2099052.17268 | 37.7431085759965 | -122.472043958778 | (37.7431085759965, -122.472043958778) | |
| 147466 | 147466 | 31413 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4015 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35001 | 6001977.40654 | 2103508.81115 | 37.755946109541995 | -122.436139035098 | (37.755946109542, -122.436139035098) | |
| 63136 | 63136 | 31414 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4015 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35001 | 6001997.26666 | 2103510.7551700003 | 37.7559525756639 | -122.436070491479 | (37.7559525756639, -122.436070491479) | |
| 181930 | 181930 | 31415 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4031 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35002 | 6001952.947240001 | 2103509.31726 | 37.7559461095403 | -122.43622365949 | (37.7559461095403, -122.43622365949) | |
| 51486 | 51486 | 31439 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 4260 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35014 | 6000763.54302 | 2102896.12937 | 37.7541947949643 | -122.440293027915 | (37.7541947949643, -122.440293027915) | |
| 55971 | 55971 | 31448 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 243 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 7 | Permit Number 35022 | 6002087.85452 | 2104429.9690900003 | 37.758481661717504 | -122.435822975573 | (37.7584816617175, -122.435822975573) | |
| 60098 | 60098 | 31449 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 243 Collingwood St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 8 | Permit Number 35022 | 6002088.98075 | 2104442.1365099996 | 37.7585151344893 | -122.435819951133 | (37.7585151344893, -122.435819951133) | |
| 177082 | 177082 | 31453 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35026 | 6001228.2731 | 2102757.74093 | 37.7538412624867 | -122.438675964135 | (37.7538412624867, -122.438675964135) | |
| 181645 | 181645 | 31456 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35026 | 6001232.81474 | 2102673.98616 | 37.7536115504365 | -122.43865425719801 | (37.7536115504365, -122.438654257198) | |
| 28667 | 28667 | 31457 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 4 | Permit Number 35026 | 6001233.81138 | 2102648.72464 | 37.7535422450846 | -122.43864900065701 | (37.7535422450846, -122.438649000657) | |
| 37332 | 37332 | 31458 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 2 | Permit Number 35026 | 6001236.64987 | 2102602.74693 | 37.7534161628409 | -122.438635890359 | (37.7534161628409, -122.438635890359) | |
| 158055 | 158055 | 31460 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 625 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 3 | Permit Number 35026 | 6001239.440780001 | 2102584.49605 | 37.7533662090858 | -122.438624931196 | (37.7533662090858, -122.438624931196) | |
| 83302 | 83302 | 31461 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 630 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | Permit Number 35027 | 6001185.04751596 | 2102718.99331881 | 37.7537324117625 | -122.438822671411 | (37.7537324117625, -122.438822671411) | ||
| 49410 | 49410 | 31464 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 419 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1999 12:00:00 AM | 8 | Permit Number 35030 | 6003624.46293 | 2102130.90923 | 37.7522561543076 | -122.430344668985 | (37.7522561543076, -122.430344668985) | |
| 57167 | 57167 | 31509 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 2426 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35069 | 6011274.30435 | 2102324.32413 | 37.753217577243205 | -122.40390377703599 | (37.7532175772432, -122.403903777036) | |
| 88178 | 88178 | 31515 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1221 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35073 | 6011656.39484291 | 2091519.89430614 | 37.723572242368896 | -122.401823009869 | (37.7235722423689, -122.401823009869) | ||
| 111302 | 111302 | 31521 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1319 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35077 | 6011660.44790907 | 2091506.61050899 | 37.7235359939753 | -122.401808065753 | (37.7235359939753, -122.401808065753) | ||
| 139505 | 139505 | 31522 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1319 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35077 | 6011660.44790907 | 2091506.61050899 | 37.7235359939753 | -122.401808065753 | (37.7235359939753, -122.401808065753) | ||
| 25526 | 25526 | 31523 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1320 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 9 | Permit Number 35078 | 6011116.30671 | 2102174.6826400002 | 37.752797866337794 | -122.404439635397 | (37.7527978663378, -122.404439635397) | |
| 107416 | 107416 | 31526 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1331 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35081 | 6011660.94420422 | 2091504.98391721 | 37.7235315553844 | -122.401806235857 | (37.7235315553844, -122.401806235857) | ||
| 160070 | 160070 | 31527 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1364 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35082 | 6011127.62197 | 2102002.7195099997 | 37.752326325712 | -122.40438840191099 | (37.752326325712, -122.404388401911) | |
| 176369 | 176369 | 31528 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1366 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35083 | 6011129.790030001 | 2101978.90007 | 37.7522610439178 | -122.40437922793899 | (37.7522610439178, -122.404379227939) | |
| 113784 | 113784 | 31529 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1372 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35084 | 6011133.311735599 | 2101955.20274251 | 37.7521961730604 | -122.40436538143601 | (37.7521961730604, -122.404365381436) | ||
| 77567 | 77567 | 31547 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 230 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | Permit Number 45060 | 5998353.30570755 | 2112667.00543316 | 37.7808856171306 | -122.449332118202 | (37.7808856171306, -122.449332118202) | ||
| 131977 | 131977 | 31558 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 172 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 8 | Permit Number 35103 | 5998551.5701 | 2112529.1677 | 37.7805184894256 | -122.448636297075 | (37.7805184894256, -122.448636297075) | |
| 138291 | 138291 | 31561 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 178 Ewing Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35104 | 5998523.78697564 | 2112531.01963796 | 37.7805219856792 | -122.448732545056 | (37.7805219856792, -122.448732545056) | ||
| 49041 | 49041 | 31563 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 196 Ewing Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/04/1996 12:00:00 AM | 8 | Permit Number 35105 | 5998443.6135 | 2112525.1066 | 37.7805011651196 | -122.44900947575199 | (37.7805011651196, -122.449009475752) | |
| 35867 | 35867 | 31577 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 1723 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 5 | Permit Number 35116 | 5989021.1478 | 2103586.321 | 37.7554143192924 | -122.48095119881799 | (37.7554143192924, -122.480951198818) |
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");