Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 267 | 267 | 175151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000727.04119 | 2093604.3094 | 37.728679573387495 | -122.43975313162399 | (37.7286795733875, -122.439753131624) | |
| 271 | 271 | 175152 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 285 Santa Rosa Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779495 | 6000750.8705 | 2093589.3929700002 | 37.728639972642604 | -122.43966968351002 | (37.7286399726426, -122.43966968351) | |
| 1054 | 1054 | 125462 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 52121 | 6009895.29665 | 2113891.24599 | 37.7849005400769 | -122.40948896803499 | (37.7849005400769, -122.409488968035) | |
| 1099 | 1099 | 250070 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 399 Austin St | 1 | : 4 | Tree 1 | DPW 2 | 2 | Width 3ft | 6005393.47416 | 2115303.0126799997 | 37.788523627097 | -122.425164323999 | (37.788523627097, -122.425164323999) | |||
| 1850 | 1850 | 251747 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 706 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002959.0 | 2087321.0 | 37.7115537887528 | -122.431588720074 | (37.7115537887528, -122.431588720074) | ||||
| 2582 | 2582 | 253132 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 522 Avalon Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 3ft | 6004047.94044 | 2092448.5749599999 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | ||||
| 5093 | 5093 | 18924 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2675 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2013 12:00:00 AM | 3 | 4x4 | Permit Number 770153 | 6002021.65815 | 2115693.95851 | 37.7894060077371 | -122.43685826610701 | (37.7894060077371, -122.436858266107) | |
| 7088 | 7088 | 107943 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 44x MacOndray Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6008438.53642 | 2119159.8208 | 37.7992850226339 | -122.41490192268 | (37.7992850226339, -122.41490192268) | |||
| 7189 | 7189 | 111999 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2414 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2015 12:00:00 AM | 24 | 4x4 | Permit Number 776155 | 6003178.791259999 | 2117077.11494 | 37.793269498846705 | -122.432953577047 | (37.7932694988467, -122.432953577047) | |
| 7458 | 7458 | 18926 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 2689 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001985.03027 | 2115691.49541 | 37.7893971628975 | -122.43698481780599 | (37.7893971628975, -122.436984817806) | |||
| 8590 | 8590 | 102757 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6002051.958459999 | 2117801.7316900003 | 37.795195129895895 | -122.436904386043 | (37.7951951298959, -122.436904386043) | |||
| 8942 | 8942 | 19287 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2810X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001358.59585 | 2115648.89401 | 37.7892445650455 | -122.439149150528 | (37.7892445650455, -122.439149150528) | |||
| 10269 | 10269 | 91500 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 125 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 52121 | 6009901.41754 | 2113830.53604 | 37.784734187987 | -122.40946350553999 | (37.784734187987, -122.40946350554) | |
| 11199 | 11199 | 79973 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 983 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | Permit Number 773711 | 6000743.92966 | 2091299.8612400002 | 37.722353046939 | -122.439529617696 | (37.722353046939, -122.439529617696) | |
| 11423 | 11423 | 110030 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 327 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774319 | 6003526.63098 | 2091782.5181900002 | 37.7238362969822 | -122.429944883475 | (37.7238362969822, -122.429944883475) |
| 12679 | 12679 | 17228 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1880X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6000994.2729400005 | 2091122.49333 | 37.721880279621 | -122.43865153853201 | (37.721880279621, -122.438651538532) | |||
| 14649 | 14649 | 67492 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1119 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/28/2015 12:00:00 AM | 3 | Permit Number 774343 | 6011679.29477 | 2103189.50582 | 37.7556157939465 | -122.40256406509701 | (37.7556157939465, -122.402564065097) | |
| 17640 | 17640 | 4490 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1602 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2002 12:00:00 AM | 3 | 3X3 | 6004561.8284 | 2099527.9975 | 37.7451622129677 | -122.426917747467 | (37.7451622129677, -122.426917747467) | ||
| 18805 | 18805 | 27714 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6001610.45471 | 2097108.7336400002 | 37.7383521588292 | -122.436949905209 | (37.7383521588292, -122.436949905209) | |||
| 19541 | 19541 | 31130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 127 Foerster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 2 | 3x3 | Permit Number 34845 | 5998083.60465 | 2093967.1558599998 | 37.729525044927705 | -122.448917737661 | (37.7295250449277, -122.448917737661) |
| 20258 | 20258 | 50073 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 2622 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46804 | 5991453.86395603 | 2097563.96514649 | 37.739019597898505 | -122.472099259809 | (37.7390195978985, -122.472099259809) | ||
| 22388 | 22388 | 7124 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005782.02097 | 2115033.60586 | 37.787805844908796 | -122.42380084655301 | (37.7878058449088, -122.423800846553) | ||
| 22516 | 22516 | 7126 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005719.585390001 | 2115024.0954299998 | 37.7877762068484 | -122.42401618562201 | (37.7877762068484, -122.424016185622) | ||
| 22560 | 22560 | 7122 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 3x3 | 6005816.457909999 | 2115038.11546 | 37.787820171109 | -122.423682021812 | (37.787820171109, -122.423682021812) | ||
| 22574 | 22574 | 7125 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 6 | 3X3 | 6005738.176580001 | 2115026.96294 | 37.7877851299198 | -122.42395206753099 | (37.7877851299198, -122.423952067531) | ||
| 22588 | 22588 | 7129 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 4 | 3X3 | 6005508.68317 | 2114972.6560299997 | 37.787623057713496 | -122.424742207381 | (37.7876230577135, -122.424742207381) | ||
| 22606 | 22606 | 7130 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 5 | 3X3 | 6005539.58789 | 2114975.93468 | 37.7876338054953 | -122.42463551632 | (37.7876338054953, -122.42463551632) | ||
| 22608 | 22608 | 9889 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005347.08674 | 2115527.81747 | 37.78913826426621 | -122.425340821331 | (37.7891382642662, -122.425340821331) | |||
| 22656 | 22656 | 17785 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1798X Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6005398.04469 | 2115519.90556 | 37.7891194189645 | -122.42516394985701 | (37.7891194189645, -122.425163949857) | |||
| 22660 | 22660 | 28058 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 7 | 3X3 | 6005467.0390099995 | 2114965.36006 | 37.7876006726807 | -122.424885768876 | (37.7876006726807, -122.424885768876) | ||
| 22690 | 22690 | 28059 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2003 12:00:00 AM | 3 | 3X3 | 6005443.48959 | 2114960.28563 | 37.7875854093804 | -122.42496688413 | (37.7875854093804, -122.42496688413) | ||
| 22706 | 22706 | 7127 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1990 12:00:00 AM | 6 | 3x3 | 6005701.71486 | 2115022.2576200003 | 37.7877701517306 | -122.424077883603 | (37.7877701517306, -122.424077883603) | ||
| 22731 | 22731 | 7128 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 399X Fern St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 12 | 3X3 | 6005491.12747 | 2114969.49683 | 37.787613391789705 | -122.424802721882 | (37.7876133917897, -122.424802721882) | ||
| 22801 | 22801 | 7123 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 300X Fern St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 9 | 3x3 | 6005797.9204 | 2115035.94869 | 37.7878131752727 | -122.42374600408701 | (37.7878131752727, -122.423746004087) | ||
| 22809 | 22809 | 125505 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6007613.99229 | 2119386.63886 | 37.799861442220895 | -122.41777122496 | (37.7998614422209, -122.41777122496) | ||||
| 23721 | 23721 | 220632 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6002213.33941 | 2100174.25358 | 37.746803608795396 | -122.43508461868299 | (37.7468036087954, -122.435084618683) | |||
| 24123 | 24123 | 175160 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000093.42571 | 2092311.2225 | 37.7250929691415 | -122.44185080298 | (37.7250929691415, -122.44185080298) | |||
| 24159 | 24159 | 33290 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 8 | Permit Number 37451 | 6009219.4283 | 2116994.47406 | 37.7933833601996 | -122.41204664625499 | (37.7933833601996, -122.412046646255) | |
| 24227 | 24227 | 203475 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991280.398630001 | 2099387.14513 | 37.7440155431828 | -122.472831922275 | (37.7440155431828, -122.472831922275) | |||
| 24295 | 24295 | 249534 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 201 Myrtle St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6006252.357009999 | 2114034.72493 | 37.785089704362704 | -122.422102579373 | (37.7850897043627, -122.422102579373) | |||
| 24395 | 24395 | 92752 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 3356 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52980 | 5999300.27951 | 2120375.08626 | 37.8021040941904 | -122.446610827352 | (37.8021040941904, -122.446610827352) | |
| 24476 | 24476 | 189185 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6013378.5695400005 | 2110827.99397 | 37.7766841099114 | -122.397223005848 | (37.7766841099114, -122.397223005848) | |||
| 24633 | 24633 | 220637 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 79 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003700.73164 | 2096802.6587900002 | 37.7376303323698 | -122.429700927958 | (37.7376303323698, -122.429700927958) | |||
| 25088 | 25088 | 189157 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6012230.29612 | 2112453.73281 | 37.78108402055079 | -122.40130951984501 | (37.7810840205508, -122.401309519845) | |||
| 25297 | 25297 | 203469 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 300 Flood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 5998711.4385400005 | 2094111.50955 | 37.7299572914866 | -122.446757644361 | (37.7299572914866, -122.446757644361) | ||||
| 25528 | 25528 | 33293 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 166 Sproule Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 10 | Permit Number 37451 | 6009221.08576 | 2116982.79677 | 37.7933513902069 | -122.412040085683 | (37.7933513902069, -122.412040085683) | |
| 26278 | 26278 | 249950 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 303 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | Width 0ft | 6011359.33086 | 2120056.95578 | 37.801912024192795 | -122.404858102512 | (37.8019120241928, -122.404858102512) | |||
| 26400 | 26400 | 203471 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 410 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5994790.95036 | 2091337.27547 | 37.7221151744519 | -122.460110243003 | (37.7221151744519, -122.460110243003) | |||
| 26515 | 26515 | 220605 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 51 Arnold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6006588.43416 | 2095556.2784900002 | 37.7343711416034 | -122.419628336682 | (37.7343711416034, -122.419628336682) | |||
| 26824 | 26824 | 125535 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 11 Miller Pl | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010079.40223 | 2116881.04203 | 37.7931201160419 | -122.409063053629 | (37.7931201160419, -122.409063053629) | |||
| 27160 | 27160 | 203449 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1474 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5992141.42239 | 2105406.9692 | 37.7605942249661 | -122.47029301742901 | (37.7605942249661, -122.470293017429) | |||
| 27258 | 27258 | 220664 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1192 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003819.11819 | 2101351.9934400003 | 37.7501284581809 | -122.429615973494 | (37.7501284581809, -122.429615973494) | |||
| 27386 | 27386 | 220596 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007814.59662 | 2105186.38117 | 37.7608822364448 | -122.416070852512 | (37.7608822364448, -122.416070852512) | |||
| 27524 | 27524 | 189155 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012260.87565 | 2112478.52323 | 37.7811537953404 | -122.40120547186899 | (37.7811537953404, -122.401205471869) | |||
| 27556 | 27556 | 220598 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Sycamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006787.43083 | 2105854.6831099996 | 37.7626594317184 | -122.41967079188801 | (37.7626594317184, -122.419670791888) | |||
| 28260 | 28260 | 92446 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1554 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52837 | 5981923.4 | 2104509.6 | 37.7575342433798 | -122.505565385243 | (37.7575342433798, -122.505565385243) |
| 28352 | 28352 | 125438 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 250 Euclid Ave | 0 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5998091.24108 | 2114006.2469099998 | 37.78454782955 | -122.45033529224199 | (37.78454782955, -122.450335292242) | ||||
| 28571 | 28571 | 203474 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 663 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991409.42461 | 2097303.39162 | 37.7383015575699 | -122.472233919881 | (37.7383015575699, -122.472233919881) | |||
| 29119 | 29119 | 220589 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002332.20411 | 2099716.00641 | 37.7455521185496 | -122.43464083471301 | (37.7455521185496, -122.434640834713) | |||
| 30036 | 30036 | 92979 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 147 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2010 12:00:00 AM | 5 | Permit Number 53131 | 6009891.19153 | 2113906.4761 | 37.78494212831 | -122.40950424575001 | (37.78494212831, -122.40950424575) | ||
| 30635 | 30635 | 125520 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008570.50339 | 2119026.46396 | 37.798926272277704 | -122.414435828363 | (37.7989262722777, -122.414435828363) | |||
| 30666 | 30666 | 189167 | DPW Maintained 3 | Afrocarpus gracilior :: Fern Pine 70 | 1300x De Haro St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012264.80612 | 2102152.7525400002 | 37.7528017667079 | -122.40046634965 | (37.7528017667079, -122.40046634965) | ||||
| 30740 | 30740 | 221771 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 155 Conrad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6001803.9521 | 2096539.96195 | 37.7368014398277 | -122.436240194438 | (37.7368014398277, -122.436240194438) | |||
| 30833 | 30833 | 220633 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 6002213.10405 | 2100169.21088 | 37.7467897493647 | -122.435085071929 | (37.7467897493647, -122.435085071929) | |||
| 31097 | 31097 | 123452 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 735 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995332.97895 | 2110593.9249 | 37.7750202604257 | -122.459630642924 | (37.7750202604257, -122.459630642924) | |||
| 31567 | 31567 | 203453 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2658 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991457.8354 | 2097316.5348 | 37.738340446961104 | -122.47206749851001 | (37.7383404469611, -122.47206749851) | |||
| 31581 | 31581 | 70151 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 846 Geary St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/1993 12:00:00 AM | 7 | 6007647.41454 | 2114440.4952 | 37.786282435643 | -122.41730487074699 | (37.786282435643, -122.417304870747) | ||
| 31786 | 31786 | 221763 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 3816 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002948.3546400005 | 2103602.92928 | 37.7562596509731 | -122.432787903054 | (37.7562596509731, -122.432787903054) | |||
| 31793 | 31793 | 221773 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5587 Diamond Heights Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6001626.70915 | 2097120.97663 | 37.7383866990834 | -122.436894581628 | (37.7383866990834, -122.436894581628) | |||
| 31906 | 31906 | 220602 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 345 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003653.16044 | 2099206.97915 | 37.744229349819896 | -122.43003686791401 | (37.7442293498199, -122.430036867914) | |||
| 32542 | 32542 | 221762 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 4407 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001705.956180001 | 2104074.38405 | 37.7574836102927 | -122.43711828977399 | (37.7574836102927, -122.437118289774) | |||
| 33240 | 33240 | 189153 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2 Shipley St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6012332.534469999 | 2112551.48713 | 37.781358134807796 | -122.400962694499 | (37.7813581348078, -122.400962694499) | |||
| 33358 | 33358 | 220588 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1285 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010337.44954 | 2101779.52105 | 37.7516692837277 | -122.40710522684499 | (37.7516692837277, -122.407105226845) | |||
| 33494 | 33494 | 175166 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004672.7463 | 2094000.25869 | 37.7299905627997 | -122.426140758388 | (37.7299905627997, -122.426140758388) | |||
| 33529 | 33529 | 175163 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 229 Delano Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6000100.60606 | 2092317.35748 | 37.7251102235329 | -122.44182642145701 | (37.7251102235329, -122.441826421457) | |||
| 33827 | 33827 | 203454 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 5 Madrone Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993011.06637 | 2099068.7919400004 | 37.743241463417796 | -122.466824576891 | (37.7432414634178, -122.466824576891) | |||
| 33829 | 33829 | 189162 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 109 Kissling St | 5 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6008137.74771 | 2109383.99653 | 37.7724260745213 | -122.41525036411998 | (37.7724260745213, -122.41525036412) | |||
| 33839 | 33839 | 220603 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 418 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6003167.3476 | 2099231.48151 | 37.744269101647795 | -122.43171845176501 | (37.7442691016478, -122.431718451765) | |||
| 33859 | 33859 | 220622 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000334.98133 | 2101342.05017 | 37.7499032598351 | -122.441663574927 | (37.7499032598351, -122.441663574927) | |||
| 34506 | 34506 | 125457 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2807 Steiner St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6002053.50035 | 2117793.13608 | 37.795171616221104 | -122.43689843522101 | (37.7951716162211, -122.436898435221) | |||
| 34843 | 34843 | 250128 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1798 Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005370.71997 | 2115516.69917 | 37.78910907136579 | -122.42525826176399 | (37.7891090713658, -122.425258261764) | |||
| 34959 | 34959 | 104356 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 1671 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2013 12:00:00 AM | 3 | Permit Number 770626 | 6004967.00865 | 2119154.82266 | 37.7990756208885 | -122.426914264396 | (37.7990756208885, -122.426914264396) | ||
| 35121 | 35121 | 125494 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1207 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6006034.74479 | 2120336.40198 | 37.8023802517163 | -122.423303571803 | (37.8023802517163, -122.423303571803) | |||
| 35158 | 35158 | 125513 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008593.294869999 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | |||
| 35258 | 35258 | 120266 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 100 24th Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 5988365.77159 | 2115120.59325 | 37.78704611790379 | -122.48406345051399 | (37.7870461179038, -122.484063450514) | ||||
| 35263 | 35263 | 249989 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 228 Filbert St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | Width 0ft | 6011581.894069999 | 2120103.40396 | 37.802051997370896 | -122.404091195777 | (37.8020519973709, -122.404091195777) | |||
| 35686 | 35686 | 125515 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008587.48018 | 2119026.85751 | 37.7989283065533 | -122.414377110727 | (37.7989283065533, -122.414377110727) | |||
| 35750 | 35750 | 250093 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1700 Gough St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6005332.30774 | 2115621.39854 | 37.789394379498894 | -122.425398617158 | (37.7893943794989, -122.425398617158) | |||
| 35891 | 35891 | 125523 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 220 Lombard St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 9ft | 6011207.16585 | 2120734.5295700002 | 37.8037639692824 | -122.40543241409401 | (37.8037639692824, -122.405432414094) | |||
| 36428 | 36428 | 203476 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 2357 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5991292.10233 | 2099373.67062 | 37.743979223173106 | -122.472790471621 | (37.7439792231731, -122.472790471621) | |||
| 36512 | 36512 | 175167 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 218 Congdon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004673.57343 | 2093985.3797 | 37.7299497551534 | -122.426136840057 | (37.7299497551534, -122.426136840057) | |||
| 36697 | 36697 | 220597 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 452 Shotwell St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007815.2262 | 2105168.52935 | 37.7608332548635 | -122.416067410784 | (37.7608332548635, -122.416067410784) | |||
| 36849 | 36849 | 220592 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1383 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007189.08287 | 2107465.79435 | 37.76710578333971 | -122.418395859874 | (37.7671057833397, -122.418395859874) | |||
| 37156 | 37156 | 189173 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1960 Quesada Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6013345.84088 | 2096070.7044 | 37.73616197508429 | -122.396301660307 | (37.7361619750843, -122.396301660307) | |||
| 37791 | 37791 | 220646 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 816 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008205.0189 | 2095636.66757 | 37.7346828016745 | -122.41404494431801 | (37.7346828016745, -122.414044944318) | |||
| 38661 | 38661 | 189188 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 40 Bluxome St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6013301.8737 | 2110750.05964 | 37.776465849843895 | -122.39748285416799 | (37.7764658498439, -122.397482854168) | |||
| 38814 | 38814 | 221775 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 21 Addison St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | |||
| 38916 | 38916 | 125482 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 1 Nob Hill Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 6009469.59091 | 2116291.78471 | 37.7914679787239 | -122.41113140348499 | (37.7914679787239, -122.411131403485) | |||
| 38930 | 38930 | 220655 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 580 Ogden Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008083.69599 | 2096082.2563599998 | 37.735899476465704 | -122.41449592016599 | (37.7358994764657, -122.414495920166) | |||
| 39363 | 39363 | 249821 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 281 Kearny St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | Width 0ft | 6010901.8759699995 | 2120623.17353 | 37.8034411387496 | -122.406481040676 | (37.8034411387496, -122.406481040676) |
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");