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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
66415 | 66415 | 215487 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 25 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994042.19305 | 2097679.65263 | 37.7394866913615 | -122.46315846449 | (37.7394866913615, -122.46315846449) | |||
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) | |||
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) | |||
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) | |||
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) | |||
64606 | 64606 | 215486 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 25 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994053.65956 | 2097702.19422 | 37.739549245488796 | -122.46312045374901 | (37.7395492454888, -122.463120453749) | |||
36418 | 36418 | 215485 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 21 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994064.51337 | 2097723.86139 | 37.7396093633696 | -122.46308449795299 | (37.7396093633696, -122.463084497953) | |||
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) | |||
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) | |||
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) | |||
71554 | 71554 | 215528 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994077.87758 | 2097807.84952 | 37.7398407436586 | -122.46304438280501 | (37.7398407436586, -122.463044382805) | |||
28099 | 28099 | 215484 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 21 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994076.92667 | 2097749.04597 | 37.739679229001496 | -122.46304340523001 | (37.7396792290015, -122.46304340523) | |||
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) | |||
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) | |||
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) | |||
159900 | 159900 | 215527 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5994087.51719 | 2097826.08343 | 37.739891364696895 | -122.463012375939 | (37.7398913646969, -122.463012375939) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
37359 | 37359 | 215483 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994103.6572 | 2097790.09327 | 37.7397934743851 | -122.46295396047199 | (37.7397934743851, -122.462953960472) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
180262 | 180262 | 215482 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5994118.54253 | 2097814.9092900003 | 37.7398624703831 | -122.462904293614 | (37.7398624703831, -122.462904293614) | |||
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) | |||
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) | |||
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) | |||
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) | |||
35801 | 35801 | 215481 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5994138.58821 | 2097841.54459 | 37.739936758872204 | -122.462836916405 | (37.7399367588722, -122.462836916405) | |||
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) | |||
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) | |||
188123 | 188123 | 215516 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 88 Keystone Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994119.69741 | 2093345.3808900001 | 37.7275903136211 | -122.462576174158 | (37.7275903136211, -122.462576174158) | |||
30311 | 30311 | 56524 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 623 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5994686.99201 | 2111263.70978 | 37.776822144368 | -122.461913814497 | (37.776822144368, -122.461913814497) | ||||
171432 | 171432 | 113444 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 742 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5994761.5711 | 2110535.58365 | 37.7748271966325 | -122.461603021673 | (37.7748271966325, -122.461603021673) | |||
40244 | 40244 | 113443 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 742 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5994762.07163 | 2110522.4331099996 | 37.7747911175465 | -122.46160033660699 | (37.7747911175465, -122.461600336607) | |||
107475 | 107475 | 110612 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 15 MAGELLAN AVE | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775412 | 5994586.0 | 2101167.0 | 37.7490933856104 | -122.46153099469801 | (37.7490933856104, -122.461530994698) | ||
149318 | 149318 | 36939 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 106 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/29/1998 12:00:00 AM | 14 | Permit Number 39578 | 5994917.29896 | 2114783.54641 | 37.78649992768511 | -122.461372345087 | (37.7864999276851, -122.461372345087) | |
159402 | 159402 | 215525 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 478 Dewey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994741.9738 | 2100056.97706 | 37.746054518502895 | -122.460911199901 | (37.7460545185029, -122.460911199901) | |||
180179 | 180179 | 215526 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 478 Dewey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 5994752.10675 | 2100066.65325 | 37.7460816699447 | -122.460876862898 | (37.7460816699447, -122.460876862898) | |||
109476 | 109476 | 19301 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5995247.10654 | 2111496.409 | 37.7774933045144 | -122.459993084378 | (37.7774933045144, -122.459993084378) | |||
103372 | 103372 | 81863 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.729301806319704 | -122.459920577502 | (37.7293018063197, -122.459920577502) | ||
69582 | 69582 | 123690 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 36 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995350.47696 | 2113583.46561 | 37.7832297501219 | -122.459786707236 | (37.7832297501219, -122.459786707236) | |||
147833 | 147833 | 123691 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 35 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995371.26757 | 2113529.88581 | 37.7830838299438 | -122.45971089838801 | (37.7830838299438, -122.459710898388) | |||
152615 | 152615 | 123689 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 32 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995378.065669999 | 2113584.47155 | 37.783234098680296 | -122.45969133488501 | (37.7832340986803, -122.459691334885) | |||
156497 | 156497 | 123688 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 26 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995407.44637 | 2113586.67183 | 37.7832418295416 | -122.45958984952699 | (37.7832418295416, -122.459589849527) | |||
170681 | 170681 | 123687 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 24 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995428.99259 | 2113586.04452 | 37.7832413460359 | -122.459515263281 | (37.7832413460359, -122.459515263281) | |||
35154 | 35154 | 123692 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 11 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5995433.731430001 | 2113533.85695 | 37.7830983254289 | -122.45949508803699 | (37.7830983254289, -122.459495088037) | |||
164598 | 164598 | 123686 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 14 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995454.47999 | 2113587.9744700002 | 37.7832481106401 | -122.459427227483 | (37.7832481106401, -122.459427227483) | |||
179766 | 179766 | 123693 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 9 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5995461.176580001 | 2113536.44974 | 37.7831070225625 | -122.45940032745101 | (37.7831070225625, -122.459400327451) | |||
73654 | 73654 | 123685 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 8 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995474.7934 | 2113587.5491 | 37.7832481106245 | -122.459356920862 | (37.7832481106245, -122.459356920862) | |||
74854 | 74854 | 123694 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 7 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995476.231380001 | 2113538.07017 | 37.7831123374099 | -122.45934836169701 | (37.7831123374099, -122.459348361697) | |||
97468 | 97468 | 52332 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 20 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48483 | 5995128.56023296 | 2096158.11276055 | 37.7353714395789 | -122.45929215094101 | (37.7353714395789, -122.459292150941) | ||||
30837 | 30837 | 123696 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995493.19231 | 2113537.8911 | 37.7831128208781 | -122.45928967118799 | (37.7831128208781, -122.459289671188) | |||
155708 | 155708 | 123695 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1 Clement St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995508.22475 | 2113538.45627 | 37.7831152369297 | -122.459237706338 | (37.7831152369297, -122.459237706338) | |||
70174 | 70174 | 124598 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3999 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 5995587.6492800005 | 2115135.34669 | 37.7875044349012 | -122.45907859763399 | (37.7875044349012, -122.459078597634) | |||
64836 | 64836 | 124680 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3885 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5995618.999559999 | 2115788.29783 | 37.7892990644884 | -122.459017428632 | (37.7892990644884, -122.459017428632) | |||
156401 | 156401 | 43942 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3885 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/2000 12:00:00 AM | 11 | Permit Number 43530 | 5995636.78457 | 2115791.89347 | 37.789309959494204 | -122.45895615544701 | (37.7893099594942, -122.458956155447) | ||
150723 | 150723 | 215523 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 80 Northwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5995460.486769999 | 2094242.81923 | 37.7301315873058 | -122.458006001202 | (37.7301315873058, -122.458006001202) | |||
98502 | 98502 | 40800 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 167 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1999 12:00:00 AM | Permit Number 41749 | 5995317.58858632 | 2087395.72139247 | 37.711322874409596 | -122.458004690935 | (37.7113228744096, -122.458004690935) | |||
48967 | 48967 | 47103 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3173 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2002 12:00:00 AM | 9 | Permit Number 45084 | 5995821.54315 | 2111362.39485 | 37.777158358184295 | -122.45799622921801 | (37.7771583581843, -122.457996229218) | ||
157153 | 157153 | 215524 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 80 Northwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5995481.220919999 | 2094239.1346200001 | 37.730122661531205 | -122.457934054513 | (37.7301226615312, -122.457934054513) | |||
50126 | 50126 | 215570 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 96 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5995600.39767 | 2096198.59734 | 37.7355097165874 | -122.457663772269 | (37.7355097165874, -122.457663772269) | |||
130639 | 130639 | 136976 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 340 Cherry St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996232.2691 | 2114976.93638 | 37.7871065186035 | -122.456836895121 | (37.7871065186035, -122.456836895121) | |||
40626 | 40626 | 136975 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 340 Cherry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5996232.67992 | 2114967.11027 | 37.7870795623305 | -122.456834762835 | (37.7870795623305, -122.456834762835) | |||
151867 | 151867 | 141076 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 189 COMMONWEALTH AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5996534.5761 | 2113062.8589 | 37.781868325512704 | -122.45565257993401 | (37.7818683255127, -122.455652579934) | |||
78358 | 78358 | 1208 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3141 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5995992.87885 | 2086942.4061599998 | 37.7101169521706 | -122.455637985173 | (37.7101169521706, -122.455637985173) | |||
152569 | 152569 | 74234 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3695 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 13 | 5997222.04614 | 2115031.5317599997 | 37.787313207081795 | -122.45341644603 | (37.7873132070818, -122.45341644603) | ||
33611 | 33611 | 72449 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3687 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 11 | 5997241.71464 | 2115032.69529 | 37.7873175292136 | -122.45334848155899 | (37.7873175292136, -122.453348481559) | ||
151038 | 151038 | 72448 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3681 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 11 | 5997285.67318 | 2115040.09705 | 37.7873403720155 | -122.45319692960899 | (37.7873403720155, -122.453196929609) | ||
111950 | 111950 | 114306 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 STANYAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997219.0 | 2107398.0 | 37.7663533458689 | -122.45287579158399 | (37.7663533458689, -122.452875791584) | ||||
34676 | 34676 | 242606 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 906 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997226.54796 | 2107348.00991 | 37.7662165183906 | -122.45284607618099 | (37.7662165183906, -122.452846076181) | |||
42458 | 42458 | 242448 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1157 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5997336.0067 | 2106240.14847 | 37.7631808847241 | -122.452387528971 | (37.7631808847241, -122.452387528971) | |||
160503 | 160503 | 73760 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3485 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 10 | 5997597.70095 | 2116065.74811 | 37.7901744154595 | -122.452191417426 | (37.7901744154595, -122.452191417426) | ||
11281 | 11281 | 1166 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.1618700002 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | ||
75118 | 75118 | 53259 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 210 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1969 12:00:00 AM | 15 | Permit Number 6149 | 5997600.12702 | 2115607.0052799997 | 37.7889149689082 | -122.452149910107 | (37.7889149689082, -122.452149910107) | ||
69807 | 69807 | 72412 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3485 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1996 12:00:00 AM | 10 | 5997617.1015 | 2116066.53919 | 37.7901776988858 | -122.452124350462 | (37.7901776988858, -122.452124350462) | ||
147164 | 147164 | 215518 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 278 Howth St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5997249.4841 | 2090499.4445099998 | 37.719955788905295 | -122.451551333026 | (37.7199557889053, -122.451551333026) | |||
78526 | 78526 | 97030 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 278 Howth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5997252.0 | 2090493.0 | 37.7199382378616 | -122.451542171872 | (37.7199382378616, -122.451542171872) | |||
88397 | 88397 | 48676 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4930 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2006 12:00:00 AM | Permit Number 48856 | 5997717.95296797 | 2105658.6000715 | 37.7616059742438 | -122.451024572529 | (37.7616059742438, -122.451024572529) | ||
72890 | 72890 | 215517 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 164 Howth St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5997515.643519999 | 2090995.9765400002 | 37.7213343884584 | -122.450667096231 | (37.7213343884584, -122.450667096231) | |||
64122 | 64122 | 242453 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 140 Belgrave Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 2ft | 5997900.49529 | 2104918.67096 | 37.7595847638524 | -122.45033989586399 | (37.7595847638524, -122.450339895864) | |||
123733 | 123733 | 68197 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 417 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/1993 12:00:00 AM | 7 | Permit Number 31977 | 5998129.56207 | 2114980.61061 | 37.787225368503606 | -122.450272974611 | (37.7872253685036, -122.450272974611) | ||
28845 | 28845 | 242449 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 150 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5997972.72284 | 2105963.31603 | 37.7624572299272 | -122.450165395921 | (37.7624572299272, -122.450165395921) | |||
148743 | 148743 | 62667 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 438 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50321 | 5998175.4126699995 | 2114969.52536 | 37.7871975551779 | -122.45011354281 | (37.7871975551779, -122.45011354281) | |
56531 | 56531 | 242450 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998044.50081 | 2105941.804 | 37.7624022705703 | -122.44991559303001 | (37.7624022705703, -122.44991559303) | |||
56784 | 56784 | 242451 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5998061.5561 | 2105942.80556 | 37.7624059964569 | -122.449856677554 | (37.7624059964569, -122.449856677554) | |||
100335 | 100335 | 87288 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096.0 | 2105951.0 | 37.762430467017204 | -122.44973813994801 | (37.7624304670172, -122.449738139948) | ||
106821 | 106821 | 87287 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 131 Rivoli St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2007 12:00:00 AM | 3x3 | Permit Number 50304 | 5998096.0 | 2105951.0 | 37.762430467017204 | -122.44973813994801 | (37.7624304670172, -122.449738139948) | ||
164969 | 164969 | 136977 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 304 Walnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5998585.82745 | 2115521.2848799997 | 37.788736018186604 | -122.448733358666 | (37.7887360181866, -122.448733358666) | |||
157194 | 157194 | 136978 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 304 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998590.88562 | 2115470.38196 | 37.7885965414477 | -122.448712190427 | (37.7885965414477, -122.448712190427) | |||
50521 | 50521 | 136979 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 304 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5998594.20506 | 2115439.35857 | 37.7885115492204 | -122.448698470366 | (37.7885115492204, -122.448698470366) | |||
173944 | 173944 | 102277 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 316 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2013 12:00:00 AM | 1 | 3x3 | Permit Number 776676 | 5998600.56179 | 2115376.04421 | 37.7883380681833 | -122.448671915192 | (37.7883380681833, -122.448671915192) | |
72997 | 72997 | 136980 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 316 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998603.003380001 | 2115358.15979 | 37.78828910189689 | -122.448662179115 | (37.7882891018969, -122.448662179115) | |||
151178 | 151178 | 136982 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 318 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5998604.86094 | 2115349.07691 | 37.7882642689212 | -122.448655097854 | (37.7882642689212, -122.448655097854) | |||
62564 | 62564 | 136981 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 318 Walnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5998609.50296 | 2115332.42012 | 37.7882187992024 | -122.448637837165 | (37.7882187992024, -122.448637837165) | |||
18635 | 18635 | 102526 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 312 Walnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 769739 | 5998624.0 | 2115422.5 | 37.7884669637257 | -122.448594170268 | (37.7884669637257, -122.448594170268) |
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");