Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17611 | 17611 | 5710 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 1609 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6005330.55919 | 2098925.54374 | 37.743551448937396 | -122.4242167677 | (37.7435514489374, -122.4242167677) | |||
| 5632 | 5632 | 27388 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 2238 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6007145.97631 | 2119998.36118 | 37.8015147288815 | -122.41943416045099 | (37.8015147288815, -122.419434160451) | |||
| 2580 | 2580 | 27387 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 2222 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6007153.30759 | 2119954.57165 | 37.8013949068162 | -122.419405682544 | (37.8013949068162, -122.419405682544) | |||
| 7273 | 7273 | 27386 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 2222 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6007153.462830001 | 2119942.0708 | 37.8013605913839 | -122.419404257997 | (37.8013605913839, -122.419404257997) | |||
| 78020 | 78020 | 112544 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 31 HIDALGO TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 3x3 | 6004997.0 | 2107458.0 | 37.7669607387675 | -122.425977392818 | (37.7669607387675, -122.425977392818) | |||
| 18417 | 18417 | 10231 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 1440 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 2x2 | 6005821.60814 | 2100602.13393 | 37.748182698482296 | -122.42263795659599 | (37.7481826984823, -122.422637956596) | |||
| 5160 | 5160 | 27393 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 2256 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6007130.3947 | 2120101.3253099998 | 37.8017965647292 | -122.41949538901899 | (37.8017965647292, -122.419495389019) | |||
| 20122 | 20122 | 10088 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 680 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X2 | 6005576.87933 | 2105026.12376 | 37.760316137501 | -122.423798743025 | (37.760316137501, -122.423798743025) | |||
| 17581 | 17581 | 9989 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 28 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2X2 | 6005374.8666900005 | 2108638.02007 | 37.7702221392707 | -122.424754366229 | (37.7702221392707, -122.424754366229) | |||
| 6651 | 6651 | 16365 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 1306X Montgomery St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011450.07983 | 2119965.49195 | 37.8016659588815 | -122.40453762461901 | (37.8016659588815, -122.404537624619) | |||
| 144257 | 144257 | 226646 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 31 Hidalgo Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6004999.4002 | 2107477.2952799997 | 37.767013854632 | -122.425970464583 | (37.767013854632, -122.425970464583) | |||
| 148863 | 148863 | 191420 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 785 Rhode Island St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 3ft | 6011880.44844 | 2104704.93056 | 37.759788043892996 | -122.401974935396 | (37.759788043893, -122.401974935396) | |||
| 73133 | 73133 | 177037 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 125 Goettingen St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 6009971.552 | 2093934.84647 | 37.7301090233129 | -122.407817447612 | (37.7301090233129, -122.407817447612) | |||
| 178665 | 178665 | 177036 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 15 Merrill St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 2ft | 6009502.62349 | 2094943.7258099997 | 37.7328529276995 | -122.409509775682 | (37.7328529276995, -122.409509775682) | |||
| 31372 | 31372 | 177035 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 15 Merrill St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 2ft | 6009505.01631 | 2094936.0613 | 37.732832016669605 | -122.409500962316 | (37.7328320166696, -122.409500962316) | |||
| 54730 | 54730 | 226647 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 31 Hidalgo Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6004982.44987 | 2107476.14572 | 37.767009740246 | -122.42602901133101 | (37.767009740246, -122.426029011331) | |||
| 101701 | 101701 | 112545 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 31 HIDALGO TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6004997.0 | 2107458.0 | 37.7669607387675 | -122.425977392818 | (37.7669607387675, -122.425977392818) | |||
| 32499 | 32499 | 72076 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 229 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 14 | 5989910.70009 | 2113826.30511 | 37.7835821901674 | -122.478623713066 | (37.7835821901674, -122.478623713066) | ||
| 36844 | 36844 | 177034 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 675 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 6008984.35993 | 2091023.84247 | 37.7220607070166 | -122.411024777165 | (37.7220607070166, -122.411024777165) | |||
| 45994 | 45994 | 226656 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 121 Moffitt St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6002727.925340001 | 2096681.4535 | 37.737242397212704 | -122.43305572295401 | (37.7372423972127, -122.433055722954) | |||
| 47963 | 47963 | 191430 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 12 Augusta St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 2ft | 6011384.738480001 | 2095507.87401 | 37.7345072405216 | -122.403042454946 | (37.7345072405216, -122.403042454946) | |||
| 49924 | 49924 | 226657 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 117 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003659.76941 | 2097669.44697 | 37.740008014859995 | -122.42990436449 | (37.74000801486, -122.42990436449) | |||
| 166827 | 166827 | 226658 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 117 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003646.084869999 | 2097679.68219 | 37.7400353434466 | -122.429952409889 | (37.7400353434466, -122.429952409889) | |||
| 5084 | 5084 | 27391 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 2250 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6007137.4365300005 | 2120063.48315 | 37.8016930563562 | -122.419468334714 | (37.8016930563562, -122.419468334714) | |||
| 11978 | 11978 | 112948 | Property Tree 7 | Ligustrum japonicum :: Japanese Privet 4 | 400 Pioche St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x15 | 6005670.66964 | 2093276.94718 | 37.7280608613968 | -122.42263943148599 | (37.7280608613968, -122.422639431486) | |||
| 21862 | 21862 | 9988 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 25 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005434.589869999 | 2108720.51419 | 37.7704520212643 | -122.424553652838 | (37.7704520212643, -122.424553652838) | |||
| 35358 | 35358 | 226639 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 145 Coso Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6007521.18601 | 2099614.94215 | 37.745567831493396 | -122.416690930545 | (37.7455678314934, -122.416690930545) | ||||
| 48051 | 48051 | 177031 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 263 Maynard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 2ft | 6005122.72167 | 2093818.5342400002 | 37.729517010390204 | -122.42457221572901 | (37.7295170103902, -122.424572215729) | |||
| 67745 | 67745 | 226648 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1488 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6005200.770269999 | 2099715.54685 | 37.7457132878504 | -122.42472173433701 | (37.7457132878504, -122.424721734337) | |||
| 134435 | 134435 | 226653 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 214 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999974.10738 | 2105629.30684 | 37.7616544501161 | -122.443219374174 | (37.7616544501161, -122.443219374174) | |||
| 24309 | 24309 | 191424 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 743 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012751.8613599995 | 2104046.56843 | 37.758028922326496 | -122.398914919298 | (37.7580289223265, -122.398914919298) | |||
| 58518 | 58518 | 42618 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 1615 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 11 | Permit Number 42680 | 6005139.94855 | 2119525.3007400003 | 37.800102635872506 | -122.426342225416 | (37.8001026358725, -122.426342225416) | |
| 58879 | 58879 | 129507 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1714 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6004691.67913 | 2119164.8681 | 37.7990876313419 | -122.42786771393 | (37.7990876313419, -122.42786771393) | |||
| 147024 | 147024 | 226652 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 225 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 5999964.01354 | 2105579.20426 | 37.7615163052595 | -122.443250685888 | (37.7615163052595, -122.443250685888) | |||
| 25862 | 25862 | 129509 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1714 Filbert St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004669.814259999 | 2119159.95033 | 37.7990728914709 | -122.42794302317499 | (37.7990728914709, -122.427943023175) | |||
| 45441 | 45441 | 119030 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 767 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5982272.9223 | 2110539.10892 | 37.774110104964706 | -122.50480338457301 | (37.7741101049647, -122.504803384573) | |||
| 59600 | 59600 | 129529 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2677 Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006561.352969999 | 2120334.1919299997 | 37.802403889494 | -122.421481088503 | (37.802403889494, -122.421481088503) | |||
| 130785 | 130785 | 129508 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1714 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004680.4249 | 2119161.32221 | 37.7990772585711 | -122.427906404578 | (37.7990772585711, -122.427906404578) | |||
| 167962 | 167962 | 129504 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2656 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000274.51269 | 2118548.1954799998 | 37.7971435390014 | -122.44310824405399 | (37.7971435390014, -122.443108244054) | |||
| 184962 | 184962 | 57852 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | 10 | Permit Number 16793 | 6012080.13289 | 2115527.6650900003 | 37.7895159399674 | -122.402045176939 | (37.7895159399674, -122.402045176939) | ||
| 186226 | 186226 | 129526 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2677 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6006553.85688 | 2120395.35345 | 37.8025714008062 | -122.421511374958 | (37.8025714008062, -122.421511374958) | |||
| 27158 | 27158 | 226650 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1210 Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997776.79189 | 2106261.7686099997 | 37.7632654911199 | -122.450864566663 | (37.7632654911199, -122.450864566663) | |||
| 40259 | 40259 | 129544 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 508 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010620.37011 | 2115953.21754 | 37.7906028228134 | -122.407125832085 | (37.7906028228134, -122.407125832085) | |||
| 57229 | 57229 | 191425 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 798 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6012697.8338 | 2103815.11788 | 37.757390399158794 | -122.399085525191 | (37.7573903991588, -122.399085525191) | |||
| 64620 | 64620 | 207367 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2 Lurline St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5992094.1475599995 | 2104940.13578 | 37.7593096900047 | -122.47042251889401 | (37.7593096900047, -122.470422518894) | |||
| 76500 | 76500 | 129528 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2677 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006558.18826 | 2120353.46017 | 37.802456616741 | -122.4214934092 | (37.802456616741, -122.4214934092) | |||
| 134337 | 134337 | 129525 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1109 Chestnut St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006520.95763 | 2120409.72682 | 37.8026090113668 | -122.42162624447799 | (37.8026090113668, -122.421626244478) | |||
| 148565 | 148565 | 129542 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 508 Stockton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010625.70171 | 2115928.16115 | 37.7905343223424 | -122.407105618041 | (37.7905343223424, -122.407105618041) | |||
| 157440 | 157440 | 129527 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2677 Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6006554.47344 | 2120382.0459 | 37.802534896425 | -122.421508295689 | (37.802534896425, -122.421508295689) | |||
| 170546 | 170546 | 129541 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 508 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6010626.2585 | 2115918.27933 | 37.7905072203931 | -122.40710299472799 | (37.7905072203931, -122.407102994728) | |||
| 26065 | 26065 | 129543 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 508 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010622.60945 | 2115940.55933 | 37.7905681917229 | -122.407117191424 | (37.7905681917229, -122.407117191424) | |||
| 33785 | 33785 | 129500 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2144 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002804.8844800005 | 2118207.36125 | 37.7963516481611 | -122.434328161126 | (37.7963516481611, -122.434328161126) | |||
| 42762 | 42762 | 226645 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3626 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 1ft | 6005580.70423 | 2101999.04422 | 37.752004698476206 | -122.42357029633301 | (37.7520046984762, -122.423570296333) | |||
| 52191 | 52191 | 177033 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 681 Colby St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008991.36209 | 2090994.1931599998 | 37.7219796888926 | -122.410998479192 | (37.7219796888926, -122.410998479192) | |||
| 70389 | 70389 | 129503 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2656 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000257.59997 | 2118546.4747099997 | 37.797137849879896 | -122.44316664242099 | (37.7971378498799, -122.443166642421) | |||
| 134630 | 134630 | 226651 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1210 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997784.115230001 | 2106211.6118400004 | 37.7631281925414 | -122.450835621062 | (37.7631281925414, -122.450835621062) | |||
| 169044 | 169044 | 129539 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 586 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010703.940330001 | 2115907.6638700003 | 37.7904824197785 | -122.406833470599 | (37.7904824197785, -122.406833470599) | |||
| 170738 | 170738 | 249913 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 356 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011242.070719999 | 2120420.51237 | 37.802903706599295 | -122.40528949653601 | (37.8029037065993, -122.405289496536) | |||
| 170844 | 170844 | 129512 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3223 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002763.64169 | 2119722.26517 | 37.8005088389808 | -122.43457924465 | (37.8005088389808, -122.43457924465) | |||
| 173094 | 173094 | 191419 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 574 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011201.13816 | 2105680.19927 | 37.762427976796296 | -122.404392995652 | (37.7624279767963, -122.404392995652) | |||
| 1872 | 1872 | 177039 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 178 Seville St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6001177.23506 | 2087434.66895 | 37.711764745717 | -122.437755094333 | (37.711764745717, -122.437755094333) | |||
| 34739 | 34739 | 129549 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012078.1031 | 2115538.76346 | 37.78954630017979 | -122.40205298038401 | (37.7895463001798, -122.402052980384) | |||
| 34865 | 34865 | 129550 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012076.26306 | 2115552.15036 | 37.7895829547447 | -122.40206028827 | (37.7895829547447, -122.40206028827) | |||
| 43164 | 43164 | 53852 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 566 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1972 12:00:00 AM | 7 | Permit Number 9560 | 6010756.69045 | 2115915.59968 | 37.7905071610361 | -122.406651517078 | (37.7905071610361, -122.406651517078) | ||
| 52039 | 52039 | 226655 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 232 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999888.11878 | 2105582.8714799997 | 37.761522046538204 | -122.44351343721901 | (37.7615220465382, -122.443513437219) | |||
| 53054 | 53054 | 129531 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 84 MacOndray Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008275.2008 | 2119135.29153 | 37.7992084921309 | -122.415465384822 | (37.7992084921309, -122.415465384822) | ||||
| 54940 | 54940 | 55616 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 407 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/16/1973 12:00:00 AM | 7 | Permit Number 11594 | 5998117.038919999 | 2115073.6250299998 | 37.787480044827596 | -122.450323009314 | (37.7874800448276, -122.450323009314) | ||
| 56461 | 56461 | 120189 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 224 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5987764.6245099995 | 2114428.11322 | 37.785109748738996 | -122.486092406972 | (37.785109748739, -122.486092406972) | |||
| 59980 | 59980 | 129511 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3223 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002767.09508 | 2119707.46883 | 37.8004684081385 | -122.43456623596799 | (37.8004684081385, -122.434566235968) | |||
| 64936 | 64936 | 129534 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 580 North Point St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6007527.54685 | 2121657.26711 | 37.8060911485403 | -122.41823143323099 | (37.8060911485403, -122.418231433231) | |||
| 75729 | 75729 | 129524 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1109 Chestnut St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006507.139280001 | 2120407.78108 | 37.802602889666794 | -122.421673924708 | (37.8026028896668, -122.421673924708) | |||
| 130118 | 130118 | 121971 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 106 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5991185.189040001 | 2114684.00966 | 37.7860111230721 | -122.474277122949 | (37.7860111230721, -122.474277122949) | |||
| 163369 | 163369 | 129540 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 586 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010689.62141 | 2115905.1759099998 | 37.7904747872294 | -122.406882837979 | (37.7904747872294, -122.406882837979) | |||
| 169559 | 169559 | 191421 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 785 Rhode Island St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6011879.919919999 | 2104709.23521 | 37.7597998340098 | -122.40197706591002 | (37.7597998340098, -122.40197706591) | |||
| 186716 | 186716 | 129538 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 586 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010716.07014 | 2115909.27019 | 37.7904875090489 | -122.406791615267 | (37.7904875090489, -122.406791615267) | |||
| 4 | 4 | 207368 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 920 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5992009.48044 | 2105269.9271 | 37.760210314285004 | -122.47073935813 | (37.760210314285, -122.47073935813) | |||
| 17499 | 17499 | 9990 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 33 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005438.43144 | 2108674.6093 | 37.7703261944175 | -122.424537099004 | (37.7703261944175, -122.424537099004) | |||
| 31087 | 31087 | 119029 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 767 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5982273.77271 | 2110527.62617 | 37.7740786267097 | -122.504799591882 | (37.7740786267097, -122.504799591882) | |||
| 37549 | 37549 | 129499 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2144 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002813.515269999 | 2118209.0658299997 | 37.7963568183789 | -122.43429841873501 | (37.7963568183789, -122.434298418735) | |||
| 39984 | 39984 | 129551 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6012074.07881 | 2115564.48535 | 37.789616701801 | -122.40206871312 | (37.789616701801, -122.40206871312) | |||
| 42723 | 42723 | 129514 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2730 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999183.84789 | 2118189.54872 | 37.796096542872206 | -122.446856379121 | (37.7960965428722, -122.446856379121) | |||
| 45735 | 45735 | 226654 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 220 Corbett Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999922.0088 | 2105601.51229 | 37.761575162283705 | -122.443397564951 | (37.7615751622837, -122.443397564951) | |||
| 47627 | 47627 | 191426 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1700 22nd St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6012934.525830001 | 2103813.36642 | 37.7573987772601 | -122.39826682196001 | (37.7573987772601, -122.39826682196) | ||||
| 52675 | 52675 | 191422 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 518 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 1ft | 6011739.544919999 | 2105950.9895099998 | 37.763201579013796 | -122.402549877375 | (37.7632015790138, -122.402549877375) | |||
| 63854 | 63854 | 129545 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 10 Miller Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6010092.54789 | 2116944.91924 | 37.7932962437837 | -122.409022077819 | (37.7932962437837, -122.409022077819) | |||
| 68161 | 68161 | 40706 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 758 Sweeny St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/10/1999 12:00:00 AM | 6 | Permit Number 41685 | 6006892.85232 | 2094109.9471200001 | 37.7304169754587 | -122.41847333918999 | (37.7304169754587, -122.41847333919) | |
| 131107 | 131107 | 129515 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2730 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999181.629430001 | 2118207.9413900003 | 37.7961469175038 | -122.44686537955 | (37.7961469175038, -122.44686537955) | |||
| 147166 | 147166 | 66159 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 90 Bay View St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/04/1990 12:00:00 AM | 6 | Permit Number 29230 | 6013889.68751 | 2094856.83218 | 37.732859178908 | -122.394336381736 | (37.732859178908, -122.394336381736) | |
| 156654 | 156654 | 177030 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 235 Ottawa Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5998356.41955 | 2089266.50528 | 37.7166337499183 | -122.447636347658 | (37.7166337499183, -122.447636347658) | |||
| 158427 | 158427 | 129506 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2644 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000302.575 | 2118552.44748 | 37.7971568138825 | -122.443011447325 | (37.7971568138825, -122.443011447325) | |||
| 165011 | 165011 | 120188 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 224 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5987762.7194300005 | 2114453.05727 | 37.785178126956396 | -122.486100829584 | (37.7851781269564, -122.486100829584) | |||
| 168068 | 168068 | 177032 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 663 University St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008682.45825 | 2090982.7781200001 | 37.7219310184866 | -122.41206547985901 | (37.7219310184866, -122.412065479859) | |||
| 179072 | 179072 | 53853 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 586 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1972 12:00:00 AM | 6 | Permit Number 9561 | 6010726.48535 | 2115910.4479900002 | 37.790491325756896 | -122.40675566215599 | (37.7904913257569, -122.406755662156) | ||
| 8152 | 8152 | 102822 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 347 Presidio Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 20638 | 5999052.21165 | 2115387.8752099997 | 37.7883963685539 | -122.44711013813401 | (37.7883963685539, -122.447110138134) | ||
| 8977 | 8977 | 60858 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 347 Presidio Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/1983 12:00:00 AM | 5 | 3x3 | Permit Number 20638 | 5999049.79752 | 2115408.40483 | 37.7884525995602 | -122.44711996863701 | (37.7884525995602, -122.447119968637) | |
| 32998 | 32998 | 129533 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 580 North Point St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6007551.84536 | 2121660.73903 | 37.806102049233395 | -122.41814759033701 | (37.8061020492334, -122.418147590337) | |||
| 36005 | 36005 | 59609 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 1063 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/26/1981 12:00:00 AM | 5 | Permit Number 19011 | 6015560.85054 | 2104166.3389 | 37.7585139078159 | -122.389208516653 | (37.7585139078159, -122.389208516653) | ||
| 36100 | 36100 | 226649 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 410 Valley St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003222.12075 | 2099233.47316 | 37.744277674881104 | -122.43152920021099 | (37.7442776748811, -122.431529200211) | |||
| 50062 | 50062 | 75146 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 240 07th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 5 | 6010085.43601 | 2111100.02376 | 37.7772471547732 | -122.408634170555 | (37.7772471547732, -122.408634170555) | ||
| 60497 | 60497 | 75390 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 240 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1994 12:00:00 AM | 5 | 6010035.62368 | 2111155.67227 | 37.77739716259529 | -122.40881041516501 | (37.7773971625953, -122.408810415165) |
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");