Street_Tree_List

Data source: data.sfgov.org

171 rows where qSpecies = 4 sorted by DBH

✎ 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
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)
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)
48397 48397 35353 Permitted Site 1 Ligustrum japonicum :: Japanese Privet 4 1023 Kansas St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/25/2013 12:00:00 AM 1   Permit Number 770231 6011656.23225 2103580.2473299997 37.7566873964196 -122.40267130024999 (37.7566873964196, -122.40267130025)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
44640 44640 58940 Permitted Site 1 Ligustrum japonicum :: Japanese Privet 4 1360 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/30/2005 12:00:00 AM 2   Permit Number 18218 6011963.90217 2102042.40825 37.7524820001659 -122.40149918233801 (37.7524820001659, -122.401499182338)
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)
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)
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)
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)
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)
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)
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)
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)
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)
172460 172460 75304 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 240 07th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/10/1994 12:00:00 AM 2     6010043.764880001 2111144.47071 37.7773668617363 -122.408781461497 (37.7773668617363, -122.408781461497)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
93337 93337 15295 DPW Maintained 3 Ligustrum japonicum :: Japanese Privet 4 1625 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/02/1995 12:00:00 AM 3 3X3   6006990.727390001 2109176.21889 37.771791036290296 -122.41920328508002 (37.7717910362903, -122.41920328508)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
133137 133137 191429 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 2399 Lane St 7 Side Yard : Yard 17 Tree 1 Private 1     4     6013991.75526 2092879.9064599997 37.7274366158882 -122.393845172923 (37.7274366158882, -122.393845172923)
150604 150604 177029 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 123 Seneca Ave 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     4 Width 0ft   6000050.7624699995 2090072.63848 37.7189438978236 -122.441837691751 (37.7189438978236, -122.441837691751)
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)
166596 166596 207366 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1263 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   5990777.74909 2106795.52344 37.7643278872345 -122.475110663153 (37.7643278872345, -122.475110663153)
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)
170716 170716 218286 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 1 Woodacre Dr 10 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4     5991335.90639 2095594.8050900002 37.7336059570417 -122.472363586812 (37.7336059570417, -122.472363586812)
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)
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)
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)
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)
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)
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)
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)
75992 75992 75228 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 240 07th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/10/1994 12:00:00 AM 5     6010065.6483 2111120.54922 37.7773024046157 -122.408704071262 (37.7773024046157, -122.408704071262)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)

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 65.654ms · Data source: data.sfgov.org