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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96077 | 96077 | 104157 | Permitted Site 1 | :: 54 | 525X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 95556 | 95556 | 104158 | Permitted Site 1 | :: 54 | 525X Church St | 6 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | SFUSD 4 | DPW 4 | 5x20 | 6004243.11162 | 2105844.84418 | 37.7624887647889 | -122.428469979895 | (37.7624887647889, -122.428469979895) | |||
| 141674 | 141674 | 104634 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 118218 | 118218 | 104635 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6009833.3 | 2099565.6 | 37.7455621186719 | -122.40869248022899 | (37.7455621186719, -122.408692480229) | |||||
| 111744 | 111744 | 104636 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 94853 | 94853 | 104637 | Permitted Site 1 | :: 54 | 217 Montcalm St | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 16x16 | 6010036.0 | 2099691.0 | 37.7459177905176 | -122.40800041337499 | (37.7459177905176, -122.408000413375) | |||||
| 125788 | 125788 | 104827 | Permitted Site 1 | :: 54 | 4366 26th St | : Cutout 24 | Tree 1 | Private 1 | 3X3 | 6001535.3 | 2100615.2 | 37.7479758185871 | -122.437460780102 | (37.7479758185871, -122.437460780102) | |||||
| 78123 | 78123 | 104843 | Permitted Site 1 | :: 54 | 1320 21st Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5989622.0 | 2106334.7 | 37.7629955389606 | -122.47907431964701 | (37.7629955389606, -122.479074319647) | ||||||
| 81298 | 81298 | 104856 | Permitted Site 1 | :: 54 | 739 27th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 02/12/2015 12:00:00 AM | 3 | 6001722.3 | 2099959.7 | 37.746186600460604 | -122.43676722664301 | (37.7461866004606, -122.436767226643) | ||||
| 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) | ||||||
| 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) | ||||||
| 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) | ||||||
| 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) | ||||||
| 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) | ||||||
| 87925 | 87925 | 104864 | Permitted Site 1 | :: 54 | 45 Hoffman Ave | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6000629.3 | 2102650.0 | 37.7535113392088 | -122.440739618385 | (37.7535113392088, -122.440739618385) | ||||||
| 80892 | 80892 | 104890 | Undocumented 2 | :: 54 | 150 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | empty | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | ||||
| 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) | ||||||
| 85839 | 85839 | 105039 | Permitted Site 1 | :: 54 | 2660 Harrison St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 122806 | 122806 | 105040 | Permitted Site 1 | :: 54 | 2660 Harrison St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x7 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 140829 | 140829 | 105041 | Permitted Site 1 | :: 54 | 2660 Harrison St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x2 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 106819 | 106819 | 105042 | Permitted Site 1 | :: 54 | 2660 Harrison St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x10 | 6008868.4 | 2102978.1 | 37.7548779915591 | -122.412270115586 | (37.7548779915591, -122.412270115586) | ||||
| 85310 | 85310 | 105043 | Permitted Site 1 | :: 54 | 2660 Harrison St | 5 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 2x4 | 6008902.0 | 2102968.0 | 37.754852144595795 | -122.41215320319701 | (37.7548521445958, -122.412153203197) | ||||
| 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) | ||||||
| 142578 | 142578 | 105065 | Permitted Site 1 | :: 54 | 3177 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006744.0 | 2099801.7 | 37.7460368842113 | -122.419391572433 | (37.7460368842113, -122.419391572433) | ||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 85903 | 85903 | 105084 | Significant Tree 6 | :: 54 | 344 Fulton St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 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) | |||||
| 96655 | 96655 | 105086 | Significant Tree 6 | :: 54 | 344 Fulton St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 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) | |||||
| 141862 | 141862 | 105088 | Significant Tree 6 | :: 54 | 344 Fulton St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 86041 | 86041 | 105089 | Significant Tree 6 | :: 54 | 344 Fulton St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 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) | |||||
| 97038 | 97038 | 105091 | Significant Tree 6 | :: 54 | 344 Fulton St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006101.8 | 2111789.5 | 37.778916373563206 | -122.42246386857201 | (37.7789163735632, -122.422463868572) | |||||
| 127904 | 127904 | 105121 | Undocumented 2 | :: 54 | 721 BEACH ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 6006739.7 | 2121813.5 | 37.8064757462399 | -122.42096901139601 | (37.8064757462399, -122.420969011396) | |||||
| 83497 | 83497 | 105359 | Permitted Site 1 | :: 54 | 850 Guerrero St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 91070 | 91070 | 105360 | Permitted Site 1 | :: 54 | 850 Guerrero St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 61493 | 61493 | 105361 | Permitted Site 1 | :: 54 | 850 Guerrero St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12x2.75 | 6005583.5 | 2103975.8 | 37.7574325683666 | -122.423701164602 | (37.7574325683666, -122.423701164602) | ||||
| 104872 | 104872 | 105437 | Undocumented 2 | :: 54 | 1116 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002483.0 | 2102334.0 | 37.75274907025911 | -122.43430654109899 | (37.7527490702591, -122.434306541099) | ||||
| 88179 | 88179 | 105438 | Undocumented 2 | :: 54 | 1116 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002483.0 | 2102334.0 | 37.75274907025911 | -122.43430654109899 | (37.7527490702591, -122.434306541099) | ||||
| 89307 | 89307 | 105925 | Permitted Site 1 | :: 54 | 4166 20th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3X3 | 6002608.6 | 2104160.0 | 37.7577699584222 | -122.434002709079 | (37.7577699584222, -122.434002709079) | |||||
| 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) | |||||
| 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) | |||||
| 98644 | 98644 | 106968 | Property Tree 7 | :: 54 | 351 26th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.48618540122601 | (37.7828456076198, -122.486185401226) | ||||||
| 83840 | 83840 | 107144 | Undocumented 2 | :: 54 | 360 Spear St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 6015708.0 | 2115219.0 | 37.7888702311939 | -122.38947147438 | (37.7888702311939, -122.38947147438) | |||||
| 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) | |||||
| 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) | ||||||
| 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) | |||||
| 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) | |||||
| 82474 | 82474 | 108629 | Undocumented 2 | :: 54 | 82-98X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6002862.02202 | 2108710.63631 | 37.7702792804688 | -122.433451461668 | (37.7702792804688, -122.433451461668) | |||
| 85063 | 85063 | 108731 | Undocumented 2 | :: 54 | 1822-1898X 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013006.0 | 2102886.0 | 37.7548564119513 | -122.39795458116001 | (37.7548564119513, -122.39795458116) | ||||
| 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) | ||||
| 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) | ||||
| 83697 | 83697 | 108792 | Permitted Site 1 | :: 54 | 201-299 University St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
| 85159 | 85159 | 108793 | Permitted Site 1 | :: 54 | 201-299 University St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6008053.41125 | 2093004.09823 | 37.727445818429295 | -122.414382893832 | (37.7274458184293, -122.414382893832) | ||||
| 145496 | 145496 | 108795 | Undocumented 2 | :: 54 | 501-599 University St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 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) | |||||
| 138812 | 138812 | 108798 | Undocumented 2 | :: 54 | 501-599 University St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 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) | |||||
| 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) | |||||
| 82769 | 82769 | 108801 | Undocumented 2 | :: 54 | 501-599 University St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008503.45306 | 2091469.8325200002 | 37.7232583218261 | -122.412718672961 | (37.7232583218261, -122.412718672961) | |||||
| 83240 | 83240 | 108802 | Undocumented 2 | :: 54 | 401-499 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 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) | |||||
| 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) | |||||
| 78523 | 78523 | 108805 | Undocumented 2 | :: 54 | 401-499 University St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008323.152369999 | 2092121.01007 | 37.7250361958168 | -122.413387969207 | (37.7250361958168, -122.413387969207) | |||||
| 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) | |||||
| 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) | |||||
| 81999 | 81999 | 108810 | Undocumented 2 | :: 54 | 301-399 University St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |||||
| 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) | |||||
| 79728 | 79728 | 108812 | Undocumented 2 | :: 54 | 301-399 University St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008160.407269999 | 2092653.74948 | 37.726489845684796 | -122.41398823310301 | (37.7264898456848, -122.413988233103) | |||||
| 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) | |||||
| 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) | ||||
| 121386 | 121386 | 108949 | Permitted Site 1 | :: 54 | 254 Dublin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003932.1 | 2088992.0 | 37.716197100768596 | -122.42834444974702 | (37.7161971007686, -122.428344449747) | |||
| 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) | |||||
| 94995 | 94995 | 108989 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 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) | |||||
| 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) | |||||
| 139188 | 139188 | 108993 | Undocumented 2 | :: 54 | 2073-2099X Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999311.1 | 2121145.9 | 37.8042211586385 | -122.446628874501 | (37.8042211586385, -122.446628874501) | |||||
| 142347 | 142347 | 109178 | Permitted Site 1 | :: 54 | 2832 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2015 12:00:00 AM | 3 | 6001592.1 | 2118171.6 | 37.796184544404895 | -122.438522078694 | (37.7961845444049, -122.438522078694) | |||
| 113500 | 113500 | 109261 | Permitted Site 1 | :: 54 | 3338X Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
| 86957 | 86957 | 109262 | Permitted Site 1 | :: 54 | 3338X Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 5983663.54917 | 2102222.75157 | 37.7513574508855 | -122.499378353213 | (37.7513574508855, -122.499378353213) | |||
| 140543 | 140543 | 109342 | Permitted Site 1 | :: 54 | 3211 Baker St | 1 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 1x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 42994 | 42994 | 109343 | Permitted Site 1 | :: 54 | 3211 Baker St | 2 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 99464 | 99464 | 109344 | Permitted Site 1 | :: 54 | 3211 Baker St | 3 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 4x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 97307 | 97307 | 109345 | Permitted Site 1 | :: 54 | 3211 Baker St | 4 | Sidewalk: Property side : Yard 9 | Landscaping 2 | Private 1 | 02/11/2015 12:00:00 AM | 3 | 8.75x13 | 5999315.1 | 2119860.5 | 37.8006920253414 | -122.446522498385 | (37.8006920253414, -122.446522498385) | ||
| 101115 | 101115 | 109364 | Permitted Site 1 | :: 54 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 91154 | 91154 | 109365 | Permitted Site 1 | :: 54 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 124298 | 124298 | 109367 | Permitted Site 1 | :: 54 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 116207 | 116207 | 109368 | Permitted Site 1 | :: 54 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 128427 | 128427 | 109369 | Permitted Site 1 | :: 54 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 125946 | 125946 | 109370 | Permitted Site 1 | :: 54 | 2061 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 13x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 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) | |||||
| 83909 | 83909 | 109520 | Undocumented 2 | :: 54 | 4801X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999644.57626 | 2104777.09851 | 37.759295701171105 | -122.44429784106501 | (37.7592957011711, -122.444297841065) | |||||
| 126302 | 126302 | 109534 | Permitted Site 1 | :: 54 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 140860 | 140860 | 109571 | Permitted Site 1 | :: 54 | 400 Brazil Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6003029.6 | 2091527.8 | 37.7231087370031 | -122.43164485974701 | (37.7231087370031, -122.431644859747) | |||
| 121197 | 121197 | 109754 | Permitted Site 1 | :: 54 | 601 Steiner St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 1x12 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) |
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");