Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99253 | 99253 | 117318 | Permitted Site 1 | :: 54 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | |||||
| 99380 | 99380 | 119616 | Private 5 | :: 54 | 400 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 6005873.6969099995 | 2111410.5639299997 | 37.777863036884796 | -122.42322602570499 | (37.7778630368848, -122.423226025705) | |||
| 99631 | 99631 | 107208 | Undocumented 2 | :: 54 | 3795 Market St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6000195.59748 | 2102713.68465 | 37.7536614933614 | -122.442244022259 | (37.7536614933614, -122.442244022259) | |||||
| 99690 | 99690 | 108992 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 99789 | 99789 | 109518 | Undocumented 2 | :: 54 | 4801X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999644.57626 | 2104777.09851 | 37.759295701171105 | -122.44429784106501 | (37.7592957011711, -122.444297841065) | |||||
| 100579 | 100579 | 117313 | Permitted Site 1 | :: 54 | 883 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5981355.6 | 2109736.3 | 37.7718518197324 | -122.50791691513099 | (37.7718518197324, -122.507916915131) | |||||
| 100812 | 100812 | 115070 | Significant Tree 6 | :: 54 | 401 DARIEN WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 5992724.0 | 2094938.0 | 37.7318827746659 | -122.467516839465 | (37.7318827746659, -122.467516839465) | ||||
| 100825 | 100825 | 33462 | Permitted Site 1 | :: 54 | 20 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1996 12:00:00 AM | Permit Number 37562 | 6006978.38557579 | 2099649.65289984 | 37.7456325955283 | -122.418570316182 | (37.7456325955283, -122.418570316182) | ||
| 100878 | 100878 | 108803 | Undocumented 2 | :: 54 | 401-499 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 101195 | 101195 | 115894 | Permitted Site 1 | :: 54 | 1900X Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2016 12:00:00 AM | 3 | 5988841.66469 | 2105121.6083400003 | 37.75961937033 | -122.48168434385401 | (37.75961937033, -122.481684343854) | |||
| 101816 | 101816 | 31149 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.730761307799504 | -122.44892931603 | (37.7307613077995, -122.44892931603) | ||
| 102292 | 102292 | 33205 | Permitted Site 1 | :: 54 | 80 Ulloa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
| 102413 | 102413 | 108826 | Undocumented 2 | :: 54 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | ||||
| 103132 | 103132 | 113996 | Undocumented 2 | :: 54 | 58 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989321.8 | 2114884.9 | 37.786454584135704 | -122.480738581989 | (37.7864545841357, -122.480738581989) | |||||
| 103251 | 103251 | 38126 | Permitted Site 1 | :: 54 | 2822 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40290 | 5987014.20991985 | 2106446.11642248 | 37.7631496691658 | -122.488101839973 | (37.7631496691658, -122.488101839973) | ||
| 104076 | 104076 | 35147 | Permitted Site 1 | :: 54 | 218 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1998 12:00:00 AM | Permit Number 38679 | 6003802.50848229 | 2109121.89341149 | 37.7714618056141 | -122.430227667803 | (37.7714618056141, -122.430227667803) | ||
| 104314 | 104314 | 105082 | Significant Tree 6 | :: 54 | 344 Fulton St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 105108 | 105108 | 104859 | Permitted Site 1 | :: 54 | 650 Fillmore St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003597.7 | 2110555.4 | 37.775386259915 | -122.43103844044701 | (37.775386259915, -122.431038440447) | ||||||
| 105296 | 105296 | 107631 | Undocumented 2 | :: 54 | 4059 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003507.0 | 2100669.0 | 37.7482354401484 | -122.43064656488701 | (37.7482354401484, -122.430646564887) | ||||||
| 105387 | 105387 | 117319 | Permitted Site 1 | :: 54 | 1935 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993426.4 | 2102307.1 | 37.7521569948021 | -122.465623688401 | (37.7521569948021, -122.465623688401) | |||||
| 105398 | 105398 | 117608 | Permitted Site 1 | :: 54 | 450 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/29/2016 12:00:00 AM | 3 | 6005708.4 | 2111040.6 | 37.776837876057 | -122.423771533631 | (37.776837876057, -122.423771533631) | |||
| 105651 | 105651 | 105081 | Significant Tree 6 | :: 54 | 344 Fulton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 106237 | 106237 | 115066 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 107067 | 107067 | 116330 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 107142 | 107142 | 108804 | Undocumented 2 | :: 54 | 401-499 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 107184 | 107184 | 116334 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 107393 | 107393 | 33714 | Permitted Site 1 | :: 54 | 171 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | Permit Number 37781 | 6003460.14310315 | 2108772.24359779 | 37.770482355194105 | -122.431386962618 | (37.7704823551941, -122.431386962618) | ||
| 108795 | 108795 | 113997 | Undocumented 2 | :: 54 | 58 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989321.8 | 2114884.9 | 37.786454584135704 | -122.480738581989 | (37.7864545841357, -122.480738581989) | |||||
| 108927 | 108927 | 116338 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 109194 | 109194 | 108807 | Undocumented 2 | :: 54 | 401-499 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 109627 | 109627 | 43024 | Permitted Site 1 | :: 54 | 430 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42886 | 6004125.6708626 | 2110297.9605007 | 37.774709297051004 | -122.429193705112 | (37.774709297051, -122.429193705112) | ||
| 109892 | 109892 | 36905 | Permitted Site 1 | :: 54 | 4416 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39553 | 6000517.15649148 | 2102301.36938584 | 37.7525476968755 | -122.441102423403 | (37.7525476968755, -122.441102423403) | ||
| 109941 | 109941 | 114620 | Undocumented 2 | :: 54 | 2400X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 110162 | 110162 | 108806 | Undocumented 2 | :: 54 | 401-499 University St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 110291 | 110291 | 105085 | Significant Tree 6 | :: 54 | 344 Fulton St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 110326 | 110326 | 37315 | Permitted Site 1 | :: 54 | 561 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/15/1998 12:00:00 AM | Permit Number 39830 | 6002709.44183784 | 2103247.60813838 | 37.7552704710237 | -122.43358875215 | (37.7552704710237, -122.43358875215) | ||
| 110336 | 110336 | 52107 | Permitted Site 1 | :: 54 | 935 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48299 | 5996504.69473395 | 2098122.17494067 | 37.7408432986479 | -122.454676219762 | (37.7408432986479, -122.454676219762) | ||
| 110497 | 110497 | 38040 | Permitted Site 1 | :: 54 | 271 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/1998 12:00:00 AM | Permit Number 40242 | 5992319.7729488 | 2097504.33557698 | 37.7389059415194 | -122.46910103166401 | (37.7389059415194, -122.469101031664) | ||
| 110521 | 110521 | 37485 | Permitted Site 1 | :: 54 | 1279 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1998 12:00:00 AM | Permit Number 39954 | 5990777.53023366 | 2106701.87780849 | 37.7640707487715 | -122.47510458341002 | (37.7640707487715, -122.47510458341) | ||
| 110696 | 110696 | 115065 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 110733 | 110733 | 33206 | Permitted Site 1 | :: 54 | 80 Ulloa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
| 111037 | 111037 | 43020 | Permitted Site 1 | :: 54 | 537 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/2000 12:00:00 AM | Permit Number 42882 | 6003129.08838274 | 2110095.37711913 | 37.7740965863099 | -122.432626609315 | (37.7740965863099, -122.432626609315) | ||
| 112032 | 112032 | 108988 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 112497 | 112497 | 104858 | Permitted Site 1 | :: 54 | 4205 24th St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 6001816.0 | 2101720.7 | 37.7510272133613 | -122.43656924920201 | (37.7510272133613, -122.436569249202) | ||||||
| 112628 | 112628 | 116325 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 113035 | 113035 | 118550 | Undocumented 2 | :: 54 | 8140 Geary Blvd | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5981686.0706 | 2112397.3766900003 | 37.7791778206923 | -122.506971243035 | (37.7791778206923, -122.506971243035) | |||||
| 113187 | 113187 | 115067 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 113351 | 113351 | 108618 | Undocumented 2 | :: 54 | 150-198X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005405.0 | 2109611.0 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | |||||
| 113454 | 113454 | 108799 | Undocumented 2 | :: 54 | 501-599 University St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 113475 | 113475 | 46634 | Permitted Site 1 | :: 54 | 1569 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | Permit Number 44755 | 6014739.185840401 | 2093576.72961431 | 37.729391461068204 | -122.391309972305 | (37.7293914610682, -122.391309972305) | ||
| 113797 | 113797 | 116339 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 114617 | 114617 | 105046 | Permitted Site 1 | :: 54 | 268 Capitol Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5995102.1 | 2087921.7 | 37.7127547049329 | -122.458787524461 | (37.7127547049329, -122.458787524461) | ||||||
| 114741 | 114741 | 104860 | Permitted Site 1 | :: 54 | 283 Randall St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6003774.7 | 2097827.3 | 37.7404479510811 | -122.429518236565 | (37.7404479510811, -122.429518236565) | ||||||
| 114951 | 114951 | 33208 | Permitted Site 1 | :: 54 | 80 Ulloa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/06/1996 12:00:00 AM | Permit Number 37408 | 5996508.84910838 | 2099508.74034148 | 37.74465070488021 | -122.454762009134 | (37.7446507048802, -122.454762009134) | |||
| 115253 | 115253 | 106460 | Undocumented 2 | :: 54 | 701 Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6007932.0 | 2097222.5 | 37.739021812259104 | -122.415101080128 | (37.7390218122591, -122.415101080128) | |||||
| 115373 | 115373 | 108811 | Undocumented 2 | :: 54 | 301-399 University St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |||||
| 115565 | 115565 | 114618 | Undocumented 2 | :: 54 | 2400X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 115960 | 115960 | 38111 | Permitted Site 1 | :: 54 | 1296 29th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | Permit Number 40278 | 5987114.66231835 | 2106457.26685396 | 37.763186144894 | -122.48775523264901 | (37.763186144894, -122.487755232649) | ||
| 115978 | 115978 | 108771 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
| 116105 | 116105 | 116281 | Undocumented 2 | :: 54 | 700X Greenwich St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 116325 | 116325 | 114670 | Undocumented 2 | :: 54 | 176X Peralta Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009847.7 | 2100071.6 | 37.7469522901695 | -122.408678376857 | (37.7469522901695, -122.408678376857) | |||||
| 116859 | 116859 | 45263 | Permitted Site 1 | :: 54 | 673 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/2001 12:00:00 AM | Permit Number 44109 | 6007439.21136226 | 2095836.00424965 | 37.7351870945672 | -122.41670672522 | (37.7351870945672, -122.41670672522) | ||
| 116897 | 116897 | 108813 | Undocumented 2 | :: 54 | 301-399 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |||||
| 117089 | 117089 | 116277 | Undocumented 2 | :: 54 | 700X Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.41122536090799 | (37.8021533125646, -122.411225360908) | |||||
| 117141 | 117141 | 115013 | Permitted Site 1 | :: 54 | 2493 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/2016 12:00:00 AM | 5999602.09209 | 2119817.77431 | 37.8005911003042 | -122.44552631681499 | (37.8005911003042, -122.445526316815) | ||||
| 117306 | 117306 | 104857 | Permitted Site 1 | :: 54 | 2555 46th Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 5982069.8 | 2097707.6 | 37.7388664658919 | -122.504555139124 | (37.7388664658919, -122.504555139124) | ||||||
| 117492 | 117492 | 115069 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 117730 | 117730 | 108800 | Undocumented 2 | :: 54 | 501-599 University St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 117766 | 117766 | 37180 | Permitted Site 1 | :: 54 | 41 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39753 | 6005613.02354759 | 2099315.01435949 | 37.7446367918581 | -122.42326775451299 | (37.7446367918581, -122.423267754513) | ||
| 117839 | 117839 | 106461 | Undocumented 2 | :: 54 | 701 Cortland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6007932.0 | 2097222.5 | 37.739021812259104 | -122.415101080128 | (37.7390218122591, -122.415101080128) | |||||
| 118121 | 118121 | 36924 | Permitted Site 1 | :: 54 | 516 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39568 | 6001154.35821609 | 2103257.26025902 | 37.755208616744795 | -122.438967374074 | (37.7552086167448, -122.438967374074) | ||
| 118134 | 118134 | 36519 | Permitted Site 1 | :: 54 | 430 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39394 | 6007460.82693634 | 2095697.00770714 | 37.7348066562255 | -122.416622148824 | (37.7348066562255, -122.416622148824) | ||
| 118536 | 118536 | 36929 | Permitted Site 1 | :: 54 | 901 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/27/1998 12:00:00 AM | Permit Number 39571 | 6000612.32634681 | 2101962.60570598 | 37.751622953989205 | -122.440749012812 | (37.7516229539892, -122.440749012812) | ||
| 118898 | 118898 | 116327 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 118997 | 118997 | 105083 | Significant Tree 6 | :: 54 | 344 Fulton St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 119022 | 119022 | 104960 | Permitted Site 1 | :: 54 | 2895 San Bruno Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6011715.1 | 2091289.8 | 37.7229437265236 | -122.401603910944 | (37.7229437265236, -122.401603910944) | ||||||
| 119252 | 119252 | 116340 | Undocumented 2 | :: 54 | 201X Bright St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 5993755.0695 | 2088847.02637 | 37.715217913096104 | -122.463510368547 | (37.7152179130961, -122.463510368547) | |||||
| 120235 | 120235 | 115062 | DPW Maintained 3 | :: 54 | 70 Coral Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6012676.36761 | 2102522.24683 | 37.7538392609312 | -122.39906901845501 | (37.7538392609312, -122.399069018455) | |||||
| 120303 | 120303 | 114621 | Undocumented 2 | :: 54 | 2400X Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000387.7 | 2114050.6 | 37.7848007706075 | -122.442393531976 | (37.7848007706075, -122.442393531976) | |||||
| 120796 | 120796 | 105087 | Significant Tree 6 | :: 54 | 344 Fulton St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 120864 | 120864 | 37457 | Permitted Site 1 | :: 54 | 442 Holladay Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1998 12:00:00 AM | Permit Number 39929 | 6010236.40979486 | 2098631.79989851 | 37.743020676259704 | -122.40723276795299 | (37.7430206762597, -122.407232767953) | ||
| 121162 | 121162 | 105090 | Significant Tree 6 | :: 54 | 344 Fulton St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 121409 | 121409 | 45784 | Permitted Site 1 | :: 54 | 355 Granada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/2002 12:00:00 AM | Permit Number 44424 | 5995605.92038879 | 2092277.61806963 | 37.7247439722696 | -122.457361104262 | (37.7247439722696, -122.457361104262) | ||
| 121543 | 121543 | 116331 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 122041 | 122041 | 38338 | Permitted Site 1 | :: 54 | 73 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/1998 12:00:00 AM | Permit Number 40405 | 5998234.47777194 | 2107177.32360217 | 37.7658055638462 | -122.44934755802 | (37.7658055638462, -122.44934755802) | |||
| 122059 | 122059 | 108765 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
| 122339 | 122339 | 104861 | Permitted Site 1 | :: 54 | 3458A 18th St | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 6006508.0 | 2105569.9 | 37.7618617394874 | -122.42061702780899 | (37.7618617394874, -122.420617027809) | ||||||
| 122633 | 122633 | 42091 | Permitted Site 1 | :: 54 | 25 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42397 | 6008240.69863747 | 2099401.70748619 | 37.7450227780609 | -122.414187874949 | (37.7450227780609, -122.414187874949) | ||
| 123158 | 123158 | 36526 | Permitted Site 1 | :: 54 | 619 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/18/1998 12:00:00 AM | Permit Number 39400 | 6007328.0 | 2097732.0 | 37.74038682503829 | -122.41722553506399 | (37.7403868250383, -122.417225535064) | ||
| 123854 | 123854 | 38201 | Permitted Site 1 | :: 54 | 254X Dwight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1998 12:00:00 AM | Permit Number 40328 | 6010721.34684579 | 2091489.60477168 | 37.723436846683704 | -122.405053190481 | (37.7234368466837, -122.405053190481) | ||
| 124407 | 124407 | 116322 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 125361 | 125361 | 116323 | Undocumented 2 | :: 54 | 1400X Potrero Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6010648.284969999 | 2101378.4314900003 | 37.7505853701643 | -122.40600205927099 | (37.7505853701643, -122.406002059271) | |||||
| 125761 | 125761 | 108576 | Property Tree 7 | :: 54 | 2479 Diamond St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6002240.0 | 2097369.0 | 37.7391025518434 | -122.434791855338 | (37.7391025518434, -122.434791855338) | |||||
| 126640 | 126640 | 108797 | Undocumented 2 | :: 54 | 501-599 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 126759 | 126759 | 31148 | Permitted Site 1 | :: 54 | 500 Hearst Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34853 | 5998089.630643 | 2094417.27408922 | 37.730761307799504 | -122.44892931603 | (37.7307613077995, -122.44892931603) | ||
| 127351 | 127351 | 35482 | Permitted Site 1 | :: 54 | 1136 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2000 12:00:00 AM | Permit Number 40088 | 6008340.04148266 | 2093836.36406151 | 37.7297471396453 | -122.413450843683 | (37.7297471396453, -122.413450843683) | ||
| 127461 | 127461 | 108990 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 127606 | 127606 | 40513 | Permitted Site 1 | :: 54 | 1620 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/1999 12:00:00 AM | Permit Number 41577 | 5999999.85509787 | 2110944.48687978 | 37.7762500681911 | -122.443512144169 | (37.7762500681911, -122.443512144169) | ||
| 127642 | 127642 | 36507 | Permitted Site 1 | :: 54 | 584 Anderson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/29/2003 12:00:00 AM | Permit Number 39385 | 6007790.43718065 | 2096197.35426509 | 37.736199030760105 | -122.41551798135401 | (37.7361990307601, -122.415517981354) |
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");