trees
502 rows where qSpecies_id = 157 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10783 | 26837 | Permitted Site 7 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1100X Duncan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2x2 | |||||||||||||
| 139031 | 67671 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1780 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/05/1992 12:00:00 AM | 3 | Permit Number 31274 | 6014163.98928 | 2095111.2366 | 37.7335729654239 | -122.3934058406 | (37.7335729654239, -122.3934058406) | 10 | 3 | 8 | 58 | 1 | ||
| 150117 | 191409 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1201 20th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014316.15581 | 2104772.8809 | 37.7601102601985 | -122.39355571262 | (37.7601102601985, -122.39355571262) | 10 | 3 | 8 | 28856 | 29 | |||
| 140776 | 51484 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 63 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/11/2005 12:00:00 AM | 3 | Permit Number 47795 | 6013789.90035 | 2095538.15707 | 37.7347244096963 | -122.394729070715 | (37.7347244096963, -122.394729070715) | 10 | 3 | 8 | 58 | 1 | ||
| 79666 | 52667 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 226@ MARIPOSA Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2006 12:00:00 AM | 4 | Permit Number 48748 | 6013989.66408 | 2106012.37339 | 37.7634954891429 | -122.394771705743 | (37.7634954891429, -122.394771705743) | 14 | 3 | 8 | 28856 | 29 | ||
| 191107 | 177001 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 154 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013011.29164 | 2086676.67622 | 37.7103492505861 | -122.396799956671 | (37.7103492505861, -122.396799956671) | 10 | 3 | 8 | 309 | 1 | |||
| 144808 | 252881 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 3536 Jennings St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 6013049.30639 | 2089480.54762 | 37.7180502424123 | -122.396865018102 | (37.7180502424123, -122.396865018102) | 10 | 3 | 8 | 58 | 1 | ||||
| 103101 | 191412 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1998 Revere Ave | 6 | Side Yard : Yard | Tree | Private 2 | 15 | 6013024.42365 | 2095944.26783 | 37.7357969159791 | -122.39740407446 | (37.7357969159791, -122.39740407446) | 10 | 3 | 8 | 58 | 1 | ||||
| 46963 | 191411 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 462 Thornton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6012808.38143 | 2094403.01246 | 37.7315529172119 | -122.39804293216 | (37.7315529172119, -122.39804293216) | 10 | 3 | 8 | 58 | 1 | |||
| 25723 | 40627 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1118 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | 7 | Permit Number 41628 | 6012181.11201 | 2103196.50544 | 37.755663016446 | -122.40082910469 | (37.755663016446, -122.40082910469) | 10 | 3 | 8 | 28856 | 29 | ||
| 117411 | 191410 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 777 Rhode Island St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6011870.78856 | 2104734.77484 | 37.7598694505299 | -122.402010442428 | (37.7598694505299, -122.402010442428) | 10 | 3 | 8 | 28856 | 29 | |||
| 1680 | 38198 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 885 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/1998 12:00:00 AM | 5 | Permit Number 40325 | 6011564.90625 | 2090771.94385 | 37.7215134173935 | -122.402086713936 | (37.7215134173935, -122.402086713936) | 10 | 3 | 7 | 309 | 28 | |
| 42105 | 71938 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 384 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1995 12:00:00 AM | 4 | 6011634.93944 | 2119088.82833 | 37.7992691828709 | -122.403836198406 | (37.7992691828709, -122.403836198406) | 3 | 1 | 10 | 308 | 23 | ||
| 185376 | 249979 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 13 Napier Ln | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6011649.02488 | 2120183.73487 | 37.802276317051 | -122.403864545927 | (37.802276317051, -122.403864545927) | 3 | 1 | 10 | 308 | 23 | |||
| 53924 | 177002 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 721 Goettingen St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 4ft | 6010761.08783 | 2091324.02864 | 37.7229844303778 | -122.404904160394 | (37.7229844303778, -122.404904160394) | 10 | 3 | 7 | 309 | 28 | |||
| 38311 | 226584 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 116 Franconia St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6010066.87681 | 2099747.40872 | 37.7460744052137 | -122.407897622203 | (37.7460744052137, -122.407897622203) | 2 | 7 | 7 | 28859 | 2 | ||||
| 129648 | 177006 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 271 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009831.15293 | 2088401.27476 | 37.7149071271443 | -122.40791276406 | (37.7149071271443, -122.40791276406) | 9 | 7 | 8 | 309 | 39 | |||
| 93984 | 227704 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 752 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6010109.25034 | 2104766.06906 | 37.7598569040934 | -122.408104977977 | (37.7598569040934, -122.408104977977) | 2 | 4 | 8 | 28859 | 19 | |||
| 183990 | 68271 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 432 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2014 12:00:00 AM | 8 | Permit Number 771022 | 6009763.04812 | 2092384.22175 | 37.7258396600504 | -122.408428941659 | (37.7258396600504, -122.408428941659) | 10 | 3 | 7 | 309 | 28 | |
| 157325 | 247978 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 501 Peralta Ave | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 6009784.19004 | 2099413.44589 | 37.7451415861154 | -122.408851562753 | (37.7451415861154, -122.408851562753) | 2 | 7 | 7 | 28859 | 2 | ||||
| 135929 | 177003 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 746 Olmstead St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009476.70201 | 2090586.07604 | 37.720886288652 | -122.409291987754 | (37.720886288652, -122.409291987754) | 9 | 3 | 7 | 309 | 28 | |||
| 22184 | 177004 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 746 Olmstead St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009463.77429 | 2090581.80292 | 37.7208738312511 | -122.40933637377 | (37.7208738312511, -122.40933637377) | 9 | 3 | 7 | 309 | 28 | |||
| 71556 | 37790 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 310 Hamilton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 6 | Permit Number 40120 | 6009327.0324 | 2092792.3248 | 37.7269357978389 | -122.409965019679 | (37.7269357978389, -122.409965019679) | 9 | 3 | 7 | 309 | 28 | |
| 39853 | 37792 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 310 Hamilton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | 5 | Permit Number 40120 | 6009317.62312 | 2092827.34387 | 37.727031425442 | -122.410000018602 | (37.727031425442, -122.410000018602) | 9 | 3 | 7 | 309 | 28 | |
| 151768 | 177025 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 300 Hamilton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009309.80145 | 2092849.95818 | 37.7270930811686 | -122.410028653892 | (37.7270930811686, -122.410028653892) | 9 | 3 | 7 | 309 | 28 | |||
| 176829 | 177005 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 362 Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009172.07817 | 2088408.58756 | 37.7148902855318 | -122.410191328669 | (37.7148902855318, -122.410191328669) | 9 | 7 | 8 | 309 | 39 | |||
| 16007 | 68284 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 665 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2012 12:00:00 AM | 2 | Permit Number 769020 | 6009000.66847 | 2092983.87364 | 37.727443453448 | -122.411106781849 | (37.727443453448, -122.411106781849) | 9 | 3 | 7 | 309 | 28 | |
| 27889 | 34479 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 756 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/1997 12:00:00 AM | 6 | 2x3 | Permit Number 38206 | 6009344.31019 | 2119468.83873 | 37.800184363566 | -122.411789466237 | (37.800184363566, -122.411789466237) | 3 | 1 | 10 | 308 | 4 |
| 93823 | 43211 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 353 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 5 | Permit Number 43002 | 6008758.60086 | 2094527.34935 | 37.73166792973 | -122.412052645639 | (37.73166792973, -122.412052645639) | 9 | 3 | 7 | 309 | 28 | |
| 36896 | 226621 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2498 Harrison St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008827.83459 | 2103955.23814 | 37.7575587153899 | -122.412479469249 | (37.7575587153899, -122.412479469249) | 2 | 4 | 7 | 28859 | 19 | |||
| 48283 | 246731 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 101 Ripley St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6008584.45337 | 2099107.91594 | 37.7442353941634 | -122.41297845991 | (37.7442353941634, -122.41297845991) | 2 | 7 | 7 | 28859 | 2 | |||
| 142565 | 226609 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 4005 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008395.32026 | 2096426.58314 | 37.7368624246667 | -122.413442851824 | (37.7368624246667, -122.413442851824) | 10 | 7 | 7 | 28859 | 2 | |||
| 177863 | 226588 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 350 Treat Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008565.82947 | 2106391.50298 | 37.7642334332393 | -122.41355789668 | (37.7642334332393, -122.41355789668) | 8 | 4 | 7 | 28859 | 19 | |||
| 158991 | 226587 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 352 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008561.06519 | 2106374.04513 | 37.7641852304909 | -122.413573140196 | (37.7641852304909, -122.413573140196) | 8 | 4 | 7 | 28859 | 19 | |||
| 144282 | 177026 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 501 Sweeny St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6008206.81715 | 2094351.99009 | 37.7311554564421 | -122.413947877816 | (37.7311554564421, -122.413947877816) | 9 | 3 | 7 | 309 | 28 | |||
| 99070 | 42982 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 469 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | 7 | Permit Number 42866 | 6008125.46012 | 2091747.89633 | 37.724000603132 | -122.414044988394 | (37.724000603132, -122.414044988394) | 9 | 3 | 7 | 309 | 28 | |
| 99938 | 226612 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 49 Bessie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6008238.81555 | 2100053.84156 | 37.7468132873058 | -122.41424051718 | (37.7468132873058, -122.41424051718) | 2 | 7 | 7 | 28859 | 2 | |||
| 74971 | 226611 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 80 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6008212.2428 | 2099629.64736 | 37.745647051868 | -122.414302395044 | (37.745647051868, -122.414302395044) | 2 | 7 | 7 | 28859 | 2 | |||
| 41556 | 226618 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 226 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007884.76815 | 2100264.95114 | 37.7473730532316 | -122.415479726319 | (37.7473730532316, -122.415479726319) | 2 | 7 | 7 | 28859 | 2 | |||
| 75558 | 226619 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 220 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007856.36673 | 2100270.38915 | 37.7473863883657 | -122.415578321691 | (37.7473863883657, -122.415578321691) | 2 | 7 | 7 | 28859 | 2 | |||
| 37309 | 43217 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 45 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 4 | Permit Number 43007 | 6007564.04162 | 2093733.91416 | 37.7294222326375 | -122.416126315492 | (37.7294222326375, -122.416126315492) | 9 | 3 | 7 | 309 | 28 | |
| 74696 | 81381 | Undocumented 4 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 822 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/08/2003 12:00:00 AM | 3x3 | 6007769.502 | 2114456.07002 | 37.7863320683098 | -122.416883582419 | (37.7863320683098, -122.416883582419) | 13 | 1 | 9 | 28858 | 36 | ||
| 187063 | 129498 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 855 Chestnut St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 6ft | 6007778.02269 | 2120584.45961 | 37.8031595862164 | -122.417288546245 | (37.8031595862164, -122.417288546245) | 5 | 1 | 1 | 308 | 32 | |||
| 96216 | 129497 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 855 Chestnut St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 6007750.73846 | 2120580.85704 | 37.8031481594106 | -122.417382708871 | (37.8031481594106, -122.417382708871) | 5 | 1 | 1 | 308 | 32 | |||
| 83864 | 226620 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 688 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007284.68348 | 2103336.34747 | 37.7557726618001 | -122.417772455244 | (37.7557726618001, -122.417772455244) | 2 | 4 | 7 | 28859 | 19 | |||
| 74725 | 129494 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 14 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6007592.27134 | 2119390.32661 | 37.7998703454969 | -122.417846649312 | (37.7998703454969, -122.417846649312) | 5 | 1 | 1 | 28858 | 32 | ||||
| 62523 | 226610 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 187 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007102.33802 | 2097997.69789 | 37.7411036742096 | -122.418024617936 | (37.7411036742096, -122.418024617936) | 2 | 7 | 7 | 28859 | 2 | |||
| 80292 | 129493 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 660 Bay St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6007573.98162 | 2121316.69576 | 37.8051586397294 | -122.418046578505 | (37.8051586397294, -122.418046578505) | 5 | 1 | 1 | 308 | 32 | |||
| 36940 | 226585 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 257 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007206.23744 | 2105617.20797 | 37.7620309629873 | -122.41820544912 | (37.7620309629873, -122.41820544912) | 8 | 4 | 7 | 28859 | 19 | |||
| 157043 | 129496 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1101 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6007491.98236 | 2119862.03748 | 37.8011599004699 | -122.418227149773 | (37.8011599004699, -122.418227149773) | 5 | 1 | 1 | 28858 | 32 | ||||
| 6887 | 129495 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1136 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 6007480.35855 | 2119354.0245 | 37.7997643702969 | -122.418231335218 | (37.7997643702969, -122.418231335218) | 5 | 1 | 1 | 28858 | 32 | |||
| 181032 | 177021 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1538 Burrows St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6006775.37088 | 2092172.25631 | 37.72508988269 | -122.41874212587 | (37.72508988269, -122.41874212587) | 9 | 7 | 7 | 309 | 5 | |||
| 88643 | 177022 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1628 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006681.72637 | 2092138.27566 | 37.7249913061838 | -122.419063436538 | (37.7249913061838, -122.419063436538) | 9 | 7 | 7 | 309 | 5 | |||
| 48168 | 177023 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1628 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006643.54009 | 2092125.78314 | 37.7249548539585 | -122.419194556805 | (37.7249548539585, -122.419194556805) | 9 | 7 | 7 | 309 | 5 | |||
| 80978 | 226613 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 322 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006488.43942 | 2097246.62658 | 37.7390068293023 | -122.420093972376 | (37.7390068293023, -122.420093972376) | 2 | 7 | 7 | 28859 | 2 | |||
| 192217 | 41753 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1644 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | 4 | Permit Number 42182 | 6006856.27196 | 2116746.53055 | 37.7925696967985 | -122.420205749089 | (37.7925696967985, -122.420205749089) | 13 | 9 | 10 | 28858 | 32 | |
| 74336 | 226582 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 383 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006413.77253 | 2097021.64328 | 37.7383848680573 | -122.420336172385 | (37.7383848680573, -122.420336172385) | 2 | 7 | 7 | 28859 | 2 | |||
| 74562 | 226614 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 322 Elsie St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006361.98798 | 2097015.14213 | 37.7383640991328 | -122.420514757074 | (37.7383640991328, -122.420514757074) | 2 | 7 | 7 | 28859 | 2 | |||
| 142178 | 226586 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 195 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006490.36158 | 2105010.39 | 37.7603244616207 | -122.420638312212 | (37.7603244616207, -122.420638312212) | 2 | 4 | 7 | 28859 | 19 | |||
| 118009 | 226581 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 110 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006265.98852 | 2097494.29518 | 37.739674335789 | -122.420880685817 | (37.739674335789, -122.420880685817) | 2 | 7 | 7 | 28859 | 2 | |||
| 186315 | 227703 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 200 Kingston St | 10 | Front Yard : Yard | Tree | Private 2 | 10 | Width 8ft | 6006269.24382 | 2098023.24286 | 37.7411268910989 | -122.420906974789 | (37.7411268910989, -122.420906974789) | 2 | 7 | 7 | 28859 | 2 | |||
| 173688 | 43171 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 369 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 8 | Permit Number 42980 | 6005855.02005 | 2091989.32837 | 37.7245357402195 | -122.421910697315 | (37.7245357402195, -122.421910697315) | 9 | 7 | 7 | 309 | 5 | |
| 56678 | 43162 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 221 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 5 | Permit Number 42972 | 6005660.57006 | 2092632.04042 | 37.726289518943 | -122.422628537103 | (37.726289518943, -122.422628537103) | 9 | 7 | 7 | 309 | 5 | |
| 92721 | 226583 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 65 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6005675.46056 | 2097328.12115 | 37.7391847556639 | -122.422910674207 | (37.7391847556639, -122.422910674207) | 2 | 7 | 7 | 28859 | 2 | |||
| 74967 | 226617 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 58 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005670.60555 | 2097390.14395 | 37.739354782383 | -122.422931867621 | (37.739354782383, -122.422931867621) | 2 | 7 | 7 | 28859 | 2 | |||
| 17444 | 70393 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 63 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6005472.78201 | 2093254.06061 | 37.7279868534853 | -122.42332190989 | (37.7279868534853, -122.42332190989) | 9 | 7 | 7 | 309 | 5 | |||
| 172115 | 226615 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 10 Appleton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005546.7514 | 2097096.07919 | 37.7385403572369 | -122.423339202051 | (37.7385403572369, -122.423339202051) | 2 | 7 | 7 | 28859 | 2 | |||
| 30566 | 226616 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2 Appleton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005523.88104 | 2097105.4034 | 37.7385646686269 | -122.423418939539 | (37.7385646686269, -122.423418939539) | 2 | 7 | 7 | 28859 | 2 | |||
| 139784 | 177024 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 11 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6005372.1534 | 2093185.8595 | 37.7277939084451 | -122.423664939183 | (37.7277939084451, -122.423664939183) | 9 | 7 | 6 | 28861 | 5 | ||||
| 164632 | 43185 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 62 Valmar Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 7 | Permit Number 42987 | 6005330.72095 | 2092724.62519 | 37.7265251215375 | -122.423775390321 | (37.7265251215375, -122.423775390321) | 9 | 7 | 6 | 28861 | 5 | |
| 154482 | 227699 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 194 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005300.17225 | 2100223.67209 | 37.7471140970563 | -122.424414151801 | (37.7471140970563, -122.424414151801) | 2 | 7 | 5 | 28859 | 22 | |||
| 68131 | 227705 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1552 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005224.91638 | 2099272.18009 | 37.7444972677381 | -122.424606707457 | (37.7444972677381, -122.424606707457) | 2 | 7 | 5 | 63 | 22 | |||
| 78703 | 250091 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1620 Gough St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6005381.25743 | 2115289.65998 | 37.7884862737667 | -122.425205641527 | (37.7884862737667, -122.425205641527) | 13 | 9 | 1 | 28858 | 41 | |||
| 125998 | 43315 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 259 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/13/2000 12:00:00 AM | 4 | Permit Number 43078 | 6004448.9414 | 2091752.36291 | 37.7238056867768 | -122.426754460261 | (37.7238056867768, -122.426754460261) | 9 | 7 | 6 | 28861 | 5 | |
| 110343 | 177027 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 127 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6004458.22384 | 2092761.54245 | 37.7265771958662 | -122.426794207588 | (37.7265771958662, -122.426794207588) | 9 | 7 | 6 | 28861 | 5 | |||
| 61786 | 95711 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 277 Athens St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767467 | 6004408.66119 | 2091673.84489 | 37.7235878160995 | -122.426888112994 | (37.7235878160995, -122.426888112994) | 9 | 7 | 6 | 28861 | 5 |
| 46719 | 227702 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1201 San Jose Ave | 44 | Front Yard : Yard | Tree | Private 2 | 1 | 6004467.63219 | 2096063.70987 | 37.7356447417011 | -122.426996770882 | (37.7356447417011, -122.426996770882) | 2 | 7 | 5 | 28861 | 2 | ||||
| 142466 | 227701 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1201 San Jose Ave | 36 | Front Yard : Yard | Tree | Private 2 | 1 | 6004423.64254 | 2096032.0928 | 37.7355554408308 | -122.427146608748 | (37.7355554408308, -122.427146608748) | 2 | 7 | 5 | 28861 | 2 | ||||
| 44558 | 177020 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 235 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6004327.31373 | 2092022.61102 | 37.724540851055 | -122.427194147806 | (37.724540851055, -122.427194147806) | 9 | 7 | 6 | 28861 | 5 | ||||
| 44582 | 177019 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 25 Madrid St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004214.26597 | 2093378.84563 | 37.7282583768115 | -122.427681523704 | (37.7282583768115, -122.427681523704) | 9 | 7 | 6 | 28861 | 5 | ||||
| 194204 | 226626 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 310 Liberty St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 6004198.11867 | 2103939.92108 | 37.7572557526583 | -122.428489808259 | (37.7572557526583, -122.428489808259) | 2 | 4 | 5 | 28862 | 3 | |||
| 176470 | 227698 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 517 Hickory St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6004312.97566 | 2110291.73585 | 37.7747028072132 | -122.428545336007 | (37.7747028072132, -122.428545336007) | 7 | 9 | 11 | 28852 | 10 | |||
| 77145 | 42630 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2634 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 6 | Permit Number 42686 | 6004473.47116 | 2118249.9245 | 37.7965630841803 | -122.428557534402 | (37.7965630841803, -122.428557534402) | 13 | 9 | 1 | 57 | 17 | |
| 94503 | 226623 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 80 Vicksburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6004079.61394 | 2102598.16626 | 37.7535649035083 | -122.428803992713 | (37.7535649035083, -122.428803992713) | 2 | 4 | 5 | 28862 | 22 | |||
| 159613 | 226622 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 2 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6004058.08528 | 2103018.40015 | 37.7547175483925 | -122.428908401328 | (37.7547175483925, -122.428908401328) | 2 | 4 | 5 | 28862 | 22 | |||
| 67597 | 226627 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 310 Liberty St | 25 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6004024.53424 | 2103933.71517 | 37.7572288881251 | -122.429089688444 | (37.7572288881251, -122.429089688444) | 2 | 4 | 5 | 28862 | 3 | |||
| 136310 | 226576 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 350 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6003654.19113 | 2098670.43277 | 37.7427561757625 | -122.429995037735 | (37.7427561757625, -122.429995037735) | 2 | 7 | 5 | 63 | 22 | |||
| 54475 | 246438 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 498 Duncan St | 4 | Front Yard : Yard | Tree | Private 2 | 18 | Width 3ft | 6003357.50799 | 2099800.56839 | 37.7458424592683 | -122.431101528529 | (37.7458424592683, -122.431101528529) | 2 | 7 | 5 | 63 | 22 | |||
| 71830 | 226600 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1463 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003321.08221 | 2099703.03715 | 37.7455725970047 | -122.431220523219 | (37.7455725970047, -122.431220523219) | 2 | 7 | 5 | 63 | 22 | |||
| 72087 | 226601 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1518 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003286.59929 | 2099387.77612 | 37.7447050093281 | -122.431317259697 | (37.7447050093281, -122.431317259697) | 2 | 7 | 5 | 63 | 22 | |||
| 36050 | 227700 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 276 Bemis St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6002994.65302 | 2096282.17867 | 37.7361612061647 | -122.432105019051 | (37.7361612061647, -122.432105019051) | 2 | 7 | 5 | 63 | 7 | |||
| 149321 | 226605 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 276 Bemis St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6002989.38257 | 2096277.75645 | 37.7361487649474 | -122.432122925433 | (37.7361487649474, -122.432122925433) | 2 | 7 | 5 | 63 | 7 | |||
| 163613 | 227706 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 580 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002827.03523 | 2098917.62308 | 37.7433880232454 | -122.432872760368 | (37.7433880232454, -122.432872760368) | 2 | 7 | 5 | 63 | 22 | |||
| 96237 | 121608 | Undocumented 4 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 99X Lamartine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002710 | 2094292 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | 9 | 7 | 5 | 28861 | 25 | ||||
| 153155 | 121606 | Undocumented 4 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 99X Lamartine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002710 | 2094292 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | 9 | 7 | 5 | 28861 | 25 | ||||
| 186126 | 121607 | Undocumented 4 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 99X Lamartine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002710 | 2094292 | 37.7306804869695 | -122.432947039569 | (37.7306804869695, -122.432947039569) | 9 | 7 | 5 | 28861 | 25 | ||||
| 59699 | 177014 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 81 Lamartine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002672.79218 | 2094323.60612 | 37.7307651596849 | -122.433077929925 | (37.7307651596849, -122.433077929925) | 9 | 7 | 5 | 28861 | 25 | |||
| 191236 | 177015 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 81 Lamartine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002665.86181 | 2094349.24813 | 37.7308351736991 | -122.433103720676 | (37.7308351736991, -122.433103720676) | 9 | 7 | 5 | 28861 | 25 | |||
| 59300 | 177016 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 81 Lamartine St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002658.82779 | 2094369.87256 | 37.7308914046921 | -122.433129511441 | (37.7308914046921, -122.433129511441) | 9 | 7 | 5 | 28861 | 25 | |||
| 127402 | 177013 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 78 Lamartine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6002644.59595 | 2094315.3545 | 37.7307409031583 | -122.433174819278 | (37.7307409031583, -122.433174819278) | 9 | 7 | 5 | 28861 | 25 |
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) );