trees
7,322 rows where qSpecies_id = 1 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
69117 | 16884 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
71016 | 242259 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Oak St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6006155.99242 | 2110416.55826 | 37.7751496650453 | -122.422178828403 | (37.7751496650453, -122.422178828403) | 7 | 9 | 11 | 28852 | 10 | |||
71374 | 241643 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 599 Buchanan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6004545.6184 | 2110424.56888 | 37.7750806969521 | -122.427750043935 | (37.7750806969521, -122.427750043935) | 7 | 9 | 11 | 28852 | 10 | |||
72006 | 32165 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
72480 | 32166 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
72582 | 22601 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 837 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005919.22221 | 2112752.51326 | 37.7815502713572 | -122.423163949356 | (37.7815502713572, -122.423163949356) | 7 | 9 | 11 | 28852 | 41 | |||
72633 | 16921 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 503 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/1999 12:00:00 AM | 6 | 3X3 | 6004502.7249 | 2110132.7907 | 37.7742771189253 | -122.427877626712 | (37.7742771189253, -122.427877626712) | 7 | 9 | 11 | 28852 | 10 | ||
74548 | 86826 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 360 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2007 12:00:00 AM | 4 | 2x3 | Permit Number 49769 | 6004805.6 | 2110066.6 | 37.7741125047722 | -122.426825211107 | (37.7741125047722, -122.426825211107) | 7 | 9 | 11 | 28852 | 10 | |
75049 | 39414 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
75324 | 244146 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 405 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004514.7784 | 2109625.7172 | 37.7728855006387 | -122.427799793679 | (37.7728855006387, -122.427799793679) | 7 | 9 | 11 | 28852 | 10 | |||
75768 | 242257 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006301.70753 | 2110434.24272 | 37.7752064401631 | -122.421676022844 | (37.7752064401631, -122.421676022844) | 7 | 9 | 11 | 28852 | 10 | |||
77193 | 241743 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 331 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004971.76706 | 2109849.72029 | 37.7735263995585 | -122.426234965985 | (37.7735263995585, -122.426234965985) | 7 | 9 | 11 | 28852 | 10 | |||
77800 | 39407 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
77962 | 97291 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778496 | 6005288 | 2108881 | 37.7708843970709 | -122.425072128908 | (37.7708843970709, -122.425072128908) | 7 | 9 | 5 | 28852 | 10 | ||
77971 | 258108 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 885 Franklin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4X4 | 6006124.86369 | 2113018.24445 | 37.7822915069765 | -122.422471414725 | (37.7822915069765, -122.422471414725) | 7 | 9 | 11 | 28852 | 41 | ||||
79685 | 51846 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Permit Number 48071 | 6010119.81915 | 2114194.4742 | 37.785745710337 | -122.40873358881 | (37.785745710337, -122.40873358881) | 14 | 10 | 10 | 28852 | 36 | ||
79789 | 83785 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 144 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2008 12:00:00 AM | 3x3 | Permit Number 51882 | 6008612.48195203 | 2112968.71572945 | 37.7822955319647 | -122.413861827361 | (37.7822955319647, -122.413861827361) | 7 | 10 | 9 | 28852 | 36 | ||
80146 | 6956 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004409.9923 | 2110521.0663 | 37.7753379822624 | -122.428226083232 | (37.7753379822624, -122.428226083232) | 7 | 9 | 11 | 28852 | 10 | ||
80324 | 244442 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 426 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004368.5048 | 2109638.1605 | 37.7729113912635 | -122.428306658376 | (37.7729113912635, -122.428306658376) | 7 | 9 | 11 | 28852 | 10 | |||
80595 | 244162 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 435 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004443.6077 | 2109779.1601 | 37.7733027911188 | -122.428056918276 | (37.7733027911188, -122.428056918276) | 7 | 9 | 11 | 28852 | 10 | |||
80932 | 6877 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 240 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/2002 12:00:00 AM | 12 | 3X3 | 6006250.63337 | 2110777.45516 | 37.7761459385303 | -122.421877085169 | (37.7761459385303, -122.421877085169) | 7 | 9 | 11 | 28852 | 10 | ||
82487 | 136869 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 870 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005850.85875 | 2112804.67339 | 37.7816896320989 | -122.423404163691 | (37.7816896320989, -122.423404163691) | 7 | 9 | 11 | 28852 | 41 | |||
83065 | 26659 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 522 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1999 12:00:00 AM | 3 | 3X3 | 6004893.91605 | 2110587.9747 | 37.7755490656586 | -122.42655684322 | (37.7755490656586, -122.42655684322) | 7 | 9 | 11 | 28852 | 10 | ||
83070 | 39419 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
83826 | 241746 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 476 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6004708.10959 | 2110374.51377 | 37.7749524482337 | -122.427184384751 | (37.7749524482337, -122.427184384751) | 7 | 9 | 11 | 28852 | 10 | |||
84727 | 242254 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 151 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006228.14158 | 2110372.18963 | 37.7750319087274 | -122.421926095532 | (37.7750319087274, -122.421926095532) | 7 | 9 | 11 | 28852 | 10 | |||
84978 | 112822 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650-680 Webster St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6004061.79304 | 2111077.33144 | 37.776845641647 | -122.429470263541 | (37.776845641647, -122.429470263541) | 7 | 9 | 11 | 28852 | 10 | |||
86150 | 258107 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 885 Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4X4 | 6006124.86369 | 2113018.24445 | 37.7822915069765 | -122.422471414725 | (37.7822915069765, -122.422471414725) | 7 | 9 | 11 | 28852 | 41 | ||||
88398 | 16850 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/1995 12:00:00 AM | 3 | 4X6 | 6006257.87931 | 2110498.54999 | 37.7753805408795 | -122.421832203671 | (37.7753805408795, -122.421832203671) | 7 | 9 | 11 | 28852 | 10 | ||
88783 | 245846 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 301 Oak St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 6005500.1805 | 2110269.8913 | 37.7747099408336 | -122.424436996012 | (37.7747099408336, -122.424436996012) | 7 | 9 | 11 | 28852 | 10 | |||
89557 | 88596 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150-198X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2008 12:00:00 AM | 3x3 | Permit Number 51541 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | ||
89696 | 142269 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 522 FELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004900.0589 | 2110592.222 | 37.7755610749768 | -122.426535896105 | (37.7755610749768, -122.426535896105) | 7 | 9 | 11 | 28852 | 10 | |||
89886 | 39406 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
90699 | 244163 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 435 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004467.3499 | 2109782.0673 | 37.7733121168049 | -122.427974997936 | (37.7733121168049, -122.427974997936) | 7 | 9 | 11 | 28852 | 10 | |||
91022 | 138836 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 658 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6004068.7691 | 2111019.0811 | 37.7766860955358 | -122.429441976219 | (37.7766860955358, -122.429441976219) | 7 | 9 | 11 | 28852 | 10 | |||
91161 | 79439 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 360 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2007 12:00:00 AM | 4 | 2x3 | Permit Number 49769 | 6004809.08231089 | 2110052.92705889 | 37.7740751590965 | -122.426812191246 | (37.7740751590965, -122.426812191246) | 7 | 9 | 11 | 28852 | 10 | |
91230 | 86827 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 360 Lily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2007 12:00:00 AM | 4 | 2x3 | Permit Number 49769 | 6004805.6 | 2110066.6 | 37.7741125047722 | -122.426825211107 | (37.7741125047722, -122.426825211107) | 7 | 9 | 11 | 28852 | 10 | |
91392 | 241750 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 124 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6004255.52528 | 2109336.25652 | 37.7720760430934 | -122.428675942734 | (37.7720760430934, -122.428675942734) | 7 | 9 | 11 | 28852 | 10 | |||
91625 | 112820 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 650-680 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6004066.01845 | 2111039.33609 | 37.776741555013 | -122.42945293633 | (37.776741555013, -122.42945293633) | 7 | 9 | 11 | 28852 | 10 | ||||
92304 | 244207 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 423 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004505.1436 | 2109785.9436 | 37.7733248982547 | -122.42784454055 | (37.7733248982547, -122.42784454055) | 7 | 9 | 11 | 28852 | 10 | |||
94295 | 112302 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25x WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6005453 | 2109246 | 37.7718959184753 | -122.424527356528 | (37.7718959184753, -122.424527356528) | 7 | 9 | 5 | 28852 | 10 | ||||
96518 | 16908 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 457 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2000 12:00:00 AM | 6 | 3X3 | 6004827.26441 | 2110175.13515 | 37.7744117407488 | -122.426758000899 | (37.7744117407488, -122.426758000899) | 7 | 9 | 11 | 28852 | 10 | ||
96739 | 39416 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
99884 | 142231 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 550 LINDEN ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004652.3755 | 2110709.3024 | 37.7758685439755 | -122.42740103573 | (37.7758685439755, -122.42740103573) | 7 | 9 | 11 | 28852 | 10 | |||
100071 | 57525 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1976 12:00:00 AM | 9 | Permit Number 16384 | 6005330.9453 | 2111340.195 | 37.7776391759665 | -122.42509858662 | (37.7776391759665, -122.42509858662) | 7 | 9 | 11 | 28852 | 10 | ||
100589 | 244154 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 475 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004268.2061 | 2109756.387 | 37.7732303365648 | -122.428662032831 | (37.7732303365648, -122.428662032831) | 7 | 9 | 11 | 28852 | 10 | |||
101237 | 39415 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
101250 | 91174 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2008 12:00:00 AM | 3X3 | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | ||
101425 | 16881 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
103272 | 6879 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 250X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/17/2000 12:00:00 AM | 6 | 3X3 | 6006196.77084 | 2110836.17136 | 37.7763041212863 | -122.422067582673 | (37.7763041212863, -122.422067582673) | 7 | 9 | 11 | 28852 | 10 | ||
104831 | 108619 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150-198X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005405 | 2109611 | 37.7728954095296 | -122.424719362301 | (37.7728954095296, -122.424719362301) | 7 | 9 | 11 | 28852 | 10 | |||||
106383 | 122643 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
108036 | 246600 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Waller St | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6005541.07514 | 2109239.29711 | 37.771882487431 | -122.424222221193 | (37.771882487431, -122.424222221193) | 7 | 9 | 5 | 28852 | 10 | |||
108494 | 51845 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Permit Number 48071 | 6010129.68999 | 2114173.2637 | 37.7856880242154 | -122.408697941478 | (37.7856880242154, -122.408697941478) | 14 | 10 | 10 | 28852 | 36 | ||
108735 | 244140 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 441 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004356.7646 | 2109602.6495 | 37.7728132224038 | -122.428344737687 | (37.7728132224038, -122.428344737687) | 7 | 9 | 11 | 28852 | 10 | |||
108933 | 244160 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 447 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004406.7831 | 2109774.7993 | 37.7732887339473 | -122.428183988801 | (37.7732887339473, -122.428183988801) | 7 | 9 | 11 | 28852 | 10 | |||
111953 | 136862 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 887 Eddy St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6006248.76357 | 2113152.51573 | 37.7826671717833 | -122.422052317182 | (37.7826671717833, -122.422052317182) | 7 | 9 | 11 | 28852 | 41 | |||
113225 | 16854 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Oak St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x4 | 6006257.87931 | 2110498.54999 | 37.7753805408795 | -122.421832203671 | (37.7753805408795, -122.421832203671) | 7 | 9 | 11 | 28852 | 10 | |||
113287 | 241641 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 65 Laussat St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6004373.36831 | 2109264.69738 | 37.7718862277038 | -122.428263213293 | (37.7718862277038, -122.428263213293) | 7 | 9 | 11 | 28852 | 10 | |||
113471 | 69229 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 542 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 10 | Permit Number 33282 | 6005165.1631 | 2111316.2461 | 37.7775640517559 | -122.42567037892 | (37.7775640517559, -122.42567037892) | 7 | 9 | 11 | 28852 | 10 | |
114253 | 136863 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 887 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/09/2015 02:32:00 PM | 5 | Width 4ft | 6006265.06799 | 2113155.12305 | 37.7826752504065 | -122.421996096038 | (37.7826752504065, -122.421996096038) | 7 | 9 | 11 | 28852 | 41 | ||
114459 | 32161 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
117091 | 244164 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 423 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004535.6693 | 2109790.3044 | 37.7733385987508 | -122.427739258675 | (37.7733385987508, -122.427739258675) | 7 | 9 | 11 | 28852 | 10 | |||
117284 | 244441 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 422 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004403.3913 | 2109642.0368 | 37.7729240085911 | -122.428186258105 | (37.7729240085911, -122.428186258105) | 7 | 9 | 11 | 28852 | 10 | |||
117374 | 39417 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
117651 | 6949 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/24/1995 12:00:00 AM | 3 | 3X3 | 6004493.7 | 2110528.4326 | 37.7753629442722 | -122.427937043837 | (37.7753629442722, -122.427937043837) | 7 | 9 | 11 | 28852 | 10 | ||
118145 | 69126 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 455 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/17/2004 12:00:00 AM | 4 | Permit Number 47616 | 6005218.3841 | 2110768.119 | 37.7760620356959 | -122.425447251868 | (37.7760620356959, -122.425447251868) | 7 | 9 | 11 | 28852 | 10 | |
119586 | 242256 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006379.21644 | 2110444.90431 | 37.7752400846936 | -122.421408658888 | (37.7752400846936, -122.421408658888) | 7 | 9 | 11 | 28852 | 10 | |||
119614 | 136872 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 280 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6006094.12679 | 2110752.63833 | 37.7760689700487 | -122.422416720665 | (37.7760689700487, -122.422416720665) | 7 | 9 | 11 | 28852 | 10 | |||
119718 | 242258 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006281.32025 | 2110433.89565 | 37.7752043375461 | -122.421746522504 | (37.7752043375461, -122.421746522504) | 7 | 9 | 11 | 28852 | 10 | |||
121987 | 7829 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 828 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6006196.28269 | 2112899.08523 | 37.7819683535895 | -122.422215867866 | (37.7819683535895, -122.422215867866) | 7 | 9 | 11 | 28852 | 41 | |||
122437 | 112355 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 333 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009378.26981 | 2114060.90388 | 37.7853373965427 | -122.411289710245 | (37.7853373965427, -122.411289710245) | 14 | 10 | 9 | 28852 | 36 | |||
122466 | 7843 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 825X Eddy St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/09/2015 02:27:00 PM | 3 | 4X4 | 6006486.55974 | 2113185.80052 | 37.7827719725902 | -122.421232006807 | (37.7827719725902, -122.421232006807) | 7 | 9 | 11 | 28852 | 41 | ||
123667 | 244157 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 459 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6004342.3399 | 2109765.5932 | 37.773259809817 | -122.428406250364 | (37.773259809817, -122.428406250364) | 7 | 9 | 11 | 28852 | 10 | |||
123921 | 7836 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 880 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x4 | 6006170.38861 | 2113076.8908 | 37.7824551035672 | -122.422318086628 | (37.7824551035672, -122.422318086628) | 7 | 9 | 11 | 28852 | 41 | |||
124569 | 242255 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6006442.07227 | 2110453.56934 | 37.7752674204858 | -122.421191841332 | (37.7752674204858, -122.421191841332) | 7 | 9 | 11 | 28852 | 10 | |||
125668 | 24442 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 436 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1995 12:00:00 AM | 6 | 3X3 | 6005321.58788 | 2110669.60903 | 37.7757973817654 | -122.425083231452 | (37.7757973817654, -122.425083231452) | 7 | 9 | 11 | 28852 | 10 | ||
129801 | 32160 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
131757 | 91175 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2008 12:00:00 AM | Permit Number 51891 | 6007496.395175 | 2110885.881534 | 37.7765138277066 | -122.41757533494 | (37.7765138277066, -122.41757533494) | 7 | 2 | 9 | 28852 | 36 | |||
132318 | 41449 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 285 Linden St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | Permit Number 42044 | 6006044.1196898 | 2110866.86670454 | 37.7763797924386 | -122.42259782775 | (37.7763797924386, -122.42259782775) | 7 | 9 | 11 | 28852 | 10 | |||
133992 | 16886 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X4 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
134241 | 51844 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 138 Cyril Magnin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2017 12:00:00 AM | 3 | Permit Number 48071 | 6010139.87184 | 2114143.25233 | 37.7856061904094 | -122.408660597109 | (37.7856061904094, -122.408660597109) | 14 | 10 | 10 | 28852 | 36 | ||
134430 | 39408 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401Bldg #8 Page St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40928 | 6004636.26366245 | 2109802.84186708 | 37.773378713416 | -122.427392181999 | (37.773378713416, -122.427392181999) | 7 | 9 | 11 | 28852 | 10 | |||
134512 | 244439 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 412 Rose St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6004528.4013 | 2109657.7841 | 37.7729743191617 | -122.427754955677 | (37.7729743191617, -122.427754955677) | 7 | 9 | 11 | 28852 | 10 | |||
134822 | 7838 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 880 Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6006162.87093 | 2113106.46808 | 37.7825358914721 | -122.422346196719 | (37.7825358914721, -122.422346196719) | 7 | 9 | 11 | 28852 | 41 | |||
134859 | 32138 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1995 12:00:00 AM | Permit Number 35496 | 6004564.35276407 | 2110630.82762794 | 37.7756480927458 | -122.427699936535 | (37.7756480927458, -122.427699936535) | 7 | 9 | 11 | 28852 | 10 | ||
135549 | 244438 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 412 Rose St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6004558.4425 | 2109662.145 | 37.7729879924477 | -122.427651350234 | (37.7729879924477, -122.427651350234) | 7 | 9 | 11 | 28852 | 10 | |||
135851 | 244159 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 447 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6004389.3398 | 2109772.3766 | 37.7732810948415 | -122.42824415487 | (37.7732810948415, -122.42824415487) | 7 | 9 | 11 | 28852 | 10 | |||
136101 | 63591 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778496 | 6005273.78540872 | 2109033.97398783 | 37.7713036237874 | -122.425132184034 | (37.7713036237874, -122.425132184034) | 7 | 9 | 5 | 28852 | 10 | |
136268 | 122644 | Private 9 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300X Oak St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2016 12:00:00 AM | 3 | 3X3 | 6005538.3415996 | 2110328.2060015 | 37.7748722137679 | -122.42430913733 | (37.7748722137679, -122.42430913733) | 7 | 9 | 11 | 28852 | 10 | ||
136465 | 32158 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 600 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1995 12:00:00 AM | Permit Number 35508 | 6004513.09393523 | 2110705.7048246 | 37.77585078754 | -122.42788259012 | (37.77585078754, -122.42788259012) | 7 | 9 | 11 | 28852 | 10 | |||
136764 | 241751 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 124 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004258.56813 | 2109322.98446 | 37.7720397734594 | -122.428664471011 | (37.7720397734594, -122.428664471011) | 7 | 9 | 11 | 28852 | 10 | |||
139255 | 92779 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/15/2009 12:00:00 AM | 3x3 | Permit Number 52997 | 6006262 | 2110430 | 37.775192551515 | -122.421813078941 | (37.775192551515, -122.421813078941) | 7 | 9 | 11 | 28852 | 10 | ||
139677 | 244166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 415 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004592.3599 | 2109799.0261 | 37.773365753083 | -122.427543779439 | (37.773365753083, -122.427543779439) | 7 | 9 | 11 | 28852 | 10 | |||
140057 | 241744 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 309 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004942.4963 | 2110033.9852 | 37.7740306916897 | -122.426349339975 | (37.7740306916897, -122.426349339975) | 7 | 9 | 11 | 28852 | 10 | |||
141648 | 107633 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 633 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6009218.01318 | 2115223.86517 | 37.78852161892 | -122.411926362828 | (37.78852161892, -122.411926362828) | 5 | 1 | 10 | 28852 | 21 | ||||
142679 | 116983 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 437 ROSE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004435 | 2109631 | 37.7728954926097 | -122.42807613315 | (37.7728954926097, -122.42807613315) | 7 | 9 | 11 | 28852 | 10 | ||||
143265 | 88282 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 368 Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51279 | 6005923.8 | 2112690.4 | 37.7813799818954 | -122.423143695986 | (37.7813799818954, -122.423143695986) | 7 | 9 | 11 | 28852 | 41 | ||
143867 | 16858 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 150 Oak St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2012 12:00:00 AM | 3 | 4X4 | 6006257.87931 | 2110498.54999 | 37.7753805408795 | -122.421832203671 | (37.7753805408795, -122.421832203671) | 7 | 9 | 11 | 28852 | 10 | ||
144051 | 136866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 750 Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6006256.67587 | 2112854.44573 | 37.7818491907342 | -122.422003762777 | (37.7818491907342, -122.422003762777) | 7 | 9 | 11 | 28852 | 41 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );