Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1148 | 1148 | 251463 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3440 16th St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003947.0 | 2106622.0 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | ||||
| 1156 | 1156 | 251462 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3440 16th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003947.0 | 2106622.0 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | ||||
| 1157 | 1157 | 251464 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3440 16th St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003947.0 | 2106622.0 | 37.7646058870383 | -122.429549548663 | (37.7646058870383, -122.429549548663) | ||||
| 5853 | 5853 | 105967 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2878 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 4x6 | Permit Number 772750 | 5999833.56214 | 2117445.14774 | 37.7940897102319 | -122.44455471813 | (37.7940897102319, -122.44455471813) | |
| 7453 | 7453 | 105968 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2878 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5x6 | Permit Number 772750 | 5999819.974169999 | 2117444.58508 | 37.79408738997179 | -122.444601693316 | (37.7940873899718, -122.444601693316) | |
| 10034 | 10034 | 109404 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 355 CHRISTOPHER DR | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5995347.2 | 2103110.3 | 37.7544729812167 | -122.45903946490299 | (37.7544729812167, -122.459039464903) | ||||
| 22829 | 22829 | 251126 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 120 Saint Germain Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998052.0 | 2104136.0 | 37.7574444146042 | -122.44975951647301 | (37.7574444146042, -122.449759516473) | ||||
| 22830 | 22830 | 251124 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 120 Saint Germain Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998052.0 | 2104136.0 | 37.7574444146042 | -122.44975951647301 | (37.7574444146042, -122.449759516473) | ||||
| 22837 | 22837 | 251125 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 120 Saint Germain Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998052.0 | 2104136.0 | 37.7574444146042 | -122.44975951647301 | (37.7574444146042, -122.449759516473) | ||||
| 23265 | 23265 | 5743 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 1760 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 6005273.48821 | 2098170.5035099997 | 37.7414750573209 | -122.424360413724 | (37.7414750573209, -122.424360413724) | |||
| 23357 | 23357 | 17461 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 2019 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6012621.10335 | 2096891.2056099998 | 37.7383745447599 | -122.398864958367 | (37.7383745447599, -122.398864958367) | |||
| 23856 | 23856 | 223819 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1201 Vermont St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011464.41366 | 2102201.65675 | 37.75289137874 | -122.40323770855 | (37.75289137874, -122.40323770855) | |||
| 24281 | 24281 | 223831 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006175.86532 | 2097493.16654 | 37.7396661564679 | -122.421192213677 | (37.7396661564679, -122.421192213677) | ||||
| 25958 | 25958 | 191004 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1200 20th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6014284.50499 | 2104834.6903 | 37.760278216687205 | -122.39366950473999 | (37.7602782166872, -122.39366950474) | |||
| 27222 | 27222 | 190998 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 801 Minnesota St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6015256.25071 | 2104772.25868 | 37.7601607427304 | -122.39030430192601 | (37.7601607427304, -122.390304301926) | |||
| 27302 | 27302 | 124237 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 285 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5996676.38035 | 2110910.45447 | 37.775966525811896 | -122.455006429336 | (37.7759665258119, -122.455006429336) | |||
| 27647 | 27647 | 223848 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000598.61266 | 2104296.68505 | 37.758030988052 | -122.44096386459299 | (37.758030988052, -122.440963864593) | |||
| 27912 | 27912 | 191009 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1350 Rankin St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 2ft | 6012766.95212 | 2096886.7999200001 | 37.7383705733355 | -122.398360372158 | (37.7383705733355, -122.398360372158) | |||
| 27929 | 27929 | 142997 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 9 Houston St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6008266.826 | 2120846.8676 | 37.8039075806775 | -122.41561561388201 | (37.8039075806775, -122.415615613882) | |||
| 29662 | 29662 | 223849 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000601.16124 | 2104292.97169 | 37.7580209372281 | -122.440954784152 | (37.7580209372281, -122.440954784152) | |||
| 30931 | 30931 | 57854 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 801 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | 3 | Permit Number 16796 | 6011320.9894199995 | 2104586.6510799997 | 37.7594320346834 | -122.40390151613701 | (37.7594320346834, -122.403901516137) | ||
| 32781 | 32781 | 223827 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006190.11427 | 2097485.70732 | 37.7396464784009 | -122.421142417311 | (37.7396464784009, -122.421142417311) | ||||
| 33020 | 33020 | 126433 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2601 Francisco St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 5999055.06177 | 2119708.37443 | 37.800259473158704 | -122.447411378646 | (37.8002594731587, -122.447411378646) | |||
| 33538 | 33538 | 207422 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 140 Bella Vista Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998335.54163 | 2097096.4043400001 | 37.7381316225622 | -122.448272015461 | (37.7381316225622, -122.448272015461) | |||
| 35205 | 35205 | 223840 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2145 Castro St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 10ft | 6002711.92837 | 2099262.74028 | 37.7443291052999 | -122.433295425556 | (37.7443291052999, -122.433295425556) | |||
| 36066 | 36066 | 223820 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1201 Vermont St | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011461.07467 | 2102226.45341 | 37.7529592784527 | -122.403250999655 | (37.7529592784527, -122.403250999655) | |||
| 36804 | 36804 | 176179 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 445 Naples St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003347.6645 | 2090993.45154 | 37.7216595581304 | -122.43050726549299 | (37.7216595581304, -122.430507265493) | |||
| 37700 | 37700 | 126432 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2750 Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 1ft | 5998549.737000001 | 2113237.1729599996 | 37.7824623826667 | -122.44869364731599 | (37.7824623826667, -122.448693647316) | |||
| 39704 | 39704 | 200493 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3239 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013517.2414 | 2090039.3064 | 37.719610517873704 | -122.395286677972 | (37.7196105178737, -122.395286677972) | |||
| 39816 | 39816 | 223841 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1548 Noe St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6003280.5948 | 2099265.14761 | 37.7443679596294 | -122.43132927013 | (37.7443679596294, -122.43132927013) | |||
| 39905 | 39905 | 223852 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3710 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003652.42128 | 2103638.06127 | 37.7563960214646 | -122.430355505816 | (37.7563960214646, -122.430355505816) | |||
| 40613 | 40613 | 176175 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 89 Ottawa Ave | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 5998972.727519999 | 2088619.88467 | 37.7148934808181 | -122.445459617764 | (37.7148934808181, -122.445459617764) | |||
| 43814 | 43814 | 191002 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1200 20th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6014292.84021 | 2104834.71715 | 37.7602787535777 | -122.393640678782 | (37.7602787535777, -122.393640678782) | |||
| 44305 | 44305 | 191011 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1540 Newhall St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 6ft | 6014228.979169999 | 2095505.16644 | 37.734658226800796 | -122.39320870561701 | (37.7346582268008, -122.393208705617) | |||
| 45687 | 45687 | 223828 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 100 Santa Marina St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6006183.12873 | 2097474.29354 | 37.739614744910604 | -122.421165760098 | (37.7396147449106, -122.421165760098) | ||||
| 45929 | 45929 | 200492 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1092 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6013522.7867 | 2090014.3525 | 37.7195423078427 | -122.395265762628 | (37.7195423078427, -122.395265762628) | |||
| 48003 | 48003 | 191018 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 801 Bay Shore Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6010873.51773 | 2095150.95249 | 37.73349864813579 | -122.404784804195 | (37.7334986481358, -122.404784804195) | |||
| 48137 | 48137 | 223837 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1201 Douglass St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6001376.71765 | 2100230.2222599997 | 37.746909744083204 | -122.437981578698 | (37.7469097440832, -122.437981578698) | |||
| 48902 | 48902 | 202080 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 52 Gould St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012726.46882 | 2090908.8088599998 | 37.7219539853837 | -122.398081078675 | (37.7219539853837, -122.398081078675) | |||
| 51485 | 51485 | 207415 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 70 Marcela Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994671.908890001 | 2100681.03345 | 37.74776398852129 | -122.461198701481 | (37.7477639885213, -122.461198701481) | |||
| 51504 | 51504 | 191019 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1751 Silver Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6011288.24464 | 2095271.1885 | 37.7338519630013 | -122.403359422808 | (37.7338519630013, -122.403359422808) | |||
| 52383 | 52383 | 207417 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 850 Quintara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5990746.38049 | 2101133.08021 | 37.7487784984387 | -122.47480582713001 | (37.7487784984387, -122.47480582713) | |||
| 54282 | 54282 | 176180 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 314 Tocoloma Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 3ft | 6012557.69703 | 2086963.50527 | 37.7111115690056 | -122.398387796956 | (37.7111115690056, -122.398387796956) | |||
| 54396 | 54396 | 201357 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1 Bitting Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012930.1032300005 | 2092562.90102 | 37.7265071269946 | -122.397493109117 | (37.7265071269946, -122.397493109117) | ||||
| 54455 | 54455 | 191000 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 900 Tennessee St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6015461.00601 | 2104768.16108 | 37.760160847055296 | -122.389595858273 | (37.7601608470553, -122.389595858273) | |||
| 54478 | 54478 | 190997 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 801 Minnesota St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6015256.7715 | 2104755.60023 | 37.7601150310956 | -122.39030133685301 | (37.7601150310956, -122.390301336853) | |||
| 54953 | 54953 | 176177 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 190 Foote Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 5998654.0159 | 2088359.7147099997 | 37.7141609137615 | -122.44654250762301 | (37.7141609137615, -122.446542507623) | |||
| 57193 | 57193 | 247001 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 401 Valley St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 8ft | 6003204.32988 | 2099186.4435 | 37.744147533977795 | -122.431587360294 | (37.7441475339778, -122.431587360294) | |||
| 58337 | 58337 | 191003 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1200 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6014288.23164 | 2104834.71281 | 37.760278485575796 | -122.393656617482 | (37.7602784855758, -122.393656617482) | |||
| 59118 | 59118 | 207421 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 7 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995137.11013 | 2096198.58173 | 37.735483049008 | -122.459265520615 | (37.735483049008, -122.459265520615) | |||
| 59355 | 59355 | 223824 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3101 17th St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 1ft | 6008016.50496 | 2106169.76352 | 37.7635937274947 | -122.41544215982799 | (37.7635937274947, -122.415442159828) | |||
| 59459 | 59459 | 207414 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2 Lurline St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992083.39749 | 2104933.95265 | 37.759292091184705 | -122.4704592472 | (37.7592920911847, -122.4704592472) | |||
| 60189 | 60189 | 191007 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1429 Rhode Island St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6012039.8637 | 2101705.15061 | 37.7515602022655 | -122.401212795961 | (37.7515602022655, -122.401212795961) | ||||
| 60233 | 60233 | 176171 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 46 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 6ft | 6008338.63627 | 2086231.2816700002 | 37.708865101208204 | -122.412918213412 | (37.7088651012082, -122.412918213412) | |||
| 63401 | 63401 | 191020 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2019 Palou Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 3ft | 6012619.01947 | 2096888.03059 | 37.7383657107066 | -122.398871940681 | (37.7383657107066, -122.398871940681) | |||
| 63486 | 63486 | 200495 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3239 Jennings St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6013536.65 | 2090071.1919999998 | 37.7196991487764 | -122.39522182131999 | (37.7196991487764, -122.39522182132) | |||
| 63555 | 63555 | 207420 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 746 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998157.11941 | 2096037.86642 | 37.7352149287304 | -122.44881268338301 | (37.7352149287304, -122.448812683383) | |||
| 63940 | 63940 | 176176 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 190 Foote Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 8ft | 5998664.09337 | 2088350.7446400002 | 37.7141368596079 | -122.44650703118499 | (37.7141368596079, -122.446507031185) | |||
| 65510 | 65510 | 126434 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1425 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6002370.67136 | 2121569.77606 | 37.8055593011865 | -122.436071357532 | (37.8055593011865, -122.436071357532) | |||
| 65778 | 65778 | 190999 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 900 Tennessee St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6015461.30451 | 2104782.94295 | 37.7602014514497 | -122.389595858288 | (37.7602014514497, -122.389595858288) | |||
| 66042 | 66042 | 223825 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3101 17th St | 3 | : 4 | Tree 1 | Private 1 | 2 | Width 1ft | 6008027.95935 | 2106170.28892 | 37.7635958139266 | -122.41540257978001 | (37.7635958139266, -122.41540257978) | |||
| 67078 | 67078 | 223835 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2100 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6008066.579580001 | 2106159.15106 | 37.7635674025314 | -122.415268215666 | (37.7635674025314, -122.415268215666) | |||
| 67210 | 67210 | 191015 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2701 Phelps St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 6011786.474719999 | 2093252.28188 | 37.72833628057529 | -122.401495039187 | (37.7283362805753, -122.401495039187) | |||
| 68292 | 68292 | 191013 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1540 Newhall St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 6014211.22756 | 2095480.9391299998 | 37.7345907173738 | -122.393268384633 | (37.7345907173738, -122.393268384633) | |||
| 68299 | 68299 | 176169 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 30 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 8ft | 6008410.17529 | 2086203.98853 | 37.7087941752841 | -122.41266903556999 | (37.7087941752841, -122.41266903557) | |||
| 68458 | 68458 | 247145 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 500 27th St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6003145.29919 | 2100074.31823 | 37.7465820851075 | -122.43185485912599 | (37.7465820851075, -122.431854859126) | ||||
| 69096 | 69096 | 223833 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2700 18th St | 3 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6009765.40934 | 2105513.7939299997 | 37.7618907290033 | -122.40934692912701 | (37.7618907290033, -122.409346929127) | |||
| 70148 | 70148 | 126436 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 33 Normandie Ter | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6000899.166669999 | 2117400.62389 | 37.794028205590294 | -122.44086442836901 | (37.7940282055903, -122.440864428369) | |||
| 70882 | 70882 | 200247 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3225 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6013551.8996 | 2090073.2715 | 37.7197057067439 | -122.395169254095 | (37.7197057067439, -122.395169254095) | |||
| 70950 | 70950 | 191001 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 900 Tennessee St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6015462.33524 | 2104739.93407 | 37.7600834154452 | -122.38958928963699 | (37.7600834154452, -122.389589289637) | |||
| 71152 | 71152 | 67675 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1729 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/2005 12:00:00 AM | 5 | Permit Number 31278 | 6014381.83684 | 2094894.1642200002 | 37.732989030203 | -122.39263749313 | (37.732989030203, -122.39263749313) | |
| 72374 | 72374 | 47608 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1301 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 3 | Permit Number 47714 | 6009600.55558 | 2109308.8857400003 | 37.772301940226896 | -122.41018504600099 | (37.7723019402269, -122.410185046001) | |
| 72924 | 72924 | 223856 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 4132 17th St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001453.75395 | 2105861.01375 | 37.7623749212873 | -122.438118485182 | (37.7623749212873, -122.438118485182) | |||
| 73332 | 73332 | 223839 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1201 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6001375.46533 | 2100241.14483 | 37.7469396636504 | -122.437986691344 | (37.7469396636504, -122.437986691344) | |||
| 73931 | 73931 | 223821 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1315 Utah St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6010905.03625 | 2102087.35489 | 37.752546274702794 | -122.405164102267 | (37.7525462747028, -122.405164102267) | |||
| 80042 | 80042 | 112741 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2514 CLAY ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6002696.0 | 2116178.0 | 37.7907733646004 | -122.43455974658 | (37.7907733646004, -122.43455974658) | ||||
| 82709 | 82709 | 46248 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1675 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2002 12:00:00 AM | Permit Number 44536 | 6016787.6752368 | 2092188.79463336 | 37.7256939401069 | -122.384131467798 | (37.7256939401069, -122.384131467798) | |||
| 86057 | 86057 | 94469 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 89776 | 89776 | 98528 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
| 93173 | 93173 | 52845 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 11X Guy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 93747 | 93747 | 26415 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 34 Maple St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 101423 | 101423 | 52849 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 101916 | 101916 | 26413 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 34 Maple St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 103402 | 103402 | 101698 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 2700 18th St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x3 | 6009810.4 | 2105505.4 | 37.7618702017999 | -122.409190731152 | (37.7618702017999, -122.409190731152) | ||||
| 103566 | 103566 | 94487 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) | |||||
| 104384 | 104384 | 98316 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1800X Clay St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 2x2 | 6006008.9 | 2116666.9 | 37.7923032687502 | -122.42313202643899 | (37.7923032687502, -122.423132026439) | ||||
| 105424 | 105424 | 26414 | DPW Maintained 3 | Cupressus sempervirens :: Italian Cypress 136 | 34 Maple St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 3 | 10 | 5996568.2197254 | 2116061.2858977 | 37.790103136313206 | -122.455752999345 | (37.7901031363132, -122.455752999345) | |||
| 106973 | 106973 | 102811 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | ||
| 107335 | 107335 | 52847 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 11X Guy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 109279 | 109279 | 102813 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | ||
| 117618 | 117618 | 52848 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 118464 | 118464 | 98529 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 428 11th St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/22/2012 12:00:00 AM | 3x3 | Permit Number 768342 | 6009030.0 | 2108561.0 | 37.7702164230423 | -122.41210579217699 | (37.7702164230423, -122.412105792177) | ||
| 119324 | 119324 | 102814 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | ||
| 120056 | 120056 | 223842 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 3922 22nd St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002306.42247 | 2102988.7945 | 37.7545369555235 | -122.434964002506 | (37.7545369555235, -122.434964002506) | |||
| 122128 | 122128 | 52846 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 11X Guy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | 5 | 3x3 | Permit Number 48860 | 6014349.88850075 | 2114221.0453464002 | 37.7860546845502 | -122.394100496655 | (37.7860546845502, -122.394100496655) | |
| 122993 | 122993 | 102812 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 50 Lansing St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 48860 | 6014354.6 | 2114220.8 | 37.7860542727502 | -122.394084178828 | (37.7860542727502, -122.394084178828) | ||
| 124170 | 124170 | 121579 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 742X Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 1x1 | 6004940.0 | 2104032.0 | 37.757550534457295 | -122.425930645849 | (37.7575505344573, -122.425930645849) | |||
| 124810 | 124810 | 70611 | Permitted Site 1 | Cupressus sempervirens :: Italian Cypress 136 | 1355 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2013 12:00:00 AM | Permit Number 770302 | 6007018.06454335 | 2115342.51032554 | 37.7887237195829 | -122.419546283037 | (37.7887237195829, -122.419546283037) | |||
| 125819 | 125819 | 110920 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 77 FEDERAL ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x1 | 6014792.0 | 2113102.0 | 37.783006604033204 | -122.392492594241 | (37.7830066040332, -122.392492594241) | ||||
| 126549 | 126549 | 94468 | Property Tree 7 | Cupressus sempervirens :: Italian Cypress 136 | 4128 17th St | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | in landscaped area | 6001502.0 | 2105859.0 | 37.7623721357484 | -122.437951476108 | (37.7623721357484, -122.437951476108) |
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");