Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 182627 | 182627 | 200520 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 63 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6016476.5475 | 2095041.1188 | 37.7335086511389 | -122.38540570010599 | (37.7335086511389, -122.385405700106) | |||
| 58587 | 58587 | 200519 | DPW Maintained 3 | Tristania conferta :: 79 | 1400x La Salle Ave | 62 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016469.2023 | 2095054.3401 | 37.7335445478075 | -122.38543201583401 | (37.7335445478075, -122.385432015834) | |||
| 132319 | 132319 | 187236 | Undocumented 2 | Tristania conferta :: 79 | 2401 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984970.7155 | 2098606.6122 | 37.7415051202811 | -122.49459152958401 | (37.7415051202811, -122.494591529584) | |||
| 178622 | 178622 | 142366 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005560.2454 | 2113404.4098 | 37.7833199541216 | -122.424452221294 | (37.7833199541216, -122.424452221294) | |||
| 31547 | 31547 | 187235 | Undocumented 2 | Tristania conferta :: 79 | 2401 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984966.2222 | 2098610.2885 | 37.7415149514197 | -122.494607336605 | (37.7415149514197, -122.494607336605) | |||
| 168383 | 168383 | 142365 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005547.6156 | 2113403.0804 | 37.783315590695096 | -122.42449582084801 | (37.7833155906951, -122.424495820848) | |||
| 1263 | 1263 | 138399 | DPW Maintained 3 | Tristania conferta :: 79 | 2445 PINE ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6002411.2137 | 2115044.4135 | 37.7876446559027 | -122.435463964972 | (37.7876446559027, -122.435463964972) | |||
| 74818 | 74818 | 142364 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005532.9915 | 2113401.0862 | 37.7833092892509 | -122.424546272586 | (37.7833092892509, -122.424546272586) | |||
| 180469 | 180469 | 138222 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998723.4884 | 2112655.399 | 37.780874916637295 | -122.44805064424999 | (37.7808749166373, -122.44805064425) | |||
| 1242 | 1242 | 138398 | DPW Maintained 3 | Tristania conferta :: 79 | 2445 PINE ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 6002388.1124 | 2115043.7135 | 37.787641421844896 | -122.435543840756 | (37.7876414218449, -122.435543840756) | |||
| 35023 | 35023 | 142363 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005513.0496 | 2113400.4215 | 37.783306337940104 | -122.424615216414 | (37.7833063379401, -122.424615216414) | |||
| 55539 | 55539 | 138221 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998706.2288 | 2112655.399 | 37.7808739300098 | -122.448110353407 | (37.7808739300098, -122.448110353407) | |||
| 44909 | 44909 | 139239 | Undocumented 2 | Tristania conferta :: 79 | 1401 WEBSTER ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003667.9911 | 2113214.7954 | 37.7826922817775 | -122.43098513109 | (37.7826922817775, -122.43098513109) | |||
| 49512 | 49512 | 200911 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015820.1566 | 2098275.9378 | 37.7423544699147 | -122.387900693237 | (37.7423544699147, -122.387900693237) | |||
| 52656 | 52656 | 142362 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005497.0961 | 2113397.7625 | 37.783298135987394 | -122.42467022002899 | (37.7832981359874, -122.424670220029) | |||
| 185860 | 185860 | 138220 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998691.3383 | 2112654.3837 | 37.78087029103521 | -122.448161793593 | (37.7808702910352, -122.448161793593) | |||
| 8926 | 8926 | 6195 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005185.2786 | 2113401.5799 | 37.7832910021365 | -122.425749257253 | (37.7832910021365, -122.425749257253) | |||
| 16375 | 16375 | 22415 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53653 | 6013701.5886 | 2091876.0685 | 37.7246641498069 | -122.39477801609101 | (37.7246641498069, -122.394778016091) | |
| 39415 | 39415 | 142361 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005477.1542 | 2113394.4389 | 37.7832878839209 | -122.424738974627 | (37.7832878839209, -122.424738974627) | |||
| 77076 | 77076 | 138219 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998675.4325 | 2112652.6916 | 37.7808647356786 | -122.448216697429 | (37.7808647356786, -122.448216697429) | |||
| 171007 | 171007 | 200910 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015813.5433 | 2098253.2638 | 37.74229184539389 | -122.387921978414 | (37.7422918453939, -122.387921978414) | |||
| 6482 | 6482 | 6194 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005201.2129999995 | 2113404.3918 | 37.7832996233389 | -122.42569433072799 | (37.7832996233389, -122.425694330728) | |||
| 46012 | 46012 | 200909 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015806.4577 | 2098231.0621 | 37.7422304915422 | -122.38794492958598 | (37.7422304915422, -122.387944929586) | |||
| 48431 | 48431 | 142360 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005454.5534 | 2113392.4447 | 37.7832811318405 | -122.424817022557 | (37.7832811318405, -122.424817022557) | |||
| 67553 | 67553 | 139237 | Undocumented 2 | Tristania conferta :: 79 | 1401 WEBSTER ST | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003660.9941 | 2113262.6079 | 37.7828231664651 | -122.431012751255 | (37.7828231664651, -122.431012751255) | |||
| 68412 | 68412 | 138218 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998658.1729999995 | 2112647.6153 | 37.7808498107721 | -122.44827604058099 | (37.7808498107721, -122.448276040581) | |||
| 7068 | 7068 | 6193 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005219.9593 | 2113402.5172 | 37.783295535433204 | -122.425629342465 | (37.7832955354332, -122.425629342465) | |||
| 49146 | 49146 | 200908 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015799.3721 | 2098207.4433 | 37.7421652466195 | -122.387967781856 | (37.7421652466195, -122.387967781856) | |||
| 152000 | 152000 | 138217 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998640.9134 | 2112646.2616 | 37.780845107122104 | -122.448335652205 | (37.7808451071221, -122.448335652205) | |||
| 175926 | 175926 | 142359 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005430.6231 | 2113387.7916 | 37.7832670039302 | -122.424899480788 | (37.7832670039302, -122.424899480788) | |||
| 7364 | 7364 | 6192 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005245.2668 | 2113409.0784 | 37.7833149808402 | -122.425542255616 | (37.7833149808402, -122.425542255616) | |||
| 42933 | 42933 | 142358 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005410.0165 | 2113384.4680000003 | 37.7832567141838 | -122.42497053492399 | (37.7832567141838, -122.424970534924) | |||
| 48586 | 48586 | 139352 | Undocumented 2 | Tristania conferta :: 79 | 1400 GEARY BLVD | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6004684.7776 | 2114110.0734 | 37.785208053515795 | -122.427531283761 | (37.7852080535158, -122.427531283761) | |||
| 66209 | 66209 | 138223 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998623.3155 | 2112642.539 | 37.7808338797166 | -122.448396263517 | (37.7808338797166, -122.448396263517) | |||
| 136545 | 136545 | 139811 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005666.9532 | 2112825.9968 | 37.7817377996033 | -122.424041907588 | (37.7817377996033, -122.424041907588) | |||
| 171170 | 171170 | 200907 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015794.1759 | 2098187.1312 | 37.742109185886505 | -122.387984331771 | (37.7421091858865, -122.387984331771) | |||
| 6979 | 6979 | 6191 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005268.6997 | 2113412.8277 | 37.7833265994852 | -122.42546145392201 | (37.7833265994852, -122.425461453922) | |||
| 9466 | 9466 | 14453 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5998924.1725 | 2112667.0746 | 37.7809184444903 | -122.447357223078 | (37.7809184444903, -122.447357223078) | |||
| 55263 | 55263 | 139936 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005717.7716 | 2112456.4224 | 37.780725907943705 | -122.423839812492 | (37.7807259079437, -122.423839812492) | |||
| 61987 | 61987 | 142357 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005388.7452 | 2113384.4680000003 | 37.7832555126318 | -122.42504412519301 | (37.7832555126318, -122.425044125193) | |||
| 67707 | 67707 | 138225 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998607.7481 | 2112640.5085 | 37.780827414440296 | -122.448449972246 | (37.7808274144403, -122.448449972246) | |||
| 70497 | 70497 | 139810 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6005664.1775 | 2112848.2023 | 37.7817986137394 | -122.42405308982599 | (37.7817986137394, -122.424053089826) | |||
| 153049 | 153049 | 200906 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015788.035 | 2098168.2362 | 37.7420569638785 | -122.388004247029 | (37.7420569638785, -122.388004247029) | |||
| 5959 | 5959 | 23753 | DPW Maintained 3 | Tristania conferta :: 79 | 900X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 25 | 4x4 | 6003923.4316 | 2112087.5817 | 37.7796117041387 | -122.43002098071501 | (37.7796117041387, -122.430020980715) | ||
| 7430 | 7430 | 6190 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005292.1326 | 2113413.765 | 37.783330497018 | -122.425380452026 | (37.783330497018, -122.425380452026) | |||
| 9376 | 9376 | 14452 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 5998927.5567 | 2112628.8329 | 37.7808136360807 | -122.44734276226002 | (37.7808136360807, -122.44734276226) | |||
| 14284 | 14284 | 22410 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53565 | 6013752.9164 | 2092008.8459 | 37.7250315835443 | -122.39460987462401 | (37.7250315835443, -122.394609874624) | |
| 30368 | 30368 | 138199 | Undocumented 2 | Tristania conferta :: 79 | 180 Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998946.8467 | 2112434.5788 | 37.7802813669123 | -122.44726204408501 | (37.7802813669123, -122.447262044085) | |||
| 70554 | 70554 | 142356 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005371.4622 | 2113379.8148 | 37.7832417597952 | -122.425103586326 | (37.7832417597952, -122.425103586326) | |||
| 131442 | 131442 | 201884 | Undocumented 2 | Tristania conferta :: 79 | 199 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015227.9296 | 2115567.3435 | 37.7898000735545 | -122.391156824011 | (37.7898000735545, -122.391156824011) | |||
| 165162 | 165162 | 200994 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6015517.8954 | 2115843.9421 | 37.7905756368486 | -122.390172893022 | (37.7905756368486, -122.390172893022) | |||
| 168926 | 168926 | 138224 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998591.1654 | 2112638.1395 | 37.7808199616553 | -122.44850716898199 | (37.7808199616553, -122.448507168982) | |||
| 172026 | 172026 | 200905 | Undocumented 2 | Tristania conferta :: 79 | 3801 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015782.8389 | 2098148.8688 | 37.74200349709729 | -122.38802086245501 | (37.7420034970973, -122.388020862455) | |||
| 173477 | 173477 | 141150 | Undocumented 2 | Tristania conferta :: 79 | 1940 O'Farrell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6001933.2499 | 2113294.5086 | 37.7828127066631 | -122.436992295504 | (37.7828127066631, -122.436992295504) | |||
| 178943 | 178943 | 139935 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005714.5324 | 2112478.1713 | 37.7807854422322 | -122.423852565408 | (37.7807854422322, -122.423852565408) | |||
| 180440 | 180440 | 184353 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984679.818 | 2106506.8001 | 37.763179828394996 | -122.49618007420099 | (37.763179828395, -122.496180074201) | |||
| 2729 | 2729 | 141998 | DPW Maintained 3 | Tristania conferta :: 79 | 818 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1990 12:00:00 AM | 13 | Width 0ft | 6003974.6435 | 2111716.5903 | 37.778595953895795 | -122.42981734758699 | (37.7785959538958, -122.429817347587) | ||
| 7083 | 7083 | 1667 | Permitted Site 1 | Tristania conferta :: 79 | 1400X Fell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000310.2061 | 2109949.902 | 37.773536884549706 | -122.44236713923901 | (37.7735368845497, -122.442367139239) | ||
| 7594 | 7594 | 21603 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005357.043 | 2114765.7223 | 37.7870463035591 | -122.42525212232901 | (37.7870463035591, -122.425252122329) | |||
| 8695 | 8695 | 6189 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005309.0043 | 2113417.5143 | 37.7833417448711 | -122.425322349467 | (37.7833417448711, -122.425322349467) | |||
| 13516 | 13516 | 22409 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53653 | 6013757.7359 | 2092026.1961 | 37.7250794916417 | -122.394594428416 | (37.7250794916417, -122.394594428416) | |
| 37109 | 37109 | 201883 | Undocumented 2 | Tristania conferta :: 79 | 199 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015205.3081 | 2115545.7503 | 37.789739528214504 | -122.391233582889 | (37.7897395282145, -122.391233582889) | |||
| 45406 | 45406 | 142355 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6005342.2141 | 2113373.8323 | 37.7832236810645 | -122.425204347304 | (37.7832236810645, -122.425204347304) | |||
| 49428 | 49428 | 244944 | Undocumented 2 | Tristania conferta :: 79 | 333 Fell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005861.1541 | 2110670.4754 | 37.775830225555 | -122.423216794436 | (37.775830225555, -122.423216794436) | |||
| 53024 | 53024 | 139808 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005655.8504 | 2112888.45 | 37.781908653892 | -122.42408476084101 | (37.781908653892, -122.424084760841) | |||
| 66126 | 66126 | 141797 | Undocumented 2 | Tristania conferta :: 79 | 1280 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003787.0547 | 2113072.446 | 37.7823081716106 | -122.43056306129499 | (37.7823081716106, -122.430563061295) | |||
| 75080 | 75080 | 139733 | Undocumented 2 | Tristania conferta :: 79 | 1181 Gough St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005538.6858 | 2113694.4096 | 37.784115004469 | -122.42454744419399 | (37.784115004469, -122.424547444194) | |||
| 126814 | 126814 | 99009 | DPW Maintained 3 | Tristania conferta :: 79 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.803316837922104 | -122.442899765771 | (37.8033168379221, -122.442899765771) | ||
| 153933 | 153933 | 139934 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005710.3678 | 2112505.9358 | 37.78086144164 | -122.423868947638 | (37.78086144164, -122.423868947638) | |||
| 162298 | 162298 | 138226 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5998572.2138 | 2112635.4321 | 37.7808114442344 | -122.448572536471 | (37.7808114442344, -122.448572536471) | |||
| 166802 | 166802 | 184808 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984676.7802 | 2106518.9511 | 37.763213013686396 | -122.49619147733 | (37.7632130136864, -122.49619147733) | |||
| 171962 | 171962 | 200993 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6015477.7938 | 2115806.9252 | 37.790471772634604 | -122.390309056024 | (37.7904717726346, -122.390309056024) | |||
| 3666 | 3666 | 21602 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005338.1501 | 2114762.148 | 37.7870354220648 | -122.425317233161 | (37.7870354220648, -122.425317233161) | |||
| 4692 | 4692 | 6906 | DPW Maintained 3 | Tristania conferta :: 79 | 333 Fell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:59:00 AM | 3 | 3X3 | 6005816.7808 | 2110662.8487 | 37.7758067801978 | -122.423369750882 | (37.7758067801978, -122.423369750882) | ||
| 6685 | 6685 | 6188 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005406.4851 | 2113431.574 | 37.783385856152 | -122.42498610479299 | (37.783385856152, -122.424986104793) | |||
| 7714 | 7714 | 14450 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5998930.2641 | 2112586.1918 | 37.7806967093816 | -122.44733032611299 | (37.7806967093816, -122.447330326113) | |||
| 13376 | 13376 | 22408 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53653 | 6013764.0013 | 2092044.0283 | 37.7251288035961 | -122.394574017561 | (37.7251288035961, -122.394574017561) | |
| 13508 | 13508 | 29427 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.38896553930401 | (37.7234697537221, -122.388965539304) | ||
| 15369 | 15369 | 22443 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6013664.0377 | 2091536.7496 | 37.7237303604467 | -122.39488407213601 | (37.7237303604467, -122.394884072136) | |||
| 15576 | 15576 | 95306 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013860.6324 | 2092285.2447 | 37.7257965069575 | -122.39425685203001 | (37.7257965069575, -122.39425685203) | |||
| 23010 | 23010 | 15288 | DPW Maintained 3 | Tristania conferta :: 79 | 1600 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 8 | 3X3 | 6006995.5283 | 2109306.0347 | 37.772147749991795 | -122.419195888407 | (37.7721477499918, -122.419195888407) | ||
| 25880 | 25880 | 121013 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6015189.8844 | 2115534.4395 | 37.78970761539271 | -122.39128615684099 | (37.7897076153927, -122.391286156841) | |||
| 30584 | 30584 | 142354 | Undocumented 2 | Tristania conferta :: 79 | 1135 ELLIS ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6005306.3187 | 2113367.185 | 37.7832034013247 | -122.42532805791599 | (37.7832034013247, -122.425328057916) | |||
| 41164 | 41164 | 141932 | Undocumented 2 | Tristania conferta :: 79 | 1050 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004095.7926 | 2111864.1542 | 37.7790079875659 | -122.42940877227899 | (37.7790079875659, -122.429408772279) | |||
| 50365 | 50365 | 139231 | Undocumented 2 | Tristania conferta :: 79 | 1401 WEBSTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003635.3387 | 2113448.027 | 37.7833308271099 | -122.43111474669901 | (37.7833308271099, -122.431114746699) | |||
| 59094 | 59094 | 95310 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6014289.9952 | 2093175.8818 | 37.728265874158 | -122.392834846305 | (37.728265874158, -122.392834846305) | |||
| 60493 | 60493 | 138227 | Undocumented 2 | Tristania conferta :: 79 | 101 Anza St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998554.9543 | 2112632.7248 | 37.7808030238066 | -122.448632050181 | (37.7808030238066, -122.448632050181) | |||
| 68784 | 68784 | 184807 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984672.982999999 | 2106530.3427 | 37.7632440693949 | -122.49620545091001 | (37.7632440693949, -122.49620545091) | |||
| 76025 | 76025 | 139807 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005654.4625 | 2112912.0434 | 37.78197335721 | -122.424091240716 | (37.78197335721, -122.424091240716) | |||
| 135255 | 135255 | 200670 | Undocumented 2 | Tristania conferta :: 79 | 1587 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6015353.4507 | 2095562.261 | 37.734877402221606 | -122.389324978833 | (37.7348774022216, -122.389324978833) | |||
| 150708 | 150708 | 139732 | Undocumented 2 | Tristania conferta :: 79 | 1191 Gough St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005537.4624 | 2113723.1591 | 37.784193874402206 | -122.42455372244301 | (37.7841938744022, -122.424553722443) | |||
| 155395 | 155395 | 200964 | Undocumented 2 | Tristania conferta :: 79 | 5600 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6013957.0226 | 2092532.4854 | 37.7264807375175 | -122.393940935112 | (37.7264807375175, -122.393940935112) | |||
| 160363 | 160363 | 200992 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6015461.3418 | 2115791.5015 | 37.7904285101106 | -122.39036490128599 | (37.7904285101106, -122.390364901286) | |||
| 163138 | 163138 | 200932 | Undocumented 2 | Tristania conferta :: 79 | 4101 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015570.0337 | 2097446.6824 | 37.740063645101294 | -122.38870767425699 | (37.7400636451013, -122.388707674257) | |||
| 163264 | 163264 | 246313 | Undocumented 2 | Tristania conferta :: 79 | 1655 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6007004.876 | 2109202.9434 | 37.771865212234005 | -122.41915623997 | (37.771865212234, -122.41915623997) | |||
| 172375 | 172375 | 140639 | Undocumented 2 | Tristania conferta :: 79 | 468 Stanyan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5996860.5832 | 2109999.5178 | 37.7734758965802 | -122.454303413235 | (37.7734758965802, -122.454303413235) | |||
| 182734 | 182734 | 143433 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6010770.5411 | 2116920.4657 | 37.7932670566772 | -122.406674439368 | (37.7932670566772, -122.406674439368) | |||
| 466 | 466 | 1665 | DPW Maintained 3 | Tristania conferta :: 79 | 1400X Fell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6000409.8977 | 2109962.9335 | 37.7735783473195 | -122.44202322778901 | (37.7735783473195, -122.442023227789) | ||
| 984 | 984 | 24262 | DPW Maintained 3 | Tristania conferta :: 79 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | ||
| 5943 | 5943 | 9604 | Permitted Site 1 | Tristania conferta :: 79 | 1355 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003125.8375 | 2112021.5623 | 37.7793852280154 | -122.432775482637 | (37.7793852280154, -122.432775482637) |
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");