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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
158169 | 158169 | 183195 | Undocumented 2 | :: 54 | 2467 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981757.2189 | 2098306.9914 | 37.740493837912396 | -122.505680301686 | (37.7404938379124, -122.505680301686) | |||
28995 | 28995 | 183156 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2354 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 0ft | 5981775.1553 | 2099067.0868 | 37.7425819051481 | -122.50567461791901 | (37.7425819051481, -122.505674617919) | |||
178952 | 178952 | 183207 | Undocumented 2 | :: 54 | 2487 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981762.9721 | 2098176.699 | 37.7401364295663 | -122.505650753582 | (37.7401364295663, -122.505650753582) | |||
147904 | 147904 | 183186 | Undocumented 2 | :: 54 | 2446 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981797.1527 | 2098421.378 | 37.740810262110294 | -122.505550705456 | (37.7408102621103, -122.505550705456) | |||
130272 | 130272 | 182923 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2615 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981792.4148 | 2097276.497 | 37.7376664555995 | -122.50548224533199 | (37.7376664555995, -122.505482245332) | |||
131228 | 131228 | 184727 | Undocumented 2 | :: 54 | 3941 Lawton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981943.3641 | 2104178.2266 | 37.756625560975706 | -122.505471780608 | (37.7566255609757, -122.505471780608) | |||
181678 | 181678 | 182929 | Undocumented 2 | :: 54 | 2635 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981797.6603 | 2097141.2975 | 37.737295543609996 | -122.50545409100799 | (37.73729554361, -122.505454091008) | |||
180164 | 180164 | 183139 | Undocumented 2 | :: 54 | 3539 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981846.5394 | 2099413.7013 | 37.7435378134359 | -122.505453483048 | (37.7435378134359, -122.505453483048) | |||
137654 | 137654 | 182938 | Undocumented 2 | :: 54 | 2657 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981803.7519 | 2096965.6566 | 37.7368136403966 | -122.505420015001 | (37.7368136403966, -122.505420015001) | |||
164615 | 164615 | 250999 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 206 Point Lobos Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5982160.80138 | 2112648.7463599998 | 37.7798959540729 | -122.505347618625 | (37.7798959540729, -122.505347618625) | |||
136932 | 136932 | 250998 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 206 Point Lobos Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5982175.8357 | 2112646.07604 | 37.779889506832 | -122.50529541115499 | (37.779889506832, -122.505295411155) | |||
35754 | 35754 | 182933 | Undocumented 2 | :: 54 | 2646 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981845.0394 | 2097064.8142 | 37.7370883295038 | -122.505284615423 | (37.7370883295038, -122.505284615423) | |||
147162 | 147162 | 182943 | Undocumented 2 | :: 54 | 2674 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981850.1157 | 2096894.2496 | 37.7366203046104 | -122.505254426993 | (37.7366203046104, -122.505254426993) | |||
154543 | 154543 | 182944 | Undocumented 2 | :: 54 | 2678 47th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981851.131 | 2096866.8374 | 37.7365450979685 | -122.50524888568701 | (37.7365450979685, -122.505248885687) | |||
187265 | 187265 | 183138 | Undocumented 2 | :: 54 | 3521 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981925.3562 | 2099416.4074 | 37.7435498815044 | -122.50518115930201 | (37.7435498815044, -122.505181159302) | |||
54374 | 54374 | 183137 | Undocumented 2 | Tree(s) :: 17 | 3515 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5981958.3374 | 2099418.2679 | 37.7435569304689 | -122.505067258282 | (37.7435569304689, -122.505067258282) | |||
123820 | 123820 | 184470 | Undocumented 2 | :: 54 | 2159 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5981994.4526 | 2100401.9916 | 37.7462600872151 | -122.50501526782601 | (37.7462600872151, -122.505015267826) | |||
153241 | 153241 | 183271 | Undocumented 2 | :: 54 | 1242 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982138.4385 | 2106630.5909 | 37.7633705325139 | -122.504978880674 | (37.7633705325139, -122.504978880674) | |||
173359 | 173359 | 118752 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 538 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 5982260.79513 | 2112091.34059 | 37.7783713653468 | -122.504960384037 | (37.7783713653468, -122.504960384037) | |||
184438 | 184438 | 119038 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 675 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5982249.27103 | 2111200.72651 | 37.7759253222044 | -122.50493423498501 | (37.7759253222044, -122.504934234985) | |||
176647 | 176647 | 184364 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 2255 46th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5982017.5295 | 2099742.21 | 37.7444498680839 | -122.50488658971099 | (37.7444498680839, -122.504886589711) | |||
134491 | 134491 | 118741 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 616 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5982283.91795 | 2111534.27882 | 37.776843197495396 | -122.50483910608801 | (37.7768431974954, -122.504839106088) | |||
188721 | 188721 | 119033 | Undocumented 2 | Prunus blireiana :: Flowering Plum 102 | 745 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5982267.74264 | 2110681.1609400003 | 37.7744998336605 | -122.50483182972499 | (37.7744998336605, -122.504831829725) | |||
146522 | 146522 | 119032 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 745 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5982268.98317 | 2110662.29991 | 37.774448119755 | -122.504826140687 | (37.774448119755, -122.504826140687) | |||
175585 | 175585 | 118731 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 718 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5982306.839459999 | 2110833.34112 | 37.774919975975706 | -122.504707866696 | (37.7749199759757, -122.504707866696) | |||
49826 | 49826 | 183146 | Undocumented 2 | :: 54 | 2314 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982075.842999999 | 2099327.1639 | 37.743313697016895 | -122.504654211145 | (37.7433136970169, -122.504654211145) | |||
153204 | 153204 | 118724 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 772 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 4ft | 5982318.50601 | 2110516.1725 | 37.7740498097465 | -122.504644005473 | (37.7740498097465, -122.504644005473) | |||
151546 | 151546 | 182946 | Undocumented 2 | :: 54 | 3500 Wawona St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982068.7362 | 2096751.2664 | 37.7362405734928 | -122.504487984804 | (37.7362405734928, -122.504487984804) | |||
163149 | 163149 | 184728 | Undocumented 2 | :: 54 | 1622 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982226.4788 | 2104040.1069 | 37.7562629800448 | -122.504482451968 | (37.7562629800448, -122.504482451968) | |||
51413 | 51413 | 118535 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7915 Geary Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5982438.45196 | 2112345.43604 | 37.7790794873063 | -122.50436464200199 | (37.7790794873063, -122.504364642002) | |||
64838 | 64838 | 183042 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2534 46th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5982128.2984 | 2097830.3243 | 37.73920687387729 | -122.50436197152099 | (37.7392068738773, -122.504361971521) | |||
133215 | 133215 | 118534 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 7915 Geary Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5982448.31014 | 2112345.83773 | 37.7790811700363 | -122.504330568895 | (37.7790811700363, -122.504330568895) | |||
64230 | 64230 | 118443 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5201 Anza St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5982458.0361 | 2111659.95745 | 37.7771985159381 | -122.504246101222 | (37.7771985159381, -122.504246101222) | |||
176415 | 176415 | 118442 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 5201 Anza St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5982468.47607 | 2111659.73383 | 37.777198515931794 | -122.504209970081 | (37.7771985159318, -122.504209970081) | |||
31114 | 31114 | 118441 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5201 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5982477.73735 | 2111660.7356 | 37.7772018111581 | -122.504178007129 | (37.7772018111581, -122.504178007129) | |||
33693 | 33693 | 118440 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 5201 Anza St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5982501.27886 | 2111662.63166 | 37.7772084016294 | -122.504096711396 | (37.7772084016294, -122.504096711396) | |||
64607 | 64607 | 117689 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 420 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5982541.98731 | 2112946.86538 | 37.780736924401495 | -122.50405103744 | (37.7807369244015, -122.50405103744) | |||
55128 | 55128 | 118439 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 5201 Anza St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5982517.7720099995 | 2111663.67845 | 37.7772122457156 | -122.504039734844 | (37.7772122457156, -122.504039734844) | |||
54495 | 54495 | 118438 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 5201 Anza St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 3ft | 5982520.38622 | 2111663.82262 | 37.7772127952946 | -122.50403070229099 | (37.7772127952946, -122.504030702291) | |||
51574 | 51574 | 184449 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2123 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 0ft | 5982298.3554 | 2100634.8258 | 37.7469172605604 | -122.50398166920601 | (37.7469172605604, -122.503981669206) | |||
164496 | 164496 | 119006 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 599 43rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 4ft | 5982537.41596 | 2111769.70858 | 37.7775045285794 | -122.50397963664801 | (37.7775045285794, -122.503979636648) | |||
182531 | 182531 | 184453 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 2127 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 5982298.6938 | 2100612.8284 | 37.746856881718294 | -122.503978870033 | (37.7468568817183, -122.503978870033) | |||
182662 | 182662 | 119005 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 599 43rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5982538.33316 | 2111759.97199 | 37.777477848688605 | -122.50397574245501 | (37.7774778486886, -122.503975742455) | |||
187448 | 187448 | 184439 | Undocumented 2 | :: 54 | 2131 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982299.7091 | 2100588.462 | 37.7467900380649 | -122.503973554813 | (37.7467900380649, -122.503973554813) | |||
39023 | 39023 | 184457 | Undocumented 2 | :: 54 | 2151 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982303.7701 | 2100458.8464 | 37.746434388466 | -122.503949913871 | (37.746434388466, -122.503949913871) | |||
134863 | 134863 | 184462 | Undocumented 2 | :: 54 | 2155 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982305.1238 | 2100432.4495 | 37.7463619895169 | -122.50394327821199 | (37.7463619895169, -122.503943278212) | |||
170209 | 170209 | 184473 | Undocumented 2 | :: 54 | 2191 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982313.2459 | 2100207.399 | 37.7457445409505 | -122.503898527906 | (37.7457445409505, -122.503898527906) | |||
57280 | 57280 | 118998 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 643 43rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5982553.77351 | 2111359.3776 | 37.776378841577504 | -122.503892652788 | (37.7763788415775, -122.503892652788) | |||
185330 | 185330 | 117887 | Undocumented 2 | Ilex spp :: Holly Species 163 | 592 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 5982584.758169999 | 2111760.42718 | 37.7774818283717 | -122.50381517937001 | (37.7774818283717, -122.50381517937) | |||
66563 | 66563 | 184459 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2170 45th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 0ft | 5982352.1644 | 2100338.7067 | 37.746107363854705 | -122.503773678611 | (37.7461073638547, -122.503773678611) | |||
147113 | 147113 | 184465 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2182 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5982354.8718 | 2100269.3302 | 37.745917034436296 | -122.503759179813 | (37.7459170344363, -122.503759179813) | |||
52297 | 52297 | 184468 | Undocumented 2 | :: 54 | 2186 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982356.9023 | 2100241.9181 | 37.7458418878069 | -122.50375012897499 | (37.7458418878069, -122.503750128975) | |||
137163 | 137163 | 184290 | Undocumented 2 | :: 54 | 1535 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982472.3445 | 2104651.9336 | 37.757957341688396 | -122.503677486302 | (37.7579573416884, -122.503677486302) | |||
170384 | 170384 | 184150 | Undocumented 2 | :: 54 | 1585 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982480.9001 | 2104357.3743 | 37.75714906821929 | -122.503626084685 | (37.7571490682193, -122.503626084685) | |||
184288 | 184288 | 184151 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1585 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5982482.7335 | 2104338.124 | 37.7570963201307 | -122.503618318652 | (37.7570963201307, -122.503618318652) | |||
36620 | 36620 | 184152 | Undocumented 2 | :: 54 | 1585 44th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982483.9557 | 2104316.7349 | 37.7570376635662 | -122.503612507973 | (37.7570376635662, -122.503612507973) | |||
150740 | 150740 | 184164 | Undocumented 2 | Shrub :: Shrub 98 | 1595 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5982483.9557 | 2104274.5677 | 37.7569218843537 | -122.503609385397 | (37.7569218843537, -122.503609385397) | |||
23417 | 23417 | 183167 | Undocumented 2 | :: 54 | 2422 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982411.0498 | 2098597.3573 | 37.741329561902596 | -122.50344114283101 | (37.7413295619026, -122.503441142831) | |||
172398 | 172398 | 184642 | Undocumented 2 | :: 54 | 1650 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982542.5956 | 2103869.9019 | 37.7558142337398 | -122.50337662716001 | (37.7558142337398, -122.50337662716) | |||
74901 | 74901 | 184666 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1662 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5982543.2067 | 2103811.5372 | 37.755654016652 | -122.503370192364 | (37.755654016652, -122.503370192364) | |||
176345 | 176345 | 183202 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2488 45th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5982426.448 | 2098192.7741 | 37.740219592908396 | -122.50335795194401 | (37.7402195929084, -122.503357951944) | |||
164529 | 164529 | 183341 | Undocumented 2 | :: 54 | 4211 Lincoln Way | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982665.5566 | 2106923.9454 | 37.7642069983045 | -122.50317750172199 | (37.7642069983045, -122.503177501722) | |||
165431 | 165431 | 183134 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 3326 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5982524.4211 | 2099491.9754 | 37.7437926009373 | -122.50311536935101 | (37.7437926009373, -122.503115369351) | |||
174225 | 174225 | 184482 | Undocumented 2 | :: 54 | 2019 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982585.5063 | 2101354.8182 | 37.748911041069796 | -122.503042038753 | (37.7489110410698, -122.503042038753) | |||
64935 | 64935 | 184387 | Undocumented 2 | :: 54 | 2027 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982586.1831 | 2101310.4849 | 37.7487893539542 | -122.503036416733 | (37.7487893539542, -122.503036416733) | |||
160327 | 160327 | 183333 | Undocumented 2 | :: 54 | 1211 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982706.5384 | 2106850.7636 | 37.764008470840295 | -122.503030341532 | (37.7640084708403, -122.503030341532) | |||
135026 | 135026 | 184254 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3923 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 0ft | 5982680.5832 | 2104884.9227 | 37.7586093051301 | -122.502974568924 | (37.7586093051301, -122.502974568924) | |||
63193 | 63193 | 184255 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3921 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 5982695.2501 | 2104884.6171 | 37.75860932807179 | -122.502923822357 | (37.7586093280718, -122.502923822357) | |||
163042 | 163042 | 184256 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3919 Kirkham St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5982710.2225 | 2104885.8393 | 37.7586135638528 | -122.502872132348 | (37.7586135638528, -122.502872132348) | |||
161086 | 161086 | 184460 | Undocumented 2 | :: 54 | 2179 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982619.5177 | 2100295.7271 | 37.7460050700863 | -122.502846039592 | (37.7460050700863, -122.502846039592) | |||
36129 | 36129 | 184472 | Undocumented 2 | :: 54 | 2191 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982622.5635 | 2100219.2438 | 37.7457952471339 | -122.50282984708001 | (37.7457952471339, -122.50282984708) | |||
32436 | 32436 | 184257 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3917 Kirkham St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 0ft | 5982725.806 | 2104886.1449 | 37.758615318801496 | -122.502818261057 | (37.7586153188015, -122.502818261057) | |||
32175 | 32175 | 183211 | Undocumented 2 | Tree(s) :: 17 | 2201 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5982626.7574 | 2100094.3318 | 37.7454525198404 | -122.50280610050699 | (37.7454525198404, -122.502806100507) | |||
46142 | 46142 | 184258 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3915 Kirkham St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5982739.8618 | 2104886.756 | 37.7586178227611 | -122.502769695768 | (37.7586178227611, -122.502769695768) | |||
39210 | 39210 | 183101 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2247 44th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 0ft | 5982633.8386 | 2099812.9726 | 37.7446804014496 | -122.502760792038 | (37.7446804014496, -122.502760792038) | |||
55245 | 55245 | 184471 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2190 44th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5982666.2199 | 2100231.7654 | 37.7458321935994 | -122.50267981868299 | (37.7458321935994, -122.502679818683) | |||
37012 | 37012 | 184241 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5982820.835 | 2104772.4768 | 37.7583088027406 | -122.502481200295 | (37.7583088027406, -122.502481200295) | |||
133248 | 133248 | 184240 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5982822.9739 | 2104756.2821 | 37.7582644623525 | -122.50247260456699 | (37.7582644623525, -122.502472604567) | |||
73766 | 73766 | 184239 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5982824.9463 | 2104668.9791 | 37.7580248688741 | -122.502459321879 | (37.7580248688741, -122.502459321879) | |||
55968 | 55968 | 184238 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5982825.5575 | 2104621.9206 | 37.7578956954358 | -122.50245372529899 | (37.7578956954358, -122.502453725299) | |||
26093 | 26093 | 184237 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5982827.6965 | 2104602.0583 | 37.7578412848543 | -122.502444857851 | (37.7578412848543, -122.502444857851) | |||
68633 | 68633 | 184236 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5982828.3076 | 2104581.8904 | 37.7577859454023 | -122.502441251823 | (37.7577859454023, -122.502441251823) | |||
177004 | 177004 | 184235 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5982828.3076 | 2104553.1664 | 37.757707077406394 | -122.502439125967 | (37.7577070774064, -122.502439125967) | |||
23950 | 23950 | 184234 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5982828.9188 | 2104533.9152 | 37.7576542549583 | -122.502435587448 | (37.7576542549583, -122.502435587448) | |||
178286 | 178286 | 184233 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1560 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5982830.1411 | 2104513.1361 | 37.757597273235 | -122.50242982245899 | (37.757597273235, -122.502429822459) | |||
39189 | 39189 | 184245 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3801 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5982856.1271 | 2104890.5755 | 37.75863514211029 | -122.502367886933 | (37.7586351421103, -122.502367886933) | |||
42457 | 42457 | 184588 | Undocumented 2 | :: 54 | 1723 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982824.9397 | 2103383.4877 | 37.7544952710451 | -122.502364209058 | (37.7544952710451, -122.502364209058) | |||
34873 | 34873 | 184590 | Undocumented 2 | :: 54 | 1727 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982826.6318 | 2103356.0755 | 37.7544201042603 | -122.502356328834 | (37.7544201042603, -122.502356328834) | |||
53752 | 53752 | 183103 | Undocumented 2 | :: 54 | 3244 Santiago St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982756.3936 | 2099499.1864 | 37.7438260327489 | -122.502313810049 | (37.7438260327489, -122.502313810049) | |||
50404 | 50404 | 184246 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3801 Kirkham St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5982874.1551 | 2104891.4922 | 37.7586387183635 | -122.50230560678601 | (37.7586387183635, -122.502305606786) | |||
33026 | 33026 | 184247 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3801 Kirkham St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5982890.9609 | 2104892.1033 | 37.7586413836843 | -122.50224753087099 | (37.7586413836843, -122.502247530871) | |||
57962 | 57962 | 184248 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3801 Kirkham St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5982906.5444 | 2104892.7144 | 37.758643977164205 | -122.502193682152 | (37.7586439771642, -122.502193682152) | |||
182198 | 182198 | 184249 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3801 Kirkham St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 0ft | 5982927.628 | 2104893.02 | 37.7586460549336 | -122.502120789288 | (37.7586460549336, -122.502120789288) | |||
39779 | 39779 | 183215 | Undocumented 2 | :: 54 | 3318 Rivera St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982838.8142 | 2100183.1408 | 37.7457088250993 | -122.50207942434601 | (37.7457088250993, -122.502079424346) | |||
131596 | 131596 | 184250 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3801 Kirkham St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5982955.7395 | 2104894.5478 | 37.758651901343605 | -122.502023681579 | (37.7586519013436, -122.502023681579) | |||
156132 | 156132 | 184251 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3801 Kirkham St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5982974.3786 | 2104894.8533 | 37.758653835131504 | -122.50195924274999 | (37.7586538351315, -122.50195924275) | |||
41740 | 41740 | 183278 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1255 42nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983028.2339 | 2106536.9311 | 37.7631656789881 | -122.50189448779601 | (37.7631656789881, -122.501894487796) | |||
114902 | 114902 | 183304 | Undocumented 2 | :: 54 | 1263 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5983031.5884 | 2106472.5871 | 37.762989205720295 | -122.5018781248 | (37.7629892057203, -122.5018781248) | |||
137445 | 137445 | 183283 | Undocumented 2 | Fremontodendron spp :: Flannel Bush Tree 331 | 1267 42nd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983032.1982 | 2106431.7242 | 37.762877043639 | -122.50187299213499 | (37.762877043639, -122.501872992135) | |||
48108 | 48108 | 184440 | Undocumented 2 | :: 54 | 2123 43rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 0 | Width 0ft | 5982918.0057 | 2100651.7469 | 37.7470001399255 | -122.50184026169599 | (37.7470001399255, -122.501840261696) |
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");