trees
953 rows where qSpecies_id = 60 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2854 | 255187 | Section 806 (d) 5 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4740 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780757 | 5980843 | 2110991 | 37.7752666409579 | -122.509783220192 | (37.7752666409579, -122.509783220192) | 11 | 6 | 2 | 55 | 26 | |
| 103448 | 118672 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4600 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 3ft | 5981237.2536 | 2110989.81786 | 37.7752866381156 | -122.508419343439 | (37.7752866381156, -122.508419343439) | 11 | 6 | 2 | 55 | 26 | ||
| 89296 | 54694 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4605 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Permit Number 10525 | 5981277.89948 | 2110939.72797 | 37.7751515013754 | -122.508275023697 | (37.7751515013754, -122.508275023697) | 11 | 6 | 2 | 55 | 26 | ||
| 190975 | 97087 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4550 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x4.5 | 5981444.7277 | 2111006.81618 | 37.7753455356701 | -122.507702917245 | (37.7753455356701, -122.507702917245) | 11 | 6 | 2 | 55 | 26 | ||
| 147989 | 38652 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1276 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/1998 12:00:00 AM | Permit Number 40574 | 5982148.09911045 | 2106418.94720672 | 37.762789987906 | -122.504929783979 | (37.762789987906, -122.504929783979) | 1 | 8 | 3 | 56 | 35 | |||
| 163115 | 184438 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2118 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5982650.6525 | 2100679.8359 | 37.7470615561433 | -122.502766809334 | (37.7470615561433, -122.502766809334) | 1 | 8 | 3 | 29491 | 35 | |||
| 3060 | 70445 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2471 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982997.1409 | 2098317.8833 | 37.7405966408958 | -122.501394010052 | (37.7405966408958, -122.501394010052) | 1 | 8 | 3 | 29491 | 35 | |||
| 3037 | 73418 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2483 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5983001.5767 | 2098246.6338 | 37.7404012697688 | -122.50137340388 | (37.7404012697688, -122.50137340388) | 1 | 8 | 3 | 29491 | 35 | |||
| 33277 | 69157 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1259 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 8 | Permit Number 33193 | 5983030.0636 | 2106498.5077 | 37.7630602867444 | -122.501885316454 | (37.7630602867444, -122.501885316454) | 1 | 8 | 3 | 56 | 35 | |
| 12444 | 260536 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 5983685.38782 | 2106695.21091 | 37.7636388518254 | -122.499633347112 | (37.7636388518254, -122.499633347112) | 1 | 8 | 3 | 56 | 35 | ||||
| 79794 | 63193 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 435 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1986 12:00:00 AM | 12 | Permit Number 23733 | 5984052.79771 | 2112895.3666 | 37.7806842528122 | -122.498820690126 | (37.7806842528122, -122.498820690126) | 11 | 6 | 2 | 55 | 26 | |
| 71429 | 89507 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4600X Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 02:18:00 PM | 3 | 3x3 | 5984357.47283 | 2111783.09259 | 37.7776481358424 | -122.497684539583 | (37.7776481358424, -122.497684539583) | 11 | 6 | 2 | 55 | 26 | ||
| 128359 | 89506 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 4600X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2018 02:10:00 PM | 3 | 3x3 | 5984376.12519 | 2111783.50145 | 37.7776503518258 | -122.497620045924 | (37.7776503518258, -122.497620045924) | 11 | 6 | 2 | 55 | 26 | ||
| 153816 | 31678 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 568 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35184 | 5984441.54106734 | 2111980.46046246 | 37.7781949786835 | -122.497408297818 | (37.7781949786835, -122.497408297818) | 11 | 6 | 2 | 55 | 26 | |||
| 40526 | 121353 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1221 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/27/2016 12:00:00 AM | 3 | 3x3 | 5984567.3281 | 2106871.8527 | 37.7641755703197 | -122.496596073864 | (37.7641755703197, -122.496596073864) | 1 | 8 | 3 | 56 | 35 | ||
| 42353 | 118039 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3501 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 5ft | 5984617.86672 | 2113142.5664 | 37.7813961183692 | -122.496884124491 | (37.7813961183692, -122.496884124491) | 11 | 6 | 2 | 55 | 26 | ||
| 29254 | 71993 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984766.04316 | 2113148.2827 | 37.7814204950816 | -122.496371935666 | (37.7814204950816, -122.496371935666) | 11 | 6 | 2 | 55 | 26 | ||
| 118441 | 71992 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984787.84427 | 2113149.41844 | 37.7814248905972 | -122.496296599357 | (37.7814248905972, -122.496296599357) | 11 | 6 | 2 | 55 | 26 | ||
| 164292 | 254354 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3449 Clement St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/17/2018 12:00:00 AM | 3 | 5984787.84427 | 2113149.41844 | 37.7814248905972 | -122.496296599357 | (37.7814248905972, -122.496296599357) | 11 | 6 | 2 | 55 | 26 | ||
| 121455 | 186786 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1200 Sunset Blvd | 60 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984829.112 | 2106870.9818 | 37.7641885128796 | -122.495690587985 | (37.7641885128796, -122.495690587985) | 1 | 8 | 3 | 56 | 35 | |||
| 51972 | 254108 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3249 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x4 | 5985350 | 2113144 | 37.781442927388 | -122.494351441891 | (37.781442927388, -122.494351441891) | 11 | 6 | 2 | 55 | 26 | ||
| 138187 | 254107 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3249 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x4 | 5985350 | 2113144 | 37.781442927388 | -122.494351441891 | (37.781442927388, -122.494351441891) | 11 | 6 | 2 | 55 | 26 | ||
| 100735 | 143858 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3239 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985412.69263 | 2113173.41466 | 37.781527360227 | -122.494136727521 | (37.781527360227, -122.494136727521) | 11 | 6 | 2 | 55 | 26 | ||
| 168476 | 143859 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3227 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985458.68749 | 2113171.92516 | 37.7815259617825 | -122.493977499883 | (37.7815259617825, -122.493977499883) | 11 | 6 | 2 | 55 | 26 | ||
| 105952 | 143860 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3215 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985515.03599 | 2113176.32631 | 37.781541342893 | -122.493782888366 | (37.781541342893, -122.493782888366) | 11 | 6 | 2 | 55 | 26 | ||
| 37203 | 143861 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3201 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | Width 4ft | 5985565.10939 | 2113174.24077 | 37.7815385460111 | -122.493609507183 | (37.7815385460111, -122.493609507183) | 11 | 6 | 2 | 55 | 26 | ||
| 24194 | 32579 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1247 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/1996 12:00:00 AM | 5 | Permit Number 37053 | 5985814.1748 | 2106726.0184 | 37.7638481208517 | -122.492272911774 | (37.7638481208517, -122.492272911774) | 1 | 8 | 3 | 56 | 35 | |
| 159203 | 69446 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 443 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/16/1994 12:00:00 AM | 10 | Permit Number 33556 | 5985911.81468 | 2112907.20872 | 37.7808256288006 | -122.492390419974 | (37.7808256288006, -122.492390419974) | 11 | 6 | 2 | 55 | 26 | |
| 168068 | 181742 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1219 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986119.9697 | 2106920.2395 | 37.7643992701936 | -122.491229569586 | (37.7643992701936, -122.491229569586) | 1 | 8 | 3 | 56 | 35 | |||
| 91172 | 181743 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1219 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986121.7407 | 2106913.1555 | 37.7643799229814 | -122.491222922878 | (37.7643799229814, -122.491222922878) | 1 | 8 | 3 | 56 | 35 | |||
| 39542 | 254749 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 164 Escolta Way | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 4x6 | Permit Number 781597 | 5986451.85258 | 2097316.8045 | 37.7380502293434 | -122.489375519691 | (37.7380502293434, -122.489375519691) | 1 | 8 | 3 | 29491 | 35 | |
| 103004 | 44808 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1371 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 4 | Permit Number 43903 | 5986465.0991 | 2105937.0115 | 37.7617197583894 | -122.489963557407 | (37.7617197583894, -122.489963557407) | 1 | 8 | 3 | 56 | 35 | |
| 192423 | 44809 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1371 31st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | 3 | Permit Number 43903 | 5986466.0604 | 2105911.3769 | 37.7616494289947 | -122.489958347215 | (37.7616494289947, -122.489958347215) | 1 | 8 | 3 | 56 | 35 | |
| 19095 | 182316 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2700X Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/12/2001 12:00:00 AM | 3 | Width 0ft | Permit Number 43905 | 5986474 | 2105095 | 37.7594083467555 | -122.489870843925 | (37.7594083467555, -122.489870843925) | 1 | 8 | 3 | 56 | 35 | |
| 56360 | 181646 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1266 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986485.3888 | 2106651.0455 | 37.7636814828681 | -122.489945903056 | (37.7636814828681, -122.489945903056) | 1 | 8 | 3 | 56 | 35 | |||
| 17381 | 78348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 741 30th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5986606.5677 | 2110833.25993 | 37.7751717483754 | -122.489834389598 | (37.7751717483754, -122.489834389598) | 11 | 6 | 2 | 55 | 26 | |||
| 3893 | 78349 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 741 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986607.90066 | 2110854.65361 | 37.7752305672016 | -122.489831352395 | (37.7752305672016, -122.489831352395) | 11 | 6 | 2 | 55 | 26 | |||
| 13343 | 69152 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1245 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/18/1994 12:00:00 AM | 5 | Permit Number 33187 | 5986742.1857 | 2106776.7875 | 37.7640417272514 | -122.48906697906 | (37.7640417272514, -122.48906697906) | 1 | 8 | 3 | 56 | 35 | |
| 101504 | 119916 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3801 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5986867.20951 | 2111818.56024 | 37.7778923194923 | -122.489005232889 | (37.7778923194923, -122.489005232889) | 11 | 6 | 2 | 55 | 26 | |||
| 14860 | 144376 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 390 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5986872.03276 | 2113312.07102 | 37.7819933565565 | -122.489098375585 | (37.7819933565565, -122.489098375585) | 11 | 6 | 2 | 55 | 26 | |||
| 182683 | 90234 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2800 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 3x3 | 5986874.44833 | 2111194.202 | 37.7761784310196 | -122.488934282178 | (37.7761784310196, -122.488934282178) | 11 | 6 | 2 | 55 | 26 | ||
| 35714 | 147127 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 583 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x6 | 5986876.14797 | 2111982.26615 | 37.7783423311713 | -122.488986349742 | (37.7783423311713, -122.488986349742) | 11 | 6 | 2 | 55 | 26 | |||
| 89189 | 112176 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 607 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 5986882.73557 | 2111785.73395 | 37.7778030939685 | -122.488949109766 | (37.7778030939685, -122.488949109766) | 11 | 6 | 2 | 55 | 26 | |||
| 89809 | 112175 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 607 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 5986883.70014 | 2111802.41515 | 37.7778489521099 | -122.488946999613 | (37.7778489521099, -122.488946999613) | 11 | 6 | 2 | 55 | 26 | |||
| 117264 | 43591 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2278 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | 4 | Permit Number 43252 | 5987031.7486 | 2099759.5703 | 37.744791251078 | -122.487549954339 | (37.744791251078, -122.487549954339) | 1 | 8 | 3 | 29491 | 35 | |
| 145536 | 182416 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1555 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987127.1216 | 2104695.2134 | 37.7583487564392 | -122.487582689554 | (37.7583487564392, -122.487582689554) | 1 | 8 | 3 | 56 | 35 | |||
| 15869 | 261717 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1983 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/24/2020 12:00:00 AM | 3 | 4x4 | 5987209 | 2101791 | 37.7503793489945 | -122.487086227612 | (37.7503793489945, -122.487086227612) | 1 | 8 | 3 | 29491 | 35 | |
| 106097 | 181661 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2706 Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5987293.6389 | 2106455.5367 | 37.7631918321241 | -122.487136093376 | (37.7631918321241, -122.487136093376) | 1 | 8 | 3 | 56 | 35 | |||
| 33970 | 181677 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2704 Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5987307.2214 | 2106457.8989 | 37.7631991100618 | -122.487089290148 | (37.7631991100618, -122.487089290148) | 1 | 8 | 3 | 56 | 35 | |||
| 58799 | 181676 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2702 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5987326.1189 | 2106457.3084 | 37.7631985905811 | -122.487023887472 | (37.7631985905811, -122.487023887472) | 1 | 8 | 3 | 56 | 35 | |||
| 131093 | 181675 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2700 Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987341.4731 | 2106458.4895 | 37.7632027287981 | -122.486970869844 | (37.7632027287981, -122.486970869844) | 1 | 8 | 3 | 56 | 35 | |||
| 44456 | 37238 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 2 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 11 | Permit Number 770085 | 5987346.2909 | 2103736.5081 | 37.7557291928217 | -122.48675431687 | (37.7557291928217, -122.48675431687) | 1 | 8 | 3 | 56 | 35 | ||
| 75223 | 33248 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2591 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 3 | 3x3 | Permit Number 37429 | 5987367.1404 | 2097667.8262 | 37.7390674308693 | -122.486236717873 | (37.7390674308693, -122.486236717873) | 1 | 8 | 3 | 29491 | 35 |
| 88465 | 38107 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
| 103073 | 38105 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
| 156716 | 38104 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
| 192625 | 38106 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1295 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | Permit Number 40275 | 5987371.29466581 | 2106479.28053316 | 37.7632615539614 | -122.486869255203 | (37.7632615539614, -122.486869255203) | 1 | 8 | 3 | 56 | 35 | ||
| 148813 | 47793 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2578 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/2002 12:00:00 AM | 3 | Permit Number 45565 | 5987410.8144 | 2097738.044 | 37.7392627758453 | -122.486090868119 | (37.7392627758453, -122.486090868119) | 1 | 8 | 3 | 29491 | 35 | |
| 77330 | 37234 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
| 78077 | 37236 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 8 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | Permit Number 770085 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
| 143420 | 37239 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
| 188906 | 37235 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200X Moraga St | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | Permit Number 39797 | 5987459.55498562 | 2104367.82715752 | 37.7574692259463 | -122.486408967056 | (37.7574692259463, -122.486408967056) | 1 | 8 | 3 | 56 | 35 | |||
| 98407 | 56330 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2526 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1973 12:00:00 AM | 8 | Permit Number 12466 | 5987579.5629 | 2113304.96132 | 37.7820151066388 | -122.486650154768 | (37.7820151066388, -122.486650154768) | 11 | 6 | 2 | 55 | 26 | ||
| 128701 | 38103 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1339 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/1998 12:00:00 AM | 6 | Permit Number 40274 | 5987697.8486 | 2106168.016 | 37.7624259403231 | -122.485716981396 | (37.7624259403231, -122.485716981396) | 1 | 8 | 3 | 56 | 35 | |
| 16761 | 72980 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1730 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5987835.4413 | 2103488.2738 | 37.7550761133303 | -122.485044488235 | (37.7550761133303, -122.485044488235) | 1 | 8 | 3 | 56 | 35 | |||
| 1684 | 65960 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2514 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | 11 | Permit Number 28982 | 5988016.2527 | 2098169.589 | 37.7404829512667 | -122.484029196034 | (37.7404829512667, -122.484029196034) | 1 | 8 | 3 | 29491 | 35 | |
| 52469 | 183924 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2118 25th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 5988539.4126 | 2100905.5456 | 37.7480256114084 | -122.482420751779 | (37.7480256114084, -122.482420751779) | 1 | 8 | 3 | 29491 | 35 | |||
| 36075 | 175765 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 5988629.85447 | 2089774.30196 | 37.7174673468061 | -122.481292995899 | (37.7174673468061, -122.481292995899) | 1 | 8 | 4 | 64 | 14 | ||||
| 100041 | 19417 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 05/04/1999 12:00:00 AM | 3 | 20 | 5988998.1028282 | 2096024.0271709 | 37.7346489082814 | -122.480477366023 | (37.7346489082814, -122.480477366023) | 1 | 8 | 3 | 64 | 35 | ||
| 11282 | 258111 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1647 23rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5989010.97347 | 2104127.32105 | 37.756899168939 | -122.481025994257 | (37.756899168939, -122.481025994257) | 1 | 8 | 3 | 56 | 35 | ||||||
| 119024 | 175766 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135 | (37.7167583770722, -122.47966897135) | 1 | 8 | 4 | 64 | 14 | ||||
| 183539 | 185068 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1 Crestlake Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5989159.6219 | 2096046.6038 | 37.7347202832405 | -122.47992059791 | (37.7347202832405, -122.47992059791) | 1 | 8 | 3 | 64 | 35 | |||
| 69956 | 120687 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2040 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:45:00 PM | 3 | Width 3ft | 5989191.37637 | 2111280.32009 | 37.7765498370385 | -122.480925799615 | (37.7765498370385, -122.480925799615) | 11 | 6 | 2 | 55 | 26 | ||
| 148169 | 116626 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 5732X GEARY BLVD | 7 | Front Yard : Cutout | Tree | MTA 3 | DPW | 3x3 | 5989254 | 2112678 | 37.780391116482 | -122.480811519646 | (37.780391116482, -122.480811519646) | 11 | 6 | 2 | 55 | 26 | |||
| 4049 | 185126 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600 Sloat Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5989258.3218 | 2096043.9506 | 37.7347187320697 | -122.479579168443 | (37.7347187320697, -122.479579168443) | 1 | 8 | 3 | 64 | 35 | |||
| 36265 | 181761 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1246 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989269.0192 | 2106863.9805 | 37.7644282944678 | -122.480333887539 | (37.7644282944678, -122.480333887539) | 1 | 8 | 3 | 56 | 35 | |||
| 37366 | 181746 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1246 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5989272.8487 | 2106849.4285 | 37.7643885611619 | -122.480319577317 | (37.7643885611619, -122.480319577317) | 1 | 8 | 3 | 56 | 35 | |||
| 11406 | 72840 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2634 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5989285.167 | 2097358.0202 | 37.7383283873436 | -122.479582470664 | (37.7383283873436, -122.479582470664) | 1 | 8 | 3 | 29491 | 35 | |||
| 187673 | 65113 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 363 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 10 | Permit Number 27082 | 5989323.43538 | 2112903.08855 | 37.7810131823211 | -122.480587794991 | (37.7810131823211, -122.480587794991) | 11 | 6 | 2 | 55 | 26 | |
| 16342 | 71996 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 340 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5989363.9833 | 2113075.99146 | 37.7814902817874 | -122.48046018125 | (37.7814902817874, -122.48046018125) | 11 | 6 | 2 | 55 | 26 | |||
| 171568 | 61172 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 346 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | 11 | Permit Number 27084 | 5989366.0565 | 2113024.18126 | 37.7813481459653 | -122.480449215491 | (37.7813481459653, -122.480449215491) | 11 | 6 | 2 | 55 | 26 | |
| 8978 | 71997 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 362 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5989369.28583 | 2112922.15861 | 37.7810682079879 | -122.48043057365 | (37.7810682079879, -122.48043057365) | 11 | 6 | 2 | 55 | 26 | |||
| 24116 | 175767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989494.93952 | 2089175.43765 | 37.7158732715029 | -122.478259065526 | (37.7158732715029, -122.478259065526) | 1 | 8 | 4 | 64 | 14 | ||||
| 116061 | 19416 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 700X Sloat Blvd | 1 | Median : Cutout | Tree | DPW 1 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989518.2187007 | 2096039.5354251 | 37.7347217027544 | -122.4786803033 | (37.7347217027544, -122.4786803033) | 1 | 8 | 3 | 64 | 35 | ||
| 17491 | 256739 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1315 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x4 | 5989553.93379 | 2106395.50264 | 37.763158533492 | -122.479314183035 | (37.763158533492, -122.479314183035) | 1 | 8 | 3 | 56 | 35 | ||
| 184553 | 175768 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989578.68884 | 2089185.36564 | 37.7159053925979 | -122.477970317478 | (37.7159053925979, -122.477970317478) | 1 | 8 | 4 | 64 | 14 | ||||
| 89898 | 175769 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5989661.94364 | 2089233.64885 | 37.7160427982152 | -122.477686080452 | (37.7160427982152, -122.477686080452) | 1 | 8 | 4 | 64 | 14 | ||||
| 2627 | 44717 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1991 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/2001 12:00:00 AM | Permit Number 43839 | 5989704.86545465 | 2101822.42727681 | 37.7506108546658 | -122.478457743126 | (37.7506108546658, -122.478457743126) | 1 | 8 | 3 | 29491 | 35 | ||
| 108590 | 19415 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 600X Sloat Blvd | 6 | Median : Cutout | Tree | DPW 1 | 05/04/1999 12:00:00 AM | 3 | 20 | 5989744.8312093 | 2096044.8028161 | 37.7347493206824 | -122.477897219949 | (37.7347493206824, -122.477897219949) | 1 | 8 | 3 | 64 | 35 | ||
| 191530 | 175770 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | 5989758.80887 | 2089246.54995 | 37.7160838423675 | -122.477352214341 | (37.7160838423675, -122.477352214341) | 1 | 8 | 4 | 64 | 14 | ||||
| 101122 | 175771 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5989791.93538 | 2089208.15493 | 37.7159803412063 | -122.477234910356 | (37.7159803412063, -122.477234910356) | 1 | 8 | 4 | 64 | 14 | ||||
| 176963 | 175772 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5989911.02174 | 2089222.5365 | 37.716026738112 | -122.476824346492 | (37.716026738112, -122.476824346492) | 1 | 8 | 4 | 64 | 14 | ||||
| 51550 | 175773 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | 5990089.90179 | 2089410.48117 | 37.7165531625873 | -122.476219779021 | (37.7165531625873, -122.476219779021) | 1 | 8 | 4 | 64 | 14 | ||||
| 113811 | 175774 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5990113.97654 | 2089437.91841 | 37.7166298945381 | -122.47613856845 | (37.7166298945381, -122.47613856845) | 1 | 8 | 4 | 64 | 14 | ||||
| 25373 | 110420 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 419X 18TH AVE | 18 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | MTA | 3x3 | 5990240 | 2112557 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | 11 | 6 | 2 | 55 | 26 | |||
| 146367 | 204608 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1563 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990535.7174 | 2104763.29262 | 37.7587338945762 | -122.475799356764 | (37.7587338945762, -122.475799356764) | 1 | 8 | 4 | 56 | 12 | |||
| 117095 | 204609 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1382 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5990541.24492 | 2105988.9613 | 37.7620995740555 | -122.475869749413 | (37.7620995740555, -122.475869749413) | 1 | 8 | 3 | 56 | 12 | |||
| 18261 | 204610 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1410 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5990554.31015 | 2105766.55939 | 37.7614896754309 | -122.475808320295 | (37.7614896754309, -122.475808320295) | 1 | 8 | 4 | 56 | 12 | |||
| 29876 | 204614 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1255 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5990910.22691 | 2105165.14407 | 37.7598589779192 | -122.474533471065 | (37.7598589779192, -122.474533471065) | 1 | 8 | 4 | 56 | 12 | |||
| 66322 | 204615 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1255 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5990928.50457 | 2105165.03843 | 37.7598597468563 | -122.474470250504 | (37.7598597468563, -122.474470250504) | 1 | 8 | 4 | 56 | 12 |
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) );