Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87654 | 87654 | 99961 | Property Tree 7 | Callistemon citrinus :: Lemon Bottlebrush 28 | 537 Valley St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/25/2012 12:00:00 AM | Permit Number 768880 | 6002459.0 | 2099152.0 | 37.7440106863694 | -122.434162082356 | (37.7440106863694, -122.434162082356) | |||
67558 | 67558 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Allston Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418.0 | 37.741524734078205 | -122.46256819082701 | (37.7415247340782, -122.462568190827) | ||
99835 | 99835 | 104913 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 608 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
175351 | 175351 | 106611 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1154 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6011908.79849 | 2103025.7220099997 | 37.7551788898075 | -122.401758852609 | (37.7551788898075, -122.401758852609) | |||
4369 | 4369 | 222216 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | ||
116994 | 116994 | 114980 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 281 32ND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x2 | 5985853.0 | 2114037.0 | 37.7839242715215 | -122.492677119536 | (37.7839242715215, -122.492677119536) | ||||
120162 | 120162 | 114792 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Linares Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x10 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | ||||
5803 | 5803 | 22598 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 835 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005965.95079 | 2112761.85116 | 37.7815785478641 | -122.42300295452401 | (37.7815785478641, -122.423002954524) | |||
5932 | 5932 | 22599 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 835 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005992.6226 | 2112765.71653 | 37.7815906662302 | -122.422910957475 | (37.7815906662302, -122.422910957475) | |||
6417 | 6417 | 18979 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2916 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000692.61661 | 2115558.6800700002 | 37.7889589430353 | -122.4414468761 | (37.7889589430353, -122.4414468761) | |||
8444 | 8444 | 13167 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1906 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6003216.0169 | 2119655.6641 | 37.8003516396791 | -122.433009083838 | (37.8003516396791, -122.433009083838) | ||
10927 | 10927 | 24271 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001388.30533 | 2086462.2685599998 | 37.70910674815379 | -122.436956008017 | (37.7091067481538, -122.436956008017) | |||
11032 | 11032 | 24272 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001382.61488 | 2086464.9875900003 | 37.7091138905754 | -122.43697586956301 | (37.7091138905754, -122.436975869563) | |||
11289 | 11289 | 24269 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001399.20674 | 2086458.92155 | 37.7090981776115 | -122.43691809171999 | (37.7090981776115, -122.43691809172) | |||
13019 | 13019 | 24270 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001396.0736 | 2086458.9864 | 37.709098177596005 | -122.436928924942 | (37.709098177596, -122.436928924942) | |||
13540 | 13540 | 27121 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2335 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2002 12:00:00 AM | 12 | 2x2 | 6013101.69827 | 2096426.31583 | 37.7371248216631 | -122.39717069499599 | (37.7371248216631, -122.397170694996) | ||
13724 | 13724 | 4898 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017985.0017 | 2094485.55993 | 37.7320665362465 | -122.380151894906 | (37.7320665362465, -122.380151894906) | |||
14242 | 14242 | 10905 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1336 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6017099.8174 | 2095796.95321 | 37.735618485109995 | -122.38330345120899 | (37.73561848511, -122.383303451209) | |||
14360 | 14360 | 5802 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 218X Cashmere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6016122.2563 | 2096227.4462099997 | 37.736746459772604 | -122.386713296401 | (37.7367464597726, -122.386713296401) | |||
15093 | 15093 | 5801 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 218X Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6016115.70396 | 2096246.37508 | 37.736798071860704 | -122.386737270517 | (37.7367980718607, -122.386737270517) | |||
16623 | 16623 | 4897 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018099.28954 | 2094405.0263599998 | 37.731851711585996 | -122.37975117949 | (37.731851711586, -122.37975117949) | |||
16806 | 16806 | 29053 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 340 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008751.0689900005 | 2108844.78645 | 37.770979979973 | -122.413090685387 | (37.770979979973, -122.413090685387) | ||
16821 | 16821 | 7409 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1074 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6010471.6875 | 2111110.7430000002 | 37.7772982123977 | -122.40729875221399 | (37.7772982123977, -122.407298752214) | |||
16917 | 16917 | 3443 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5999529.741909999 | 2099788.8465400003 | 37.745592625791296 | -122.444336516539 | (37.7455926257913, -122.444336516539) | |||
16979 | 16979 | 10038 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005474.31982 | 2106984.12162 | 37.7656865461171 | -122.424292710045 | (37.7656865461171, -122.424292710045) | |||
17023 | 17023 | 4229 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3987 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003999.73105 | 2100398.02374 | 37.7475193045808 | -122.428923399303 | (37.7475193045808, -122.428923399303) | |||
17287 | 17287 | 4230 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3987 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004020.01969 | 2100398.84161 | 37.7475226986238 | -122.42885330076099 | (37.7475226986238, -122.428853300761) | |||
17685 | 17685 | 1341 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 172 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5999321.34336 | 2099380.66579 | 37.7444599674701 | -122.44502778580299 | (37.7444599674701, -122.445027785803) | |||
17737 | 17737 | 4853 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6000632.86051 | 2098307.8213299997 | 37.7415889582704 | -122.440415912169 | (37.7415889582704, -122.440415912169) | |||
18279 | 18279 | 4484 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1566 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1990 12:00:00 AM | 12 | 3X3 | 6004549.88502 | 2099732.13285 | 37.7457220463542 | -122.42697358187701 | (37.7457220463542, -122.426973581877) | ||
18431 | 18431 | 1350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 261 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 5999733.43875 | 2099278.43357 | 37.7442027739306 | -122.443595506633 | (37.7442027739306, -122.443595506633) | |||
18490 | 18490 | 90663 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984396.70061 | 2110421.43862 | 37.7739117254104 | -122.497448288038 | (37.7739117254104, -122.497448288038) | ||
18712 | 18712 | 10788 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
18988 | 18988 | 16343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | ||
19627 | 19627 | 16344 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996005.09349 | 2094651.8098799998 | 37.7312858527477 | -122.45615279610901 | (37.7312858527477, -122.456152796109) | ||
19703 | 19703 | 16350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995968.77487 | 2094643.75333 | 37.731261646602995 | -122.45627777310601 | (37.731261646603, -122.456277773106) | ||
19869 | 19869 | 1340 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 157 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5999318.51798 | 2099488.255 | 37.7447552202944 | -122.445045288424 | (37.7447552202944, -122.445045288424) | |||
19999 | 19999 | 1998 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 213 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6007163.78515 | 2097749.92103 | 37.7404267922562 | -122.41779459653799 | (37.7404267922562, -122.417794596538) | |||
20092 | 20092 | 24477 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 94 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6002318.918930001 | 2096714.27726 | 37.7373093148834 | -122.43447219024401 | (37.7373093148834, -122.434472190244) | ||
20148 | 20148 | 17245 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501 Ortega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3 | 5992555.1394 | 2103055.38176 | 37.754161290716205 | -122.468691056856 | (37.7541612907162, -122.468691056856) | |||
20227 | 20227 | 4881 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 83 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6000907.7136 | 2097921.62837 | 37.74054420955 | -122.439437888659 | (37.74054420955, -122.439437888659) | |||
20471 | 20471 | 8716 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997420.69043 | 2113059.93694 | 37.7819111134077 | -122.452586840538 | (37.7819111134077, -122.452586840538) | |||
20560 | 20560 | 22807 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 16 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/1991 12:00:00 AM | 12 | 2X2 | 5998909.64995 | 2099772.3846 | 37.745512026751896 | -122.446479507446 | (37.7455120267519, -122.446479507446) | ||
21275 | 21275 | 5112 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2711 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4X4 | 6002382.81986 | 2096188.0405700002 | 37.7358680173011 | -122.434213645952 | (37.7358680173011, -122.434213645952) | |||
21448 | 21448 | 5058 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5521 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001859.76299 | 2097506.95056 | 37.739459736871204 | -122.436116409072 | (37.7394597368712, -122.436116409072) | |||
21696 | 21696 | 10044 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 Guerrero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005474.87318 | 2106843.21233 | 37.7652996739685 | -122.424280773353 | (37.7652996739685, -122.424280773353) | |||
21714 | 21714 | 26062 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994603.6211 | 2088111.4430000002 | 37.71324702988721 | -122.460524155594 | (37.7132470298872, -122.460524155594) | |||
21784 | 21784 | 10043 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 Guerrero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005477.51423 | 2106859.7680900004 | 37.765345281278 | -122.424272816157 | (37.765345281278, -122.424272816157) | |||
21834 | 21834 | 4871 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 48 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000859.63404 | 2098067.6041 | 37.7409422881585 | -122.43961459104901 | (37.7409422881585, -122.439614591049) | |||
22253 | 22253 | 4256 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4082 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003396.9856199995 | 2100411.62921 | 37.7475225268465 | -122.431008624962 | (37.7475225268465, -122.431008624962) | |||
22386 | 22386 | 9093 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989210.8329 | 2112629.8539 | 37.78025641160821 | -122.48095732694999 | (37.7802564116082, -122.48095732695) | |||
22392 | 22392 | 9015 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990451.7846 | 2112676.0938 | 37.780455430166704 | -122.47666772777599 | (37.7804554301667, -122.476667727776) | |||
22394 | 22394 | 9094 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989203.8431 | 2112625.0148 | 37.7802427184836 | -122.48098115319901 | (37.7802427184836, -122.480981153199) | |||
22395 | 22395 | 9019 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 8M | 5990422.2126 | 2112674.4808 | 37.780449286015 | -122.476769912257 | (37.780449286015, -122.476769912257) | ||
22396 | 22396 | 21529 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006199.49469 | 2114932.42153 | 37.7875515759816 | -122.42234927152799 | (37.7875515759816, -122.422349271528) | |||
22405 | 22405 | 9178 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987973.0454 | 2112592.9065 | 37.7800829358976 | -122.485236638901 | (37.7800829358976, -122.485236638901) | |||
22408 | 22408 | 21538 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1350 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006090.48396 | 2114915.1534700003 | 37.787498012379 | -122.42272519983 | (37.787498012379, -122.42272519983) | |||
22427 | 22427 | 9095 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989203.3055 | 2112634.6929 | 37.780269260588604 | -122.480983721798 | (37.7802692605886, -122.480983721798) | |||
22433 | 22433 | 9091 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989224.2748 | 2112631.4669 | 37.7802616218044 | -122.48091094389 | (37.7802616218044, -122.48091094389) | |||
22441 | 22441 | 9219 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987356.9662 | 2112573.6226 | 37.779994079355895 | -122.487366491184 | (37.7799940793559, -122.487366491184) | |||
22462 | 22462 | 9179 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987967.3441 | 2112595.2541 | 37.7800890496186 | -122.48525653433799 | (37.7800890496186, -122.485256534338) | |||
22464 | 22464 | 9180 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987967.6795 | 2112585.8637 | 37.7800632857697 | -122.485254684827 | (37.7800632857697, -122.485254684827) | |||
22465 | 22465 | 9099 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989192.0143 | 2112627.1655 | 37.780247936097396 | -122.481022231507 | (37.7802479360974, -122.481022231507) | |||
22471 | 22471 | 9181 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987959.6305 | 2112590.5589 | 37.7800757085683 | -122.485282874223 | (37.7800757085683, -122.485282874223) | |||
22497 | 22497 | 9218 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987387.1497 | 2112575.6349 | 37.78000136471471 | -122.48726222211799 | (37.7800013647147, -122.487262222118) | |||
22507 | 22507 | 9049 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989816.2539 | 2112654.318 | 37.7803587568757 | -122.478864709732 | (37.7803587568757, -122.478864709732) | |||
22524 | 22524 | 9096 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989196.3157 | 2112631.4669 | 37.78025999658 | -122.48100766619 | (37.78025999658, -122.48100766619) | |||
22529 | 22529 | 9177 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987977.7406 | 2112589.2174 | 37.7800730801841 | -122.485220125518 | (37.7800730801841, -122.485220125518) | |||
22540 | 22540 | 9014 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990456.086 | 2112679.8576 | 37.7804660140104 | -122.476653122424 | (37.7804660140104, -122.476653122424) | |||
22541 | 22541 | 9137 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988584.9325 | 2112610.849 | 37.7801678269123 | -122.48312118538799 | (37.7801678269123, -122.483121185388) | |||
22544 | 22544 | 9217 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987387.8205 | 2112562.8907 | 37.77996641187121 | -122.487258965224 | (37.7799664118712, -122.487258965224) | |||
22548 | 22548 | 9215 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987407.9428 | 2112568.2567 | 37.779982318766706 | -122.48718974831999 | (37.7799823187667, -122.48718974832) | |||
22573 | 22573 | 9017 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990440.4935 | 2112674.4808 | 37.780450346394794 | -122.476706670705 | (37.7804503463948, -122.476706670705) | |||
22584 | 22584 | 9016 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990445.3325 | 2112679.3199 | 37.7804639139017 | -122.476690284152 | (37.7804639139017, -122.476690284152) | |||
22612 | 22612 | 9018 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990428.6646 | 2112675.0185 | 37.7804511366409 | -122.476747631291 | (37.7804511366409, -122.476747631291) | |||
22637 | 22637 | 9140 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988567.4931 | 2112610.849 | 37.7801668120621 | -122.48318151551001 | (37.7801668120621, -122.48318151551) | |||
22654 | 22654 | 21537 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1350 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006105.21197 | 2114916.89235 | 37.787503617856295 | -122.42267436743299 | (37.7875036178563, -122.422674367433) | |||
22655 | 22655 | 9184 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987942.8619 | 2112587.5406 | 37.7800664442915 | -122.485340662126 | (37.7800664442915, -122.485340662126) | |||
22662 | 22662 | 8993 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5200 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990760.6778 | 2112689.8051 | 37.7805109894096 | -122.47560013351601 | (37.7805109894096, -122.475600133516) | |||
22666 | 22666 | 9139 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988574.5359 | 2112606.1537 | 37.7801543299329 | -122.483156807286 | (37.7801543299329, -122.483156807286) | |||
22696 | 22696 | 9182 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987952.9231 | 2112592.5712 | 37.780080843030795 | -122.485306225563 | (37.7800808430308, -122.485306225563) | |||
22701 | 22701 | 9176 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987984.4481 | 2112593.2419 | 37.7800845210592 | -122.48519721690901 | (37.7800845210592, -122.485197216909) | |||
22724 | 22724 | 9880 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1520 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6005412.72445 | 2114999.44781 | 37.7876912011289 | -122.42507611306601 | (37.7876912011289, -122.425076113066) | |||
22732 | 22732 | 8994 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5200 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990725.1914 | 2112685.5037 | 37.7804971216948 | -122.47572258227899 | (37.7804971216948, -122.475722582279) | |||
22736 | 22736 | 9183 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987946.551 | 2112592.9065 | 37.7800813924537 | -122.485328293876 | (37.7800813924537, -122.485328293876) | |||
22762 | 22762 | 9216 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987396.5402 | 2112575.6349 | 37.7800019123037 | -122.487229736584 | (37.7800019123037, -122.487229736584) | |||
22772 | 22772 | 9881 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1520 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6005407.78962 | 2115025.03332 | 37.78776117379871 | -122.425095007823 | (37.7877611737987, -122.425095007823) | |||
22773 | 22773 | 9138 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5900 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5988580.2372 | 2112606.1537 | 37.7801546617076 | -122.48313708412701 | (37.7801546617076, -122.483137084127) | |||
22782 | 22782 | 9092 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989215.1343 | 2112630.3915 | 37.7802581377407 | -122.48094248596901 | (37.7802581377407, -122.480942485969) | |||
22783 | 22783 | 9048 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5500 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989831.8464 | 2112654.8557 | 37.7803611386504 | -122.478810807949 | (37.7803611386504, -122.478810807949) | |||
23034 | 23034 | 4896 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/11/1999 12:00:00 AM | 6 | 3X4 | 6018106.77773 | 2094390.5453599999 | 37.731812362636205 | -122.37972428526699 | (37.7318123626362, -122.379724285267) | ||
23163 | 23163 | 4877 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 67 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6000895.2061 | 2098063.61209 | 37.74093335159429 | -122.43949131018199 | (37.7409333515943, -122.439491310182) | |||
23230 | 23230 | 21527 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 4X4 | 6006243.804880001 | 2114938.20274 | 37.7875699491469 | -122.42219637775601 | (37.7875699491469, -122.422196377756) | |||
23289 | 23289 | 1876 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017644.79908 | 2094278.9873799998 | 37.731480553283795 | -122.381313702976 | (37.7314805532838, -122.381313702976) | |||
23311 | 23311 | 5813 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 73 Dukes Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X4 | 6016158.83077 | 2096436.54005 | 37.7373226140504 | -122.38660141713301 | (37.7373226140504, -122.386601417133) | |||
23678 | 23678 | 204530 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999185.819 | 2097019.3718599998 | 37.7379686834 | -122.44532665482299 | (37.7379686834, -122.445326654823) | |||
26004 | 26004 | 204552 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 60 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 5ft | 5999641.44525 | 2097441.40723 | 37.7391534907361 | -122.443781647414 | (37.7391534907361, -122.443781647414) | |||
27066 | 27066 | 204545 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 73 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 3ft | 5999723.14356 | 2097244.03838 | 37.7386162222515 | -122.44348499883999 | (37.7386162222515, -122.44348499884) | |||
27949 | 27949 | 175625 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009376.03196 | 2090018.08104 | 37.719321051904295 | -122.40959990662701 | (37.7193210519043, -122.409599906627) | |||
28651 | 28651 | 175628 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 43 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 6009091.54392 | 2089913.6992400002 | 37.719018495673396 | -122.41057591204701 | (37.7190184956734, -122.410575912047) |
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");