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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 18065 | 18065 | 3438 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 5999496.088930001 | 2099864.34678 | 37.745798011161604 | -122.444458308101 | (37.7457980111616, -122.444458308101) | |||
| 17960 | 17960 | 3459 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 62 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999653.670059999 | 2099474.18097 | 37.7447356995905 | -122.44388538959998 | (37.7447356995905, -122.4438853896) | |||
| 18267 | 18267 | 3460 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 66 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5999690.18055 | 2099466.98031 | 37.74471801084229 | -122.44375862655501 | (37.7447180108423, -122.443758626555) | |||
| 18774 | 18774 | 3456 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999576.30354 | 2099521.60011 | 37.7448614877731 | -122.444156313979 | (37.7448614877731, -122.444156313979) | |||
| 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) | |||
| 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) | |||
| 88124 | 88124 | 14443 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 85 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5998809.64126 | 2112795.13693 | 37.7812635250965 | -122.447762663299 | (37.7812635250965, -122.447762663299) | |||
| 111540 | 111540 | 14442 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 75 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5998805.22132 | 2112827.04238 | 37.781350876552104 | -122.44778025164699 | (37.7813508765521, -122.447780251647) | |||
| 25790 | 25790 | 222210 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 286 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6002911.44026 | 2096221.9598 | 37.735991140781294 | -122.43238841969601 | (37.7359911407813, -122.432388419696) | ||||
| 7769 | 7769 | 13131 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1727 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003964.7125 | 2119675.6431 | 37.8004489355963 | -122.43041972679701 | (37.8004489355963, -122.430419726797) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 106026 | 106026 | 4854 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 208X Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6000949.9317226 | 2097825.5763540003 | 37.7402828758816 | -122.439285032066 | (37.7402828758816, -122.439285032066) | |||
| 107781 | 107781 | 13236 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2308 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6001297.71761 | 2119386.00749 | 37.7995022380504 | -122.43962780331199 | (37.7995022380504, -122.439627803312) | |||
| 125866 | 125866 | 4865 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 32 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/14/1992 12:00:00 AM | 35 | 3X3 | 6000909.0364823 | 2098039.6345395 | 37.74086830199771 | -122.439441771578 | (37.7408683019977, -122.439441771578) | ||
| 139393 | 139393 | 4855 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 208X Berkeley Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6000949.9317226 | 2097825.5763540003 | 37.7402828758816 | -122.439285032066 | (37.7402828758816, -122.439285032066) | |||
| 142229 | 142229 | 13130 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1727 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004021.471059999 | 2119661.74787 | 37.8004139978499 | -122.430222327563 | (37.8004139978499, -122.430222327563) | |||
| 53193 | 53193 | 123034 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 648 Funston Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | Width 4ft | 5991946.460390001 | 2111029.3621799997 | 37.776020536333 | -122.47137696956499 | (37.776020536333, -122.471376969565) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 78251 | 78251 | 121234 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 55 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001014.0 | 2101393.0 | 37.7500818202531 | -122.439319152756 | (37.7500818202531, -122.439319152756) | |||
| 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) | ||
| 16354 | 16354 | 43351 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 385 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1977 12:00:00 AM | 26 | 3x3 | Permit Number 43103 | 6010005.031690001 | 2109964.91982 | 37.7741259209126 | -122.408832212936 | (37.7741259209126, -122.408832212936) | |
| 54964 | 54964 | 204604 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 178 Judson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 5998865.22507 | 2093516.48509 | 37.7283322776885 | -122.446183203316 | (37.7283322776885, -122.446183203316) | |||
| 10942 | 10942 | 4875 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6000876.37429 | 2097986.48313 | 37.7407205018559 | -122.43955089567801 | (37.7407205018559, -122.439550895678) | |||
| 17138 | 17138 | 4856 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 9 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6000665.42788 | 2098259.03827 | 37.7414568658316 | -122.440299807886 | (37.7414568658316, -122.440299807886) | |||
| 17602 | 17602 | 4876 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Crags Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6000878.44646 | 2097957.44454 | 37.74064088666079 | -122.43954164975099 | (37.7406408866608, -122.439541649751) | |||
| 18698 | 18698 | 4862 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 22 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000700.353999999 | 2098195.46944 | 37.7412843093321 | -122.44017448827299 | (37.7412843093321, -122.440174488273) | |||
| 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) | |||
| 20190 | 20190 | 4864 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 25 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1992 12:00:00 AM | 25 | 2X2 | 6000739.41947 | 2098202.35217 | 37.7413054316983 | -122.440039907412 | (37.7413054316983, -122.440039907412) | ||
| 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) | |||
| 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) | |||
| 23397 | 23397 | 54440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 512 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 25 | Permit Number 10217 | 6014062.04664 | 2104690.51395 | 37.7598699757444 | -122.39442879427601 | (37.7598699757444, -122.394428794276) | ||
| 122169 | 122169 | 4878 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 67 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 2X2 | 6000744.9101647 | 2098152.0241158 | 37.741167555314604 | -122.44001731469801 | (37.7411675553146, -122.440017314698) | |||
| 124565 | 124565 | 4872 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 56 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6000821.7829322 | 2098156.9001957 | 37.7411853197784 | -122.439751866369 | (37.7411853197784, -122.439751866369) | |||
| 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) | |||
| 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) | |||
| 28306 | 28306 | 220804 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 286 Bemis St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | 6002911.89345 | 2096223.73908 | 37.735996051974396 | -122.432386979878 | (37.7359960519744, -122.432386979878) | ||||
| 74641 | 74641 | 205772 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 5999313.6439 | 2097558.6392200002 | 37.7394566791949 | -122.444923457253 | (37.7394566791949, -122.444923457253) | |||
| 136443 | 136443 | 222181 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500x 27th St | 32 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 4ft | 6003013.920940001 | 2100069.89733 | 37.7465624978683 | -122.432308835085 | (37.7465624978683, -122.432308835085) | |||
| 166351 | 166351 | 222164 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 976 Elizabeth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 4ft | 6000208.07575 | 2101987.18481 | 37.75166741222971 | -122.442148723208 | (37.7516674122297, -122.442148723208) | |||
| 26358 | 26358 | 188851 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 397 08th St | 1 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6010057.61121 | 2109905.66708 | 37.7739661716411 | -122.40864614951299 | (37.7739661716411, -122.408646149513) | |||
| 60102 | 60102 | 188852 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 397 08th St | 2 | : 4 | Tree 1 | Private 1 | 22 | Width 3ft | 6010041.330130001 | 2109925.85439 | 37.774020689429996 | -122.408703893195 | (37.77402068943, -122.408703893195) | |||
| 73970 | 73970 | 222486 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 124 Moreland St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 2ft | 6002283.64402 | 2097512.32666 | 37.7394985713917 | -122.43465120030001 | (37.7394985713917, -122.4346512003) | |||
| 75794 | 75794 | 54149 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 34 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/20/1972 12:00:00 AM | 22 | Permit Number 9884 | 6013977.76426 | 2095493.9516 | 37.7346134738323 | -122.394076462386 | (37.7346134738323, -122.394076462386) | ||
| 138089 | 138089 | 204532 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 21 | Width 3ft | 5999409.97615 | 2097047.8639900002 | 37.7380597091791 | -122.44455368300699 | (37.7380597091791, -122.444553683007) | |||
| 152792 | 152792 | 222246 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1149 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5997700.29974 | 2106538.60043 | 37.764021222026294 | -122.451149091478 | (37.7640212220263, -122.451149091478) | |||
| 18724 | 18724 | 4858 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 16 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6000671.66564 | 2098216.18353 | 37.7413395519912 | -122.440275167373 | (37.7413395519912, -122.440275167373) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 31126 | 31126 | 222212 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1012 Chenery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6000957.79216 | 2096197.5485099999 | 37.7358131397705 | -122.439141199604 | (37.7358131397705, -122.439141199604) | ||||
| 98571 | 98571 | 69201 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2829 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | 20 | Permit Number 33249 | 6008994.37155301 | 2101984.87642995 | 37.7521578906902 | -122.411764291769 | (37.7521578906902, -122.411764291769) | |
| 166394 | 166394 | 250229 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 20 | Width 0ft | 6011206.629819999 | 2120043.6184099996 | 37.8018668665295 | -122.405385582777 | (37.8018668665295, -122.405385582777) | |||
| 182762 | 182762 | 204600 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 158 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 5999447.0256900005 | 2093744.5020599999 | 37.7289915679835 | -122.44418827768 | (37.7289915679835, -122.44418827768) | |||
| 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) | |||
| 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) | |||
| 25148 | 25148 | 220775 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2800 Mariposa St | 6 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6009066.85397 | 2105930.68426 | 37.762996251197706 | -122.411792424993 | (37.7629962511977, -122.411792424993) | |||
| 64513 | 64513 | 205694 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 788 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 5990530.51036 | 2099765.7034299998 | 37.745011526166394 | -122.47545247388001 | (37.7450115261664, -122.47545247388) | |||
| 64625 | 64625 | 205790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Hearst Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6000031.692480001 | 2094391.3460900001 | 37.7308009895781 | -122.442213461795 | (37.7308009895781, -122.442213461795) | ||||
| 69791 | 69791 | 250225 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 18 | Width 0ft | 6011230.02021 | 2120062.52676 | 37.8019200919915 | -122.40530597298701 | (37.8019200919915, -122.405305972987) | |||
| 76783 | 76783 | 222163 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 976 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 6000221.60157 | 2101988.12675 | 37.7516707693994 | -122.442102016907 | (37.7516707693994, -122.442102016907) | |||
| 77122 | 77122 | 55323 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1186 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 18 | Permit Number 11253 | 6011357.40386 | 2089280.46993 | 37.7174065499613 | -122.402699162137 | (37.7174065499613, -122.402699162137) | ||
| 109540 | 109540 | 9884 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1530 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6005423.33111 | 2115078.55002 | 37.7879089952385 | -122.425045046399 | (37.7879089952385, -122.425045046399) | |||
| 133326 | 133326 | 204540 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 3ft | 5999530.69026 | 2097034.8442 | 37.7380308472428 | -122.444135380462 | (37.7380308472428, -122.444135380462) | |||
| 29102 | 29102 | 220887 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 58 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5998263.6114 | 2106253.00585 | 37.7632692871588 | -122.449180194907 | (37.7632692871588, -122.449180194907) | |||
| 38657 | 38657 | 204518 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 47 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 3ft | 5999003.37096 | 2096940.1521400001 | 37.737740748427704 | -122.445951769058 | (37.7377407484277, -122.445951769058) | |||
| 42569 | 42569 | 175629 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 44 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6009095.75789 | 2089908.2938299999 | 37.719003889795104 | -122.410560964431 | (37.7190038897951, -122.410560964431) | |||
| 48313 | 48313 | 188250 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6013748.16101 | 2089779.7890700002 | 37.7189107748964 | -122.39447030426099 | (37.7189107748964, -122.394470304261) | ||||
| 56197 | 56197 | 120863 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 651 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5990016.037690001 | 2110918.45187 | 37.7756041478874 | -122.47804662724899 | (37.7756041478874, -122.478046627249) | |||
| 66335 | 66335 | 204517 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 48 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 3ft | 5998995.15377 | 2096935.4716400001 | 37.7377274276678 | -122.445979843191 | (37.7377274276678, -122.445979843191) | |||
| 68376 | 68376 | 175674 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 116 Vienna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6004710.8636300005 | 2092757.34918 | 37.726579963084504 | -122.42592054229999 | (37.7265799630845, -122.4259205423) | |||
| 83083 | 83083 | 99749 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4216 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | Looks like it was planted at same time with permit to plant tree no. 1 | 6002493.0 | 2100648.0 | 37.7481202809952 | -122.434151441743 | (37.7481202809952, -122.434151441743) | ||
| 133892 | 133892 | 204554 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 63 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5999684.52262 | 2097404.39689 | 37.7390543260871 | -122.443630047808 | (37.7390543260871, -122.443630047808) | |||
| 134860 | 134860 | 188853 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 385 08th St | 2 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6009987.41661 | 2109987.90496 | 37.7741880460757 | -122.408894768882 | (37.7741880460757, -122.408894768882) | |||
| 137479 | 137479 | 222322 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3290 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6007845.78874 | 2101533.25903 | 37.750853350400796 | -122.415704304121 | (37.7508533504008, -122.415704304121) | |||
| 149146 | 149146 | 205771 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5999270.55629 | 2097571.10979 | 37.7394884612284 | -122.445073331084 | (37.7394884612284, -122.445073331084) | |||
| 153705 | 153705 | 199925 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1314 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6016264.3657 | 2092862.8823 | 37.727515905313 | -122.385987492696 | (37.727515905313, -122.385987492696) | |||
| 165525 | 165525 | 204534 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 3ft | 5999452.84675 | 2097039.9655900002 | 37.7380404681896 | -122.44440489108 | (37.7380404681896, -122.44440489108) | |||
| 166321 | 166321 | 250223 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 0ft | 6011234.32087 | 2120070.9566599997 | 37.80194347887979 | -122.405291684587 | (37.8019434788798, -122.405291684587) | |||
| 18186 | 18186 | 105551 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6017214.0 | 2092838.0 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | |||
| 25778 | 25778 | 220791 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1201 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6011142.88889 | 2102704.62469 | 37.7542544559807 | -122.404385006975 | (37.7542544559807, -122.404385006975) | |||
| 37670 | 37670 | 222193 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 876 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6000809.24973 | 2102020.54317 | 37.751793248965505 | -122.440072182292 | (37.7517932489655, -122.440072182292) | |||
| 38946 | 38946 | 220913 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 82 Ellsworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008134.61068 | 2098261.71796 | 37.7418866599353 | -122.414474058548 | (37.7418866599353, -122.414474058548) | |||
| 39947 | 39947 | 204539 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 3ft | 5999517.17436 | 2097035.6641400002 | 37.7380323275304 | -122.444182170371 | (37.7380323275304, -122.444182170371) | |||
| 48723 | 48723 | 204404 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1440 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5994305.88631 | 2105718.15994 | 37.7615735767848 | -122.4628297533 | (37.7615735767848, -122.4628297533) | |||
| 48816 | 48816 | 204541 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 3ft | 5999538.51913 | 2097033.8732 | 37.7380286277303 | -122.444108242518 | (37.7380286277303, -122.444108242518) | |||
| 56579 | 56579 | 204560 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 54 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 5999598.12734 | 2097466.8336099996 | 37.7392208346642 | -122.443933247029 | (37.7392208346642, -122.443933247029) | |||
| 59598 | 59598 | 205698 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2330 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5992340.2953 | 2099583.2383 | 37.7446152659802 | -122.46918134115299 | (37.7446152659802, -122.469181341153) | |||
| 67816 | 67816 | 250228 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 312 Filbert St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | Width 0ft | 6011211.1715400005 | 2120049.4002099996 | 37.8018829958704 | -122.40537027363101 | (37.8018829958704, -122.405370273631) | |||
| 75962 | 75962 | 125833 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1870 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005225.66086 | 2117499.28655 | 37.794544561227795 | -122.425901330993 | (37.7945445612278, -122.425901330993) | |||
| 116978 | 116978 | 57253 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4216 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/1975 12:00:00 AM | 16 | Permit Number 14544 | 6002483.9611287005 | 2100656.53536988 | 37.748143204098504 | -122.434183307899 | (37.7481432040985, -122.434183307899) | ||
| 131033 | 131033 | 142555 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 680 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6008015.0924 | 2121019.6955 | 37.804367969011395 | -122.41649900590001 | (37.8043679690114, -122.4164990059) |
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");