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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 22972 | 22972 | 108950 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 601 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775169 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | |
| 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) | |||
| 23074 | 23074 | 8830 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1993 12:00:00 AM | 4 | 3x3 | 5994612.73133 | 2112879.8624299997 | 37.7812553917023 | -122.462287945756 | (37.7812553917023, -122.462287945756) | ||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 23641 | 23641 | 222492 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 265 Beacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002907.41416 | 2097886.83375 | 37.740562273319505 | -122.43252121989599 | (37.7405622733195, -122.432521219896) | |||
| 23812 | 23812 | 220970 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 75 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000907.15737 | 2097980.81519 | 37.740706690970995 | -122.43944405351601 | (37.740706690971, -122.439444053516) | |||
| 23858 | 23858 | 222304 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 159 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007445.403080001 | 2100226.12885 | 37.747241750408605 | -122.416996273782 | (37.7472417504086, -122.416996273782) | |||
| 23906 | 23906 | 199914 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1220 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6017119.8344 | 2092922.0985 | 37.7277258082427 | -122.38303422196002 | (37.7277258082427, -122.38303422196) | |||
| 23921 | 23921 | 102246 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 337 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x6 | 6013795.01675 | 2105505.95048 | 37.7620941385477 | -122.395409453676 | (37.7620941385477, -122.395409453676) | |||
| 23971 | 23971 | 78224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6009704.84764 | 2090538.9392099997 | 37.7207696402774 | -122.40850003035101 | (37.7207696402774, -122.408500030351) | ||
| 24048 | 24048 | 113755 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6001200.73843 | 2089055.6919999998 | 37.7162170508648 | -122.43778988730499 | (37.7162170508648, -122.437789887305) | |||
| 24071 | 24071 | 250790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 284 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.49245762762101 | (37.7838471713633, -122.492457627621) | |||
| 24103 | 24103 | 122254 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1751 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990004.74374 | 2113334.11556 | 37.7822362348945 | -122.47826236215 | (37.7822362348945, -122.47826236215) | |||
| 24105 | 24105 | 205695 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2236 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990740.52284 | 2100154.10993 | 37.7460901613437 | -122.47475463951 | (37.7460901613437, -122.47475463951) | |||
| 24139 | 24139 | 188877 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 711 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011296.96428 | 2105014.49573 | 37.7606054583887 | -122.40401471650299 | (37.7606054583887, -122.404014716503) | |||
| 24165 | 24165 | 54475 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 80 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 10 | Permit Number 10267 | 6012323.1841 | 2095334.0847599998 | 37.73408241247979 | -122.399785717559 | (37.7340824124798, -122.399785717559) | ||
| 24237 | 24237 | 222185 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1266 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003207.46719 | 2100851.7918599998 | 37.7487203698443 | -122.431695388655 | (37.7487203698443, -122.431695388655) | |||
| 24354 | 24354 | 54553 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 12 | Permit Number 10348 | 6012791.48057 | 2095648.57895 | 37.7349720434069 | -122.39818871674801 | (37.7349720434069, -122.398188716748) | ||
| 24699 | 24699 | 54559 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 10 | Permit Number 10354 | 6012768.0788 | 2095448.27942 | 37.734420759018604 | -122.398255576836 | (37.7344207590186, -122.398255576836) | ||
| 24743 | 24743 | 204401 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5994301.112480001 | 2105797.04761 | 37.761789906893604 | -122.462851987244 | (37.7617899068936, -122.462851987244) | |||
| 24774 | 24774 | 143056 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 30 EDITH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010306.5322 | 2120406.926 | 37.8028140529926 | -122.40852599821699 | (37.8028140529926, -122.408525998217) | |||
| 24882 | 24882 | 220794 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2406 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6011347.91317 | 2102325.1902900003 | 37.753224067640296 | -122.403649282384 | (37.7532240676403, -122.403649282384) | |||
| 24915 | 24915 | 222484 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 59 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002447.270769999 | 2096535.4200900001 | 37.7368254993903 | -122.434015637735 | (37.7368254993903, -122.434015637735) | |||
| 24943 | 24943 | 175677 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 165 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004417.90024 | 2094349.92502 | 37.7309362610921 | -122.427046687756 | (37.7309362610921, -122.427046687756) | |||
| 25061 | 25061 | 222360 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 498 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003186.117380001 | 2102736.4547200003 | 37.7538939996264 | -122.43190377055599 | (37.7538939996264, -122.431903770556) | |||
| 25079 | 25079 | 204442 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2395 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991351.20232 | 2099149.48654 | 37.743367092409294 | -122.472569777984 | (37.7433670924093, -122.472569777984) | |||
| 25149 | 25149 | 220954 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3339 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006068.29873 | 2103732.65961 | 37.75679231583621 | -122.42200726293001 | (37.7567923158362, -122.42200726293) | |||
| 25239 | 25239 | 183737 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1014 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989684.0603 | 2099734.5492 | 37.744876881917 | -122.47837703617901 | (37.744876881917, -122.478377036179) | |||
| 25241 | 25241 | 205846 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994462.98595 | 2090252.1993200001 | 37.7191169462637 | -122.46116531412301 | (37.7191169462637, -122.461165314123) | |||
| 25282 | 25282 | 125851 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1359 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007069.22573 | 2118411.6669099997 | 37.797153742719296 | -122.41958711357901 | (37.7971537427193, -122.419587113579) | |||
| 25312 | 25312 | 69188 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2249 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33230 | 6010676.3293699995 | 2106439.96142 | 37.7644847703853 | -122.40626165736401 | (37.7644847703853, -122.406261657364) | ||
| 25695 | 25695 | 114253 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 500 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5990028.62528 | 2111858.48615 | 37.778185952947 | -122.478071825887 | (37.778185952947, -122.478071825887) | |||
| 25762 | 25762 | 220852 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1395 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003936.80464 | 2100186.5973 | 37.7469352146856 | -122.429125922127 | (37.7469352146856, -122.429125922127) | |||
| 25769 | 25769 | 175689 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1419 Wayland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007497.28407 | 2091377.76414 | 37.7229489970823 | -122.416190298655 | (37.7229489970823, -122.416190298655) | |||
| 25775 | 25775 | 188897 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 837 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6012777.55941 | 2103554.0520599997 | 37.7566780119987 | -122.398791479242 | (37.7566780119987, -122.398791479242) | |||
| 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) | |||
| 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) | ||||
| 25822 | 25822 | 217692 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 150 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5992741.6623 | 2097644.2084 | 37.739314365266 | -122.467652516069 | (37.739314365266, -122.467652516069) | |||
| 25836 | 25836 | 222165 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 953 Elizabeth St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6000303.115259999 | 2101951.8939 | 37.7515759277946 | -122.441817532557 | (37.7515759277946, -122.441817532557) | |||
| 25851 | 25851 | 118062 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 440 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5984715.49156 | 2112889.6967 | 37.780707531386795 | -122.49652772957899 | (37.7807075313868, -122.496527729579) | |||
| 25912 | 25912 | 205736 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1469 Northwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5995878.81817 | 2093821.3570700001 | 37.7289983803529 | -122.456529318894 | (37.7289983803529, -122.456529318894) | |||
| 26005 | 26005 | 222217 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002025.85337 | 2096457.93156 | 37.736588808613206 | -122.43546711921302 | (37.7365888086132, -122.435467119213) | |||
| 26120 | 26120 | 125878 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 712 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011759.18652 | 2117854.8104 | 37.7958878075263 | -122.403319400277 | (37.7958878075263, -122.403319400277) | |||
| 26136 | 26136 | 188896 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 851 Wisconsin St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012778.37681 | 2103525.2873 | 37.7565990757928 | -122.398786633697 | (37.7565990757928, -122.398786633697) | |||
| 26171 | 26171 | 189043 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 70 Moss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010322.24625 | 2111201.84362 | 37.7775399884207 | -122.407822145684 | (37.7775399884207, -122.407822145684) | |||
| 26223 | 26223 | 175637 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1177 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011646.28852 | 2089340.4245799999 | 37.7175872984009 | -122.401704827622 | (37.7175872984009, -122.401704827622) | |||
| 26267 | 26267 | 204461 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 376 Magellan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 3ft | 5993925.03451 | 2099657.87207 | 37.7449116357803 | -122.46370708514 | (37.7449116357803, -122.46370708514) | |||
| 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) | |||
| 26473 | 26473 | 138043 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1511 GOUGH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005359.99 | 2115008.8327 | 37.787713990640995 | -122.42525923232701 | (37.787713990641, -122.425259232327) | |||
| 26733 | 26733 | 188939 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2225 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012171.90247 | 2099321.56683 | 37.745022760504206 | -122.400588763562 | (37.7450227605042, -122.400588763562) | |||
| 26742 | 26742 | 222356 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3719 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003591.29083 | 2103007.3382900003 | 37.7546607427065 | -122.43052191368 | (37.7546607427065, -122.43052191368) | |||
| 27024 | 27024 | 38346 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.50417542529499 | (37.7518433707941, -122.504175425295) | |
| 27069 | 27069 | 175748 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 66 Baltimore Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002940.94851 | 2086563.0179 | 37.7094715113586 | -122.43159703068501 | (37.7094715113586, -122.431597030685) | |||
| 27128 | 27128 | 120861 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 575 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5989997.60391 | 2111451.48261 | 37.777066633188895 | -122.478149373865 | (37.7770666331889, -122.478149373865) | |||
| 27250 | 27250 | 121998 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 690 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991325.52809 | 2110732.20722 | 37.7751686909072 | -122.473503236905 | (37.7751686909072, -122.473503236905) | |||
| 27327 | 27327 | 185602 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2612 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985366.1309 | 2100949.2405 | 37.7479604792755 | -122.49339689517299 | (37.7479604792755, -122.493396895173) | |||
| 27562 | 27562 | 204441 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2391 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5991348.1208 | 2099203.10843 | 37.7435141459709 | -122.47258434161199 | (37.7435141459709, -122.472584341612) | |||
| 27617 | 27617 | 56389 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1338 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 14 | Permit Number 12542 | 6016160.8061 | 2092941.1028 | 37.727724951534704 | -122.38635095351299 | (37.7277249515347, -122.386350953513) | ||
| 27713 | 27713 | 61447 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1745 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/1994 12:00:00 AM | 7 | Permit Number 33475 | 6004648.5784 | 2118760.76141 | 37.7979756196421 | -122.42798804503599 | (37.7979756196421, -122.427988045036) | ||
| 27773 | 27773 | 222390 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 331 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001150.925480001 | 2104433.80629 | 37.7584389313379 | -122.439063562935 | (37.7584389313379, -122.439063562935) | |||
| 27851 | 27851 | 189007 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1739 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014800.47126 | 2096669.79143 | 37.7378877812889 | -122.39131423337 | (37.7378877812889, -122.39131423337) | |||
| 27971 | 27971 | 222333 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4239 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6001628.05008 | 2101736.4596599997 | 37.7510598032865 | -122.43722032596001 | (37.7510598032865, -122.43722032596) | |||
| 27979 | 27979 | 205735 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993166.85587 | 2093123.26656 | 37.726925522195 | -122.465853997962 | (37.726925522195, -122.465853997962) | |||
| 28005 | 28005 | 220847 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010640.7419300005 | 2100124.57221 | 37.747142125307 | -122.40593982595502 | (37.747142125307, -122.405939825955) | |||
| 28006 | 28006 | 108969 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 678 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5994435.965419999 | 2110902.3742400003 | 37.77581555851361 | -122.46275596534299 | (37.7758155585136, -122.462755965343) | |||
| 28106 | 28106 | 32369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 858 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | 6 | Permit Number 36919 | 6008860.83914 | 2119402.12264 | 37.799974043636205 | -122.413457749072 | (37.7999740436362, -122.413457749072) | ||
| 28182 | 28182 | 175586 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 158 Rome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 1ft | 5998844.18074 | 2089066.48098 | 37.7161123931481 | -122.44593602912799 | (37.7161123931481, -122.445936029128) | |||
| 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) | ||||
| 28466 | 28466 | 220788 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 443 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005526.143130001 | 2101115.3994299998 | 37.7495753337563 | -122.423696154666 | (37.7495753337563, -122.423696154666) |
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");