trees
3,267 rows where qSpecies_id = 67 sorted by qCaretaker_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 58508 | 8948 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
| 59406 | 1350 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 261 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 5999733.43875 | 2099278.43357 | 37.7442027739306 | -122.443595506633 | (37.7442027739306, -122.443595506633) | 2 | 7 | 5 | 63 | 22 | |||
| 59457 | 113505 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 13 | 3x3 | 6011134.80907 | 2090561.37437 | 37.7209112214707 | -122.403558643321 | (37.7209112214707, -122.403558643321) | 10 | 3 | 7 | 309 | 28 | |||
| 60964 | 10978 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1468X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016410.2814628 | 2096936.3836856 | 37.7387090009717 | -122.385766856192 | (37.7387090009717, -122.385766856192) | 10 | 3 | 8 | 58 | 1 | |||
| 61422 | 8885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 10 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
| 61968 | 9049 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989816.2539 | 2112654.318 | 37.7803587568757 | -122.478864709732 | (37.7803587568757, -122.478864709732) | 11 | 6 | 2 | 55 | 26 | |||
| 62767 | 9053 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989985.8536433 | 2112684.8221383 | 37.7804523594748 | -122.478280222727 | (37.7804523594748, -122.478280222727) | 11 | 6 | 2 | 55 | 26 | |||
| 64242 | 204560 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 54 | Median : Cutout | Tree | DPW 1 | 16 | Width 5ft | 5999598.12734 | 2097466.83361 | 37.7392208346642 | -122.443933247029 | (37.7392208346642, -122.443933247029) | 9 | 7 | 4 | 59 | 40 | |||
| 64701 | 204527 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 31 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5999174.36675 | 2097015.29768 | 37.737956842928 | -122.445365957891 | (37.737956842928, -122.445365957891) | 9 | 7 | 4 | 59 | 40 | |||
| 67043 | 204547 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 68 | Median : Cutout | Tree | DPW 1 | 15 | Width 5ft | 5999723.97514 | 2097336.19746 | 37.7388693166702 | -122.443488741839 | (37.7388693166702, -122.443488741839) | 9 | 7 | 4 | 59 | 40 | |||
| 67586 | 113508 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 203 WILLOW ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2016 10:06:00 AM | 3 | 4x4 | 6006475 | 2113325 | 37.7831535286214 | -122.421281886667 | (37.7831535286214, -122.421281886667) | 7 | 9 | 11 | 28858 | 41 | ||
| 67836 | 22598 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 835 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005965.95079 | 2112761.85116 | 37.7815785478641 | -122.423002954524 | (37.7815785478641, -122.423002954524) | 7 | 9 | 11 | 28852 | 41 | |||
| 67901 | 205753 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Terrace Dr | 34 | Median : Yard | Tree | DPW 1 | 4 | 5993866.87232 | 2096473.28451 | 37.7361642036105 | -122.463677108908 | (37.7361642036105, -122.463677108908) | 1 | 8 | 4 | 59 | 40 | ||||
| 68107 | 9218 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6300 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987387.1497 | 2112575.6349 | 37.7800013647147 | -122.487262222118 | (37.7800013647147, -122.487262222118) | 11 | 6 | 2 | 55 | 26 | |||
| 68539 | 4484 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1566 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1990 12:00:00 AM | 12 | 3X3 | 6004549.88502 | 2099732.13285 | 37.7457220463542 | -122.426973581877 | (37.7457220463542, -122.426973581877) | 2 | 7 | 5 | 63 | 22 | ||
| 68776 | 113504 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Mansell St | 10 | Median : Cutout | Tree | DPW 1 | 7 | 3x3 | 6011150.15882 | 2090569.37703 | 37.7209340525347 | -122.403506146294 | (37.7209340525347, -122.403506146294) | 10 | 3 | 7 | 309 | 28 | |||
| 70114 | 8959 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
| 71405 | 1879 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45X Lillian St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/12/2003 12:00:00 AM | 12 | 3X4 | 6017774.309035 | 2094355.975399 | 37.7316990960952 | -122.380871307769 | (37.7316990960952, -122.380871307769) | 10 | 3 | 8 | 58 | 1 | ||
| 71426 | 204535 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 13 | Median : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5999462.01157 | 2097038.1578 | 37.7380360273359 | -122.444373073979 | (37.7380360273359, -122.444373073979) | 9 | 7 | 4 | 59 | 40 | |||
| 71789 | 222180 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500x 27th St | 31 | Median : Cutout | Tree | DPW 1 | 15 | Width 4ft | 6003010.48164 | 2100075.576 | 37.7465778951541 | -122.432321133307 | (37.7465778951541, -122.432321133307) | 2 | 7 | 5 | 63 | 22 | |||
| 71945 | 8884 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
| 72664 | 24269 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300X Winding Way | 7 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 6001399.20674 | 2086458.92155 | 37.7090981776115 | -122.43691809172 | (37.7090981776115, -122.43691809172) | 9 | 7 | 6 | 28861 | 5 | |||
| 72863 | 4882 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 83 Crags Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 2X2 | 6000675.0021603 | 2098204.4094064 | 37.7413074129943 | -122.440262786724 | (37.7413074129943, -122.440262786724) | 2 | 7 | 5 | 63 | 7 | |||
| 74687 | 9096 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5700 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989196.3157 | 2112631.4669 | 37.78025999658 | -122.48100766619 | (37.78025999658, -122.48100766619) | 11 | 6 | 2 | 55 | 26 | |||
| 75281 | 24236 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200X Willow St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2016 10:02:00 AM | 3 | 4x4 | 6006547.3507 | 2113418.3192 | 37.7834138390239 | -122.421038210119 | (37.7834138390239, -122.421038210119) | 7 | 9 | 11 | 28858 | 41 | ||
| 75966 | 5802 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218X Cashmere St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6016122.2563 | 2096227.44621 | 37.7367464597726 | -122.386713296401 | (37.7367464597726, -122.386713296401) | 10 | 3 | 8 | 58 | 1 | |||
| 76138 | 222177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500x 27th St | 28 | Median : Cutout | Tree | DPW 1 | 4 | Width 4ft | 6003006.81083 | 2100070.04416 | 37.7465624978721 | -122.432333431547 | (37.7465624978721, -122.432333431547) | 2 | 7 | 5 | 63 | 22 | |||
| 77170 | 204555 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 59 | Median : Cutout | Tree | DPW 1 | 14 | Width 5ft | 5999635.81986 | 2097444.21934 | 37.7391608912586 | -122.443801299384 | (37.7391608912586, -122.443801299384) | 9 | 7 | 4 | 59 | 40 | |||
| 77427 | 10850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1220X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017356.4574634 | 2095156.0177673 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | 10 | 3 | 8 | 58 | 1 | |||
| 77929 | 8943 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4800 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5992178.808881 | 2112763.6040387 | 37.780795730088 | -122.470699570025 | (37.780795730088, -122.470699570025) | 11 | 6 | 2 | 54 | 11 | |||
| 78124 | 1875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6018011.4321332 | 2094063.1260405 | 37.7309080736078 | -122.380031174991 | (37.7309080736078, -122.380031174991) | 10 | 3 | 8 | 58 | 1 | |||
| 78369 | 9137 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5900 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5988584.9325 | 2112610.849 | 37.7801678269123 | -122.483121185388 | (37.7801678269123, -122.483121185388) | 11 | 6 | 2 | 55 | 26 | |||
| 79648 | 205752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Terrace Dr | 33 | Median : Yard | Tree | DPW 1 | 5 | 5993857.73884 | 2096475.3667 | 37.7361693944936 | -122.463708837915 | (37.7361693944936, -122.463708837915) | 1 | 8 | 4 | 59 | 40 | ||||
| 80084 | 9016 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990445.3325 | 2112679.3199 | 37.7804639139017 | -122.476690284152 | (37.7804639139017, -122.476690284152) | 11 | 6 | 2 | 55 | 26 | |||
| 81169 | 8882 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
| 82027 | 204517 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 48 | Median : Cutout | Tree | DPW 1 | 17 | Width 3ft | 5998995.15377 | 2096935.47164 | 37.7377274276678 | -122.445979843191 | (37.7377274276678, -122.445979843191) | 9 | 7 | 4 | 59 | 40 | |||
| 83132 | 222178 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500x 27th St | 29 | Median : Cutout | Tree | DPW 1 | 10 | Width 4ft | 6003005.10045 | 2100073.32596 | 37.7465714119449 | -122.432339580201 | (37.7465714119449, -122.432339580201) | 2 | 7 | 5 | 63 | 22 | |||
| 83230 | 9014 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990456.086 | 2112679.8576 | 37.7804660140104 | -122.476653122424 | (37.7804660140104, -122.476653122424) | 11 | 6 | 2 | 55 | 26 | |||
| 83673 | 204553 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 64 | Median : Cutout | Tree | DPW 1 | 14 | Width 5ft | 5999694.8834 | 2097395.01803 | 37.7390291648714 | -122.443593551518 | (37.7390291648714, -122.443593551518) | 9 | 7 | 4 | 59 | 40 | |||
| 83819 | 8681 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
| 84541 | 222176 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500x 27th St | 26 | Median : Cutout | Tree | DPW 1 | 15 | Width 4ft | 6002985.78905 | 2100071.06849 | 37.7465641184368 | -122.432406195695 | (37.7465641184368, -122.432406195695) | 2 | 7 | 5 | 63 | 22 | |||
| 85392 | 8837 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4000 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994660.7719396 | 2112852.5225639 | 37.7811830898725 | -122.462119766821 | (37.7811830898725, -122.462119766821) | 11 | 6 | 2 | 54 | 11 | |||
| 86146 | 16343 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 922X Monterey Blvd | 1 | Median : Cutout | Tree | DPW 1 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | 9 | 7 | 4 | 59 | 40 | ||
| 86147 | 8956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
| 86223 | 5805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5 Dukes Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6016140.1129448 | 2096198.2445968 | 37.7366672666368 | -122.386649521955 | (37.7366672666368, -122.386649521955) | 10 | 3 | 8 | 58 | 1 | |||
| 88370 | 175623 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 20 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6009402.84406 | 2090023.10643 | 37.719336352976 | -122.409507581334 | (37.719336352976, -122.409507581334) | 9 | 3 | 8 | 309 | 18 | |||
| 88544 | 8682 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
| 89334 | 18800 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017918.7507593 | 2094507.5509584 | 37.732123263915 | -122.380382469104 | (37.732123263915, -122.380382469104) | 10 | 3 | 8 | 58 | 1 | |||
| 89472 | 8728 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
| 89897 | 204528 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 30 | Median : Cutout | Tree | DPW 1 | 10 | Width 3ft | 5999178.73464 | 2097017.09345 | 37.7379620230245 | -122.445350985083 | (37.7379620230245, -122.445350985083) | 9 | 7 | 4 | 59 | 40 | |||
| 90020 | 8727 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
| 90355 | 222216 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | 2 | 7 | 5 | 63 | 7 | ||
| 90741 | 9177 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6100 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987977.7406 | 2112589.2174 | 37.7800730801841 | -122.485220125518 | (37.7800730801841, -122.485220125518) | 11 | 6 | 2 | 55 | 26 | |||
| 90795 | 8677 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2900 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5998150.0688375 | 2113145.5858248 | 37.7821880464461 | -122.450069715057 | (37.7821880464461, -122.450069715057) | 15 | 6 | 1 | 54 | 31 | |||
| 92956 | 9215 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6300 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987407.9428 | 2112568.2567 | 37.7799823187667 | -122.48718974832 | (37.7799823187667, -122.48718974832) | 11 | 6 | 2 | 55 | 26 | |||
| 95003 | 22599 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 835 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005992.6226 | 2112765.71653 | 37.7815906662302 | -122.422910957475 | (37.7815906662302, -122.422910957475) | 7 | 9 | 11 | 28852 | 41 | |||
| 95011 | 9217 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6300 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5987387.8205 | 2112562.8907 | 37.7799664118712 | -122.487258965224 | (37.7799664118712, -122.487258965224) | 11 | 6 | 2 | 55 | 26 | |||
| 96046 | 8927 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
| 97741 | 9054 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5500 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5989985.8536433 | 2112684.8221383 | 37.7804523594748 | -122.478280222727 | (37.7804523594748, -122.478280222727) | 11 | 6 | 2 | 55 | 26 | |||
| 97744 | 175619 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500x Mansell St | 5 | Median : Cutout | Tree | DPW 1 | 14 | Width 0ft | 6010523.52441 | 2090366.11314 | 37.7203409100883 | -122.405657935276 | (37.7203409100883, -122.405657935276) | 10 | 3 | 8 | 309 | 28 | |||
| 97768 | 5801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 218X Cashmere St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6016115.70396 | 2096246.37508 | 37.7367980718607 | -122.386737270517 | (37.7367980718607, -122.386737270517) | 10 | 3 | 8 | 58 | 1 | |||
| 97848 | 204556 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 58 | Median : Cutout | Tree | DPW 1 | 15 | Width 5ft | 5999628.6217 | 2097449.48982 | 37.7391749521682 | -122.443826565843 | (37.7391749521682, -122.443826565843) | 9 | 7 | 4 | 59 | 40 | |||
| 98410 | 4877 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 67 Crags Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6000895.2061 | 2098063.61209 | 37.7409333515943 | -122.439491310182 | (37.7409333515943, -122.439491310182) | 2 | 7 | 5 | 63 | 7 | |||
| 98428 | 8814 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3800 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5995279.8386756 | 2112876.8357526 | 37.7812854712581 | -122.459979879431 | (37.7812854712581, -122.459979879431) | 11 | 6 | 2 | 54 | 11 | |||
| 98997 | 205772 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 31 | Median : Cutout | Tree | DPW 1 | 23 | Width 5ft | 5999313.6439 | 2097558.63922 | 37.7394566791949 | -122.444923457253 | (37.7394566791949, -122.444923457253) | 9 | 7 | 4 | 59 | 40 | |||
| 101458 | 16350 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 922X Monterey Blvd | 3 | Median : Cutout | Tree | DPW 1 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995968.77487 | 2094643.75333 | 37.731261646603 | -122.456277773106 | (37.731261646603, -122.456277773106) | 9 | 7 | 4 | 59 | 40 | ||
| 102010 | 8928 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4600 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5992801.3833857 | 2112786.477091 | 37.7808945155903 | -122.468547465827 | (37.7808945155903, -122.468547465827) | 11 | 6 | 2 | 54 | 11 | |||
| 102150 | 175618 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500x Mansell St | 2 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6010611.86255 | 2090397.85136 | 37.7204329961751 | -122.405354811601 | (37.7204329961751, -122.405354811601) | 10 | 3 | 8 | 309 | 28 | |||
| 102190 | 125867 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 49 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6011400.22925 | 2120293.8654 | 37.8025648060933 | -122.404733262242 | (37.8025648060933, -122.404733262242) | 3 | 1 | 10 | 308 | 23 | |||
| 102469 | 1340 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 157 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5999318.51798 | 2099488.255 | 37.7447552202944 | -122.445045288424 | (37.7447552202944, -122.445045288424) | 2 | 7 | 5 | 63 | 22 | |||
| 102481 | 125868 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 50 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6011397.07627 | 2120306.83138 | 37.8026002312778 | -122.404745086537 | (37.8026002312778, -122.404745086537) | 3 | 1 | 10 | 308 | 23 | |||
| 102674 | 125864 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 46 | Median : Yard | Tree | DPW 1 | 11 | Width 8ft | 6011404.31889 | 2120270.95614 | 37.8025021314422 | -122.404717496217 | (37.8025021314422, -122.404717496217) | 3 | 1 | 10 | 308 | 23 | |||
| 102812 | 175626 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 700x Mansell St | 41 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6009096.33692 | 2089936.65243 | 37.7190817890677 | -122.410560964424 | (37.7190817890677, -122.410560964424) | 9 | 3 | 8 | 309 | 18 | |||
| 103006 | 8722 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
| 103393 | 204540 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 5 | Median : Cutout | Tree | DPW 1 | 18 | Width 3ft | 5999530.69026 | 2097034.8442 | 37.7380308472428 | -122.444135380462 | (37.7380308472428, -122.444135380462) | 9 | 7 | 4 | 59 | 40 | |||
| 103540 | 8721 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 1 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
| 104264 | 18979 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2916 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000692.61661 | 2115558.68007 | 37.7889589430353 | -122.4414468761 | (37.7889589430353, -122.4414468761) | 13 | 6 | 1 | 29490 | 27 | |||
| 107666 | 1998 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 213 Bocana St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6007163.78515 | 2097749.92103 | 37.7404267922562 | -122.417794596538 | (37.7404267922562, -122.417794596538) | 2 | 7 | 7 | 28859 | 2 | |||
| 107749 | 9246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5986886.6516554 | 2112572.1737573 | 37.7799626628655 | -122.488993391881 | (37.7799626628655, -122.488993391881) | 11 | 6 | 2 | 55 | 26 | |||
| 107981 | 8955 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5000 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5991565.8879728 | 2112742.4953614 | 37.7807023086422 | -122.472818401074 | (37.7807023086422, -122.472818401074) | 11 | 6 | 2 | 54 | 26 | |||
| 110227 | 9018 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 7 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990428.6646 | 2112675.0185 | 37.7804511366409 | -122.476747631291 | (37.7804511366409, -122.476747631291) | 11 | 6 | 2 | 55 | 26 | |||
| 110443 | 9017 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5317 Geary Blvd | 6 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990440.4935 | 2112674.4808 | 37.7804503463948 | -122.476706670705 | (37.7804503463948, -122.476706670705) | 11 | 6 | 2 | 55 | 26 | |||
| 110989 | 204554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 63 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5999684.52262 | 2097404.39689 | 37.7390543260871 | -122.443630047808 | (37.7390543260871, -122.443630047808) | 9 | 7 | 4 | 59 | 40 | |||
| 112054 | 16344 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 922X Monterey Blvd | 2 | Median : Cutout | Tree | DPW 1 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996005.09349 | 2094651.80988 | 37.7312858527477 | -122.456152796109 | (37.7312858527477, -122.456152796109) | 9 | 7 | 4 | 59 | 40 | ||
| 112318 | 125866 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1306x Montgomery St | 48 | Median : Yard | Tree | DPW 1 | 6 | Width 8ft | 6011400.87154 | 2120290.44992 | 37.802555463919 | -122.404730798994 | (37.802555463919, -122.404730798994) | 3 | 1 | 10 | 308 | 23 | |||
| 113541 | 18812 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017743.9455674 | 2094518.0196352 | 37.7321423618577 | -122.380987543086 | (37.7321423618577, -122.380987543086) | 10 | 3 | 8 | 58 | 1 | |||
| 114326 | 8724 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
| 114433 | 8993 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5200 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5990760.6778 | 2112689.8051 | 37.7805109894096 | -122.475600133516 | (37.7805109894096, -122.475600133516) | 11 | 6 | 2 | 54 | 26 | |||
| 114808 | 6392 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 15 Espanola St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017974.4315502 | 2094113.8790238 | 37.7310453900638 | -122.380162619042 | (37.7310453900638, -122.380162619042) | 10 | 3 | 8 | 58 | 1 | |||
| 115074 | 8898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 Geary Blvd | 2 | Median : Cutout | Tree | DPW 1 | 3 | M6 | 5993420.4630402 | 2112810.6467907 | 37.7809966203952 | -122.466407540491 | (37.7809966203952, -122.466407540491) | 11 | 6 | 2 | 54 | 11 | |||
| 115092 | 204519 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 43 | Median : Cutout | Tree | DPW 1 | 15 | Width 3ft | 5999085.31812 | 2096976.18126 | 37.7378443548231 | -122.445671029498 | (37.7378443548231, -122.445671029498) | 9 | 7 | 4 | 59 | 40 | |||
| 115109 | 204532 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 400x Marietta Dr | 16 | Median : Cutout | Tree | DPW 1 | 21 | Width 3ft | 5999409.97615 | 2097047.86399 | 37.7380597091791 | -122.444553683007 | (37.7380597091791, -122.444553683007) | 9 | 7 | 4 | 59 | 40 | |||
| 116442 | 9140 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5900 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 3 | 8M | 5988567.4931 | 2112610.849 | 37.7801668120621 | -122.48318151551 | (37.7801668120621, -122.48318151551) | 11 | 6 | 2 | 55 | 26 | |||
| 117115 | 18806 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X4 | 6017853.0028401 | 2094472.3604 | 37.7320230094763 | -122.380607331399 | (37.7320230094763, -122.380607331399) | 10 | 3 | 8 | 58 | 1 | |||
| 118886 | 24477 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 94 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6002318.91893 | 2096714.27726 | 37.7373093148834 | -122.434472190244 | (37.7373093148834, -122.434472190244) | 2 | 7 | 5 | 63 | 7 | ||
| 119370 | 17245 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 501 Ortega St | 1 | Median : Cutout | Tree | DPW 1 | 6 | 3 | 5992555.1394 | 2103055.38176 | 37.7541612907162 | -122.468691056856 | (37.7541612907162, -122.468691056856) | 1 | 8 | 4 | 56 | 12 | |||
| 119376 | 204557 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300x Marietta Dr | 57 | Median : Cutout | Tree | DPW 1 | 13 | Width 5ft | 5999620.61184 | 2097454.77716 | 37.7391890130662 | -122.443854640005 | (37.7391890130662, -122.443854640005) | 9 | 7 | 4 | 59 | 40 | |||
| 119525 | 8883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4200 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5994040.3790539 | 2112832.2888332 | 37.7810917943038 | -122.464264532347 | (37.7810917943038, -122.464264532347) | 11 | 6 | 2 | 54 | 11 | |||
| 119960 | 27529 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1430 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6015974.48783 | 2094842.30112 | 37.7329349481517 | -122.387127616668 | (37.7329349481517, -122.387127616668) | 10 | 3 | 8 | 58 | 1 | |||
| 120162 | 8743 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3300 Geary Blvd | 8 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5996964.8998051 | 2112982.2523578 | 37.7816716864396 | -122.454158044121 | (37.7816716864396, -122.454158044121) | 11 | 6 | 1 | 54 | 31 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );