Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5834 | 5834 | 6999 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002754.2205 | 2110289.0229 | 37.774607023478 | -122.433937185692 | (37.774607023478, -122.433937185692) | ||
| 5872 | 5872 | 24489 | Permitted Site 1 | Tristania conferta :: 79 | 840 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6003385.8226 | 2110373.2704 | 37.774874168918 | -122.43175836681499 | (37.774874168918, -122.431758366815) | ||
| 5987 | 5987 | 28074 | Permitted Site 1 | Tristania conferta :: 79 | 915 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008638.4319 | 2120527.3912 | 37.8030512599832 | -122.414307026238 | (37.8030512599832, -122.414307026238) | ||
| 6001 | 6001 | 5894 | Permitted Site 1 | Tristania conferta :: 79 | 1142 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 3 | 3X3 | 6004948.741 | 2113023.7653 | 37.7822402475105 | -122.42654067221599 | (37.7822402475105, -122.426540672216) | ||
| 6257 | 6257 | 18235 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1999 12:00:00 AM | 3 | 4X4 | 6003758.3462 | 2114245.8879 | 37.7855285225047 | -122.430746144837 | (37.7855285225047, -122.430746144837) | ||
| 6506 | 6506 | 9520 | Permitted Site 1 | Tristania conferta :: 79 | 1046 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004532.0878 | 2112270.4724 | 37.780148328739706 | -122.42792841204799 | (37.7801483287397, -122.427928412048) | ||
| 6587 | 6587 | 5904 | DPW Maintained 3 | Tristania conferta :: 79 | 1256 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004447.9733 | 2112952.6596 | 37.782016686789 | -122.428268035802 | (37.782016686789, -122.428268035802) | ||
| 6593 | 6593 | 7059 | DPW Maintained 3 | Tristania conferta :: 79 | 1516 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6000148.3323 | 2109926.5898 | 37.773463647588 | -122.44292540854099 | (37.773463647588, -122.442925408541) | ||
| 6633 | 6633 | 17842 | DPW Maintained 3 | Tristania conferta :: 79 | 2031 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004091.8528 | 2115280.5278 | 37.7883882726819 | -122.42966612859699 | (37.7883882726819, -122.429666128597) | |||
| 6645 | 6645 | 1662 | Permitted Site 1 | Tristania conferta :: 79 | 1400X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000535.6523 | 2109979.223 | 37.7736302396696 | -122.441589394177 | (37.7736302396696, -122.441589394177) | ||
| 6856 | 6856 | 26449 | DPW Maintained 3 | Tristania conferta :: 79 | 1096 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2004 12:00:00 AM | 3 | 3X3 | 6005161.0819 | 2113052.9102 | 37.7823322739768 | -122.425808142175 | (37.7823322739768, -122.425808142175) | ||
| 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) | ||
| 7125 | 7125 | 18238 | DPW Maintained 3 | Tristania conferta :: 79 | 1790X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2000 12:00:00 AM | 3 | 4X4 | 6003705.6129 | 2114238.8254 | 37.7855061428919 | -122.430928082284 | (37.7855061428919, -122.430928082284) | ||
| 7203 | 7203 | 8199 | DPW Maintained 3 | Tristania conferta :: 79 | 1310X Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2011 12:00:00 AM | 3 | 3x3 | 6001414.7162 | 2111141.806 | 37.7768724447291 | -122.438631903562 | (37.7768724447291, -122.438631903562) | ||
| 7208 | 7208 | 5898 | Permitted Site 1 | Tristania conferta :: 79 | 1174 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 3 | 3X3 | 6004835.6312 | 2113008.499 | 37.782191935057504 | -122.42693089417101 | (37.7821919350575, -122.426930894171) | ||
| 7450 | 7450 | 5896 | DPW Maintained 3 | Tristania conferta :: 79 | 1160 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 3 | 3x3 | 6004888.3695 | 2113012.6625 | 37.7822063488626 | -122.426748739826 | (37.7822063488626, -122.426748739826) | ||
| 7459 | 7459 | 7015 | Permitted Site 1 | Tristania conferta :: 79 | 1050 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002372.7109 | 2110234.5481 | 37.7744357915241 | -122.435253003778 | (37.7744357915241, -122.435253003778) | ||
| 7923 | 7923 | 12350 | DPW Maintained 3 | Tristania conferta :: 79 | 1280 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1997 12:00:00 AM | 3 | 4x4 | 6004697.5402 | 2113177.8166 | 37.782649030091704 | -122.42742069293699 | (37.7826490300917, -122.427420692937) | ||
| 7978 | 7978 | 18236 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 3 | 4X4 | 6003740.4545 | 2114242.5919999997 | 37.7855184591156 | -122.43080780955201 | (37.7855184591156, -122.430807809552) | ||
| 8162 | 8162 | 13268 | Permitted Site 1 | Tristania conferta :: 79 | 2467 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2002 12:00:00 AM | 3 | 3X3 | 6000591.5664 | 2119207.4707 | 37.7989718069145 | -122.442058509671 | (37.7989718069145, -122.442058509671) | ||
| 8445 | 8445 | 5893 | DPW Maintained 3 | Tristania conferta :: 79 | 1136 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1998 12:00:00 AM | 3 | 3X3 | 6004974.4162 | 2113025.1532 | 37.7822455097776 | -122.42645194629401 | (37.7822455097776, -122.426451946294) | ||
| 8597 | 8597 | 7014 | Permitted Site 1 | Tristania conferta :: 79 | 1050 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2008 12:00:00 AM | 3 | 3X3 | 6002429.2937 | 2110241.5336 | 37.774458185014296 | -122.43505777310101 | (37.7744581850143, -122.435057773101) | ||
| 8600 | 8600 | 12267 | DPW Maintained 3 | Tristania conferta :: 79 | 649 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6004918.0391 | 2111202.3941 | 37.7772374748382 | -122.42651715535101 | (37.7772374748382, -122.426517155351) | ||
| 8775 | 8775 | 9640 | Permitted Site 1 | Tristania conferta :: 79 | 1475 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2002 12:00:00 AM | 3 | 3X3 | 6002575.9976 | 2111942.0905 | 37.779135818895 | -122.434671923313 | (37.779135818895, -122.434671923313) | ||
| 9005 | 9005 | 7012 | Permitted Site 1 | Tristania conferta :: 79 | 1030 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002476.0968 | 2110247.1221 | 37.774476187107 | -122.43489627219601 | (37.774476187107, -122.434896272196) | ||
| 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) | |
| 13571 | 13571 | 29433 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2011 12:00:00 AM | 3 | 3x3 | 6015500.9632 | 2091579.7516 | 37.7239504043026 | -122.388537076537 | (37.7239504043026, -122.388537076537) | ||
| 13601 | 13601 | 22334 | DPW Maintained 3 | Tristania conferta :: 79 | 5201 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/2015 02:59:00 PM | 3 | 3X3 | 6014532.0059 | 2093984.9826 | 37.7305009408534 | -122.39205475697099 | (37.7305009408534, -122.392054756971) | ||
| 13702 | 13702 | 22191 | Permitted Site 1 | Tristania conferta :: 79 | 4011 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 6015646.0862 | 2097696.0967 | 37.7407527004376 | -122.38846211797701 | (37.7407527004376, -122.388462117977) | |||
| 13739 | 13739 | 30026 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6013442.0581 | 2091191.4573 | 37.7227699118645 | -122.39562724256201 | (37.7227699118645, -122.395627242562) | ||
| 13756 | 13756 | 29432 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015452.0518 | 2091514.7509 | 37.7237692145382 | -122.38870162152 | (37.7237692145382, -122.38870162152) | ||
| 13997 | 13997 | 22496 | DPW Maintained 3 | Tristania conferta :: 79 | 6321 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/03/2011 12:00:00 AM | 3 | 3x3 | 6013227.4986 | 2090389.3545 | 37.7205555613998 | -122.396312742847 | (37.7205555613998, -122.396312742847) | ||
| 14035 | 14035 | 87473 | Permitted Site 1 | Tristania conferta :: 79 | 5176 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6014507.8856 | 2094193.7018 | 37.7310727023064 | -122.39215273626499 | (37.7310727023064, -122.392152736265) | ||
| 14096 | 14096 | 29566 | Permitted Site 1 | Tristania conferta :: 79 | 3224 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6014068.4858 | 2089729.2978 | 37.718789938046605 | -122.39335952751999 | (37.7187899380466, -122.39335952752) | ||
| 14292 | 14292 | 22494 | DPW Maintained 3 | Tristania conferta :: 79 | 6315 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6013237.8961 | 2090421.2401 | 37.7206436914379 | -122.39627903536699 | (37.7206436914379, -122.396279035367) | |||
| 14553 | 14553 | 29440 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015660.6839 | 2091799.6156 | 37.7245629575419 | -122.38800027789101 | (37.7245629575419, -122.388000277891) | ||
| 14819 | 14819 | 29402 | Permitted Site 1 | Tristania conferta :: 79 | 2919 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x2 | 6014617.8699 | 2090399.8874 | 37.720661752825706 | -122.391507367115 | (37.7206617528257, -122.391507367115) | |||
| 15225 | 15225 | 22440 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/2001 12:00:00 AM | 3 | 3X3 | 6013624.7927 | 2091445.832 | 37.723478536743 | -122.395013371509 | (37.723478536743, -122.395013371509) | ||
| 15567 | 15567 | 22419 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/19/2000 12:00:00 AM | 3 | 3x3 | 6013854.3759 | 2092034.5068 | 37.7251076834032 | -122.394260933329 | (37.7251076834032, -122.394260933329) | ||
| 15623 | 15623 | 22475 | DPW Maintained 3 | Tristania conferta :: 79 | 6245 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/1995 12:00:00 AM | 3 | 3x3 | 6013399.7881 | 2090837.5348 | 37.7217957603798 | -122.395748575331 | (37.7217957603798, -122.395748575331) | ||
| 15636 | 15636 | 22484 | DPW Maintained 3 | Tristania conferta :: 79 | 6271 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1998 12:00:00 AM | 3 | 3x3 | 6013332.0905 | 2090676.3033 | 37.72134928484171 | -122.395971297174 | (37.7213492848417, -122.395971297174) | ||
| 15652 | 15652 | 29527 | DPW Maintained 3 | Tristania conferta :: 79 | 2220 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 2X3 | 6015766.2095 | 2092015.0636 | 37.7251603810099 | -122.387650511034 | (37.7251603810099, -122.387650511034) | ||
| 15695 | 15695 | 22463 | DPW Maintained 3 | Tristania conferta :: 79 | 6202 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/02/2011 12:00:00 AM | 3 | 3x3 | 6013379.6455 | 2091026.8711 | 37.7223145193079 | -122.395831463965 | (37.7223145193079, -122.395831463965) | ||
| 15886 | 15886 | 30095 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013424.226 | 2091142.2984 | 37.7226339394685 | -122.395685442076 | (37.7226339394685, -122.395685442076) | |||
| 15952 | 15952 | 87520 | Permitted Site 1 | Tristania conferta :: 79 | 5299 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014418.8496 | 2093596.4572 | 37.7294278455371 | -122.39241879281201 | (37.7294278455371, -122.392418792812) | |||
| 15973 | 15973 | 22420 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6013860.9167 | 2092056.0916 | 37.725167314492104 | -122.39423983281799 | (37.7251673144921, -122.394239832818) | ||
| 15995 | 15995 | 22344 | Permitted Site 1 | Tristania conferta :: 79 | 5251 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2007 12:00:00 AM | 3 | 3X3 | 6014461.365 | 2093739.0473 | 37.729821729988 | -122.392281780639 | (37.729821729988, -122.392281780639) | ||
| 16118 | 16118 | 22394 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6013900.6343 | 2092382.1168 | 37.7260647216629 | -122.394125346164 | (37.7260647216629, -122.394125346164) | ||
| 16179 | 16179 | 30024 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013452.1791 | 2091216.0368 | 37.7228379652128 | -122.39559397744 | (37.7228379652128, -122.39559397744) | |||
| 16191 | 16191 | 22439 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2011 12:00:00 AM | 3 | 3X3 | 6013618.2519 | 2091420.3228 | 37.7234081298852 | -122.39503419617901 | (37.7234081298852, -122.395034196179) | ||
| 16303 | 16303 | 95313 | DPW Maintained 3 | Tristania conferta :: 79 | 6295 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/14/2011 12:00:00 AM | 3 | 3x3 | 6013297.1751 | 2090576.8022 | 37.7210741321738 | -122.396085021222 | (37.7210741321738, -122.396085021222) | ||
| 16494 | 16494 | 22329 | Permitted Site 1 | Tristania conferta :: 79 | 5166 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2001 12:00:00 AM | 3 | 3X3 | 6014522.2059 | 2094241.4361 | 37.7312045661254 | -122.39210656510599 | (37.7312045661254, -122.392106565106) | ||
| 16601 | 16601 | 22174 | Permitted Site 1 | Tristania conferta :: 79 | 3900 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1995 12:00:00 AM | 3 | 3X3 | 6015675.1373 | 2098078.9572 | 37.7418055667015 | -122.388388385005 | (37.7418055667015, -122.388388385005) | ||
| 16654 | 16654 | 22374 | Permitted Site 1 | Tristania conferta :: 79 | 5518 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6014092.4507 | 2092899.7319999998 | 37.7274966482783 | -122.393498452721 | (37.7274966482783, -122.393498452721) | ||
| 16659 | 16659 | 29380 | DPW Maintained 3 | Tristania conferta :: 79 | 3231 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6014087.9762 | 2089684.2263 | 37.7186672634726 | -122.393289004191 | (37.7186672634726, -122.393289004191) | ||
| 16696 | 16696 | 29546 | DPW Maintained 3 | Tristania conferta :: 79 | 2900X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6014598.9886 | 2090439.4771 | 37.7207694102971 | -122.39157540084999 | (37.7207694102971, -122.39157540085) | ||
| 16817 | 16817 | 22393 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6013906.4177 | 2092399.467 | 37.726112683263295 | -122.39410656725799 | (37.7261126832633, -122.394106567258) | ||
| 16856 | 16856 | 22379 | DPW Maintained 3 | Tristania conferta :: 79 | 5545 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 6014134.9775 | 2092764.4635 | 37.72712759108239 | -122.39334197422 | (37.7271275910824, -122.39334197422) | ||
| 17129 | 17129 | 6985 | DPW Maintained 3 | Tristania conferta :: 79 | 819 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6003479.628 | 2110333.4443 | 37.7747701331995 | -122.43143103071199 | (37.7747701331995, -122.431431030712) | ||
| 17659 | 17659 | 6961 | Permitted Site 1 | Tristania conferta :: 79 | 675 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/22/2008 12:00:00 AM | 3 | 3X3 | 6004210.2657 | 2110437.8608 | 37.775098217514206 | -122.42891105054301 | (37.7750982175142, -122.428911050543) | ||
| 17810 | 17810 | 10406 | Permitted Site 1 | Tristania conferta :: 79 | 1386 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 5999529.6926 | 2108795.3635 | 37.7703222971334 | -122.444984028084 | (37.7703222971334, -122.444984028084) | ||
| 17851 | 17851 | 526 | Permitted Site 1 | Tristania conferta :: 79 | 2830 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6009862.6031 | 2102227.8681 | 37.7528737602498 | -122.40877894251899 | (37.7528737602498, -122.408778942519) | |||
| 17941 | 17941 | 495 | Permitted Site 1 | Tristania conferta :: 79 | 2749X 24th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2010 12:00:00 AM | 3 | 3X3 | 6010480.319 | 2102220.7863 | 37.752888894824295 | -122.406642256485 | (37.7528888948243, -122.406642256485) | ||
| 18101 | 18101 | 10433 | Permitted Site 1 | Tristania conferta :: 79 | 1449 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2001 12:00:00 AM | 3 | 3x3 | 5999155.0008 | 2108693.838 | 37.7700221418409 | -122.446272777074 | (37.7700221418409, -122.446272777074) | ||
| 18778 | 18778 | 7005 | DPW Maintained 3 | Tristania conferta :: 79 | 1001 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/1999 12:00:00 AM | 3 | 3X3 | 6002577.0261 | 2110209.591 | 37.7743788659974 | -122.43454445471201 | (37.7743788659974, -122.434544454712) | ||
| 19252 | 19252 | 10388 | DPW Maintained 3 | Tristania conferta :: 79 | 1354 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999661.5734 | 2108814.8136 | 37.770383228179895 | -122.44452925228799 | (37.7703832281799, -122.444529252288) | ||
| 19294 | 19294 | 9654 | DPW Maintained 3 | Tristania conferta :: 79 | 95 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 3 | 3X3 | 6006063.7461 | 2109945.4115 | 37.7738508061395 | -122.422464444627 | (37.7738508061395, -122.422464444627) | ||
| 19714 | 19714 | 10469 | DPW Maintained 3 | Tristania conferta :: 79 | 1608 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2011 12:00:00 AM | 3 | 3x3 | 5998376.833 | 2108635.1438 | 37.769816509818796 | -122.44896020681499 | (37.7698165098188, -122.448960206815) | ||
| 20341 | 20341 | 9651 | DPW Maintained 3 | Tristania conferta :: 79 | 75 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2012 12:00:00 AM | 3 | 3x3 | 6006082.2488 | 2109830.2127 | 37.7735355417257 | -122.422392253849 | (37.7735355417257, -122.422392253849) | ||
| 20800 | 20800 | 10428 | Permitted Site 1 | Tristania conferta :: 79 | 1427 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999264.0192 | 2108708.6767 | 37.7700691107077 | -122.44589675291799 | (37.7700691107077, -122.445896752918) | ||
| 21123 | 21123 | 24497 | DPW Maintained 3 | Tristania conferta :: 79 | 823 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2011 12:00:00 AM | 3 | 3x3 | 6003451.3218 | 2110329.4946 | 37.774757683987396 | -122.43152866558901 | (37.7747576839874, -122.431528665589) | ||
| 21688 | 21688 | 15565 | Permitted Site 1 | Tristania conferta :: 79 | 2871 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 4X4 | 6007116.1618 | 2101629.0258 | 37.751075261652105 | -122.418234216284 | (37.7510752616521, -122.418234216284) | ||
| 22121 | 22121 | 10491 | DPW Maintained 3 | Tristania conferta :: 79 | 1694 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2008 12:00:00 AM | 3 | 3X3 | 5998067.7185 | 2108593.9143 | 37.769685621068895 | -122.45002644909901 | (37.7696856210689, -122.450026449099) | ||
| 22266 | 22266 | 17051 | DPW Maintained 3 | Tristania conferta :: 79 | 1235 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/29/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774567 | 6001055.3761 | 2109653.1693 | 37.7727645748724 | -122.43976821361 | (37.7727645748724, -122.43976821361) | |
| 22563 | 22563 | 9064 | Permitted Site 1 | Tristania conferta :: 79 | 5530 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2001 12:00:00 AM | 3 | 3X3 | 5989802.812000001 | 2112705.6659 | 37.7804989633648 | -122.478914967756 | (37.7804989633648, -122.478914967756) | ||
| 23032 | 23032 | 10440 | DPW Maintained 3 | Tristania conferta :: 79 | 1476 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999041.0219 | 2108727.6134 | 37.770108370408 | -122.44666945726999 | (37.770108370408, -122.44666945727) | |||
| 23145 | 23145 | 17835 | DPW Maintained 3 | Tristania conferta :: 79 | 2012 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004225.6146 | 2115353.7675 | 37.788596943608496 | -122.429208558626 | (37.7885969436085, -122.429208558626) | |||
| 25813 | 25813 | 50649 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51399 | 6012160.9197 | 2112637.3571 | 37.7815843393908 | -122.401562438489 | (37.7815843393908, -122.401562438489) | |
| 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) | |||
| 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) | |||
| 31623 | 31623 | 92117 | Permitted Site 1 | Tristania conferta :: 79 | 2012 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52450 | 6004206.4384 | 2115352.2396 | 37.788591662793 | -122.42927479639401 | (37.788591662793, -122.429274796394) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 38764 | 38764 | 140349 | Undocumented 2 | Tristania conferta :: 79 | 1314 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004502.4614 | 2113302.7614 | 37.7829810622913 | -122.42810448919901 | (37.7829810622913, -122.428104489199) | |||
| 40296 | 40296 | 51914 | Permitted Site 1 | Tristania conferta :: 79 | 1738 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50190 | 6004049.1514 | 2119767.1187 | 37.8007048866604 | -122.43013406376998 | (37.8007048866604, -122.43013406377) | |
| 46127 | 46127 | 139927 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6005686.5366 | 2112676.4561 | 37.781328303180295 | -122.42396352092699 | (37.7813283031803, -122.423963520927) | |||
| 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) | |||
| 50370 | 50370 | 244131 | Undocumented 2 | Tristania conferta :: 79 | 322 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004550.5333 | 2109497.9798 | 37.7725367873822 | -122.42766701053002 | (37.7725367873822, -122.42766701053) | |||
| 54915 | 54915 | 142501 | Undocumented 2 | Tristania conferta :: 79 | 601 UNION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6010024.9768 | 2119514.2391 | 37.800347183021294 | -122.409437290498 | (37.8003471830213, -122.409437290498) | |||
| 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) | |||
| 66752 | 66752 | 141273 | Undocumented 2 | Tristania conferta :: 79 | 363 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997942.7493 | 2112553.5341 | 37.780550561830395 | -122.450744243509 | (37.7805505618304, -122.450744243509) | |||
| 68021 | 68021 | 121007 | Undocumented 2 | Tristania conferta :: 79 | 199X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6015091.1726 | 2115438.8125 | 37.789439566894295 | -122.391621004116 | (37.7894395668943, -122.391621004116) | |||
| 69366 | 69366 | 93014 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 01/08/2010 12:00:00 AM | 3 | 4x4 | Permit Number 53139; 3-year maintenance agreement through 12/29/12 | 6001021.4146 | 2119265.9756 | 37.7991569323377 | -122.440575294128 | (37.7991569323377, -122.440575294128) |
| 74930 | 74930 | 138582 | Undocumented 2 | Tristania conferta :: 79 | 2780 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6000598.8856 | 2114847.063 | 37.7869996869349 | -122.44172008067 | (37.7869996869349, -122.44172008067) | |||
| 76601 | 76601 | 200961 | Undocumented 2 | Tristania conferta :: 79 | 5600 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6013983.5299 | 2092601.4044 | 37.72667144833171 | -122.39385412187401 | (37.7266714483317, -122.393854121874) | |||
| 80311 | 80311 | 108697 | Permitted Site 1 | Tristania conferta :: 79 | 2414 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774621 | 6000824.14262 | 2119316.97174 | 37.7992857188841 | -122.441261581656 | (37.7992857188841, -122.441261581656) |
| 96238 | 96238 | 54270 | Permitted Site 1 | Tristania conferta :: 79 | 1240 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | Permit Number 10023 | 5993331.28695265 | 2107027.13972063 | 37.765111509668706 | -122.466295599736 | (37.7651115096687, -122.466295599736) |
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");