trees
40 rows where Supervisor Districts = 1 and qSpecies_id = 65 sorted by qSpecies_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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16670 | 57208 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2238 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2015 12:00:00 AM | 3 | Permit Number 775007 | 6000879.71894 | 2116143.1485 | 37.7905743988346 | -122.440841472269 | (37.7905743988346, -122.440841472269) | 13 | 6 | 1 | 29490 | 27 | ||
| 33356 | 138630 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1702 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6000078.3648 | 2114795.7207 | 37.7868290426993 | -122.443517270296 | (37.7868290426993, -122.443517270296) | 13 | 6 | 1 | 29490 | 27 | |||
| 39918 | 41209 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3241 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1999 12:00:00 AM | 48 | Permit Number 41916 | 6000362.60573 | 2119451.91027 | 37.7996299225355 | -122.442868349911 | (37.7996299225355, -122.442868349911) | 13 | 9 | 1 | 57 | 17 | |
| 46734 | 125549 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006015.52243 | 2119649.2025 | 37.8004922923456 | -122.423321211112 | (37.8004922923456, -122.423321211112) | 13 | 9 | 1 | 28858 | 32 | |||
| 60571 | 250774 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 261 32nd Ave | 1 | : | Tree | Private 2 | 30 | Width 3ft | 5985867.52173 | 2114167.09587 | 37.7842823263074 | -122.49263646502 | (37.7842823263074, -122.49263646502) | 11 | 6 | 1 | 55 | 33 | |||
| 64228 | 114566 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 633 Spruce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | Permit Number 774120 | 5997130.5 | 2113555.2 | 37.7832543439484 | -122.45362653243 | (37.7832543439484, -122.45362653243) | 11 | 6 | 1 | 54 | 31 | |||
| 79432 | 41233 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3725 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/10/2014 12:00:00 AM | 3 | Permit Number 773159 | 6002526.96331 | 2121423.4126 | 37.8051663037497 | -122.435520011048 | (37.8051663037497, -122.435520011048) | 13 | 9 | 1 | 57 | 17 | |
| 81710 | 125550 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006031.52695 | 2119650.26621 | 37.8004961162623 | -122.423265904597 | (37.8004961162623, -122.423265904597) | 13 | 9 | 1 | 28858 | 32 | |||
| 83313 | 68880 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3633 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2018 12:00:00 AM | 3 | Permit Number 32851 | 6000180.50707 | 2120770.20455 | 37.8032392229736 | -122.443593228653 | (37.8032392229736, -122.443593228653) | 13 | 9 | 1 | 57 | 17 | |
| 88133 | 94732 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3965 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995732.51221 | 2115478.09158 | 37.7884538465346 | -122.458602225523 | (37.7884538465346, -122.458602225523) | 11 | 6 | 1 | 54 | 31 |
| 91062 | 84740 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 143 Alhambra St | 1 | Front Yard : Cutout | Tree | Private 2 | 03/27/2007 12:00:00 AM | 13 | 4x6 | Permit Number 49254 | 6001588.49283 | 2120281.76365 | 37.8019782934262 | -122.438685839601 | (37.8019782934262, -122.438685839601) | 13 | 9 | 1 | 57 | 17 | |
| 92331 | 125545 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3211 Sacramento St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 5999423.84524 | 2115333.31799 | 37.7882677951647 | -122.445820424872 | (37.7882677951647, -122.445820424872) | 13 | 6 | 1 | 29490 | 31 | |||
| 92398 | 91464 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52106 | 6008023.92041 | 2119932.41057 | 37.8013830546338 | -122.416391395149 | (37.8013830546338, -122.416391395149) | 5 | 1 | 1 | 308 | 32 | |
| 96623 | 91462 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52106 | 6007994.73789 | 2119928.92262 | 37.8013718365043 | -122.416492132729 | (37.8013718365043, -122.416492132729) | 5 | 1 | 1 | 308 | 32 | |
| 99540 | 124272 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2 03rd Ave | 1 | Front Yard : Yard | Tree | Private 2 | 14 | 5994894.05661 | 2114999.9706 | 37.787092832167 | -122.46146845316 | (37.787092832167, -122.46146845316) | 11 | 6 | 1 | 54 | 11 | ||||
| 100013 | 112856 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 1700x BAKER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6000040 | 2114920 | 37.7871680933118 | -122.443658934554 | (37.7871680933118, -122.443658934554) | 15 | 6 | 1 | 29490 | 31 | |||
| 101270 | 125542 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 65 Heather Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5997338.84626 | 2114106.78779 | 37.78478079984 | -122.452945569076 | (37.78478079984, -122.452945569076) | 15 | 6 | 1 | 54 | 31 | |||
| 106863 | 91463 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52106 | 6008009.62404 | 2119930.75783 | 37.8013777126716 | -122.416440749956 | (37.8013777126716, -122.416440749956) | 5 | 1 | 1 | 308 | 32 | |
| 110025 | 255477 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 2669 Greenwich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780207 | 6000139.26098 | 2118831.12681 | 37.7979126806609 | -122.443596582177 | (37.7979126806609, -122.443596582177) | 13 | 9 | 1 | 57 | 17 | |
| 124027 | 124414 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 111 Cherry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 2ft | 5996072.31903 | 2115814.16927 | 37.7893961490256 | -122.457450879091 | (37.7893961490256, -122.457450879091) | 11 | 6 | 1 | 54 | 31 | |||
| 124927 | 114086 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Cook St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5997489.0948 | 2113600.1035 | 37.783398187645 | -122.452389185424 | (37.783398187645, -122.452389185424) | 15 | 6 | 1 | 54 | 31 | |||
| 125241 | 138631 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1704 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6000076.1375 | 2114809.8269 | 37.7868676476344 | -122.443525989893 | (37.7868676476344, -122.443525989893) | 13 | 6 | 1 | 29490 | 27 | |||
| 137740 | 124329 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 122 Palm Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5995931.07902 | 2113567.14983 | 37.7832183231598 | -122.457776888478 | (37.7832183231598, -122.457776888478) | 11 | 6 | 1 | 54 | 31 | |||
| 141712 | 125540 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 47 Casa Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6001554.26648 | 2121557.3314 | 37.8054787165372 | -122.438895742254 | (37.8054787165372, -122.438895742254) | 13 | 9 | 1 | 57 | 17 | |||
| 147662 | 36190 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 8 | Permit Number 39257 | 5996902.2714 | 2113184.5215 | 37.7822234726194 | -122.454389322982 | (37.7822234726194, -122.454389322982) | 11 | 6 | 1 | 54 | 31 | |
| 150779 | 125547 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005968.56582 | 2119641.09275 | 37.8004673748183 | -122.423483123267 | (37.8004673748183, -122.423483123267) | 13 | 9 | 1 | 28858 | 32 | |||
| 152974 | 94731 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3965 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53863 | 5995713.23783 | 2115474.26613 | 37.788442235114 | -122.458668634362 | (37.788442235114, -122.458668634362) | 11 | 6 | 1 | 54 | 31 |
| 160053 | 107230 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005960.15833 | 2119639.59713 | 37.8004627936866 | -122.423512110213 | (37.8004627936866, -122.423512110213) | 13 | 9 | 1 | 28858 | 32 | |||
| 160833 | 125544 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1410 Jefferson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002431.61204 | 2121624.28708 | 37.8057124359506 | -122.435864366851 | (37.8057124359506, -122.435864366851) | 13 | 9 | 1 | 57 | 17 | |||
| 164826 | 66782 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/20/1991 12:00:00 AM | 14 | Permit Number 30052 | 6006921.4512 | 2120474.40868 | 37.8028091860666 | -122.420244926256 | (37.8028091860666, -122.420244926256) | 5 | 1 | 1 | 28858 | 32 | |
| 165916 | 125541 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 65 Heather Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | 5997339.5515 | 2114115.46943 | 37.7848046777406 | -122.452943756065 | (37.7848046777406, -122.452943756065) | 15 | 6 | 1 | 54 | 31 | ||||
| 167316 | 91465 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1001 Greenwich St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52106 | 6008039.0019 | 2119934.2418 | 37.8013889308135 | -122.416339336112 | (37.8013889308135, -122.416339336112) | 5 | 1 | 1 | 308 | 32 | |
| 169489 | 63578 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1359 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/30/1987 12:00:00 AM | 17 | Permit Number 24201 | 6006442.54317 | 2119356.06995 | 37.799711515327 | -122.421822711261 | (37.799711515327, -122.421822711261) | 13 | 9 | 1 | 28858 | 32 | |
| 172187 | 114784 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2015 12:00:00 AM | Permit Number 773262 | 6000262.8 | 2113654.9 | 37.7837071608561 | -122.442797219915 | (37.7837071608561, -122.442797219915) | 15 | 6 | 1 | 29490 | 13 | |||
| 175001 | 124270 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2 03rd Ave | 3 | Front Yard : Yard | Tree | Private 2 | 14 | 5994893.51688 | 2115041.88961 | 37.78720789934 | -122.461473360648 | (37.78720789934, -122.461473360648) | 11 | 6 | 1 | 54 | 11 | ||||
| 178287 | 125551 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006045.33094 | 2119651.17602 | 37.8004993933977 | -122.423218201864 | (37.8004993933977, -122.423218201864) | 13 | 9 | 1 | 28858 | 32 | |||
| 180027 | 114084 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Cook St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 17 | 5997493.8327 | 2113562.2002 | 37.7832943866098 | -122.452370058209 | (37.7832943866098, -122.452370058209) | 15 | 6 | 1 | 54 | 31 | |||
| 183389 | 36189 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 181 Parker Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/04/1998 12:00:00 AM | 11 | Permit Number 39257 | 5996904.302 | 2113169.9694 | 37.7821836328514 | -122.454381246555 | (37.7821836328514, -122.454381246555) | 11 | 6 | 1 | 54 | 31 | |
| 193468 | 114082 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 20 Cook St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 16 | 5997500.7704 | 2113521.7588 | 37.7831837426404 | -122.452343137457 | (37.7831837426404, -122.452343137457) | 15 | 6 | 1 | 54 | 31 | |||
| 193967 | 125548 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1445 Greenwich St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006007.30583 | 2119647.97872 | 37.8004884684307 | -122.423349556855 | (37.8004884684307, -122.423349556855) | 13 | 9 | 1 | 28858 | 32 |
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) );