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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161949 | 161949 | 129517 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3047 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6000445.055869999 | 2118784.6129 | 37.7978024012088 | -122.442535107006 | (37.7978024012088, -122.442535107006) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 85596 | 85596 | 108938 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 431 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010275.9 | 2120590.4 | 37.8033161117204 | -122.408644952554 | (37.8033161117204, -122.408644952554) | |||
| 75267 | 75267 | 117692 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 435 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5982808.33309 | 2112832.48805 | 37.780438537012294 | -122.50312116344101 | (37.7804385370123, -122.503121163441) | |||
| 132877 | 132877 | 117693 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 435 42nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5982808.8484 | 2112817.53757 | 37.7803975176735 | -122.503118273577 | (37.7803975176735, -122.503118273577) | |||
| 31025 | 31025 | 129553 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012058.5984 | 2115646.10201 | 37.7898399378192 | -122.402128014397 | (37.7898399378192, -122.402128014397) | |||
| 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) | |||
| 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) | |||
| 40379 | 40379 | 129554 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012057.79655 | 2115657.86651 | 37.7898721955983 | -122.40213161617599 | (37.7898721955983, -122.402131616176) | |||
| 166908 | 166908 | 129552 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 44 Montgomery St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6012061.46033 | 2115633.25932 | 37.789804834569296 | -122.402117209065 | (37.7898048345693, -122.402117209065) | |||
| 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) | ||
| 72309 | 72309 | 226644 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 48 Cumberland St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005321.7767900005 | 2104616.40188 | 37.7591767333496 | -122.42465187767701 | (37.7591767333496, -122.424651877677) | |||
| 163344 | 163344 | 226643 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 48 Cumberland St | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6005334.035069999 | 2104616.89651 | 37.75917878378829 | -122.42460951781099 | (37.7591787837883, -122.424609517811) | |||
| 138207 | 138207 | 123058 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 500 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5991916.77661 | 2111982.4939599996 | 37.778635859363206 | -122.471549122693 | (37.7786358593632, -122.471549122693) | |||
| 168981 | 168981 | 123060 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 500 Funston Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5991917.4637 | 2111957.21563 | 37.7785664917216 | -122.47154490330601 | (37.7785664917216, -122.471544903306) | |||
| 170003 | 170003 | 123059 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 500 Funston Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5991916.7341 | 2111968.89129 | 37.7785985076866 | -122.47154827826901 | (37.7785985076866, -122.471548278269) | |||
| 26018 | 26018 | 207370 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 501x Ortega St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 5992545.91088 | 2103073.9348400002 | 37.754211699531005 | -122.46872432099501 | (37.754211699531, -122.468724320995) | |||
| 33936 | 33936 | 207369 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 501x Ortega St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 2ft | 5992541.8863 | 2103083.6869900003 | 37.7542382439023 | -122.468738948444 | (37.7542382439023, -122.468738948444) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 38963 | 38963 | 40933 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 516 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1999 12:00:00 AM | 3 | Permit Number 41796 | 5987525.4413 | 2112407.46828 | 37.7795476900895 | -122.486771463248 | (37.7795476900895, -122.486771463248) | ||
| 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) | |||
| 181690 | 181690 | 121987 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 524 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991287.8185 | 2111802.50892 | 37.7781052628966 | -122.47371177632799 | (37.7781052628966, -122.473711776328) | |||
| 147994 | 147994 | 45642 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 557 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/2001 12:00:00 AM | 3 | Permit Number 44345 | 5987489.41692 | 2112170.49335 | 37.778894923713395 | -122.486878678096 | (37.7788949237134, -122.486878678096) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 54794 | 54794 | 119044 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 591 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5982228.00989 | 2111743.54314 | 37.7774144867655 | -122.50504801740401 | (37.7774144867655, -122.505048017404) | |||
| 130268 | 130268 | 177038 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 649 Hamilton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009808.87936 | 2091375.19794 | 37.7230716583033 | -122.40819937261801 | (37.7230716583033, -122.408199372618) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 73064 | 73064 | 123375 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 757 03rd Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 5995016.33653 | 2110447.72713 | 37.7746006270727 | -122.460715372994 | (37.7746006270727, -122.460715372994) | ||||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 178970 | 178970 | 118574 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 7900 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5982449.98783 | 2112431.50605 | 37.779316488746 | -122.50433111328199 | (37.779316488746, -122.504331113282) | |||
| 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) | |||
| 79224 | 79224 | 96951 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 798X 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5988521.53055 | 2110635.12143 | 37.7747393420729 | -122.48319565729601 | (37.7747393420729, -122.483195657296) | |||
| 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) | ||||
| 154592 | 154592 | 117871 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 850 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5983579.8283400005 | 2110008.29889 | 37.7727294500776 | -122.500243389783 | (37.7727294500776, -122.500243389783) | |||
| 171149 | 171149 | 191423 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 872 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6011836.2577599995 | 2104328.91927 | 37.758753133763705 | -122.402101335126 | (37.7587531337637, -122.402101335126) | |||
| 178419 | 178419 | 191431 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 9 Sumner St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6009550.82105 | 2110763.25421 | 37.7762925082147 | -122.410459796982 | (37.7762925082147, -122.410459796982) | |||
| 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) | |
| 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) | |||
| 133340 | 133340 | 226641 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 953 Treat Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6008623.395269999 | 2103036.69536 | 37.7550251300303 | -122.413121556411 | (37.7550251300303, -122.413121556411) |
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");