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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 880 | 880 | 246102 | DPW Maintained 3 | Tristania conferta :: 79 | 1764 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 5997188.4287 | 2108119.9769 | 37.768333957535795 | -122.453033652641 | (37.7683339575358, -122.453033652641) | |||
| 978 | 978 | 200822 | DPW Maintained 3 | Tristania conferta :: 79 | 5266 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6014368.9731 | 2093728.9009999998 | 37.7297887395904 | -122.392600482998 | (37.7297887395904, -122.392600482998) | |||
| 979 | 979 | 200925 | Undocumented 2 | Tristania conferta :: 79 | 4100 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | Width 0ft | 6015478.3928 | 2097437.2349 | 37.7400326248174 | -122.389023874228 | (37.7400326248174, -122.389023874228) | ||
| 986 | 986 | 200823 | DPW Maintained 3 | Tristania conferta :: 79 | 5286 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/1998 12:00:00 AM | 4 | Width 0ft | 6014347.7859 | 2093662.4762 | 37.7296051738385 | -122.392669085224 | (37.7296051738385, -122.392669085224) | ||
| 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) | |||
| 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) | |||
| 1978 | 1978 | 141844 | DPW Maintained 3 | Tristania conferta :: 79 | 1295 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/24/2015 09:40:00 AM | 8 | Width 0ft | 6004339.0372 | 2112890.3204 | 37.781839354336 | -122.428640459804 | (37.781839354336, -122.428640459804) | ||
| 1999 | 1999 | 141841 | DPW Maintained 3 | Tristania conferta :: 79 | 1297 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 0ft | 6004290.5512 | 2112882.1345 | 37.781814133771704 | -122.42880761506001 | (37.7818141337717, -122.42880761506) | |||
| 2670 | 2670 | 246001 | DPW Maintained 3 | Tristania conferta :: 79 | 1437 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 3 | Width 0ft | 5999214.6581 | 2108701.4088 | 37.7700463362513 | -122.446066968815 | (37.7700463362513, -122.446066968815) | ||
| 2701 | 2701 | 141995 | DPW Maintained 3 | Tristania conferta :: 79 | 818 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/1999 12:00:00 AM | 5 | Width 0ft | 6003983.7554 | 2111636.8614 | 37.778377554053 | -122.42978013780301 | (37.778377554053, -122.429780137803) | ||
| 2710 | 2710 | 141992 | DPW Maintained 3 | Tristania conferta :: 79 | 818 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2005 12:00:00 AM | 9 | Width 0ft | 6003994.291 | 2111559.6951 | 37.778166271074205 | -122.429738185966 | (37.7781662710742, -122.429738185966) | ||
| 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) | ||
| 2936 | 2936 | 246076 | Permitted Site 1 | Tristania conferta :: 79 | 1215 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 11 | Width 0ft | Permit Number 17670 | 5999867.5576 | 2108450.6663 | 37.769395122673394 | -122.443790589358 | (37.7693951226734, -122.443790589358) | |
| 2972 | 2972 | 246077 | Permitted Site 1 | Tristania conferta :: 79 | 1221 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1980 12:00:00 AM | 6 | Width 0ft | Permit Number 17671 | 5999841.5143 | 2108446.1238 | 37.769381164613 | -122.443880345259 | (37.769381164613, -122.443880345259) | |
| 2981 | 2981 | 245990 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 11 | Width 0ft | Permit Number 53135 | 5999824.4044 | 2108487.46 | 37.76949368743671 | -122.44394249781901 | (37.7694936874367, -122.443942497819) | |
| 2995 | 2995 | 245989 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 14 | Width 0ft | Permit Number 53135 | 5999854.6873 | 2108493.8194 | 37.7695128761205 | -122.443838207787 | (37.7695128761205, -122.443838207787) | |
| 3047 | 3047 | 246310 | DPW Maintained 3 | Tristania conferta :: 79 | 1601 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2012 10:05:00 AM | 2 | Width 0ft | 6007075.5388 | 2109348.1328 | 37.7722678469563 | -122.41892211112301 | (37.7722678469563, -122.418922111123) | ||
| 3074 | 3074 | 199930 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016497.9258 | 2092921.8231 | 37.727690668221506 | -122.385184171361 | (37.7276906682215, -122.385184171361) | ||
| 3081 | 3081 | 199928 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/27/2008 12:00:00 AM | 4 | Width 0ft | 6016476.4427 | 2092884.9162 | 37.727588140695204 | -122.385255868852 | (37.7275881406952, -122.385255868852) | ||
| 3082 | 3082 | 199927 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 5 | Width 0ft | 6016464.324 | 2092869.4925 | 37.7275451198245 | -122.385296689415 | (37.7275451198245, -122.385296689415) | ||
| 3105 | 3105 | 199929 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | ||
| 4588 | 4588 | 200921 | Permitted Site 1 | Tristania conferta :: 79 | 4040 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/18/2008 12:00:00 AM | 5 | Width 0ft | 6015547.5959 | 2097647.2059 | 37.7406129979736 | -122.388799250904 | (37.7406129979736, -122.388799250904) | |
| 22810 | 22810 | 141129 | Undocumented 2 | Tristania conferta :: 79 | 1740 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6002454.9272 | 2113020.8946 | 37.782091069378296 | -122.43516793707701 | (37.7820910693783, -122.435167937077) | |||
| 22844 | 22844 | 141842 | Undocumented 2 | Tristania conferta :: 79 | 1268 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004263.4746 | 2112800.275 | 37.7815878353953 | -122.42889544965401 | (37.7815878353953, -122.428895449654) | |||
| 23419 | 23419 | 141308 | Undocumented 2 | Tristania conferta :: 79 | 217 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998909.1127 | 2112249.8005 | 37.7797718573521 | -122.44737927944401 | (37.7797718573521, -122.447379279444) | |||
| 23565 | 23565 | 140557 | Undocumented 2 | Tristania conferta :: 79 | 1175 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003583.5208 | 2111740.6921 | 37.7786399751241 | -122.43117211119 | (37.7786399751241, -122.43117211119) | |||
| 23573 | 23573 | 143104 | Undocumented 2 | Tristania conferta :: 79 | 1736 STOCKTON ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6010039.5193 | 2120117.0378 | 37.8020031344426 | -122.40942953292802 | (37.8020031344426, -122.409429532928) | |||
| 23809 | 23809 | 139263 | Undocumented 2 | Tristania conferta :: 79 | 760 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004028.8382 | 2111306.0158 | 37.7774716865894 | -122.42960057778 | (37.7774716865894, -122.42960057778) | |||
| 24026 | 24026 | 140096 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005837.0353 | 2111584.8045 | 37.7783393900211 | -122.42336524088002 | (37.7783393900211, -122.42336524088) | |||
| 24280 | 24280 | 143114 | Undocumented 2 | Tristania conferta :: 79 | 1463 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6005363.4287 | 2119869.54 | 37.801060458669795 | -122.42559341080499 | (37.8010604586698, -122.425593410805) | |||
| 25095 | 25095 | 139803 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005645.0945 | 2112991.4978 | 37.7821909905379 | -122.42412930203699 | (37.7821909905379, -122.424129302037) | |||
| 25138 | 25138 | 138681 | Undocumented 2 | Tristania conferta :: 79 | 3050 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999237.6946 | 2114657.8109999998 | 37.786402399412 | -122.44641585719 | (37.786402399412, -122.44641585719) | |||
| 25260 | 25260 | 137791 | Undocumented 2 | Tristania conferta :: 79 | 1711 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005267.8978 | 2115649.4507 | 37.789467764436395 | -122.425623465766 | (37.7894677644364, -122.425623465766) | |||
| 25264 | 25264 | 142786 | Undocumented 2 | Tristania conferta :: 79 | 730 POLK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007071.7839 | 2113562.2092 | 37.7838384745362 | -122.419234083256 | (37.7838384745362, -122.419234083256) | |||
| 26024 | 26024 | 245425 | Undocumented 2 | Tristania conferta :: 79 | 2500 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6009073.1901 | 2106875.611 | 37.7655911583595 | -122.411837285128 | (37.7655911583595, -122.411837285128) | |||
| 26424 | 26424 | 143385 | Undocumented 2 | Tristania conferta :: 79 | 1658 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004429.3589 | 2119821.4466 | 37.800875583620794 | -122.428822263738 | (37.8008755836208, -122.428822263738) | |||
| 26560 | 26560 | 245957 | Undocumented 2 | Tristania conferta :: 79 | 850 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997681.1316 | 2107596.9911 | 37.7669261962578 | -122.451291725243 | (37.7669261962578, -122.451291725243) | |||
| 26582 | 26582 | 244213 | Undocumented 2 | Tristania conferta :: 79 | 322 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004508.1464 | 2109493.0779 | 37.7725209302455 | -122.427813281818 | (37.7725209302455, -122.427813281818) | |||
| 26584 | 26584 | 137902 | Undocumented 2 | Tristania conferta :: 79 | 404 Austin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005251.6199 | 2115313.5756 | 37.788544615646 | -122.425655870363 | (37.788544615646, -122.425655870363) | |||
| 26798 | 26798 | 199951 | Undocumented 2 | Tristania conferta :: 79 | 1899 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016408.6882 | 2092795.6787 | 37.7273393636102 | -122.38548388280701 | (37.7273393636102, -122.385483882807) | |||
| 27173 | 27173 | 247332 | Undocumented 2 | Tristania conferta :: 79 | 755 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003759.8807 | 2110373.3337 | 37.7748955391679 | -122.430464426106 | (37.7748955391679, -122.430464426106) | |||
| 27596 | 27596 | 139676 | Undocumented 2 | Tristania conferta :: 79 | 2130 O'Farrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000922.1046 | 2113153.0063 | 37.782366653551605 | -122.44048027276199 | (37.7823666535516, -122.440480272762) | |||
| 27680 | 27680 | 142315 | Undocumented 2 | Tristania conferta :: 79 | 1679 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999782.049 | 2110521.1531 | 37.7750752776396 | -122.444235164846 | (37.7750752776396, -122.444235164846) | |||
| 27736 | 27736 | 140098 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005841.2329 | 2111549.6492 | 37.7782430990341 | -122.42334822002701 | (37.7782430990341, -122.423348220027) | |||
| 27756 | 27756 | 199895 | Undocumented 2 | Tristania conferta :: 79 | 1700 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016530.9767 | 2093031.4421 | 37.7279934886935 | -122.38507754718599 | (37.7279934886935, -122.385077547186) | |||
| 27762 | 27762 | 141282 | Undocumented 2 | Tristania conferta :: 79 | 311 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998168.815 | 2112585.6841 | 37.780651775237395 | -122.44996449635201 | (37.7806517752374, -122.449964496352) | |||
| 27993 | 27993 | 138916 | Undocumented 2 | Tristania conferta :: 79 | 707 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004396.0968 | 2110813.5411 | 37.7761402601039 | -122.428295000541 | (37.7761402601039, -122.428295000541) | |||
| 28165 | 28165 | 244387 | Undocumented 2 | Tristania conferta :: 79 | 877 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003242.3169 | 2110300.201 | 37.774665402715705 | -122.432249563339 | (37.7746654027157, -122.432249563339) | |||
| 28177 | 28177 | 244436 | Undocumented 2 | Tristania conferta :: 79 | 404 Rose St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004598.6589 | 2109671.3511 | 37.7730155449031 | -122.42751289271999 | (37.7730155449031, -122.42751289272) | |||
| 28226 | 28226 | 141974 | Undocumented 2 | Tristania conferta :: 79 | 620 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004711.5378 | 2111604.9174 | 37.778331029000505 | -122.42726018965 | (37.7783310290005, -122.42726018965) | |||
| 28713 | 28713 | 199660 | Undocumented 2 | Tristania conferta :: 79 | 2799 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6014919.1748 | 2090797.1689 | 37.7217693287026 | -122.390493586774 | (37.7217693287026, -122.390493586774) | |||
| 28789 | 28789 | 141775 | Undocumented 2 | Tristania conferta :: 79 | 1330 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003753.6876 | 2113301.7561 | 37.7829359095028 | -122.430694865244 | (37.7829359095028, -122.430694865244) | |||
| 28829 | 28829 | 200962 | Undocumented 2 | Tristania conferta :: 79 | 5600 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013974.3728 | 2092581.6444 | 37.726616682460204 | -122.393884395326 | (37.7266166824602, -122.393884395326) | |||
| 29166 | 29166 | 137923 | Undocumented 2 | Tristania conferta :: 79 | 1901 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003379.2097 | 2115283.9028 | 37.788357161353105 | -122.432131998946 | (37.7883571613531, -122.432131998946) | |||
| 29369 | 29369 | 199905 | Undocumented 2 | Tristania conferta :: 79 | 1298 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6016747.5421 | 2093255.8132 | 37.7286215447387 | -122.38434448732599 | (37.7286215447387, -122.384344487326) | |||
| 29400 | 29400 | 141784 | Undocumented 2 | Tristania conferta :: 79 | 1380 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003871.6154 | 2112872.0612 | 37.7817627549494 | -122.43025621822599 | (37.7817627549494, -122.430256218226) | |||
| 29635 | 29635 | 200799 | Undocumented 2 | Tristania conferta :: 79 | 5307 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6014333.8188 | 2093306.6984 | 37.7286275041699 | -122.39269249263599 | (37.7286275041699, -122.392692492636) | |||
| 29984 | 29984 | 140324 | Undocumented 2 | Tristania conferta :: 79 | 1465 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004553.8078 | 2113880.8448 | 37.784571240321604 | -122.42796805864799 | (37.7845712403216, -122.427968058648) | |||
| 30044 | 30044 | 140524 | Undocumented 2 | Tristania conferta :: 79 | 1140 MCALLISTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003674.0233 | 2111802.6448 | 37.778815210032 | -122.430863450741 | (37.778815210032, -122.430863450741) | |||
| 30128 | 30128 | 141814 | Undocumented 2 | Tristania conferta :: 79 | 621 WILLOW ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004559.3867 | 2113103.2378 | 37.782436440597294 | -122.42789332920499 | (37.7824364405973, -122.427893329205) | |||
| 30173 | 30173 | 199711 | Undocumented 2 | Tristania conferta :: 79 | 1510 Wallace Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6015245.4888 | 2092572.1176 | 37.7266610833371 | -122.389489489481 | (37.7266610833371, -122.389489489481) | |||
| 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) | |||
| 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) | |||
| 30658 | 30658 | 140638 | Undocumented 2 | Tristania conferta :: 79 | 472 Stanyan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996864.7991 | 2109972.3061 | 37.7734014220919 | -122.45428686398199 | (37.7734014220919, -122.454286863982) | |||
| 30730 | 30730 | 142336 | Undocumented 2 | Tristania conferta :: 79 | 1696 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999780.0519 | 2110221.7447 | 37.7742530643991 | -122.444220553239 | (37.7742530643991, -122.444220553239) | |||
| 30896 | 30896 | 138911 | Undocumented 2 | Tristania conferta :: 79 | 723 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004266.8521 | 2110794.1209 | 37.776079623036 | -122.428740708053 | (37.776079623036, -122.428740708053) | |||
| 30915 | 30915 | 142286 | Undocumented 2 | Tristania conferta :: 79 | 1670 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999804.9802 | 2110571.1381 | 37.7752138319513 | -122.444159433615 | (37.7752138319513, -122.444159433615) | |||
| 30969 | 30969 | 140095 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005831.7882 | 2111608.4162 | 37.77840392585679 | -122.423385071553 | (37.7784039258568, -122.423385071553) | |||
| 30970 | 30970 | 141807 | Undocumented 2 | Tristania conferta :: 79 | 1398 WILLOW ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004301.1437 | 2113069.4068 | 37.7823289364611 | -122.42878432451201 | (37.7823289364611, -122.428784324512) | |||
| 31370 | 31370 | 201231 | Undocumented 2 | Tristania conferta :: 79 | 405 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014377.5686 | 2114753.9994 | 37.787519592158496 | -122.39404205332899 | (37.7875195921585, -122.394042053329) | |||
| 31503 | 31503 | 142082 | Undocumented 2 | Tristania conferta :: 79 | 1593 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000216.454 | 2110924.9728 | 37.776208837743894 | -122.442761469865 | (37.7762088377439, -122.442761469865) | |||
| 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) | |||
| 31611 | 31611 | 137788 | Undocumented 2 | Tristania conferta :: 79 | 1711 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005258.2038 | 2115760.6088 | 37.789772428971 | -122.425664920751 | (37.789772428971, -122.425664920751) | |||
| 31667 | 31667 | 199657 | Undocumented 2 | Tristania conferta :: 79 | 1395 Donner Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015062.4933 | 2090889.5822 | 37.7220310269415 | -122.39000462027599 | (37.7220310269415, -122.390004620276) | |||
| 31989 | 31989 | 140231 | Undocumented 2 | Tristania conferta :: 79 | 2227 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997121.9683 | 2110490.0939 | 37.774837877214104 | -122.45343467561199 | (37.7748378772141, -122.453434675612) | |||
| 32015 | 32015 | 184222 | Undocumented 2 | Tristania conferta :: 79 | 3521 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983907.1382 | 2104926.4256 | 37.7587952746185 | -122.49873571831999 | (37.7587952746185, -122.49873571832) | |||
| 32255 | 32255 | 247284 | Undocumented 2 | Tristania conferta :: 79 | 1432 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999197.6689 | 2108750.6497 | 37.7701805691053 | -122.44612927641501 | (37.7701805691053, -122.446129276415) | |||
| 32291 | 32291 | 140132 | Undocumented 2 | Tristania conferta :: 79 | 501 GOUGH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005852.7764 | 2111465.1717 | 37.778011795869006 | -122.42330228001002 | (37.778011795869, -122.42330228001) | |||
| 32382 | 32382 | 200015 | Undocumented 2 | Tristania conferta :: 79 | 1021 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6018293.9123 | 2092319.9509 | 37.7261372321338 | -122.37893357191099 | (37.7261372321338, -122.378933571911) | |||
| 32392 | 32392 | 137777 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001052.3759 | 2111729.7512 | 37.7784661743304 | -122.439927511873 | (37.7784661743304, -122.439927511873) | |||
| 32620 | 32620 | 199933 | Undocumented 2 | Tristania conferta :: 79 | 1898 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016396.5695 | 2092856.2721 | 37.7275050706356 | -122.385529998516 | (37.7275050706356, -122.385529998516) | |||
| 32804 | 32804 | 137881 | Undocumented 2 | Tristania conferta :: 79 | 1859 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6005045.9205 | 2115408.4016 | 37.7887933587006 | -122.42637431353201 | (37.7887933587006, -122.426374313532) | |||
| 32931 | 32931 | 142689 | Undocumented 2 | Tristania conferta :: 79 | 554 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6008629.0451 | 2121101.0906 | 37.8046259673251 | -122.414380126753 | (37.8046259673251, -122.414380126753) | |||
| 32990 | 32990 | 141276 | Undocumented 2 | Tristania conferta :: 79 | 351 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5998048.3369 | 2112566.7325 | 37.780592844686204 | -122.45037991931999 | (37.7805928446862, -122.45037991932) | |||
| 33025 | 33025 | 140323 | Undocumented 2 | Tristania conferta :: 79 | 1465 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004546.9673 | 2113926.2686 | 37.78469557575121 | -122.42799496248001 | (37.7846955757512, -122.42799496248) | |||
| 33091 | 33091 | 200934 | Undocumented 2 | Tristania conferta :: 79 | 4220 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015398.3252 | 2097166.7998 | 37.73928562681979 | -122.38928183799801 | (37.7392856268198, -122.389281837998) | |||
| 33237 | 33237 | 200504 | Undocumented 2 | Tristania conferta :: 79 | 5835 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6013821.0176 | 2091948.8219 | 37.7248705556165 | -122.394370253635 | (37.7248705556165, -122.394370253635) | |||
| 33384 | 33384 | 141091 | Undocumented 2 | Tristania conferta :: 79 | 194 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996268.2382 | 2112980.2839 | 37.78162630877429 | -122.456568006554 | (37.7816263087743, -122.456568006554) | |||
| 33862 | 33862 | 142046 | Undocumented 2 | Tristania conferta :: 79 | 365 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005924.2473 | 2110971.3816 | 37.7766600015096 | -122.42301993075 | (37.7766600015096, -122.42301993075) | |||
| 34095 | 34095 | 137898 | Undocumented 2 | Tristania conferta :: 79 | 1826 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003442.8192 | 2115139.0382 | 37.787963006088 | -122.43190157246599 | (37.787963006088, -122.431901572466) | |||
| 34259 | 34259 | 199768 | Undocumented 2 | Tristania conferta :: 79 | 2029 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016150.937999999 | 2092445.1351 | 37.7263625758948 | -122.386350503257 | (37.7263625758948, -122.386350503257) | |||
| 34345 | 34345 | 200150 | Undocumented 2 | Tristania conferta :: 79 | 6199 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013507.0577 | 2091126.6395 | 37.7225955506276 | -122.39539801261499 | (37.7225955506276, -122.395398012615) | |||
| 34727 | 34727 | 200931 | Undocumented 2 | Tristania conferta :: 79 | 4101 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6015563.8928 | 2097421.6465 | 37.7399945612986 | -122.388727159879 | (37.7399945612986, -122.388727159879) | |||
| 34740 | 34740 | 199817 | Undocumented 2 | Tristania conferta :: 79 | 2224 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6015723.8893 | 2091960.1023 | 37.7250071238567 | -122.38779297577899 | (37.7250071238567, -122.387792975779) | |||
| 34767 | 34767 | 143135 | Undocumented 2 | Tristania conferta :: 79 | 2684 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999523.0401 | 2119140.8402 | 37.79872790718311 | -122.445751158267 | (37.7987279071831, -122.445751158267) | |||
| 34825 | 34825 | 141281 | Undocumented 2 | Tristania conferta :: 79 | 313 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998146.1408 | 2112582.9767 | 37.7806430439961 | -122.45004274172301 | (37.7806430439961, -122.450042741723) | |||
| 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) | |||
| 35592 | 35592 | 140677 | Undocumented 2 | Tristania conferta :: 79 | 1307 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004183.5277 | 2113015.8026 | 37.7821750951609 | -122.429187400422 | (37.7821750951609, -122.429187400422) | |||
| 35787 | 35787 | 245464 | Undocumented 2 | Tristania conferta :: 79 | 2601 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6008830.1741 | 2106813.5651 | 37.76540715826 | -122.41267343991501 | (37.76540715826, -122.412673439915) | |||
| 35829 | 35829 | 139042 | Undocumented 2 | Tristania conferta :: 79 | 1434 BAKER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6000193.0745 | 2113977.6097 | 37.7845892631082 | -122.443061626662 | (37.7845892631082, -122.443061626662) |
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");