Street_Tree_List

Data source: data.sfgov.org

171 rows where qSpecies = 4 sorted by PlotSize descending

✎ View and edit SQL

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
37851 37851 226637 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1199 Capp St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 9ft   6007225.3101699995 2100622.72822 37.7483183396245 -122.417785447755 (37.7483183396245, -122.417785447755)
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)
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)
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)
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)
64468 64468 191428 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 22 Robblee Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 5ft   6012599.814780001 2095974.63355 37.735856643564404 -122.39887425376001 (37.7358566435644, -122.39887425376)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
170102 170102 207365 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1678 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5990916.62821 2103981.8612 37.756610367702706 -122.47442498042601 (37.7566103677027, -122.474424980426)
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)
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)
174209 174209 191427 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1627 20th St 1 : 4 Tree 1 Private 1     4 Width 3ft   6013091.09687 2104712.62895 37.7598766756903 -122.39778840962099 (37.7598766756903, -122.397788409621)
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)
180697 180697 129556 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 216 Post St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6011025.30596 2115257.2463 37.7887145046082 -122.405675728365 (37.7887145046082, -122.405675728365)
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)
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)
182512 182512 129555 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 216 Post St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     1 Width 3ft   6011031.64459 2115258.30549 37.7887177673445 -122.40565387214599 (37.7887177673445, -122.405653872146)
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)
188033 188033 226640 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 10 Crescent Ave 2 Side Yard : Yard 17 Tree 1 Private 1     4 Width 3ft   6005282.96903 2095902.7994400002 37.7352489878562 -122.42416639485799 (37.7352489878562, -122.424166394858)
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)
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)
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)
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)
35462 35462 129513 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 25 Heather Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 2ft   5997331.52493 2114270.89109 37.785230964483105 -122.45298274796998 (37.7852309644831, -122.45298274797)
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)
37818 37818 226638 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 201 Coso Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 2ft   6007716.3532 2099510.6976099997 37.74529257420679 -122.41600868956301 (37.7452925742068, -122.416008689563)
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)
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)
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)
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)
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)
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)
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)
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)
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)
65210 65210 226642 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 14 Cumberland St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     2 Width 2ft   6005484.04077 2104618.2918599998 37.759191085608 -122.42409082483101 (37.759191085608, -122.424090824831)
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)
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)
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)
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)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 68.428ms · Data source: data.sfgov.org