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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
133672 | 133672 | 249499 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1765 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005919.33859 | 2115875.5653 | 37.7901254069127 | -122.423385630445 | (37.7901254069127, -122.423385630445) | |||
66325 | 66325 | 249500 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1765 California St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005972.54693 | 2115883.04317 | 37.7901489421804 | -122.42320206534401 | (37.7901489421804, -122.423202065344) | |||
159256 | 159256 | 249501 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1765 California St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6006000.97948 | 2115886.86804 | 37.790161048840794 | -122.42310396280001 | (37.7901610488408, -122.4231039628) | |||
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) | |||
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) | |||
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) | ||
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) | ||
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) | |||
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) | |||
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) | |||
92559 | 92559 | 92776 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 2701 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
109480 | 109480 | 92778 | Permitted Site 1 | Ligustrum japonicum :: Japanese Privet 4 | 2701 Pacific Ave | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/15/2009 12:00:00 AM | Permit Number 52996 | 6001178.5 | 2116864.5 | 37.7925720539586 | -122.43985945141 | (37.7925720539586, -122.43985945141) | ||||
135694 | 135694 | 129558 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 300 California St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6012591.8685800005 | 2116885.11843 | 37.793271734566005 | -122.400370000791 | (37.793271734566, -122.400370000791) | |||
161411 | 161411 | 129557 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 300 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6012628.75569 | 2116888.8810400004 | 37.7932841227067 | -122.40024263249201 | (37.7932841227067, -122.400242632492) | |||
48699 | 48699 | 129547 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 13 Miller Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6010075.14286 | 2116919.1763 | 37.7932245849005 | -122.40908048339399 | (37.7932245849005, -122.409080483394) | |||
55659 | 55659 | 129546 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 13 Miller Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6010072.19276 | 2116933.78445 | 37.7932645300763 | -122.40909172222099 | (37.7932645300763, -122.409091722221) | |||
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) | |||
49684 | 49684 | 129501 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2857 Union St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 5999309.06977 | 2118008.46724 | 37.795606494203604 | -122.446410054597 | (37.7956064942036, -122.446410054597) | |||
161992 | 161992 | 129502 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2857 Union St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 1ft | 5999324.2861 | 2118011.40576 | 37.7956154316639 | -122.44635761511499 | (37.7956154316639, -122.446357615115) | |||
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) | |||
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) | |||
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) | |||
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) | |||
45848 | 45848 | 129548 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1 Saroyan Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6011012.0164 | 2118485.6729900003 | 37.7975782452004 | -122.405949226574 | (37.7975782452004, -122.405949226574) | |||
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) | |||
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) | |||
182054 | 182054 | 129505 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2644 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000286.7796 | 2118548.8617700003 | 37.7971460678835 | -122.44306584551501 | (37.7971460678835, -122.443065845515) | |||
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) | |||
160826 | 160826 | 129520 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6000447.31564 | 2118755.2398900003 | 37.7977218795107 | -122.442525177605 | (37.7977218795107, -122.442525177605) | |||
47655 | 47655 | 129519 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6000446.25144 | 2118762.17983 | 37.79774087408789 | -122.442529358545 | (37.7977408740879, -122.442529358545) | |||
165862 | 165862 | 129518 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3041 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6000446.00148 | 2118771.96061 | 37.797767715271796 | -122.44253092607 | (37.7977677152718, -122.44253092607) | |||
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) | |||
34884 | 34884 | 129516 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 3047 Divisadero St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6000442.909 | 2118797.59081 | 37.797837912738295 | -122.44254346802 | (37.7978379127383, -122.44254346802) | |||
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) | ||||
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) | |||
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) | |||
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) | |||
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) | |
27531 | 27531 | 129510 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2500 Chestnut St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 5999790.44594 | 2119530.29467 | 37.799812509208 | -122.444853861425 | (37.799812509208, -122.444853861425) | |||
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) | |||
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) | |||
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) | |||
66967 | 66967 | 129530 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1040 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6007879.71026 | 2119961.12323 | 37.8014537818135 | -122.416892463243 | (37.8014537818135, -122.416892463243) | |||
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) | |||
164863 | 164863 | 129537 | DPW Maintained 3 | Ligustrum japonicum :: Japanese Privet 4 | 1306x Montgomery St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011446.5417 | 2119990.51434 | 37.801734466528 | -122.404551630663 | (37.801734466528, -122.404551630663) | |||
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) | |||
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) | |||
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) | |||
187883 | 187883 | 129522 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1240 Lombard St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6006403.02216 | 2120103.20622 | 37.8017607330441 | -122.422012573438 | (37.8017607330441, -122.422012573438) | |||
24975 | 24975 | 129535 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1420 Montgomery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 6011436.62121 | 2120241.6491 | 37.802423466843294 | -122.404603649235 | (37.8024234668433, -122.404603649235) | |||
47134 | 47134 | 129521 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2222 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000122.02291 | 2120260.78291 | 37.8018371520253 | -122.443758994388 | (37.8018371520253, -122.443758994388) | |||
69137 | 69137 | 129536 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1440 Montgomery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6011432.08366 | 2120273.70789 | 37.8025112388511 | -122.40462160961599 | (37.8025112388511, -122.404621609616) | |||
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) | |||
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) | |||
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) | |||
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) | |||
150809 | 150809 | 129523 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1109 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006484.20699 | 2120406.53709 | 37.802598180831396 | -122.42175319366001 | (37.8025981808314, -122.42175319366) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
134626 | 134626 | 129532 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 2135 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009758.75399 | 2121832.78165 | 37.8066984049805 | -122.410522343935 | (37.8066984049805, -122.410522343935) |
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");