Street_Tree_List

Data source: data.sfgov.org

233 rows where qSiteInfo = 2 and qSpecies = 46 sorted by Latitude

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: SiteOrder, DBH, PlotSize

qSiteInfo ✖

  • Sidewalk: Curb side : Yard · 233 ✖
Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude ▼ Longitude Location
150445 150445 180561 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1134 Naples St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 8ft   6001348.51244 2087850.78247 37.712917038962495 -122.437192888562 (37.7129170389625, -122.437192888562)
165192 165192 180560 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1134 Naples St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     15 Width 8ft   6001363.50733 2087875.35573 37.7129853640648 -122.437142819708 (37.7129853640648, -122.437142819708)
43463 43463 215571 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 32 Malta Dr 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 3ft   5999675.11481 2095972.7575700001 37.7351228462426 -122.443559761297 (37.7351228462426, -122.443559761297)
133254 133254 215479 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 85 Santa Ana Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 8ft   5992627.2877 2096233.3886799999 37.7354340044744 -122.467945378584 (37.7354340044744, -122.467945378584)
131907 131907 215515 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 299 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993879.1268 2096286.34679 37.735651625116795 -122.463621177382 (37.7356516251168, -122.463621177382)
74578 74578 215514 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 299 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993902.7407599995 2096288.82132 37.7356597801802 -122.463539714991 (37.7356597801802, -122.463539714991)
56932 56932 215513 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 299 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993924.28661 2096292.23015 37.7356703813878 -122.463465470563 (37.7356703813878, -122.463465470563)
170673 170673 215512 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 299 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993946.596609999 2096298.3133099999 37.7356883696217 -122.463388778181 (37.7356883696217, -122.463388778181)
49155 49155 215568 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 262 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993854.87202 2096314.6537799998 37.735727951492294 -122.463707088708 (37.7357279514923, -122.463707088708)
47189 47189 215569 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 262 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993829.85654 2096316.71457 37.735732168414 -122.46379372579901 (37.735732168414, -122.463793725799)
33717 33717 215511 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 299 Santa Paula Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5993997.50574 2096315.53912 37.73573860035479 -122.463214016518 (37.7357386003548, -122.463214016518)
62362 62362 215567 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 254 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993893.11792 2096318.4579099999 37.735740600456 -122.46357513479201 (37.735740600456, -122.463575134792)
153089 153089 215510 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 299 Santa Paula Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   5994019.7098199995 2096325.7252599997 37.73576784809 -122.463137987822 (37.73576784809, -122.463137987822)
24162 24162 215566 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 250 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993936.1007 2096327.5375 37.735768007292705 -122.463427186434 (37.7357680072927, -122.463427186434)
63775 63775 200790 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1582 McKinnon Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 0ft   6015482.0599 2095886.5322 37.735774914559 -122.38890295979799 (37.735774914559, -122.388902959798)
167961 167961 215565 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 250 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993953.18487 2096333.32123 37.7357848722665 -122.46336853982099 (37.7357848722665, -122.463368539821)
109259 109259 215564 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 250 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993972.9824 2096339.8161099998 37.7358038461725 -122.463300563692 (37.7358038461725, -122.463300563692)
188770 188770 215509 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 265 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994040.687530001 2096338.7929099998 37.7358049370452 -122.46306640808201 (37.7358049370452, -122.463066408082)
135165 135165 215563 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 244 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5993985.88408 2096348.3750200002 37.735828090088894 -122.463256578734 (37.7358280900889, -122.463256578734)
74354 74354 200792 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1582 McKinnon Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 0ft   6015444.6863 2095914.5624 37.735849808179296 -122.389034132513 (37.7358498081793, -122.389034132513)
173974 173974 215508 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 261 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994073.52001 2096368.39822 37.7358881171279 -122.462955041436 (37.7358881171279, -122.462955041436)
131337 131337 215562 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 244 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994036.57489 2096375.72 37.735906092783 -122.463083305449 (37.735906092783, -122.463083305449)
50663 50663 215561 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 240 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994051.56415 2096391.9131599998 37.7359514186289 -122.46303265654899 (37.7359514186289, -122.463032656549)
148557 148557 215480 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 55 Santa Ana Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 8ft   5992620.877830001 2096424.4716400001 37.7359583002413 -122.467981434219 (37.7359583002413, -122.467981434219)
68154 68154 215507 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 255 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994095.64493 2096399.41615 37.735974559073604 -122.462880797029 (37.7359745590736, -122.462880797029)
181242 181242 215560 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 240 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994063.02887 2096405.4928599999 37.7359893655189 -122.462994003686 (37.7359893655189, -122.462994003686)
170224 170224 215559 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 240 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994067.05947 2096413.8540400001 37.7360125554181 -122.46298067483102 (37.7360125554181, -122.462980674831)
181522 181522 215506 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 255 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994105.35353 2096421.48762 37.7360357210632 -122.46284883151199 (37.7360357210632, -122.462848831512)
26007 26007 215558 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 240 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994076.83101 2096438.6024200001 37.7360810711916 -122.46294868592699 (37.7360810711916, -122.462948685927)
177068 177068 215505 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 245 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994112.73436 2096460.53675 37.7361433654214 -122.462826145227 (37.7361433654214, -122.462826145227)
137176 137176 215557 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 230 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994081.97838 2096463.44747 37.7361495860356 -122.462932691498 (37.7361495860356, -122.462932691498)
151862 151862 215504 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 235 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 4ft   5994113.803830001 2096483.0865200001 37.736205343103705 -122.462824083076 (37.7362053431037, -122.462824083076)
185782 185782 215556 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 230 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5994083.61734 2096486.4471099998 37.736212831753896 -122.46292869311701 (37.7362128317539, -122.462928693117)
28058 28058 215555 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 230 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994079.01038 2096505.73845 37.7362655356317 -122.46294602033701 (37.7362655356317, -122.462946020337)
59643 59643 215503 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 233 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994106.38436 2096527.49502 37.736326850502294 -122.46285295579901 (37.7363268505023, -122.462852955799)
64525 64525 215554 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 224 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994072.66196 2096533.8959299999 37.736342483419705 -122.462970011551 (37.7363424834197, -122.462970011551)
48305 48305 215502 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 225 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994102.838830001 2096543.31026 37.7363700710175 -122.462866361103 (37.7363700710175, -122.462866361103)
24337 24337 198558 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1709 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6014602.581680001 2096122.3818299999 37.73637372225429 -122.391960171423 (37.7363737222543, -122.391960171423)
168657 168657 198524 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1709 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014591.36063 2096131.8328599997 37.7363990498707 -122.391999628307 (37.7363990498707, -122.391999628307)
155291 155291 215553 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 224 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   5994066.55371 2096555.1384299998 37.736400458215 -122.46299267090099 (37.736400458215, -122.462992670901)
73770 73770 198559 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1708 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6014669.54022 2096142.63764 37.7364330577276 -122.39173008170201 (37.7364330577276, -122.391730081702)
59944 59944 198525 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1700 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014663.37225 2096146.01075 37.736441977203995 -122.391751642923 (37.736441977204, -122.391751642923)
161771 161771 198523 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1721 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6014565.5806599995 2096150.99697 37.7364502392755 -122.392090100993 (37.7364502392755, -122.392090100993)
172471 172471 198556 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1721 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6014562.239130001 2096154.4115400002 37.736459429456794 -122.392101892885 (37.7364594294568, -122.392101892885)
31013 31013 198560 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1708 Newcomb Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6014655.2828 2096153.01044 37.7364607478562 -122.39178010106899 (37.7364607478562, -122.391780101069)
171175 171175 215501 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 225 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994092.6368 2096583.0249700001 37.7364785301452 -122.462904513945 (37.7364785301452, -122.462904513945)
76234 76234 198526 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1700 Newcomb Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014646.0524 2096160.0564599999 37.736479582376 -122.391812507248 (37.736479582376, -122.391812507248)
74462 74462 215552 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 220 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994058.81672 2096590.6188599998 37.73649743301171 -122.463021994195 (37.7364974330117, -122.463021994195)
39339 39339 198561 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1708 Newcomb Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6014636.301940001 2096168.28095 37.7365016238531 -122.391846793904 (37.7365016238531, -122.391846793904)
185967 185967 198527 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1700 Newcomb Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6014634.66691 2096168.3212099997 37.736501643630795 -122.39185244975599 (37.7365016436308, -122.391852449756)
149918 149918 198528 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1712 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 7ft   6014599.09575 2096195.7007900001 37.736574847558295 -122.39197734938601 (37.7365748475583, -122.391977349386)
69805 69805 198553 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1731 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 4ft   6014499.16672 2096200.32532 37.736581997166205 -122.392323172901 (37.7365819971662, -122.392323172901)
129804 129804 198557 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1712 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6014596.8944 2096198.8509099998 37.7365833749264 -122.391985180675 (37.7365833749264, -122.391985180675)
158886 158886 198521 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1737 Newcomb Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 7ft   6014485.10287 2096211.0948599998 37.7366107871579 -122.39237255107099 (37.7366107871579, -122.392372551071)
27525 27525 215551 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 212 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994048.13405 2096632.6874900002 37.7366123276804 -122.46306197983401 (37.7366123276804, -122.463061979834)
25994 25994 198552 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1737 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6014479.14008 2096215.50605 37.7366225682648 -122.39239347560499 (37.7366225682648, -122.392393475605)
131093 131093 198520 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1737 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 7ft   6014468.3432 2096223.93289 37.7366451070745 -122.392431394602 (37.7366451070745, -122.392431394602)
61140 61140 198551 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1739 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6014460.695 2096227.3713599998 37.736654123686705 -122.392458078374 (37.7366541236867, -122.392458078374)
25770 25770 198550 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1743 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 4ft   6014437.8332 2096238.2314099998 37.736682673554895 -122.392537881536 (37.7366826735549, -122.392537881536)
137036 137036 198519 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1743 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 7ft   6014430.37923 2096250.7581099998 37.7367166553422 -122.39256452932699 (37.7367166553422, -122.392564529327)
33160 33160 215550 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 200 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994032.03336 2096692.14483 37.7367746553097 -122.463121959218 (37.7367746553097, -122.463121959218)
143698 143698 215500 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 223 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 4ft   5994062.94348 2096703.04121 37.736806354618004 -122.46301588057301 (37.736806354618, -122.463015880573)
59161 59161 198549 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1742 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   6014473.930819999 2096284.0177200001 37.73681039796789 -122.39241627700899 (37.7368103979679, -122.392416277009)
36619 36619 215549 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 200 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994024.47246 2096717.6403700002 37.7368442241821 -122.463149949734 (37.7368442241821, -122.463149949734)
179616 179616 198546 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1759 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6014355.59614 2096302.28152 37.7368539746257 -122.39282669249901 (37.7368539746257, -122.392826692499)
54689 54689 198548 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1748 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6014451.76229 2096301.9779599998 37.7368584820264 -122.39249417986 (37.7368584820264, -122.39249417986)
154449 154449 198530 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1748 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014455.10696 2096302.51395 37.7368601394856 -122.39248265324899 (37.7368601394856, -122.392482653249)
181781 181781 198545 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1763 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 4ft   6014347.46676 2096307.9182900002 37.736869000500995 -122.392855193808 (37.736869000501, -122.392855193808)
53945 53945 198518 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1759 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 7ft   6014349.89775 2096310.6445799998 37.7368766213595 -122.392846979413 (37.7368766213595, -122.392846979413)
133047 133047 215548 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 200 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994023.18881 2096729.95205 37.736877955053295 -122.463155280903 (37.7368779550533, -122.463155280903)
74748 74748 198547 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1750 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6014431.1753 2096316.6231 37.73689755128171 -122.392566382859 (37.7368975512817, -122.392566382859)
29855 29855 198531 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1750 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014434.12864 2096316.99865 37.736898746479895 -122.392556198035 (37.7368987464799, -122.392556198035)
129816 129816 198516 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1763 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 7ft   6014335.026380001 2096322.17337 37.736907451020606 -122.392899203062 (37.7369074510206, -122.392899203062)
39650 39650 215547 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 200 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5994018.95115 2096748.4675900002 37.7369285500121 -122.46317127533999 (37.7369285500121, -122.46317127534)
160048 160048 198542 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1762 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 3ft   6014379.25839 2096358.1696400002 37.7370087461611 -122.39274878964301 (37.7370087461611, -122.392748789643)
135251 135251 198533 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1762 Newcomb Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 7ft   6014374.32844 2096361.3025900002 37.737017074781896 -122.392766053934 (37.7370170747819, -122.392766053934)
164412 164412 198541 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1766 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6014350.02594 2096380.1036099999 37.737067348687404 -122.39285139418502 (37.7370673486874, -122.392851394185)
61085 61085 198534 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1766 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 7ft   6014341.63524 2096385.88519 37.7370827576597 -122.392880809218 (37.7370827576597, -122.392880809218)
26682 26682 198540 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1770 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6014330.01059 2096395.8315299999 37.7371094225658 -122.39292169687401 (37.7371094225658, -122.392921696874)
150324 150324 198535 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1770 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6014325.04496 2096399.73326 37.73711986009079 -122.392939138341 (37.7371198600908, -122.392939138341)
76754 76754 198539 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1774 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 4ft   6014319.22336 2096405.90013 37.7371364696747 -122.392959697748 (37.7371364696747, -122.392959697748)
186460 186460 198536 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 1782 Newcomb Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6014278.07437 2096434.6477400002 37.7372131188949 -122.393103980488 (37.7372131188949, -122.393103980488)
184959 184959 215546 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 95 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993989.2635699995 2097198.82691 37.738163414500605 -122.463306588246 (37.7381634145006, -122.463306588246)
39846 39846 215499 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 95 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993991.18061 2097202.58443 37.738173842158105 -122.463300232714 (37.7381738421581, -122.463300232714)
47464 47464 215545 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 90 Santa Paula Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft   5993953.28384 2097231.84575 37.7382520031164 -122.46343338275899 (37.7382520031164, -122.463433382759)
32806 32806 215544 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 90 Santa Paula Ave 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993951.56494 2097251.7365 37.738306519129 -122.46344076888398 (37.738306519129, -122.463440768884)
162282 162282 215543 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 90 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993948.48206 2097274.4923 37.738368823268296 -122.46345307882 (37.7383688232683, -122.46345307882)
27464 27464 215498 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 95 Santa Paula Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993979.5407 2097285.08347 37.7383996933922 -122.46334646239201 (37.7383996933922, -122.463346462392)
175108 175108 215542 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 90 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993945.302519999 2097292.64109 37.7384184721345 -122.463465388735 (37.7384184721345, -122.463465388735)
164646 164646 215541 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 90 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993946.31928 2097307.1562900003 37.73845838583971 -122.463462926386 (37.7384583858397, -122.463462926386)
120433 120433 215497 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 73 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993976.24019 2097340.1859999998 37.738550801067 -122.46336187137 (37.738550801067, -122.46336187137)
27511 27511 215496 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 69 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993975.721530001 2097357.94979 37.7385995461283 -122.46336495334299 (37.7385995461283, -122.463364953343)
179962 179962 215540 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 80 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993944.908340001 2097392.63187 37.7386929991944 -122.46347400603001 (37.7386929991944, -122.46347400603)
176765 176765 215495 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 69 Santa Paula Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993977.518540001 2097401.11032 37.7387181577226 -122.46336187135401 (37.7387181577226, -122.463361871354)
33083 33083 215539 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 70 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993947.30597 2097439.0269400002 37.73882052663561 -122.463469082233 (37.7388205266356, -122.463469082233)
172608 172608 215494 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 61 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993979.60004 2097443.67302 37.7388351442124 -122.463357762357 (37.7388351442124, -122.463357762357)
38137 38137 215538 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 66 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 3ft   5993953.054409999 2097475.42453 37.7389207965449 -122.46345184763099 (37.7389207965449, -122.463451847631)
174423 174423 215537 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 66 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993955.64334 2097496.99749 37.7389801796769 -122.463444461504 (37.7389801796769, -122.463444461504)
134274 134274 215493 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 51 Santa Paula Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993987.93159 2097500.89824 37.7389927504044 -122.46333310743601 (37.7389927504044, -122.463333107436)
157065 157065 215536 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 56 Santa Paula Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 3ft   5993957.82429 2097516.0973 37.739032748648796 -122.463438306534 (37.7390327486488, -122.463438306534)

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