trees
953 rows where qSpecies_id = 60 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70458 | 188315 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 850 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6012418.40198 | 2104012.51765 | 37.7579168397997 | -122.400065779927 | (37.7579168397997, -122.400065779927) | 10 | 3 | 8 | 28856 | 29 | |||
| 72533 | 116876 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6012412.72368 | 2104109.13047 | 37.7581818007698 | -122.400092202897 | (37.7581818007698, -122.400092202897) | 10 | 3 | 8 | 28856 | 29 | |||
| 77285 | 114570 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 366 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014008 | 2105399 | 37.7618123194661 | -122.394665331171 | (37.7618123194661, -122.394665331171) | 10 | 3 | 8 | 28856 | 29 | ||||
| 80882 | 188322 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 5 | : | Tree | Private 2 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.7569678967592 | -122.399012327554 | (37.7569678967592, -122.399012327554) | 10 | 3 | 8 | 28856 | 29 | |||
| 84088 | 97996 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1450 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6012957.39156 | 2106153.16264 | 37.7638246167349 | -122.398351909517 | (37.7638246167349, -122.398351909517) | 14 | 3 | 8 | 28856 | 29 | |||
| 84711 | 188335 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 2 | : | Tree | Private 2 | 12 | Width 5ft | 6013335.43042 | 2105239.42727 | 37.761336752 | -122.396980309397 | (37.761336752, -122.396980309397) | 10 | 3 | 8 | 28856 | 29 | |||
| 84768 | 188333 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 300 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6013450.64323 | 2105637.16099 | 37.7624352541126 | -122.396609715869 | (37.7624352541126, -122.396609715869) | 10 | 3 | 8 | 28856 | 29 | |||
| 86196 | 56136 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 755 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 17 | Permit Number 12240 | 6012456.10249 | 2104419.18715 | 37.7590355667492 | -122.3999639524 | (37.7590355667492, -122.3999639524) | 10 | 3 | 8 | 28856 | 29 | ||
| 88423 | 108730 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1822-1898X 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773105 | 6013006 | 2102886 | 37.7548564119513 | -122.39795458116 | (37.7548564119513, -122.39795458116) | 10 | 3 | 8 | 28856 | 29 |
| 89713 | 49814 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46606 | 6012411.85736 | 2104145.59448 | 37.7582818746203 | -122.400097759826 | (37.7582818746203, -122.400097759826) | 10 | 3 | 8 | 28856 | 29 | |
| 90148 | 49815 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2003 12:00:00 AM | 11 | 3x3 | Permit Number 46737 | 6012411.85302 | 2104156.13739 | 37.7583108228906 | -122.400098515246 | (37.7583108228906, -122.400098515246) | 10 | 3 | 8 | 28856 | 29 | |
| 101323 | 188323 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 6 | : | Tree | Private 2 | 3 | Width 3ft | 6012718.59247 | 2103642.79546 | 37.7569183962771 | -122.399001638237 | (37.7569183962771, -122.399001638237) | 10 | 3 | 8 | 28856 | 29 | |||
| 101359 | 101157 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x5 | 6013434.11839 | 2105245.81969 | 37.7613597971466 | -122.396639434871 | (37.7613597971466, -122.396639434871) | 10 | 3 | 8 | 28856 | 29 | |||
| 103366 | 188308 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 195 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6012915.64836 | 2106174.80894 | 37.7638817272787 | -122.398497806527 | (37.7638817272787, -122.398497806527) | 14 | 3 | 8 | 28856 | 29 | |||
| 103736 | 188330 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 214 Texas St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6013707.23683 | 2106019.48516 | 37.7634993094715 | -122.395749036807 | (37.7634993094715, -122.395749036807) | 14 | 3 | 8 | 28856 | 29 | |||
| 105529 | 39521 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1330 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1998 12:00:00 AM | 1 | 3x3 | Permit Number 40968 | 6012480.371 | 2107070.1033 | 37.7663157471753 | -122.400066187848 | (37.7663157471753, -122.400066187848) | 14 | 3 | 8 | 28856 | 20 |
| 109747 | 54597 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 630 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/1972 12:00:00 AM | 19 | Permit Number 10420 | 6014092.76415 | 2104176.14538 | 37.7584593387525 | -122.394286543097 | (37.7584593387525, -122.394286543097) | 10 | 3 | 8 | 28856 | 29 | ||
| 111140 | 67472 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 644 Wisconsin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/08/1992 12:00:00 AM | 12 | Permit Number 30994 | 6012673.57761 | 2104437.30819 | 37.7590974455196 | -122.399213087719 | (37.7590974455196, -122.399213087719) | 10 | 3 | 8 | 28856 | 29 | |
| 111726 | 108723 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 764 Arkansas St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773103 | 6013016.81056 | 2103494.00722 | 37.7565264696642 | -122.397959844253 | (37.7565264696642, -122.397959844253) | 10 | 3 | 8 | 28856 | 29 | |
| 117544 | 101158 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x5 | 6013408.6905 | 2105245.25033 | 37.7613568185891 | -122.396727339995 | (37.7613568185891, -122.396727339995) | 10 | 3 | 8 | 28856 | 29 | |||
| 123431 | 188320 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 3 | : | Tree | Private 2 | 4 | Width 3ft | 6012714.93717 | 2103702.00953 | 37.7570807814757 | -122.399018435778 | (37.7570807814757, -122.399018435778) | 10 | 3 | 8 | 28856 | 29 | |||
| 125221 | 188314 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 209 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6012920.39435 | 2106015.17263 | 37.7634436657274 | -122.39847018925 | (37.7634436657274, -122.39847018925) | 14 | 3 | 8 | 28856 | 29 | |||
| 125660 | 188325 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 9 | : | Tree | Private 2 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.398989421832 | (37.7567499739592, -122.398989421832) | 10 | 3 | 8 | 28856 | 29 | |||
| 127070 | 254844 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 475 Arkansas St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6013011 | 2104854 | 37.7602603887437 | -122.398075345371 | (37.7602603887437, -122.398075345371) | 10 | 3 | 8 | 28856 | 29 | ||
| 127668 | 56137 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 767 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 23 | Permit Number 12241 | 6012457.22858 | 2104373.65416 | 37.7589106059655 | -122.399956860327 | (37.7589106059655, -122.399956860327) | 10 | 3 | 8 | 28856 | 29 | ||
| 131846 | 188326 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1810 23rd St | 1 | : | Tree | Private 2 | 8 | Width 2ft | 6012985.75281 | 2102888.64274 | 37.7548625406828 | -122.398024787438 | (37.7548625406828, -122.398024787438) | 10 | 3 | 8 | 28856 | 29 | |||
| 135162 | 188304 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 601 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6015659.79181 | 2105320.44232 | 37.7616883131784 | -122.388946905678 | (37.7616883131784, -122.388946905678) | 10 | 3 | 8 | 28856 | 29 | |||
| 136865 | 188317 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2200 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6011501.39155 | 2104667.35812 | 37.7596637153197 | -122.403283270917 | (37.7596637153197, -122.403283270917) | 10 | 3 | 8 | 28856 | 29 | |||
| 137786 | 116874 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 824 Carolina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6012413.67241 | 2104134.33813 | 37.7582510683591 | -122.400090692038 | (37.7582510683591, -122.400090692038) | 10 | 3 | 8 | 28856 | 29 | |||
| 141840 | 188307 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 635 Tennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015454.50593 | 2106102.86687 | 37.7638253011319 | -122.389711563256 | (37.7638253011319, -122.389711563256) | 14 | 3 | 8 | 28856 | 29 | |||
| 148011 | 188321 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 800 Wisconsin St | 4 | : | Tree | Private 2 | 4 | Width 3ft | 6012714.29279 | 2103681.13676 | 37.757023433506 | -122.399019199302 | (37.757023433506, -122.399019199302) | 10 | 3 | 8 | 28856 | 29 | |||
| 152007 | 188318 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2000 20th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 6012048.56124 | 2104706.10168 | 37.759800640718 | -122.401393594734 | (37.759800640718, -122.401393594734) | 10 | 3 | 8 | 28856 | 29 | |||
| 155842 | 107041 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1301 18TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6013691.7 | 2105657.2 | 37.7625036896712 | -122.395777387543 | (37.7625036896712, -122.395777387543) | 10 | 3 | 8 | 28856 | 29 | ||||
| 163055 | 188336 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1490 19th St | 3 | : | Tree | Private 2 | 11 | Width 5ft | 6013315.97127 | 2105238.81397 | 37.7613339848017 | -122.397047567891 | (37.7613339848017, -122.397047567891) | 10 | 3 | 8 | 28856 | 29 | |||
| 180671 | 114552 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1121 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777071 | 6011681.54455 | 2103150.14548 | 37.7555078447183 | -122.402553516927 | (37.7555078447183, -122.402553516927) | 10 | 3 | 8 | 28856 | 29 | ||
| 184229 | 188329 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1850 23rd St | 2 | : | Tree | Private 2 | 1 | Width 2ft | 6012894.83022 | 2102885.32696 | 37.7548483718617 | -122.398338992565 | (37.7548483718617, -122.398338992565) | 10 | 3 | 8 | 28856 | 29 | |||
| 188055 | 188331 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 612 Texas St | 1 | : | Tree | Private 2 | 18 | Width 4ft | 6013806.03622 | 2104232.11636 | 37.7585970807056 | -122.395282104281 | (37.7585970807056, -122.395282104281) | 10 | 3 | 8 | 28856 | 29 | |||
| 56301 | 33288 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1242 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 7 | Permit Number 37449 | 6008832.98278 | 2116682.76958 | 37.7925058062477 | -122.413361726687 | (37.7925058062477, -122.413361726687) | 5 | 1 | 10 | 28857 | 21 | |
| 422 | 113225 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 3x3 | 6008828.65356 | 2115644.68399 | 37.7896552332384 | -122.413303262628 | (37.7896552332384, -122.413303262628) | 5 | 1 | 10 | 28858 | 21 | ||
| 12100 | 96019 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 23186 | 103507 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 30336 | 125888 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.7844075146451 | -122.415878065725 | (37.7844075146451, -122.415878065725) | 7 | 10 | 9 | 28858 | 36 | |||
| 37840 | 96018 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 37894 | 45238 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 871 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2001 12:00:00 AM | Permit Number 44088 | 6008421.36689101 | 2115188.65226849 | 37.7883802062735 | -122.414680152021 | (37.7883802062735, -122.414680152021) | 5 | 1 | 10 | 28858 | 21 | |||
| 44831 | 125887 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006289.37196 | 2113344.72886 | 37.7831972322057 | -122.421925487583 | (37.7831972322057, -122.421925487583) | 7 | 9 | 11 | 28858 | 41 | |||
| 44956 | 103510 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 46632 | 21528 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1300 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2007 12:00:00 AM | 3 | 4X4 | 6006219.82958 | 2114935.40618 | 37.7875609181413 | -122.422279128893 | (37.7875609181413, -122.422279128893) | 13 | 9 | 1 | 28858 | 41 | ||
| 49184 | 125884 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008808.31826 | 2115292.90351 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | 5 | 1 | 10 | 28858 | 21 | |||
| 56102 | 52371 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 970JONES Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2005 12:00:00 AM | 6 | 3x3 | Permit Number 48503 | 6008855.4568 | 2115649.67517 | 37.7896704425982 | -122.413210878899 | (37.7896704425982, -122.413210878899) | 5 | 1 | 10 | 28858 | 21 |
| 70980 | 96020 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769 | 2115301 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | 5 | 1 | 10 | 28858 | 21 | |
| 74489 | 24256 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 203 Willow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/15/2014 12:00:00 AM | 3 | 2x3 | 6006439.8092 | 2113362.67149 | 37.7832549812742 | -122.421406308981 | (37.7832549812742, -122.421406308981) | 7 | 9 | 11 | 28858 | 41 | ||
| 81150 | 24248 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 265X Willow St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1990 12:00:00 AM | 3 | 4x4 | 6006141.132777 | 2113311.4044124 | 37.783097370149 | -122.422435967678 | (37.783097370149, -122.422435967678) | 7 | 9 | 11 | 28858 | 41 | ||
| 83367 | 103511 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 83415 | 107235 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008834.66692 | 2115296.44284 | 37.7886993852058 | -122.413257820814 | (37.7886993852058, -122.413257820814) | 5 | 1 | 10 | 28858 | 21 | |||
| 84156 | 125883 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008823.04151 | 2115295.32129 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | 5 | 1 | 10 | 28858 | 21 | |||
| 95201 | 24238 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 200X Willow St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 6 | 4X4 | 6006547.3507 | 2113418.3192 | 37.7834138390239 | -122.421038210119 | (37.7834138390239, -122.421038210119) | 7 | 9 | 11 | 28858 | 41 | ||
| 96910 | 114307 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 595 ELLIS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008020 | 2113749 | 37.7844047125189 | -122.415966831143 | (37.7844047125189, -122.415966831143) | 7 | 10 | 9 | 28858 | 36 | ||||
| 98519 | 48359 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1400X Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2002 12:00:00 AM | 7 | 3x3 | Permit Number 45770 | 6005451 | 2114476 | 37.7862561057092 | -122.424906431455 | (37.7862561057092, -122.424906431455) | 13 | 9 | 11 | 28858 | 13 | |
| 98772 | 66797 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2655 Polk St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 11/26/2018 12:00:00 AM | 3 | Permit Number 782624 | 6006123.61383 | 2119959.43623 | 37.8013502149967 | -122.422969232649 | (37.8013502149967, -122.422969232649) | 13 | 9 | 1 | 28858 | 32 | |
| 116464 | 125885 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 476 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008153.2935 | 2113467.57124 | 37.7836394702246 | -122.415485749065 | (37.7836394702246, -122.415485749065) | 7 | 10 | 9 | 28858 | 36 | |||
| 118525 | 125882 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2100 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6005138.85638 | 2116964.61432 | 37.7930715805281 | -122.426163602963 | (37.7930715805281, -122.426163602963) | 13 | 9 | 1 | 28858 | 27 | |||
| 143719 | 103509 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 149802 | 96017 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767661 | 6008768.28006 | 2115323.27409 | 37.7887693299764 | -122.413489408823 | (37.7887693299764, -122.413489408823) | 5 | 1 | 10 | 28858 | 21 |
| 160338 | 103508 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 100X Leroy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008356 | 2116660 | 37.7924164947138 | -122.415010494885 | (37.7924164947138, -122.415010494885) | 5 | 1 | 10 | 28858 | 21 | |||
| 165247 | 125886 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 260 Willow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006255.84548 | 2113363.12878 | 37.7832458630397 | -122.422042783457 | (37.7832458630397, -122.422042783457) | 7 | 9 | 11 | 28858 | 41 | |||
| 166077 | 96016 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 810 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767661 | 6008769.14714 | 2115306.341 | 37.788722884507 | -122.41348521079 | (37.788722884507, -122.41348521079) | 5 | 1 | 10 | 28858 | 21 |
| 175317 | 39767 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 476 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | 3 | 2x2 | Permit Number 42916 | 6008173.90648 | 2113469.9166 | 37.7836470686025 | -122.415414601899 | (37.7836470686025, -122.415414601899) | 7 | 10 | 9 | 28858 | 36 |
| 175825 | 125890 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 8 Sharp Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007493.35542 | 2119123.01732 | 37.7991308141058 | -122.418169974478 | (37.7991308141058, -122.418169974478) | 5 | 1 | 10 | 28858 | 32 | |||
| 4922 | 152652 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1113 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6008666.19749 | 2102064.94601 | 37.75235932814 | -122.412904832409 | (37.75235932814, -122.412904832409) | 2 | 4 | 7 | 28859 | 19 | |||
| 5626 | 52490 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2005 12:00:00 AM | Permit Number 48600 | 6008167.5363144 | 2096496.40585448 | 37.7370413503065 | -122.414235342537 | (37.7370413503065, -122.414235342537) | 2 | 7 | 7 | 28859 | 2 | ||
| 5780 | 261485 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3608 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005560 | 2104915 | 37.760010064893 | -122.423849219023 | (37.760010064893, -122.423849219023) | 2 | 4 | 5 | 28859 | 19 | ||||
| 11333 | 222507 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1266 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 6ft | 6010033.6534 | 2101840.39608 | 37.7518194273238 | -122.408160091111 | (37.7518194273238, -122.408160091111) | 2 | 4 | 7 | 28859 | 19 | |||
| 12817 | 221354 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6008383.52326 | 2103860.65415 | 37.7572740646699 | -122.414009391436 | (37.7572740646699, -122.414009391436) | 2 | 4 | 7 | 28859 | 19 | |||
| 14406 | 165740 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 119 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007607.32013 | 2098066.61783 | 37.7413213218322 | -122.41628344773 | (37.7413213218322, -122.41628344773) | 2 | 7 | 7 | 28859 | 2 | |||
| 15317 | 261202 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 699x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007339 | 2095419 | 37.7340364554683 | -122.417023656077 | (37.7340364554683, -122.417023656077) | 2 | 7 | 7 | 28859 | 2 | ||||
| 16961 | 261483 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3608 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005560 | 2104915 | 37.760010064893 | -122.423849219023 | (37.760010064893, -122.423849219023) | 2 | 4 | 5 | 28859 | 19 | ||||
| 17436 | 153178 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 855 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6010194.64784 | 2104257.6801 | 37.7584657635091 | -122.407773780163 | (37.7584657635091, -122.407773780163) | 10 | 4 | 7 | 28859 | 19 | |||
| 19637 | 116726 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 180X PERALTA AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009777 | 2100122 | 37.7470867174475 | -122.408926407614 | (37.7470867174475, -122.408926407614) | 2 | 7 | 7 | 28859 | 2 | ||||
| 20379 | 221335 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1641 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010542.34793 | 2100138.19824 | 37.7471740359465 | -122.406281026071 | (37.7471740359465, -122.406281026071) | 2 | 7 | 7 | 28859 | 2 | |||
| 23911 | 96839 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 186 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009509 | 2097504 | 37.7398832463975 | -122.409668377616 | (37.7398832463975, -122.409668377616) | 10 | 7 | 7 | 28859 | 2 | |||
| 24217 | 221347 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 115 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6009327.08226 | 2096770.42354 | 37.7378588087266 | -122.41024559558 | (37.7378588087266, -122.41024559558) | 10 | 7 | 7 | 28859 | 2 | |||
| 24389 | 221356 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2517 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008902.61993 | 2103693.22479 | 37.7568434827621 | -122.412202312603 | (37.7568434827621, -122.412202312603) | 2 | 4 | 7 | 28859 | 19 | |||
| 24772 | 221325 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006242.86506 | 2104074.32841 | 37.7577403028851 | -122.42142781086 | (37.7577403028851, -122.42142781086) | 2 | 4 | 5 | 28859 | 19 | |||
| 25487 | 222564 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 160 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007476.41433 | 2100201.58357 | 37.7471760989928 | -122.416887300207 | (37.7471760989928, -122.416887300207) | 2 | 7 | 7 | 28859 | 2 | |||
| 26153 | 108935 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12X CAMP ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005858 | 2106413 | 37.7641400388714 | -122.422925047265 | (37.7641400388714, -122.422925047265) | 8 | 4 | 5 | 28859 | 19 | ||||
| 29421 | 107444 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 3333 21ST ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 6x6 | 6006088.7 | 2103711.1 | 37.7567342687503 | -122.421935176249 | (37.7567342687503, -122.421935176249) | 2 | 4 | 5 | 28859 | 19 | |||
| 32334 | 221326 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6005468.19863 | 2101476.92488 | 37.7505647282985 | -122.423922233444 | (37.7505647282985, -122.423922233444) | 2 | 4 | 5 | 28859 | 19 | |||
| 33218 | 34342 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 12661268 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | Permit Number 38099 | 6010039 | 2101826 | 37.7517801982502 | -122.408140586549 | (37.7517801982502, -122.408140586549) | 2 | 4 | 7 | 28859 | 19 | ||
| 34465 | 222549 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 199 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6007198.14969 | 2097813.68298 | 37.7406038022373 | -122.417680295405 | (37.7406038022373, -122.417680295405) | 2 | 7 | 7 | 28859 | 2 | |||
| 37578 | 221355 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2971 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008404.74116 | 2103860.62661 | 37.757275180723 | -122.413936009452 | (37.757275180723, -122.413936009452) | 2 | 4 | 7 | 28859 | 19 | |||
| 39187 | 33577 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37685 | 6007025.08907683 | 2097945.62097714 | 37.7409563345382 | -122.418288026055 | (37.7409563345382, -122.418288026055) | 2 | 7 | 7 | 28859 | 2 | |||
| 40262 | 221321 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 76 Oakwood St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6005240.58146 | 2105045.63355 | 37.7603507164348 | -122.424963229285 | (37.7603507164348, -122.424963229285) | 2 | 4 | 5 | 28859 | 19 | |||
| 40733 | 46346 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 384 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/14/2002 12:00:00 AM | Permit Number 44592 | 6005461.4442402 | 2101476.38644964 | 37.7505628685682 | -122.423945552398 | (37.7505628685682, -122.423945552398) | 2 | 4 | 5 | 28859 | 19 | ||
| 42114 | 40737 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 163 Putnam St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/12/1999 12:00:00 AM | Permit Number 41716 | 6009144.8463962 | 2096601.1649491 | 37.737383844528 | -122.410863725513 | (37.737383844528, -122.410863725513) | 10 | 7 | 7 | 28859 | 2 | ||
| 42439 | 221348 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 225 Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007116.4311 | 2096880.25923 | 37.7380362287807 | -122.417896696594 | (37.7380362287807, -122.417896696594) | 2 | 7 | 7 | 28859 | 2 | |||
| 45162 | 100793 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Recently planted by FUF. | 6008363 | 2103862 | 37.7572766073656 | -122.414080464335 | (37.7572766073656, -122.414080464335) | 2 | 4 | 7 | 28859 | 19 | ||||
| 46708 | 37017 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/29/1998 12:00:00 AM | Permit Number 39630 | 6008600.86286293 | 2102426.42877225 | 37.7533482108195 | -122.413156329636 | (37.7533482108195, -122.413156329636) | 2 | 4 | 7 | 28859 | 19 | ||
| 47264 | 256155 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 80X Peralta Ave | 4 | Median : Cutout | Tree | Private 2 | 3x3 | 6010428 | 2100359 | 37.747773912222 | -122.406691992098 | (37.747773912222, -122.406691992098) | 2 | 7 | 7 | 28859 | 2 | ||||
| 50195 | 96837 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 190 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009513 | 2097465 | 37.7397763850106 | -122.409651795241 | (37.7397763850106, -122.409651795241) | 10 | 7 | 7 | 28859 | 2 | |||
| 50910 | 222561 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 380 Tompkins Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008138.86201 | 2096500.51335 | 37.7370510178737 | -122.414334773354 | (37.7370510178737, -122.414334773354) | 2 | 7 | 7 | 28859 | 2 |
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) );