trees
1,377 rows where qSpecies_id = 61 sorted by SiteOrder descending
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▲ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43598 | 138224 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5998591.1654 | 2112638.1395 | 37.7808199616553 | -122.448507168982 | (37.7808199616553, -122.448507168982) | 15 | 6 | 2 | 54 | 16 | |||
| 48658 | 139935 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6005714.5324 | 2112478.1713 | 37.7807854422322 | -122.423852565408 | (37.7807854422322, -122.423852565408) | 7 | 9 | 11 | 28852 | 41 | |||
| 81371 | 23753 | DPW Maintained 1 | Tristania conferta :: 61 | 900X Webster St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/19/1992 12:00:00 AM | 25 | 4x4 | 6003923.4316 | 2112087.5817 | 37.7796117041387 | -122.430020980715 | (37.7796117041387, -122.430020980715) | 7 | 9 | 11 | 29490 | 41 | ||
| 89017 | 200905 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015782.8389 | 2098148.8688 | 37.7420034970973 | -122.388020862455 | (37.7420034970973, -122.388020862455) | 10 | 3 | 8 | 58 | 1 | |||
| 92800 | 199895 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 Ingalls St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016530.9767 | 2093031.4421 | 37.7279934886935 | -122.385077547186 | (37.7279934886935, -122.385077547186) | 10 | 3 | 8 | 58 | 1 | |||
| 118471 | 141150 | DPW Maintained 1 | Tristania conferta :: 61 | 1940 O'Farrell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6001933.2499 | 2113294.5086 | 37.7828127066631 | -122.436992295504 | (37.7828127066631, -122.436992295504) | 13 | 5 | 11 | 29490 | 41 | |||
| 127215 | 184353 | DPW Maintained 1 | Tristania conferta :: 61 | 1251 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 0ft | 5984679.818 | 2106506.8001 | 37.763179828395 | -122.496180074201 | (37.763179828395, -122.496180074201) | 1 | 8 | 3 | 56 | 35 | |||
| 127636 | 142356 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005371.4622 | 2113379.8148 | 37.7832417597952 | -122.425103586326 | (37.7832417597952, -122.425103586326) | 7 | 9 | 11 | 28858 | 41 | |||
| 147265 | 6190 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005292.1326 | 2113413.765 | 37.783330497018 | -122.425380452026 | (37.783330497018, -122.425380452026) | 7 | 9 | 11 | 28858 | 41 | |||
| 147566 | 14452 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Masonic Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3x3 | 5998927.5567 | 2112628.8329 | 37.7808136360807 | -122.44734276226 | (37.7808136360807, -122.44734276226) | 15 | 5 | 1 | 54 | 16 | |||
| 161326 | 138199 | DPW Maintained 1 | Tristania conferta :: 61 | 180 Masonic Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5998946.8467 | 2112434.5788 | 37.7802813669123 | -122.447262044085 | (37.7802813669123, -122.447262044085) | 15 | 5 | 1 | 54 | 16 | |||
| 171298 | 200994 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6015517.8954 | 2115843.9421 | 37.7905756368486 | -122.390172893022 | (37.7905756368486, -122.390172893022) | 6 | 2 | 9 | 28855 | 6 | |||
| 172637 | 22410 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53565 | 6013752.9164 | 2092008.8459 | 37.7250315835443 | -122.394609874624 | (37.7250315835443, -122.394609874624) | 10 | 3 | 8 | 58 | 1 | |
| 192834 | 201884 | DPW Maintained 1 | Tristania conferta :: 61 | 199 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6015227.9296 | 2115567.3435 | 37.7898000735545 | -122.391156824011 | (37.7898000735545, -122.391156824011) | 6 | 2 | 9 | 28855 | 6 | |||
| 22953 | 244944 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005861.1541 | 2110670.4754 | 37.775830225555 | -122.423216794436 | (37.775830225555, -122.423216794436) | 7 | 9 | 11 | 28852 | 10 | |||
| 23416 | 201883 | DPW Maintained 1 | Tristania conferta :: 61 | 199 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015205.3081 | 2115545.7503 | 37.7897395282145 | -122.391233582889 | (37.7897395282145, -122.391233582889) | 6 | 2 | 9 | 28855 | 6 | |||
| 31903 | 138226 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5998572.2138 | 2112635.4321 | 37.7808114442344 | -122.448572536471 | (37.7808114442344, -122.448572536471) | 15 | 6 | 2 | 54 | 16 | |||
| 32812 | 99009 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
| 43274 | 22409 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53653 | 6013757.7359 | 2092026.1961 | 37.7250794916417 | -122.394594428416 | (37.7250794916417, -122.394594428416) | 10 | 3 | 8 | 58 | 1 | |
| 45863 | 1667 | DPW Maintained 1 | Tristania conferta :: 61 | 1400X Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000310.2061 | 2109949.902 | 37.7735368845497 | -122.442367139239 | (37.7735368845497, -122.442367139239) | 15 | 5 | 11 | 29492 | 16 | ||
| 46817 | 139934 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005710.3678 | 2112505.9358 | 37.78086144164 | -122.423868947638 | (37.78086144164, -122.423868947638) | 7 | 9 | 11 | 28852 | 41 | |||
| 65960 | 139808 | DPW Maintained 1 | Tristania conferta :: 61 | 1101 GOUGH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6005655.8504 | 2112888.45 | 37.781908653892 | -122.424084760841 | (37.781908653892, -122.424084760841) | 7 | 9 | 11 | 28852 | 41 | |||
| 77502 | 256068 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.388965539304 | (37.7234697537221, -122.388965539304) | 10 | 3 | 8 | 58 | 1 | ||||
| 91350 | 21603 | DPW Maintained 1 | Tristania conferta :: 61 | 1515 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005357.043 | 2114765.7223 | 37.7870463035591 | -122.425252122329 | (37.7870463035591, -122.425252122329) | 13 | 9 | 11 | 28858 | 13 | |||
| 92479 | 200993 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6015477.7938 | 2115806.9252 | 37.7904717726346 | -122.390309056024 | (37.7904717726346, -122.390309056024) | 6 | 2 | 9 | 28855 | 6 | |||
| 125087 | 142355 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6005342.2141 | 2113373.8323 | 37.7832236810645 | -122.425204347304 | (37.7832236810645, -122.425204347304) | 7 | 9 | 11 | 28858 | 41 | |||
| 128744 | 257950 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 134665 | 141797 | DPW Maintained 1 | Tristania conferta :: 61 | 1280 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6003787.0547 | 2113072.446 | 37.7823081716106 | -122.430563061295 | (37.7823081716106, -122.430563061295) | 7 | 9 | 11 | 29490 | 41 | |||
| 144438 | 139733 | DPW Maintained 1 | Tristania conferta :: 61 | 1181 Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005538.6858 | 2113694.4096 | 37.784115004469 | -122.424547444194 | (37.784115004469, -122.424547444194) | 7 | 9 | 11 | 28858 | 41 | |||
| 156608 | 29495 | DPW Maintained 1 | Tristania conferta :: 61 | 1700X Ingalls St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016616.3583 | 2093144.917 | 37.7283097910179 | -122.384790279442 | (37.7283097910179, -122.384790279442) | 10 | 3 | 8 | 58 | 1 | ||
| 169848 | 184808 | DPW Maintained 1 | Tristania conferta :: 61 | 1251 Sunset Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5984676.7802 | 2106518.9511 | 37.7632130136864 | -122.49619147733 | (37.7632130136864, -122.49619147733) | 1 | 8 | 3 | 56 | 35 | |||
| 176645 | 141998 | DPW Maintained 1 | Tristania conferta :: 61 | 818 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/23/1990 12:00:00 AM | 13 | Width 0ft | 6003974.6435 | 2111716.5903 | 37.7785959538958 | -122.429817347587 | (37.7785959538958, -122.429817347587) | 7 | 9 | 11 | 29490 | 41 | ||
| 188008 | 6189 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005309.0043 | 2113417.5143 | 37.7833417448711 | -122.425322349467 | (37.7833417448711, -122.425322349467) | 7 | 9 | 11 | 28858 | 41 | |||
| 4029 | 138227 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998554.9543 | 2112632.7248 | 37.7808030238066 | -122.448632050181 | (37.7808030238066, -122.448632050181) | 15 | 6 | 2 | 54 | 16 | |||
| 5894 | 29427 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.388965539304 | (37.7234697537221, -122.388965539304) | 10 | 3 | 8 | 58 | 1 | ||
| 26846 | 15288 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 8 | 3X3 | 6006995.5283 | 2109306.0347 | 37.7721477499918 | -122.419195888407 | (37.7721477499918, -122.419195888407) | 8 | 2 | 9 | 28853 | 19 | ||
| 53635 | 139231 | DPW Maintained 1 | Tristania conferta :: 61 | 1401 WEBSTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6003635.3387 | 2113448.027 | 37.7833308271099 | -122.431114746699 | (37.7833308271099, -122.431114746699) | 15 | 9 | 11 | 29490 | 41 | |||
| 59643 | 6906 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2017 09:59:00 AM | 3 | 3X3 | 6005816.7808 | 2110662.8487 | 37.7758067801978 | -122.423369750882 | (37.7758067801978, -122.423369750882) | 7 | 9 | 11 | 28852 | 10 | ||
| 62375 | 95306 | DPW Maintained 1 | Tristania conferta :: 61 | 5700 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6013860.6324 | 2092285.2447 | 37.7257965069575 | -122.39425685203 | (37.7257965069575, -122.39425685203) | 10 | 3 | 8 | 58 | 1 | |||
| 63048 | 184807 | DPW Maintained 1 | Tristania conferta :: 61 | 1251 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 0ft | 5984672.983 | 2106530.3427 | 37.7632440693949 | -122.49620545091 | (37.7632440693949, -122.49620545091) | 1 | 8 | 3 | 56 | 35 | |||
| 67221 | 141932 | DPW Maintained 1 | Tristania conferta :: 61 | 1050 MCALLISTER ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004095.7926 | 2111864.1542 | 37.7790079875659 | -122.429408772279 | (37.7790079875659, -122.429408772279) | 7 | 9 | 11 | 29490 | 41 | |||
| 74345 | 21602 | DPW Maintained 1 | Tristania conferta :: 61 | 1515 Sutter St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005338.1501 | 2114762.148 | 37.7870354220648 | -122.425317233161 | (37.7870354220648, -122.425317233161) | 13 | 9 | 11 | 28858 | 13 | |||
| 84228 | 139807 | DPW Maintained 1 | Tristania conferta :: 61 | 1101 GOUGH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6005654.4625 | 2112912.0434 | 37.78197335721 | -122.424091240716 | (37.78197335721, -122.424091240716) | 7 | 9 | 11 | 28852 | 41 | |||
| 97618 | 200670 | DPW Maintained 1 | Tristania conferta :: 61 | 1587 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6015353.4507 | 2095562.261 | 37.7348774022216 | -122.389324978833 | (37.7348774022216, -122.389324978833) | 10 | 3 | 8 | 58 | 1 | |||
| 97758 | 22443 | DPW Maintained 1 | Tristania conferta :: 61 | 6025 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X3 | 6013664.0377 | 2091536.7496 | 37.7237303604467 | -122.394884072136 | (37.7237303604467, -122.394884072136) | 10 | 3 | 8 | 58 | 1 | |||
| 104500 | 200992 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015461.3418 | 2115791.5015 | 37.7904285101106 | -122.390364901286 | (37.7904285101106, -122.390364901286) | 6 | 2 | 9 | 28855 | 6 | |||
| 111988 | 6188 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005406.4851 | 2113431.574 | 37.783385856152 | -122.424986104793 | (37.783385856152, -122.424986104793) | 7 | 9 | 11 | 28858 | 41 | |||
| 112871 | 246313 | DPW Maintained 1 | Tristania conferta :: 61 | 1655 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6007004.876 | 2109202.9434 | 37.771865212234 | -122.41915623997 | (37.771865212234, -122.41915623997) | 8 | 2 | 9 | 28853 | 19 | |||
| 122790 | 257949 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 128975 | 22408 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53653 | 6013764.0013 | 2092044.0283 | 37.7251288035961 | -122.394574017561 | (37.7251288035961, -122.394574017561) | 10 | 3 | 8 | 58 | 1 | |
| 138329 | 200932 | Undocumented 4 | Tristania conferta :: 61 | 4101 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015570.0337 | 2097446.6824 | 37.7400636451013 | -122.388707674257 | (37.7400636451013, -122.388707674257) | 10 | 3 | 8 | 58 | 1 | |||
| 140821 | 95310 | DPW Maintained 1 | Tristania conferta :: 61 | 5411 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6014289.9952 | 2093175.8818 | 37.728265874158 | -122.392834846305 | (37.728265874158, -122.392834846305) | 10 | 3 | 8 | 58 | 1 | |||
| 146686 | 139732 | DPW Maintained 1 | Tristania conferta :: 61 | 1191 Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005537.4624 | 2113723.1591 | 37.7841938744022 | -122.424553722443 | (37.7841938744022, -122.424553722443) | 7 | 9 | 11 | 28858 | 41 | |||
| 151088 | 14450 | DPW Maintained 1 | Tristania conferta :: 61 | 100 Masonic Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 5998930.2641 | 2112586.1918 | 37.7806967093816 | -122.447330326113 | (37.7806967093816, -122.447330326113) | 15 | 5 | 1 | 54 | 16 | |||
| 169675 | 121013 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 4x4 | 6015189.8844 | 2115534.4395 | 37.7897076153927 | -122.391286156841 | (37.7897076153927, -122.391286156841) | 6 | 2 | 9 | 28855 | 6 | |||
| 172191 | 200964 | DPW Maintained 1 | Tristania conferta :: 61 | 5668 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6013957.0226 | 2092532.4854 | 37.7264807375175 | -122.393940935112 | (37.7264807375175, -122.393940935112) | 10 | 3 | 8 | 58 | 1 | |||
| 172205 | 140639 | DPW Maintained 1 | Tristania conferta :: 61 | 468 Stanyan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5996860.5832 | 2109999.5178 | 37.7734758965802 | -122.454303413235 | (37.7734758965802, -122.454303413235) | 15 | 5 | 2 | 29492 | 16 | |||
| 187085 | 142354 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 ELLIS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005306.3187 | 2113367.185 | 37.7832034013247 | -122.425328057916 | (37.7832034013247, -122.425328057916) | 7 | 9 | 11 | 28858 | 41 | |||
| 174856 | 200520 | DPW Maintained 1 | Tristania conferta :: 61 | 1400x La Salle Ave | 63 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6016476.5475 | 2095041.1188 | 37.7335086511389 | -122.385405700106 | (37.7335086511389, -122.385405700106) | 10 | 3 | 8 | 58 | 1 | |||
| 63696 | 200519 | DPW Maintained 1 | Tristania conferta :: 61 | 1400x La Salle Ave | 62 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016469.2023 | 2095054.3401 | 37.7335445478075 | -122.385432015834 | (37.7335445478075, -122.385432015834) | 10 | 3 | 8 | 58 | 1 | |||
| 3148 | 24262 | DPW Maintained 1 | Tristania conferta :: 61 | 600X Willow St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2004 12:00:00 AM | 3 | 3X3 | 6004514.0905 | 2113119.5269 | 37.7824786038336 | -122.428051195433 | (37.7824786038336, -122.428051195433) | 7 | 9 | 11 | 29490 | 41 | ||
| 11372 | 121012 | DPW Maintained 1 | Tristania conferta :: 61 | 199X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 4x4 | 6015178.5737 | 2115521.0723 | 37.7896702844128 | -122.391324356251 | (37.7896702844128, -122.391324356251) | 6 | 2 | 9 | 28855 | 6 | |||
| 16944 | 1665 | DPW Maintained 1 | Tristania conferta :: 61 | 1400X Fell St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/06/1992 12:00:00 AM | 18 | 3X3 | 6000409.8977 | 2109962.9335 | 37.7735783473195 | -122.442023227789 | (37.7735783473195, -122.442023227789) | 15 | 5 | 11 | 29492 | 16 | ||
| 25862 | 29433 | DPW Maintained 1 | Tristania conferta :: 61 | 2401X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2011 12:00:00 AM | 3 | 3x3 | 6015500.9632 | 2091579.7516 | 37.7239504043026 | -122.388537076537 | (37.7239504043026, -122.388537076537) | 10 | 3 | 8 | 58 | 1 | ||
| 26474 | 6905 | DPW Maintained 1 | Tristania conferta :: 61 | 333 Fell St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6005791.8208 | 2110660.0754 | 37.7757977566382 | -122.423455896757 | (37.7757977566382, -122.423455896757) | 7 | 9 | 11 | 28852 | 10 | |||
| 27103 | 200991 | DPW Maintained 1 | Tristania conferta :: 61 | 75 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6015446.9463 | 2115775.0495 | 37.7903825381625 | -122.390413559192 | (37.7903825381625, -122.390413559192) | 6 | 2 | 9 | 28855 | 6 | |||
| 27181 | 9604 | DPW Maintained 1 | Tristania conferta :: 61 | 1355 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6003125.8375 | 2112021.5623 | 37.7793852280154 | -122.432775482637 | (37.7793852280154, -122.432775482637) | 15 | 9 | 11 | 29490 | 41 | |||
| 37021 | 95600 | DPW Maintained 1 | Tristania conferta :: 61 | 1625 Carroll Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6014023.4144 | 2092013.9314 | 37.7250605821221 | -122.393675141136 | (37.7250605821221, -122.393675141136) | 10 | 3 | 8 | 58 | 1 | |||
| 37867 | 139932 | DPW Maintained 1 | Tristania conferta :: 61 | 800 GOUGH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005703.8894 | 2112554.5236 | 37.7809944860981 | -122.423894815633 | (37.7809944860981, -122.423894815633) | 7 | 9 | 11 | 28852 | 41 | |||
| 42123 | 140638 | DPW Maintained 1 | Tristania conferta :: 61 | 472 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5996864.7991 | 2109972.3061 | 37.7734014220919 | -122.454286863982 | (37.7734014220919, -122.454286863982) | 15 | 5 | 2 | 29492 | 16 | |||
| 44887 | 29426 | DPW Maintained 1 | Tristania conferta :: 61 | 2501X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015353.5854 | 2091384.7495 | 37.723406798628 | -122.389032933904 | (37.723406798628, -122.389032933904) | 10 | 3 | 8 | 58 | 1 | ||
| 46309 | 199800 | DPW Maintained 1 | Tristania conferta :: 61 | 2655 Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015155.3655 | 2091117.0238 | 37.7226606870185 | -122.389699459103 | (37.7226606870185, -122.389699459103) | 10 | 3 | 8 | 58 | 1 | |||
| 65091 | 22405 | DPW Maintained 1 | Tristania conferta :: 61 | 5800 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/1992 12:00:00 AM | 5 | 3X3 | 6013773.1583 | 2092062.8244 | 37.7251809229772 | -122.394543678104 | (37.7251809229772, -122.394543678104) | 10 | 3 | 8 | 58 | 1 | ||
| 76889 | 30096 | DPW Maintained 1 | Tristania conferta :: 61 | 6190X 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2011 12:00:00 AM | 6 | 3x3 | 6013417.4786 | 2091122.0564 | 37.7225779836625 | -122.395707348923 | (37.7225779836625, -122.395707348923) | 10 | 3 | 8 | 58 | 1 | ||
| 79872 | 200931 | DPW Maintained 1 | Tristania conferta :: 61 | 4101 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015563.8928 | 2097421.6465 | 37.7399945612986 | -122.388727159879 | (37.7399945612986, -122.388727159879) | 10 | 3 | 8 | 58 | 1 | |||
| 86043 | 138229 | DPW Maintained 1 | Tristania conferta :: 61 | 101 Anza St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998536.6795 | 2112630.6942 | 37.7807964033341 | -122.448695125032 | (37.7807964033341, -122.448695125032) | 15 | 6 | 2 | 54 | 16 | |||
| 91017 | 15287 | DPW Maintained 1 | Tristania conferta :: 61 | 1600 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007004.1044 | 2109328.3326 | 37.7722094576916 | -122.41916780485 | (37.7722094576916, -122.41916780485) | 8 | 2 | 9 | 28853 | 19 | ||
| 104949 | 22397 | DPW Maintained 1 | Tristania conferta :: 61 | 5700 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1995 12:00:00 AM | 6 | 3X3 | 6013870.7534 | 2092308.3783 | 37.7258605897355 | -122.394223483114 | (37.7258605897355, -122.394223483114) | 10 | 3 | 8 | 58 | 1 | ||
| 114302 | 139806 | DPW Maintained 1 | Tristania conferta :: 61 | 1101 GOUGH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6005650.9929 | 2112934.249 | 37.7820341324354 | -122.424104823616 | (37.7820341324354, -122.424104823616) | 7 | 9 | 11 | 28852 | 41 | |||
| 124213 | 200669 | DPW Maintained 1 | Tristania conferta :: 61 | 1589 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6015338.0615 | 2095574.9021 | 37.7349112589219 | -122.389379067602 | (37.7349112589219, -122.389379067602) | 10 | 3 | 8 | 58 | 1 | |||
| 132192 | 142796 | DPW Maintained 1 | Tristania conferta :: 61 | 533 Larkin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6007561.1357 | 2113189.4218 | 37.7828424376989 | -122.417514674644 | (37.7828424376989, -122.417514674644) | 7 | 9 | 9 | 28852 | 36 | |||
| 141864 | 246311 | Undocumented 4 | Tristania conferta :: 61 | 1601 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6007089.8834 | 2109370.8451 | 37.772331017243 | -122.418874102872 | (37.772331017243, -122.418874102872) | 8 | 2 | 9 | 28853 | 19 | |||
| 150184 | 21601 | DPW Maintained 1 | Tristania conferta :: 61 | 1515 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005314.151 | 2114757.5524 | 37.7870214478079 | -122.42539993759 | (37.7870214478079, -122.42539993759) | 13 | 9 | 11 | 28858 | 13 | |||
| 161261 | 200913 | DPW Maintained 1 | Tristania conferta :: 61 | 3801 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6015728.5157 | 2097971.7279 | 37.7415140947501 | -122.388196336709 | (37.7415140947501, -122.388196336709) | 10 | 3 | 8 | 58 | 1 | |||
| 162144 | 95309 | DPW Maintained 1 | Tristania conferta :: 61 | 5411 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6014280.838 | 2093157.5675 | 37.7282150781576 | -122.392865222605 | (37.7282150781576, -122.392865222605) | 10 | 3 | 8 | 58 | 1 | |||
| 162433 | 99007 | DPW Maintained 1 | Tristania conferta :: 61 | 2099X Beach St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 01/20/2015 12:00:00 AM | 3 | Permit Number 771149 | 6000381.4 | 2120794.3 | 37.8033168379221 | -122.442899765771 | (37.8033168379221, -122.442899765771) | 13 | 9 | 1 | 57 | 17 | ||
| 176867 | 137780 | DPW Maintained 1 | Tristania conferta :: 61 | 1773 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6001115.5375 | 2111737.5615 | 37.7784912146937 | -122.439709572654 | (37.7784912146937, -122.439709572654) | 15 | 5 | 11 | 29490 | 41 | |||
| 180500 | 199893 | DPW Maintained 1 | Tristania conferta :: 61 | 1700 Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016554.6632 | 2093059.5354 | 37.7280719375741 | -122.384997617963 | (37.7280719375741, -122.384997617963) | 10 | 3 | 8 | 58 | 1 | |||
| 180990 | 6201 | DPW Maintained 1 | Tristania conferta :: 61 | 1135 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005283.7179 | 2113361.2024 | 37.7831856976936 | -122.42540582178 | (37.7831856976936, -122.42540582178) | 7 | 9 | 11 | 28858 | 41 | |||
| 182717 | 6187 | DPW Maintained 1 | Tristania conferta :: 61 | 1100 Ellis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005423.3129 | 2113433.3911 | 37.783391795987 | -122.424928016493 | (37.783391795987, -122.424928016493) | 7 | 9 | 11 | 28858 | 41 | |||
| 183125 | 29440 | DPW Maintained 1 | Tristania conferta :: 61 | 2301X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015660.6839 | 2091799.6156 | 37.7245629575419 | -122.388000277891 | (37.7245629575419, -122.388000277891) | 10 | 3 | 8 | 58 | 1 | ||
| 190547 | 257948 | Undocumented 4 | Tristania conferta :: 61 | 901x Gough St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005635 | 2113075 | 37.782419697088 | -122.42417016492 | (37.782419697088, -122.42417016492) | 7 | 9 | 11 | 28852 | 41 | ||||
| 191309 | 140352 | DPW Maintained 1 | Tristania conferta :: 61 | 1314 ELLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004399.7686 | 2113290.1868 | 37.7829407248934 | -122.428458867439 | (37.7829407248934, -122.428458867439) | 7 | 9 | 11 | 29490 | 41 | |||
| 192100 | 29386 | DPW Maintained 1 | Tristania conferta :: 61 | 3199X Ingalls St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014271.9163 | 2089934.5554 | 37.7193648351704 | -122.392670694873 | (37.7193648351704, -122.392670694873) | 10 | 3 | 8 | 58 | 1 | ||
| 193240 | 143432 | DPW Maintained 1 | Tristania conferta :: 61 | 855 SACRAMENTO ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6010753.9601 | 2116917.9148 | 37.7932591248157 | -122.406731631165 | (37.7932591248157, -122.406731631165) | 3 | 1 | 10 | 28857 | 4 | |||
| 7868 | 140649 | DPW Maintained 1 | Tristania conferta :: 61 | 109 Shrader St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5997299.8022 | 2110011.7822 | 37.7735347493893 | -122.452784984309 | (37.7735347493893, -122.452784984309) | 15 | 5 | 2 | 29492 | 16 | |||
| 14066 | 141995 | DPW Maintained 1 | Tristania conferta :: 61 | 818 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1999 12:00:00 AM | 5 | Width 0ft | 6003983.7554 | 2111636.8614 | 37.778377554053 | -122.429780137803 | (37.778377554053, -122.429780137803) | 7 | 9 | 11 | 29490 | 41 | ||
| 15889 | 245992 | DPW Maintained 1 | Tristania conferta :: 61 | 1250 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5999690.8568 | 2108469.5931 | 37.7694370106113 | -122.444403147816 | (37.7694370106113, -122.444403147816) | 15 | 5 | 11 | 29492 | 9 | |||
| 16824 | 13677 | DPW Maintained 1 | Tristania conferta :: 61 | 681 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/14/2020 12:00:00 AM | 3 | 4X4 | Permit Number 771659 | 6011836.71983 | 2114948.58904 | 37.7879123453203 | -122.402846621288 | (37.7879123453203, -122.402846621288) | 12 | 2 | 9 | 28855 | 6 | |
| 18999 | 29494 | DPW Maintained 1 | Tristania conferta :: 61 | 1700X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016622.9685 | 2093155.934 | 37.7283404071211 | -122.384768194628 | (37.7283404071211, -122.384768194628) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );