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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19204 | 19204 | 15640 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3620 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005331.9888 | 2097082.5189 | 37.7384910005149 | -122.424080784585 | (37.7384910005149, -122.424080784585) | |||
| 19282 | 19282 | 4868 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 40 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6000785.76982 | 2098130.67734 | 37.7411112680693 | -122.439874506828 | (37.7411112680693, -122.439874506828) | |||
| 19503 | 19503 | 113857 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1201 SAN BRUNO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011184.0 | 2102716.0 | 37.754287987368706 | -122.40424363426001 | (37.7542879873687, -122.40424363426) | ||||
| 19667 | 19667 | 4866 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6000802.3716400005 | 2098157.55359 | 37.741186008934896 | -122.43981903034701 | (37.7411860089349, -122.439819030347) | |||
| 19828 | 19828 | 26060 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5994622.6639 | 2088111.4430000002 | 37.713248125396 | -122.46045833760701 | (37.713248125396, -122.460458337607) | |||
| 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) | |||
| 19879 | 19879 | 25601 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1425 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009396.61831 | 2097480.31655 | 37.7398119185732 | -122.41005527655099 | (37.7398119185732, -122.410055276551) | |||
| 19933 | 19933 | 26061 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 5994614.7294 | 2088111.1256 | 37.7132467974329 | -122.46048573878299 | (37.7132467974329, -122.460485738783) | |||
| 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) | |||
| 20024 | 20024 | 3441 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 14 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999497.99147 | 2099800.2431099997 | 37.7456221064729 | -122.444447123237 | (37.7456221064729, -122.444447123237) | |||
| 20027 | 20027 | 3444 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 22 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5999501.27167 | 2099733.2475400004 | 37.745438339921996 | -122.44443096691799 | (37.745438339922, -122.444430966918) | |||
| 20048 | 20048 | 3452 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 42 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999533.14078 | 2099571.88767 | 37.744997102831896 | -122.44430917535401 | (37.7449971028319, -122.444309175354) | |||
| 20088 | 20088 | 4215 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3947 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004216.72102 | 2100407.9706900003 | 37.7475588963331 | -122.42817377030599 | (37.7475588963331, -122.428173770306) | |||
| 20145 | 20145 | 3440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999495.83861 | 2099835.0042 | 37.7457174292197 | -122.44445706524401 | (37.7457174292197, -122.444457065244) | |||
| 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) | |||
| 20446 | 20446 | 4375 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1035 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000885.93841 | 2096177.1796 | 37.7357531225975 | -122.43938816603 | (37.7357531225975, -122.43938816603) | |||
| 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) | |||
| 20553 | 20553 | 5090 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2599 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6002264.68723 | 2096743.2424700002 | 37.737385768040106 | -122.434661764636 | (37.7373857680401, -122.434661764636) | |||
| 20698 | 20698 | 17233 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Ora Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6001155.387569999 | 2098531.68959 | 37.7422333863766 | -122.438625231576 | (37.7422333863766, -122.438625231576) | |||
| 20747 | 20747 | 1331 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4X Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999508.60348 | 2099913.11882 | 37.7459326414862 | -122.44441853919399 | (37.7459326414862, -122.444418539194) | |||
| 20816 | 20816 | 3449 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 30 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5999507.11863 | 2099668.7039099997 | 37.7452614522515 | -122.44440611146601 | (37.7452614522515, -122.444406111466) | |||
| 20936 | 20936 | 3454 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 46 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999549.90183 | 2099548.27551 | 37.7449332257802 | -122.444249522399 | (37.7449332257802, -122.444249522399) | |||
| 20962 | 20962 | 3446 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 26 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5999504.19515 | 2099700.97572 | 37.745349896074295 | -122.444418539177 | (37.7453498960743, -122.444418539177) | |||
| 21010 | 21010 | 26523 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2827 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008996.21929 | 2101987.30534 | 37.75216466358871 | -122.41175807359899 | (37.7521646635887, -122.411758073599) | |||
| 21017 | 21017 | 1925 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 96 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001058.612819999 | 2097389.17311 | 37.7390907990037 | -122.43887799141899 | (37.7390907990037, -122.438877991419) | |||
| 21093 | 21093 | 4212 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3939 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004266.44714 | 2100411.8898 | 37.7475724706926 | -122.428002099622 | (37.7475724706926, -122.428002099622) | |||
| 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) | |||
| 21375 | 21375 | 22812 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 33 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 5999068.47154 | 2099593.84313 | 37.745030865178 | -122.44591749052601 | (37.745030865178, -122.445917490526) | |||
| 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) | |||
| 21532 | 21532 | 4874 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000875.46201 | 2097999.81649 | 37.7407570602008 | -122.439555005583 | (37.7407570602008, -122.439555005583) | |||
| 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) | |||
| 21998 | 21998 | 22832 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 96 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999484.67049 | 2098974.10299 | 37.743352964077395 | -122.44443382318 | (37.7433529640774, -122.44443382318) | |||
| 22049 | 22049 | 26522 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2829 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6008999.5105099995 | 2101948.0462700003 | 37.75205705160771 | -122.411743918249 | (37.7520570516077, -122.411743918249) | |||
| 22079 | 22079 | 4859 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 17 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000712.83991 | 2098222.9013099996 | 37.7413603416151 | -122.440133283139 | (37.7413603416151, -122.440133283139) | |||
| 22100 | 22100 | 19346 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5992530.80337 | 2089863.7154 | 37.717938880250394 | -122.46781582943999 | (37.7179388802504, -122.46781582944) | |||
| 22230 | 22230 | 3451 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 38 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5999519.82118 | 2099605.44915 | 37.745088494646396 | -122.44435764339701 | (37.7450884946464, -122.444357643397) | |||
| 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) | |||
| 22260 | 22260 | 9373 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 292 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x4 | 6001116.19267 | 2097967.75303 | 37.740682719538796 | -122.438720354687 | (37.7406827195388, -122.438720354687) | |||
| 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) | |||
| 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) | |||
| 22477 | 22477 | 9883 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1530 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6005400.00219 | 2115093.82301 | 37.787949613228 | -122.42512684742701 | (37.787949613228, -122.425126847427) | |||
| 22486 | 22486 | 21531 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1301 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006257.76496 | 2114889.71602 | 37.7874376040064 | -122.422144632576 | (37.7874376040064, -122.422144632576) | |||
| 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) | |||
| 22504 | 22504 | 21526 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6006270.376630001 | 2114940.85918 | 37.787578741804204 | -122.422104633424 | (37.7875787418042, -122.422104633424) | |||
| 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) | |||
| 22511 | 22511 | 21525 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6006287.01156 | 2114943.3231200003 | 37.7875864454 | -122.422047254877 | (37.7875864454, -122.422047254877) | |||
| 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) | |||
| 22557 | 22557 | 21535 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1337 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006166.93073 | 2114876.17563 | 37.787395301706795 | -122.422457938402 | (37.7873953017068, -122.422457938402) | |||
| 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) | |||
| 22620 | 22620 | 21530 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1307 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006237.14055 | 2114887.59542 | 37.7874306180636 | -122.422215838204 | (37.7874306180636, -122.422215838204) | |||
| 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) | |||
| 22786 | 22786 | 9882 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1530 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005403.02502 | 2115071.7670299998 | 37.7878892237663 | -122.425114819002 | (37.7878892237663, -122.425114819002) | |||
| 22855 | 22855 | 188957 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1708 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014940.685740001 | 2096639.31184 | 37.73781187133179 | -122.39082730983499 | (37.7378118713318, -122.390827309835) | |||
| 23011 | 23011 | 7688 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 545 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 0 | 6008696.1209 | 2121067.5649 | 37.8045376819256 | -122.414145630391 | (37.8045376819256, -122.414145630391) | |||
| 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) | |||
| 23374 | 23374 | 189044 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007758.60706 | 2109046.4903599997 | 37.771478047011705 | -122.416537939674 | (37.7714780470117, -122.416537939674) | |||
| 23383 | 23383 | 220866 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3725 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004888.252669999 | 2102494.31533 | 37.753325487792104 | -122.426000149411 | (37.7533254877921, -122.426000149411) | |||
| 23406 | 23406 | 205700 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 455 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993494.37195 | 2099449.4133900004 | 37.744314435578396 | -122.465181086546 | (37.7443144355784, -122.465181086546) | |||
| 23430 | 23430 | 220933 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 155 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006212.833769999 | 2096779.64339 | 37.737709065310995 | -122.421013744088 | (37.737709065311, -122.421013744088) | |||
| 23467 | 23467 | 205659 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1598 10th Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993106.7424 | 2104692.3682 | 37.7586878807581 | -122.466902491455 | (37.7586878807581, -122.466902491455) | |||
| 23609 | 23609 | 125847 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1752 Taylor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6008754.651330001 | 2118947.56933 | 37.7987199902862 | -122.413793029843 | (37.7987199902862, -122.413793029843) |
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");