trees
861 rows where qSpecies_id = 18 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1422 | 259801 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 3379 | 258367 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 901 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | ||||||||||||||
| 7878 | 259091 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 11502 | 259802 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 13366 | 259090 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 14717 | 259092 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1298 Visitacion Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 18615 | 259800 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1180x Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
| 4681 | 6924 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 446 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X4 | 6005254.8423 | 2110638.1989 | 37.775707366557 | -122.425311885836 | (37.775707366557, -122.425311885836) | 7 | 9 | 11 | 28852 | 10 | |||
| 4785 | 16923 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 503 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6004556.4237 | 2110140.1804 | 37.7743004469023 | -122.427692399322 | (37.7743004469023, -122.427692399322) | 7 | 9 | 11 | 28852 | 10 | ||||
| 8222 | 240694 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 316 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6004685.09774 | 2109764.27844 | 37.7732755894234 | -122.427220510535 | (37.7732755894234, -122.427220510535) | 7 | 9 | 11 | 28852 | 10 | |||
| 16467 | 16902 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 427 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004930.51635 | 2110189.46412 | 37.7744569217764 | -122.426401853189 | (37.7744569217764, -122.426401853189) | 7 | 9 | 11 | 28852 | 10 | |||
| 27439 | 227588 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 435 Oak St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6004887.16184 | 2110182.76224 | 37.7744360692067 | -122.42655134748 | (37.7744360692067, -122.42655134748) | 7 | 9 | 11 | 28852 | 10 | |||
| 31088 | 142250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 623 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6004849.3706 | 2110876.8893 | 37.7763398361781 | -122.426731515889 | (37.7763398361781, -122.426731515889) | 7 | 9 | 11 | 28852 | 10 | |||
| 50640 | 129442 | Undocumented 4 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010104.97756 | 2114284.67603 | 37.7859925517698 | -122.408791302782 | (37.7859925517698, -122.408791302782) | 14 | 10 | 10 | 28852 | 36 | |||
| 52831 | 30703 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 2 | Permit Number 34614 | 6005258.9715 | 2110239.8029 | 37.7746137012839 | -122.425269246 | (37.7746137012839, -122.425269246) | 7 | 9 | 11 | 28852 | 10 | |
| 57443 | 129441 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010109.81427 | 2114257.21673 | 37.7859174259901 | -122.408772631062 | (37.7859174259901, -122.408772631062) | 14 | 10 | 10 | 28852 | 36 | |||
| 73444 | 16909 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 457 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2009 12:00:00 AM | 18 | 3X3 | 6004854.34153 | 2110178.37501 | 37.7744221674765 | -122.426664566741 | (37.7744221674765, -122.426664566741) | 7 | 9 | 11 | 28852 | 10 | ||
| 77639 | 16894 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 361 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2008 12:00:00 AM | 3 | 3X3 | 6005282.37962 | 2110221.51905 | 37.7745648206797 | -122.425186971324 | (37.7745648206797, -122.425186971324) | 7 | 9 | 11 | 28852 | 10 | ||
| 140138 | 6925 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 460 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005200.4571 | 2110629.3361 | 37.7756799587692 | -122.425499387051 | (37.7756799587692, -122.425499387051) | 7 | 9 | 11 | 28852 | 10 | |||
| 147379 | 16905 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 441 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 6004878.06154 | 2110135.30859 | 37.774305258574 | -122.426579447402 | (37.774305258574, -122.426579447402) | 7 | 9 | 11 | 28852 | 10 | ||
| 159582 | 129443 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 144 Cyril Magnin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6010100.50138 | 2114305.77616 | 37.7860502369758 | -122.408808278389 | (37.7860502369758, -122.408808278389) | 14 | 10 | 10 | 28852 | 36 | |||
| 164304 | 142249 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 619 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004863.0676 | 2110879.3064 | 37.7763472473304 | -122.426684306291 | (37.7763472473304, -122.426684306291) | 7 | 9 | 11 | 28852 | 10 | |||
| 11467 | 82943 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52427 | 6009392.50715 | 2110510.58601 | 37.7755898643032 | -122.410989600209 | (37.7755898643032, -122.410989600209) | 8 | 2 | 9 | 28853 | 34 | |
| 14062 | 227597 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005381.2036 | 2107800.12984 | 37.7679218515506 | -122.424672832791 | (37.7679218515506, -122.424672832791) | 8 | 4 | 5 | 28853 | 19 | |||
| 20284 | 227665 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006330.78292 | 2109566.87483 | 37.7728264958779 | -122.421513830121 | (37.7728264958779, -122.421513830121) | 8 | 2 | 9 | 28853 | 19 | |||
| 32476 | 227594 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005345.94103 | 2107798.56704 | 37.7679155688764 | -122.424794690941 | (37.7679155688764, -122.424794690941) | 8 | 4 | 5 | 28853 | 19 | |||
| 33337 | 108294 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | |||
| 36272 | 108295 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
| 36949 | 227666 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6006306.62249 | 2109592.20963 | 37.7728946968577 | -122.421599203664 | (37.7728946968577, -122.421599203664) | 8 | 2 | 9 | 28853 | 19 | |||
| 45106 | 246316 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | 8 | 2 | 9 | 28853 | 19 | |||
| 59466 | 32295 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1616 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/1996 12:00:00 AM | 5 | Permit Number 36875 | 6011596.3586 | 2107020.1725 | 37.7661293203346 | -122.403120325202 | (37.7661293203346, -122.403120325202) | 8 | 3 | 8 | 28853 | 20 | ||
| 72292 | 227593 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005330.86399 | 2107797.8602 | 37.7679127764864 | -122.424846790463 | (37.7679127764864, -122.424846790463) | 8 | 4 | 5 | 28853 | 19 | |||
| 81001 | 246317 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006842.0158 | 2108939.8347 | 37.7711336054687 | -122.419700914309 | (37.7711336054687, -122.419700914309) | 8 | 2 | 9 | 28853 | 19 | |||
| 81548 | 227664 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 46 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006352.61358 | 2109543.15644 | 37.7727626017523 | -122.421436630498 | (37.7727626017523, -122.421436630498) | 8 | 2 | 9 | 28853 | 19 | |||
| 93076 | 227595 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6005359.22331 | 2107799.65504 | 37.7679193064505 | -122.424748826411 | (37.7679193064505, -122.424748826411) | 8 | 4 | 5 | 28853 | 19 | |||
| 106988 | 227598 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005393.4683 | 2107800.64006 | 37.7679239451627 | -122.424630446843 | (37.7679239451627, -122.424630446843) | 8 | 4 | 5 | 28853 | 19 | |||
| 110399 | 227596 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005369.47041 | 2107799.69843 | 37.7679200043356 | -122.424713385909 | (37.7679200043356, -122.424713385909) | 8 | 4 | 5 | 28853 | 19 | |||
| 116395 | 82944 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 230 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52427 | 6009357.52887 | 2110544.08161 | 37.7756798738576 | -122.4111129656 | (37.7756798738576, -122.4111129656) | 8 | 2 | 9 | 28853 | 34 | |
| 144752 | 246315 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 6006857.4528 | 2108984.4305 | 37.7712569245067 | -122.419650681714 | (37.7712569245067, -122.419650681714) | 8 | 2 | 9 | 28853 | 19 | |||
| 153462 | 108297 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
| 154792 | 108296 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 55x DIVISION ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011511.3 | 2108309.6 | 37.7696650457173 | -122.40350525397 | (37.7696650457173, -122.40350525397) | 8 | 2 | 8 | 28853 | 20 | ||||
| 155967 | 246318 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 5 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6006836.8702 | 2108926.9706 | 37.7710979938489 | -122.419717800254 | (37.7710979938489, -122.419717800254) | 8 | 2 | 9 | 28853 | 19 | |||
| 157815 | 7404 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1060 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/1992 12:00:00 AM | 24 | 3X3 | 6010543.2443 | 2111181.3457 | 37.777496075538 | -122.407056190657 | (37.777496075538, -122.407056190657) | 14 | 2 | 9 | 28853 | 34 | ||
| 160727 | 28934 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 260 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6009412.25627 | 2110486.96274 | 37.7755261077757 | -122.410919614063 | (37.7755261077757, -122.410919614063) | 8 | 2 | 9 | 28853 | 34 | ||
| 170850 | 227592 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 501 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6005300.21046 | 2107796.96547 | 37.7679085883379 | -122.424952753964 | (37.7679085883379, -122.424952753964) | 8 | 4 | 5 | 28853 | 19 | |||
| 188316 | 246314 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1660 Mission St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 6006868.6018 | 2109014.4469 | 37.7713399704187 | -122.419614246796 | (37.7713399704187, -122.419614246796) | 8 | 2 | 9 | 28853 | 19 | |||
| 9474 | 35363 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 5 | Permit Number 38825 | 6011873.19867 | 2103659.86628 | 37.7569181237816 | -122.401926543791 | (37.7569181237816, -122.401926543791) | 10 | 3 | 8 | 28856 | 29 | |
| 16048 | 191248 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 611 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010994.55519 | 2105384.5641 | 37.7616046825239 | -122.405086676019 | (37.7616046825239, -122.405086676019) | 10 | 3 | 8 | 28856 | 29 | |||
| 39091 | 191280 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014475.48285 | 2110565.83203 | 37.7760252782883 | -122.393410079138 | (37.7760252782883, -122.393410079138) | 6 | 2 | 9 | 28856 | 20 | |||
| 41810 | 191276 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014137.59227 | 2110902.38763 | 37.7769306051104 | -122.394602513603 | (37.7769306051104, -122.394602513603) | 6 | 2 | 9 | 28856 | 20 | |||
| 50235 | 191277 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6014120.49796 | 2110919.75939 | 37.7769773536703 | -122.394662865301 | (37.7769773536703, -122.394662865301) | 6 | 2 | 9 | 28856 | 20 | |||
| 51728 | 191273 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014193.41583 | 2110841.84159 | 37.7767674626879 | -122.394405160994 | (37.7767674626879, -122.394405160994) | 6 | 2 | 9 | 28856 | 20 | |||
| 59713 | 35365 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011873.18705 | 2103679.58539 | 37.7569722674636 | -122.401927970125 | (37.7569722674636, -122.401927970125) | 10 | 3 | 8 | 28856 | 29 | |
| 62494 | 191261 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 690 Wisconsin St | 3 | : | Tree | Private 2 | 18 | Width 3ft | 6012675.54577 | 2104288.99957 | 37.7586903323146 | -122.399195870217 | (37.7586903323146, -122.399195870217) | 10 | 3 | 8 | 28856 | 29 | |||
| 63082 | 191270 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014244.47605 | 2110787.29844 | 37.7766205377503 | -122.394224707529 | (37.7766205377503, -122.394224707529) | 6 | 2 | 9 | 28856 | 20 | |||
| 64266 | 57069 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 920 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 27 | 7x13 | Permit Number 14335 | 6015211.40645 | 2104319.9485 | 37.7589163085501 | -122.390427794128 | (37.7589163085501, -122.390427794128) | 10 | 3 | 8 | 28856 | 29 | |
| 64446 | 35364 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1000 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/23/1998 12:00:00 AM | 7 | Permit Number 38825 | 6011875.91601 | 2103641.32434 | 37.7568673633546 | -122.401915842767 | (37.7568673633546, -122.401915842767) | 10 | 3 | 8 | 28856 | 29 | |
| 71662 | 191263 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 728 Wisconsin St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 6012693.03822 | 2104091.70249 | 37.7581495726586 | -122.399121524154 | (37.7581495726586, -122.399121524154) | 10 | 3 | 8 | 28856 | 29 | |||
| 72423 | 191283 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6014423.24539 | 2110620.23478 | 37.7761717535676 | -122.39359459214 | (37.7761717535676, -122.39359459214) | 6 | 2 | 9 | 28856 | 20 | |||
| 73078 | 191259 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 900x Carolina St | 27 | Median : Yard | Tree | DPW 1 | 17 | 6012470.08805 | 2103421.28043 | 37.7562963136528 | -122.399845510773 | (37.7562963136528, -122.399845510773) | 10 | 3 | 8 | 28856 | 29 | ||||
| 73992 | 191281 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014459.12873 | 2110582.79031 | 37.776070933269 | -122.393467839873 | (37.776070933269, -122.393467839873) | 6 | 2 | 9 | 28856 | 20 | |||
| 77042 | 191255 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1901 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011611.18002 | 2106494.85248 | 37.764687737485 | -122.403032107369 | (37.764687737485, -122.403032107369) | 8 | 3 | 8 | 28856 | 29 | |||
| 81296 | 191274 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014170.53603 | 2110866.45323 | 37.7768337688053 | -122.394486033405 | (37.7768337688053, -122.394486033405) | 6 | 2 | 9 | 28856 | 20 | |||
| 87345 | 191264 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 801 Arkansas St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 6013055.03201 | 2103799.19748 | 37.7573665842245 | -122.397849067074 | (37.7573665842245, -122.397849067074) | 10 | 3 | 8 | 28856 | 29 | ||||
| 88043 | 191269 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | 6 | 2 | 9 | 28856 | 6 | ||||
| 88948 | 191275 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6014152.76855 | 2110885.05471 | 37.7768838565355 | -122.394548799799 | (37.7768838565355, -122.394548799799) | 6 | 2 | 9 | 28856 | 20 | |||
| 98347 | 191256 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1901 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011633.04872 | 2106495.65954 | 37.7646911746678 | -122.402956525646 | (37.7646911746678, -122.402956525646) | 8 | 3 | 8 | 28856 | 29 | |||
| 101952 | 191250 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015147.38841 | 2105382.23529 | 37.7618295678896 | -122.390723435432 | (37.7618295678896, -122.390723435432) | 10 | 3 | 8 | 28856 | 29 | |||
| 112779 | 191282 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6014441.41184 | 2110601.16162 | 37.7761203923639 | -122.393530413818 | (37.7761203923639, -122.393530413818) | 6 | 2 | 9 | 28856 | 20 | |||
| 115877 | 191267 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6015157.46118 | 2113744.49366 | 37.7847910341296 | -122.391273164948 | (37.7847910341296, -122.391273164948) | 6 | 2 | 9 | 28856 | 6 | ||||
| 116184 | 191257 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1901 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011651.29828 | 2106497.39901 | 37.7646969699043 | -122.402893527222 | (37.7646969699043, -122.402893527222) | 8 | 3 | 8 | 28856 | 29 | |||
| 116888 | 191254 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1901 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011532.07084 | 2106491.2007 | 37.7646732925511 | -122.403305469766 | (37.7646732925511, -122.403305469766) | 8 | 3 | 8 | 28856 | 29 | |||
| 119112 | 191262 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 690 Wisconsin St | 5 | : | Tree | Private 2 | 15 | Width 3ft | 6012676.19431 | 2104276.36771 | 37.7586556841436 | -122.399192740559 | (37.7586556841436, -122.399192740559) | 10 | 3 | 8 | 28856 | 29 | |||
| 119184 | 191279 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6014488.65143 | 2110553.2747 | 37.7759915303161 | -122.393363646226 | (37.7759915303161, -122.393363646226) | 6 | 2 | 9 | 28856 | 20 | |||
| 122965 | 191252 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6015147.22099 | 2105373.94992 | 37.7618068087648 | -122.390723435452 | (37.7618068087648, -122.390723435452) | 10 | 3 | 8 | 28856 | 29 | |||
| 144967 | 191271 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014227.23158 | 2110805.88928 | 37.7766706254784 | -122.394285663563 | (37.7766706254784, -122.394285663563) | 6 | 2 | 9 | 28856 | 20 | |||
| 146947 | 104025 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 716 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6012687.87968 | 2104149.7182 | 37.7583085835989 | -122.399143437016 | (37.7583085835989, -122.399143437016) | 10 | 3 | 8 | 28856 | 29 | |||
| 152679 | 191278 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014098.28059 | 2110942.62046 | 37.7770388897689 | -122.394741323978 | (37.7770388897689, -122.394741323978) | 6 | 2 | 9 | 28856 | 20 | |||
| 161594 | 191268 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 538 Delancey St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6015150.51675 | 2113731.33336 | 37.7847545135408 | -122.391296270324 | (37.7847545135408, -122.391296270324) | 6 | 2 | 9 | 28856 | 6 | ||||
| 162746 | 94211 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 465 Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013546.79092 | 2104912.40006 | 37.7604505699522 | -122.396226376258 | (37.7604505699522, -122.396226376258) | 10 | 3 | 8 | 28856 | 29 | |
| 166507 | 191258 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1901 17th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011671.67609 | 2106498.8214 | 37.7647020133105 | -122.402823145387 | (37.7647020133105, -122.402823145387) | 8 | 3 | 8 | 28856 | 29 | |||
| 172712 | 191251 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6015148.84129 | 2105378.48456 | 37.7618193498029 | -122.390718148336 | (37.7618193498029, -122.390718148336) | 10 | 3 | 8 | 28856 | 29 | |||
| 176725 | 191284 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 751 04th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6014408.26812 | 2110636.4725 | 37.7762155064684 | -122.393647539722 | (37.7762155064684, -122.393647539722) | 6 | 2 | 9 | 28856 | 20 | |||
| 178232 | 191253 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 654 Minnesota St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6015148.44265 | 2105367.15882 | 37.7617882296504 | -122.390718735586 | (37.7617882296504, -122.390718735586) | 10 | 3 | 8 | 28856 | 29 | |||
| 179884 | 94214 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 465 Missouri St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53589 | 6013545.01697 | 2104957.62874 | 37.7605746593094 | -122.396235681545 | (37.7605746593094, -122.396235681545) | 10 | 3 | 8 | 28856 | 29 | |
| 185996 | 50456 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 993 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/21/2003 12:00:00 AM | 6 | Permit Number 47101 | 6015538.43851 | 2104592.1377 | 37.7596818177679 | -122.38931576171 | (37.7596818177679, -122.38931576171) | 10 | 3 | 8 | 28856 | 29 | ||
| 189316 | 191272 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 659 04th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6014208.1321 | 2110827.64494 | 37.7767292999414 | -122.394353258399 | (37.7767292999414, -122.394353258399) | 6 | 2 | 9 | 28856 | 20 | |||
| 189800 | 191249 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2300 18th St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 10ft | 6010915.57021 | 2105542.63703 | 37.7620342994705 | -122.405370986778 | (37.7620342994705, -122.405370986778) | 8 | 3 | 8 | 28856 | 29 | |||
| 192933 | 191260 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1058 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6012165.085 | 2103460.39568 | 37.7563867072014 | -122.400903071241 | (37.7563867072014, -122.400903071241) | 10 | 3 | 8 | 28856 | 29 | |||
| 46340 | 129439 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010043.54378 | 2115756.33064 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | 5 | 1 | 10 | 28857 | 21 | |||
| 144399 | 129436 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010030.57511 | 2115756.25526 | 37.7900289879055 | -122.409152593735 | (37.7900289879055, -122.409152593735) | 5 | 1 | 10 | 28857 | 21 | |||
| 155983 | 129437 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010035.0094 | 2115756.16478 | 37.7900289878849 | -122.409137245009 | (37.7900289878849, -122.409137245009) | 5 | 1 | 10 | 28857 | 21 | |||
| 190708 | 129438 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 715 Bush St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.7900271217973 | -122.409114812309 | (37.7900271217973, -122.409114812309) | 5 | 1 | 10 | 28857 | 21 | |||
| 4788 | 71255 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1392 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6007494.44606 | 2117816.87319 | 37.7955445300156 | -122.418073553678 | (37.7955445300156, -122.418073553678) | 5 | 1 | 10 | 28858 | 32 | |||
| 11930 | 4545 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 41 | |||
| 18434 | 105315 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2101 Laguna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 770797 | 6004250.84301 | 2116191.67517 | 37.7908990545176 | -122.429181041856 | (37.7908990545176, -122.429181041856) | 13 | 9 | 1 | 28858 | 27 | |||||
| 19602 | 129440 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 754 Post St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008519.41832 | 2114901.84945 | 37.7875982238142 | -122.414320608106 | (37.7875982238142, -122.414320608106) | 5 | 1 | 10 | 28858 | 21 | |||
| 25613 | 37524 | Permitted Site 7 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 1154 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779577 | 6007313.66795 | 2115327.60271 | 37.7886994328701 | -122.418522478123 | (37.7886994328701, -122.418522478123) | 13 | 9 | 10 | 28858 | 21 |
| 26105 | 111098 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 754 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/20/2015 12:00:00 AM | 3 | 3x3 | 6008536.0762 | 2114905.536 | 37.7876092819021 | -122.414263235869 | (37.7876092819021, -122.414263235869) | 5 | 1 | 10 | 28858 | 21 | ||
| 31494 | 4538 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 66 Cleary Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004823.98553 | 2113713.43923 | 37.784126867551 | -122.427021407244 | (37.784126867551, -122.427021407244) | 13 | 9 | 11 | 28858 | 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) );