trees
42 rows where Police Districts = 9 and qSpecies_id = 65 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3705 | 244981 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/31/2019 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005180.5539 | 2109687.8318 | 37.7730936920725 | -122.425501217452 | (37.7730936920725, -122.425501217452) | 7 | 9 | 11 | 28852 | 10 |
8756 | 221784 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 201 Buchanan St | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6004701.97389 | 2109293.67351 | 37.7719843770185 | -122.427128606994 | (37.7719843770185, -122.427128606994) | 7 | 9 | 11 | 28852 | 10 | |||
21320 | 221799 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 430 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6004120.07608 | 2110306.19132 | 37.7747315801401 | -122.42921364562 | (37.7747315801401, -122.42921364562) | 7 | 9 | 11 | 28852 | 10 | |||
24285 | 115206 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 390 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 775334 | 6003427 | 2108679.3 | 37.7702252763858 | -122.431494968546 | (37.7702252763858, -122.431494968546) | 15 | 9 | 11 | 29492 | 10 | |||
26083 | 65485 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | Permit Number 30733 | 6004123.88206182 | 2110310.82859854 | 37.7747445284274 | -122.429200810683 | (37.7747445284274, -122.429200810683) | 7 | 9 | 11 | 28852 | 10 | ||
29277 | 256167 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
36626 | 245863 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 138 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781995 | 6005228.3599 | 2109588.7098 | 37.7728242280559 | -122.42532879528 | (37.7728242280559, -122.42532879528) | 7 | 9 | 11 | 28852 | 10 | |
55347 | 63855 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 728 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24554 | 6003932.92812606 | 2110451.32130531 | 37.7751194750929 | -122.429871382589 | (37.7751194750929, -122.429871382589) | 7 | 9 | 11 | 29492 | 10 | ||
64215 | 221934 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 210 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003798.91454 | 2109132.99672 | 37.7714920890238 | -122.430240891706 | (37.7714920890238, -122.430240891706) | 7 | 9 | 11 | 29492 | 10 | |||
72775 | 125543 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 511 Webster St | 1 | : | Tree | Private 2 | 1 | Width 4ft | 6004027.82216 | 2110630.44547 | 37.7756166793921 | -122.429555900592 | (37.7756166793921, -122.429555900592) | 7 | 9 | 11 | 29492 | 10 | |||
77926 | 63770 | Permitted Site 7 | Agonis flexuosa :: Peppermint Willow 65 | 533 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/1999 12:00:00 AM | Permit Number 24449 | 6003130.90758036 | 2110082.2752919 | 37.7740607150966 | -122.432619380335 | (37.7740607150966, -122.432619380335) | 15 | 9 | 11 | 29492 | 10 | ||
85775 | 30579 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 396 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/1995 12:00:00 AM | 2 | Permit Number 34554 | 6003425.76209 | 2108645.89167 | 37.7701334751172 | -122.43149686511 | (37.7701334751172, -122.43149686511) | 15 | 9 | 11 | 29492 | 10 | ||
92411 | 244965 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 250 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6005276.5809 | 2110102.9361 | 37.7742388930949 | -122.42519859053 | (37.7742388930949, -122.42519859053) | 7 | 9 | 11 | 28852 | 10 | |||
121537 | 256166 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
155522 | 247495 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 537 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003124.7415 | 2110167.9221 | 37.7742955303854 | -122.432646828997 | (37.7742955303854, -122.432646828997) | 15 | 9 | 11 | 29492 | 10 | |||
157942 | 221798 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 430 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004116.67022 | 2110321.94704 | 37.7747746486742 | -122.429226550889 | (37.7747746486742, -122.429226550889) | 7 | 9 | 11 | 28852 | 10 | |||
164117 | 109153 | Undocumented 4 | Agonis flexuosa :: Peppermint Willow 65 | 124 LILY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x2 | 6005951.6 | 2110200.9 | 37.7745459888588 | -122.422870538078 | (37.7745459888588, -122.422870538078) | 7 | 9 | 11 | 28852 | 10 | |||
172746 | 256165 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 200 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6005182.68808 | 2109644.93499 | 37.772976028407 | -122.425490781615 | (37.772976028407, -122.425490781615) | 7 | 9 | 11 | 28852 | 10 | ||||
183625 | 244227 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 332 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003264.0141 | 2109482.4208 | 37.7724212100587 | -122.43211609665 | (37.7724212100587, -122.43211609665) | 15 | 9 | 11 | 29492 | 10 | |||
194425 | 221795 | Prune Opt Out 3 | Agonis flexuosa :: Peppermint Willow 65 | 438 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | Permit Number 787981 | 6004107.34969 | 2110372.49722 | 37.7749129194169 | -122.42926239785 | (37.7749129194169, -122.42926239785) | 7 | 9 | 11 | 28852 | 10 | ||
194440 | 221797 | Prune Opt Out 3 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | Permit Number 787981 | 6004113.21358 | 2110335.22701 | 37.7748109165297 | -122.429239455258 | (37.7748109165297, -122.429239455258) | 7 | 9 | 11 | 28852 | 10 | ||
194442 | 221796 | Prune Opt Out 3 | Agonis flexuosa :: Peppermint Willow 65 | 436 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | Permit Number 787981 | 6004110.94859 | 2110346.00561 | 37.7748403836965 | -122.429248059072 | (37.7748403836965, -122.429248059072) | 7 | 9 | 11 | 28852 | 10 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |||
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 | |||
64277 | 37529 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007263.39142 | 2115650.05703 | 37.7895819825607 | -122.418719304647 | (37.7895819825607, -122.418719304647) | 13 | 9 | 10 | 28858 | 21 | |
71978 | 37528 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 21 | Permit Number 39976 | 6007265.87204 | 2115633.53426 | 37.789536754768 | -122.418709549719 | (37.789536754768, -122.418709549719) | 13 | 9 | 10 | 28858 | 21 | |
107607 | 37527 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1244 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 19 | Permit Number 39976 | 6007268.1881 | 2115618.13797 | 37.7894946107457 | -122.418700444082 | (37.7894946107457, -122.418700444082) | 13 | 9 | 10 | 28858 | 21 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
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 | |||
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 | |||
33220 | 139917 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004809.1682 | 2112368.8803 | 37.7804342038606 | -122.426976875009 | (37.7804342038606, -122.426976875009) | 7 | 9 | 11 | 28852 | 41 | |||
146765 | 139915 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004816.1035 | 2112332.8828 | 37.7803357557587 | -122.426950318013 | (37.7803357557587, -122.426950318013) | 7 | 9 | 11 | 28852 | 41 | |||
185738 | 139916 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1000 LAGUNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004814.4523 | 2112350.3862 | 37.7803837224117 | -122.426957277261 | (37.7803837224117, -122.426957277261) | 7 | 9 | 11 | 28852 | 41 |
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) );