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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
23034 | 23034 | 4896 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/11/1999 12:00:00 AM | 6 | 3X4 | 6018106.77773 | 2094390.5453599999 | 37.731812362636205 | -122.37972428526699 | (37.7318123626362, -122.379724285267) | ||
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) | |||
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) | |||
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) | |||
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) | |||
23617 | 23617 | 205782 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 451 Hearst Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998547.56823 | 2094367.17005 | 37.730649912448605 | -122.447342555315 | (37.7306499124486, -122.447342555315) | |||
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) | |||
23673 | 23673 | 222238 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1022 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997287.2431 | 2106942.28914 | 37.7651059905631 | -122.45260686101801 | (37.7651059905631, -122.452606861018) | |||
23678 | 23678 | 204530 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400x Marietta Dr | 28 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999185.819 | 2097019.3718599998 | 37.7379686834 | -122.44532665482299 | (37.7379686834, -122.445326654823) | |||
23720 | 23720 | 188872 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 969 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012202.49655 | 2103904.7568 | 37.757608911948104 | -122.40080490573798 | (37.7576089119481, -122.400804905738) | |||
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) | ||
23987 | 23987 | 175686 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Madison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005601.68798 | 2092672.56295 | 37.726397462770706 | -122.42283496838199 | (37.7263974627707, -122.422834968382) | |||
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) | |||
24055 | 24055 | 188977 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Thomas Ave | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012688.07294 | 2095454.3657900002 | 37.7344330140672 | -122.398532612087 | (37.7344330140672, -122.398532612087) | |||
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) | ||
24185 | 24185 | 220918 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3590 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008482.3827 | 2098155.73861 | 37.7416151950936 | -122.41326407916999 | (37.7416151950936, -122.41326407917) | |||
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) | |||
24324 | 24324 | 138190 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1837 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003409.3754 | 2115058.633 | 37.7877403378272 | -122.432011538078 | (37.7877403378272, -122.432011538078) | |||
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) | ||
24442 | 24442 | 205788 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 201 Hearst Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000020.87413 | 2094345.53232 | 37.7306745790527 | -122.442247574877 | (37.7306745790527, -122.442247574877) | |||
24448 | 24448 | 220803 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006506.67533 | 2105838.44875 | 37.7625990368337 | -122.42064067382401 | (37.7625990368337, -122.420640673824) | |||
24561 | 24561 | 220882 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 599 Belvedere St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998626.62137 | 2105762.24598 | 37.7619425398344 | -122.44788933414 | (37.7619425398344, -122.44788933414) | |||
24616 | 24616 | 222318 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 838 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009101.97358 | 2104063.21002 | 37.7578705625017 | -122.41153901044301 | (37.7578705625017, -122.411539010443) | |||
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) | |||
24798 | 24798 | 45088 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1900 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 2 | Permit Number 43969 | 5988077.6041 | 2102404.3375 | 37.752114018434206 | -122.484127544226 | (37.7521140184342, -122.484127544226) | |
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) | |||
24935 | 24935 | 175691 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1419 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007522.85958 | 2091386.22385 | 37.722973663691 | -122.41610248796499 | (37.722973663691, -122.416102487965) | |||
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) | |||
25111 | 25111 | 222282 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 322 Elsie St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006404.19555 | 2097095.06945 | 37.7385859402852 | -122.42037449518699 | (37.7385859402852, -122.420374495187) | |||
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) | |||
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) | |||
25152 | 25152 | 222160 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Fountain St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000360.36109 | 2101597.05955 | 37.7506049001065 | -122.44159410859899 | (37.7506049001065, -122.441594108599) | |||
25188 | 25188 | 99927 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 665 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6008996.47999 | 2092997.0616099997 | 37.727479429923896 | -122.411122192648 | (37.7274794299239, -122.411122192648) | ||||
25230 | 25230 | 188862 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2145 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011298.33693 | 2105542.34604 | 37.7620548939477 | -122.404047117302 | (37.7620548939477, -122.404047117302) | |||
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) | |||
25287 | 25287 | 188860 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 601 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011271.15548 | 2105473.51141 | 37.7618643707515 | -122.40413628328899 | (37.7618643707515, -122.404136283289) | |||
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) | ||
25569 | 25569 | 222200 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000609.51746 | 2102650.2071599998 | 37.753510781406604 | -122.44080804535801 | (37.7535107814066, -122.440808045358) | |||
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) | |||
25911 | 25911 | 205719 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 141 Taraval St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993232.44961 | 2099151.4105700003 | 37.7434810877719 | -122.466065100337 | (37.7434810877719, -122.466065100337) |
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");