Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
180856 | 180856 | 72281 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 730 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 8 | 5982929.242880001 | 2110803.7534 | 37.7748753302021 | -122.502552686167 | (37.7748753302021, -122.502552686167) | ||
159217 | 159217 | 47193 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 383 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45152 | 5987133.5813 | 2113398.4948 | 37.7822459140534 | -122.488199902231 | (37.7822459140534, -122.488199902231) | |
188081 | 188081 | 47192 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 383 28th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45152 | 5987134.96931 | 2113380.92602 | 37.782197756171705 | -122.488193808962 | (37.7821977561717, -122.488193808962) | |
159263 | 159263 | 120760 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2000 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5989219.70066 | 2114726.96958 | 37.7860150171 | -122.481080247842 | (37.7860150171, -122.481080247842) | |||
161848 | 161848 | 70149 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 754 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1993 12:00:00 AM | 8 | 5989468.1167 | 2110177.57013 | 37.773538072981204 | -122.479887770247 | (37.7735380729812, -122.479887770247) | ||
134180 | 134180 | 219427 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5991170.38541 | 2105691.7804 | 37.7613200515933 | -122.47367213637101 | (37.7613200515933, -122.473672136371) | |||
23782 | 23782 | 219426 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1426 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991173.89859 | 2105672.02771 | 37.7612660194265 | -122.473658544928 | (37.7612660194265, -122.473658544928) | |||
59288 | 59288 | 219438 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2551 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991712.62848 | 2098073.6420400003 | 37.74043401203279 | -122.471241703239 | (37.7404340120328, -122.471241703239) | |||
172853 | 172853 | 123882 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 12th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992074.12323 | 2114872.38939 | 37.7865798197895 | -122.47121541022601 | (37.7865798197895, -122.471215410226) | |||
183248 | 183248 | 136920 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 207 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5996591.90102 | 2115549.28793 | 37.788698686447894 | -122.45563404108499 | (37.7886986864479, -122.455634041085) | |||
116305 | 116305 | 26040 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2015 12:00:00 AM | 8 | 3x3 | 5996258.07972 | 2088089.3008299998 | 37.7132812744111 | -122.45480421322901 | (37.7132812744111, -122.454804213229) | ||
167045 | 167045 | 219446 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 762 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5997041.47466 | 2095025.35 | 37.7323709396524 | -122.45259680479201 | (37.7323709396524, -122.452596804792) | ||||
130711 | 130711 | 75004 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1996 12:00:00 AM | 8 | 5997965.54363 | 2116098.57851 | 37.7902856238171 | -122.450921084564 | (37.7902856238171, -122.450921084564) | ||
154342 | 154342 | 136919 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Laurel St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5997971.7056 | 2116051.1115099997 | 37.790155644821 | -122.450896340588 | (37.790155644821, -122.450896340588) | |||
118573 | 118573 | 120668 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1154 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5998951.0 | 2105925.0 | 37.76240795737721 | -122.44677915122601 | (37.7624079573772, -122.446779151226) | |||
71395 | 71395 | 136927 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3835 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000575.8794 | 2121488.3697200003 | 37.8052336530829 | -122.44227662028 | (37.8052336530829, -122.44227662028) | |||
163030 | 163030 | 136929 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000583.85394 | 2121442.09911 | 37.8051070609006 | -122.442245699797 | (37.8051070609006, -122.442245699797) | |||
38435 | 38435 | 136931 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3825 Scott St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6000586.31642 | 2121417.2428200003 | 37.805038952541295 | -122.442235392672 | (37.8050389525413, -122.442235392672) | |||
65789 | 65789 | 219445 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 332 Congo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000112.34279 | 2094905.0087400002 | 37.73221598377361 | -122.441971496493 | (37.7322159837736, -122.441971496493) | |||
58932 | 58932 | 40193 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3430 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/1999 12:00:00 AM | 8 | Permit Number 41376 | 6000802.81629 | 2120169.1836 | 37.801624451566894 | -122.441396561715 | (37.8016244515669, -122.441396561715) | ||
167505 | 167505 | 62133 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 221 San Juan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/1993 12:00:00 AM | 8 | Permit Number 31836 | 6001106.23705 | 2092334.34097 | 37.7252141069394 | -122.43835128458599 | (37.7252141069394, -122.438351284586) | |
56808 | 56808 | 47721 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001839.98608 | 2118371.66878 | 37.7967479784971 | -122.437678679828 | (37.7967479784971, -122.437678679828) | |
57296 | 57296 | 47722 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/2002 12:00:00 AM | 8 | Permit Number 45805 | 6001852.4852599995 | 2118373.09609 | 37.796752608195796 | -122.437635532153 | (37.7967526081958, -122.437635532153) | |
65259 | 65259 | 136914 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2325 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001866.38234 | 2118375.10794 | 37.7967589223518 | -122.437587589309 | (37.7967589223518, -122.437587589309) | |||
136729 | 136729 | 136918 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 Alhambra St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001921.35919 | 2120601.2758299997 | 37.8028745199931 | -122.437556861278 | (37.8028745199931, -122.437556861278) | |||
171114 | 171114 | 136915 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2301 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001927.36855 | 2118383.65644 | 37.796785861541096 | -122.43737717584101 | (37.7967858615411, -122.437377175841) | |||
38608 | 38608 | 180407 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 314 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6002242.22225 | 2094108.3589599999 | 37.7301497068323 | -122.434551091376 | (37.7301497068323, -122.434551091376) | |||
132171 | 132171 | 242912 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1154 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004415.185819999 | 2102148.8561 | 37.7523501901347 | -122.427611502469 | (37.7523501901347, -122.427611502469) | |||
163047 | 163047 | 44470 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 128 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | Permit Number 43784 | 6005782.65957 | 2093100.8203 | 37.727583573204896 | -122.422239770059 | (37.7275835732049, -122.422239770059) | |
27967 | 27967 | 44472 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 236 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | Permit Number 43786 | 6006212.75467 | 2092719.23658 | 37.726560078178395 | -122.420725846847 | (37.7265600781784, -122.420725846847) | |
12240 | 12240 | 44475 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 275 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 8 | 3x3 | Permit Number 43789 | 6006290.74635 | 2092615.37122 | 37.726279281939895 | -122.42044886282301 | (37.7262792819399, -122.420448862823) |
181702 | 181702 | 70405 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 225 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006525.54367 | 2092869.6574799998 | 37.726990725739 | -122.41965521291999 | (37.726990725739, -122.41965521292) | ||
45366 | 45366 | 70407 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 231 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1994 12:00:00 AM | 8 | 6006535.83698 | 2092862.23217 | 37.7269709172726 | -122.419619102459 | (37.7269709172726, -122.419619102459) | ||
169678 | 169678 | 198407 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 42 Washburn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008385.72143 | 2110427.77402 | 37.7753059744256 | -122.414466467358 | (37.7753059744256, -122.414466467358) | |||
31207 | 31207 | 198409 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 50 Washburn St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008437.7646 | 2110373.29523 | 37.7751593120891 | -122.41428258206801 | (37.7751593120891, -122.414282582068) | |||
20785 | 20785 | 856 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2001 12:00:00 AM | 8 | 3x3 | 6008178.91279 | 2095102.6011299998 | 37.7332149048351 | -122.414097431452 | (37.7332149048351, -122.414097431452) | ||
60291 | 60291 | 180468 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008161.02959 | 2092664.87988 | 37.7265204423377 | -122.413986868806 | (37.7265204423377, -122.413986868806) | |||
58632 | 58632 | 180467 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008177.51533 | 2092609.86875 | 37.72637031941721 | -122.413925988288 | (37.7263703194172, -122.413925988288) | |||
33652 | 33652 | 180465 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008194.47669 | 2092552.7848 | 37.7262145316512 | -122.413863317257 | (37.7262145316512, -122.413863317257) | |||
44658 | 44658 | 180462 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008228.9593 | 2092440.66794 | 37.725908619167704 | -122.413736185485 | (37.7259086191677, -122.413736185485) | |||
182709 | 182709 | 180445 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008486.19305 | 2091610.48343 | 37.723643550705 | -122.412788276664 | (37.723643550705, -122.412788276664) | |||
187668 | 187668 | 180443 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 599 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008502.54989 | 2091553.3243 | 37.7234875219066 | -122.412727694727 | (37.7234875219066, -122.412727694727) | |||
97843 | 97843 | 29758 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 699X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6009685.79902 | 2119118.10904 | 37.7992404975665 | -122.41058299614099 | (37.7992404975665, -122.410582996141) | |||
38853 | 38853 | 70336 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 324 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009735.9866 | 2094035.87413 | 37.7303732333298 | -122.408638954927 | (37.7303732333298, -122.408638954927) | ||
173810 | 173810 | 75766 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 100 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | 8 | 6009894.26848 | 2094011.0737400001 | 37.730314000377 | -122.408090001562 | (37.730314000377, -122.408090001562) | ||
156961 | 156961 | 32340 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Burrows St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 8 | Permit Number 36902 | 6010864.0771699995 | 2093419.2397900003 | 37.7287432013131 | -122.40469557435 | (37.7287432013131, -122.40469557435) | ||
185844 | 185844 | 68890 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 35 Exeter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 8 | Permit Number 32862 | 6012596.9510699995 | 2091063.5496200002 | 37.7223716575091 | -122.398539644797 | (37.7223716575091, -122.398539644797) | |
134417 | 134417 | 198415 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3310 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6013330.68803 | 2089861.99882 | 37.7191132896144 | -122.39591911208299 | (37.7191132896144, -122.395919112083) | |||
176376 | 176376 | 70562 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 164 South Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/23/1994 12:00:00 AM | 8 | 6014127.69322 | 2112419.53716 | 37.7810958034577 | -122.39474303089199 | (37.7810958034577, -122.394743030892) |
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");