trees
237 rows where Supervisor Districts = 5 and qSpecies_id = 95 sorted by SiteOrder descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38847 | 233542 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 660 Clipper St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001023.66433 | 2100904.77572 | 37.748741823193 | -122.439250743354 | (37.748741823193, -122.439250743354) | 2 | 4 | 5 | 28862 | 22 | |
148302 | 9320 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
165955 | 233515 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1001 San Jose Ave | 78 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005400.68613 | 2097518.02448 | 37.739690679175 | -122.423874221345 | (37.739690679175, -122.423874221345) | 2 | 7 | 5 | 28859 | 2 | |||
10468 | 233514 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1001 San Jose Ave | 77 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 6005401.35781 | 2097519.59788 | 37.7396950372957 | -122.423872010811 | (37.7396950372957, -122.423872010811) | 2 | 7 | 5 | 28859 | 2 | |||
163493 | 233513 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1001 San Jose Ave | 73 | Front Yard : Yard | Tree | Private 2 | 0 | 6005382.19397 | 2097506.55271 | 37.7396581363049 | -122.423937343859 | (37.7396581363049, -122.423937343859) | 2 | 7 | 5 | 28859 | 2 | ||||
23939 | 233545 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 91 Gold Mine Dr | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001696.74822 | 2099105.93964 | 37.7438409236316 | -122.436794475402 | (37.7438409236316, -122.436794475402) | 2 | 7 | 5 | 63 | 22 | |||
143292 | 233541 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 660 Clipper St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001052.25493 | 2100904.1832 | 37.7487418231882 | -122.439151834995 | (37.7487418231882, -122.439151834995) | 2 | 4 | 5 | 28862 | 22 | |
150312 | 233516 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1101 San Jose Ave | 62 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 8ft | 6005012.256 | 2096572.07245 | 37.737071372249 | -122.425149956418 | (37.737071372249, -122.425149956418) | 2 | 7 | 5 | 28859 | 2 | |||
20293 | 254534 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 737 Buena Vista Ave West | 6 | Front Yard : Yard | Tree | Private 2 | 02/27/2018 12:00:00 AM | 3 | 10X10 | 5999910.14564 | 2107959.614 | 37.7680492454315 | -122.443607999122 | (37.7680492454315, -122.443607999122) | 15 | 5 | 5 | 29492 | 9 | ||
122652 | 9318 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
180852 | 98066 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5235 Diamond Heights Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001081.8 | 2099374.5 | 37.7445433581402 | -122.43894005993 | (37.7445433581402, -122.43894005993) | 2 | 7 | 5 | 63 | 22 | |||
31464 | 233550 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4181 23rd St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6001978.75219 | 2102336.68489 | 37.7527278082485 | -122.436050510349 | (37.7527278082485, -122.436050510349) | 2 | 4 | 5 | 28862 | 22 | |||
54500 | 233949 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 204 Addison St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002692.85575 | 2097299.74902 | 37.738938104903 | -122.433221140644 | (37.738938104903, -122.433221140644) | 2 | 7 | 5 | 63 | 7 | |||
33991 | 233554 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 650 27th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 6002271.55455 | 2100062.74856 | 37.7465007477171 | -122.434875343722 | (37.7465007477171, -122.434875343722) | 2 | 7 | 5 | 63 | 22 | |||
48142 | 233572 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1457 Noe St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003319.15516 | 2099739.21072 | 37.7456718120051 | -122.43122976824 | (37.7456718120051, -122.43122976824) | 2 | 7 | 5 | 63 | 22 | |||
59365 | 18544 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 61X Quartz Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 5999058.055369 | 2099782.1056805 | 37.7455471938994 | -122.445967045704 | (37.7455471938994, -122.445967045704) | 2 | 7 | 5 | 63 | 22 | |||
72529 | 233569 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 526 Duncan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003042.82855 | 2099802.56387 | 37.7458301016873 | -122.432189787355 | (37.7458301016873, -122.432189787355) | 2 | 7 | 5 | 63 | 22 | |||
125252 | 9316 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
132579 | 233565 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 537 Duncan St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003042.37062 | 2099780.38707 | 37.7457691834059 | -122.432189787337 | (37.7457691834059, -122.432189787337) | 2 | 7 | 5 | 63 | 22 | |||
163330 | 233948 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 204 Addison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002699.14748 | 2097262.07033 | 37.7388350048341 | -122.433196695276 | (37.7388350048341, -122.433196695276) | 2 | 7 | 5 | 63 | 7 | |||
185640 | 233594 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 153 Upper Ter | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999783.99245 | 2106717.08599 | 37.7646303787236 | -122.44395506189 | (37.7646303787236, -122.44395506189) | 15 | 5 | 5 | 29492 | 3 | |||
14941 | 22854 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 136 Turquoise Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5999388.6872646 | 2099024.8421573 | 37.7434868046411 | -122.444769353708 | (37.7434868046411, -122.444769353708) | 2 | 7 | 5 | 63 | 7 | |||
21728 | 233568 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 526 Duncan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003041.20009 | 2099796.6014 | 37.7458136378054 | -122.4321949926 | (37.7458136378054, -122.4321949926) | 2 | 7 | 5 | 63 | 22 | |||
30205 | 233564 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 537 Duncan St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003043.53097 | 2099778.26462 | 37.745763421443 | -122.43218562347 | (37.745763421443, -122.43218562347) | 2 | 7 | 5 | 63 | 22 | |||
31343 | 233540 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 660 Clipper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779879 | 6001114.06108 | 2100904.6606 | 37.7487466507355 | -122.438938144387 | (37.7487466507355, -122.438938144387) | 2 | 4 | 5 | 28862 | 22 | |
59345 | 233512 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 276 Bemis St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6002977.74121 | 2096270.78168 | 37.7361289537975 | -122.432162676393 | (37.7361289537975, -122.432162676393) | 2 | 7 | 5 | 63 | 7 | ||||
70609 | 233553 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 916 Alvarado St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 3ft | 6000357.83918 | 2102588.4411 | 37.7533268502794 | -122.441673968381 | (37.7533268502794, -122.441673968381) | 2 | 4 | 5 | 28862 | 22 | |||
81853 | 233947 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 204 Addison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002729.83296 | 2097128.04747 | 37.7384687496377 | -122.433081026271 | (37.7384687496377, -122.433081026271) | 2 | 7 | 5 | 63 | 7 | |||
86750 | 233556 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1831 Castro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6002654.10578 | 2100168.36427 | 37.7468124563267 | -122.433560071764 | (37.7468124563267, -122.433560071764) | 2 | 7 | 5 | 63 | 22 | ||||
92555 | 9315 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
95152 | 211430 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 192 Mangels Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6000196.52602 | 2095258.93091 | 37.7331925683786 | -122.441705847568 | (37.7331925683786, -122.441705847568) | 9 | 7 | 5 | 63 | 40 | ||||
97999 | 18543 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 61X Quartz Way | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2x2 | 5999058.055369 | 2099782.1056805 | 37.7455471938994 | -122.445967045704 | (37.7455471938994, -122.445967045704) | 2 | 7 | 5 | 63 | 22 | |||
106485 | 233579 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 276 Bemis St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 4ft | 6002979.39187 | 2096268.21022 | 37.7361219867449 | -122.432156785813 | (37.7361219867449, -122.432156785813) | 2 | 7 | 5 | 63 | 7 | |||
108571 | 233593 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 153 Upper Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999778.9401 | 2106697.07391 | 37.7645751423391 | -122.443971098582 | (37.7645751423391, -122.443971098582) | 15 | 5 | 5 | 29492 | 3 | |||
114248 | 233537 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1338 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001357.95069 | 2099754.76956 | 37.7456031964469 | -122.438012421832 | (37.7456031964469, -122.438012421832) | 2 | 4 | 5 | 63 | 22 | |||
124106 | 233956 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3 Penny Ln | 3 | Back Yard : Yard | Tree | Private 2 | 1 | Width 2ft | 6002403.32332 | 2096434.71653 | 37.7365464964208 | -122.434160386288 | (37.7365464964208, -122.434160386288) | 2 | 7 | 5 | 63 | 7 | |||
144970 | 233534 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 31 Quartz Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5999106.34001 | 2099792.15312 | 37.7455775387887 | -122.445800807972 | (37.7455775387887, -122.445800807972) | 2 | 7 | 5 | 63 | 22 | |||
169878 | 233544 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 91 Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6001580.78817 | 2099098.04809 | 37.743812664228 | -122.437194872452 | (37.743812664228, -122.437194872452) | 2 | 7 | 5 | 63 | 22 | |||
170864 | 9339 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 187 Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 6000798.3699591 | 2098653.6744451 | 37.7425480118371 | -122.439868429368 | (37.7425480118371, -122.439868429368) | 2 | 7 | 5 | 63 | 7 | |||
91420 | 233560 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500x 27th St | 20 | Median : Cutout | Tree | DPW 1 | 4 | Width 4ft | 6002902.39579 | 2100065.70765 | 37.7465446697032 | -122.432694177509 | (37.7465446697032, -122.432694177509) | 2 | 7 | 5 | 63 | 22 | |||
17728 | 233533 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 31 Quartz Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5999070.48463 | 2099792.05863 | 37.745575232026 | -122.445924783116 | (37.745575232026, -122.445924783116) | 2 | 7 | 5 | 63 | 22 | |||
24514 | 233561 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 560 27th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 4ft | 6002675.90697 | 2100082.82266 | 37.7465788160682 | -122.433478573399 | (37.7465788160682, -122.433478573399) | 2 | 7 | 5 | 63 | 22 | |||
25035 | 11455 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 9 Jade Pl | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 6000702.8384041 | 2098560.6268459 | 37.7422870867037 | -122.440192077523 | (37.7422870867037, -122.440192077523) | 2 | 7 | 5 | 63 | 7 | ||||
32019 | 233567 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 526 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 6003041.12582 | 2099793.00501 | 37.7458037587468 | -122.432194992624 | (37.7458037587468, -122.432194992624) | 2 | 7 | 5 | 63 | 22 | |||
44426 | 233547 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4438 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6001071.14985 | 2101157.00952 | 37.7494370989653 | -122.439104614294 | (37.7494370989653, -122.439104614294) | 2 | 4 | 5 | 28862 | 22 | |||
48058 | 233536 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1338 Douglass St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6001348.41294 | 2099754.39195 | 37.7456016172129 | -122.43804537481 | (37.7456016172129, -122.43804537481) | 2 | 4 | 5 | 63 | 22 | |||
54862 | 251605 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 48R Amber Dr | 2 | Back Yard : Yard | Tree | Private 2 | 5999482 | 2100041 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | 2 | 7 | 5 | 63 | 22 | |||||
63481 | 233552 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4165 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6002130.8284 | 2102343.64409 | 37.7527555550267 | -122.435525102106 | (37.7527555550267, -122.435525102106) | 2 | 4 | 5 | 28862 | 22 | |||
85427 | 233592 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 153 Upper Ter | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5999768.90882 | 2106676.50531 | 37.7645180938672 | -122.444004315968 | (37.7645180938672, -122.444004315968) | 15 | 5 | 5 | 29492 | 3 | |||
103683 | 233589 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4525 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999084.08203 | 2105681.95366 | 37.7617482143332 | -122.44630138682 | (37.7617482143332, -122.44630138682) | 15 | 5 | 5 | 29492 | 3 | |||
107904 | 1365 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 25 Amethyst Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 1X1 | 5999130.7643175 | 2100002.9435196 | 37.7461577128307 | -122.445731509099 | (37.7461577128307, -122.445731509099) | 2 | 7 | 5 | 63 | 22 | |||
108601 | 9338 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 187 Gold Mine Dr | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 6000798.3699591 | 2098653.6744451 | 37.7425480118371 | -122.439868429368 | (37.7425480118371, -122.439868429368) | 2 | 7 | 5 | 63 | 7 | |||
131460 | 233543 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 91 Gold Mine Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001553.31466 | 2099095.46636 | 37.7438040136364 | -122.437289684382 | (37.7438040136364, -122.437289684382) | 2 | 7 | 5 | 63 | 22 | |||
133277 | 3462 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 71 Cameo Way | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 5999685.8115095 | 2099510.7695448 | 37.7448379963746 | -122.443776879152 | (37.7448379963746, -122.443776879152) | 2 | 7 | 5 | 63 | 22 | |||
133609 | 233558 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1832 Castro St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6002599.08836 | 2100146.34807 | 37.7467488832615 | -122.43374874323 | (37.7467488832615, -122.43374874323) | 2 | 7 | 5 | 63 | 22 | |||
144775 | 233955 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3 Penny Ln | 2 | Back Yard : Yard | Tree | Private 2 | 4 | Width 2ft | 6002401.2653 | 2096437.12023 | 37.7365529796221 | -122.434167673516 | (37.7365529796221, -122.434167673516) | 2 | 7 | 5 | 63 | 7 | |||
169899 | 233563 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 537 Duncan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6003044.06499 | 2099774.95569 | 37.7457543661711 | -122.432183540644 | (37.7457543661711, -122.432183540644) | 2 | 7 | 5 | 63 | 22 | |||
178158 | 227557 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4648 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000417.67775 | 2104660.60062 | 37.759019904154 | -122.441615728291 | (37.759019904154, -122.441615728291) | 2 | 4 | 5 | 28862 | 3 | |||
187627 | 233549 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4181 23rd St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 6001924.74366 | 2102332.8937 | 37.7527143301036 | -122.436237009941 | (37.7527143301036, -122.436237009941) | 2 | 4 | 5 | 28862 | 22 | |||
193069 | 253276 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 998 Douglass St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/14/2017 12:00:00 AM | 3 | 3x3 | 6001226 | 2100921 | 37.7487978830785 | -122.438552231639 | (37.7487978830785, -122.438552231639) | 2 | 4 | 5 | 28862 | 22 | ||
106264 | 233559 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 500x 27th St | 19 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6002897.95217 | 2100065.79943 | 37.746544669698 | -122.432709549607 | (37.746544669698, -122.432709549607) | 2 | 7 | 5 | 63 | 22 | |||
150260 | 233517 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Hwy 101 Southbound | 12 | Back Yard : Yard | Tree | Private 2 | 7 | 6005882.82166 | 2108930.28485 | 37.7710533043986 | -122.423018127005 | (37.7710533043986, -122.423018127005) | 8 | 2 | 5 | 28853 | 19 | ||||
52206 | 233518 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 100 Hwy 101 Southbound | 10 | Back Yard : Yard | Tree | Private 2 | 7 | 6005873.99672 | 2108944.2877 | 37.7710912548825 | -122.423049648243 | (37.7710912548825, -122.423049648243) | 8 | 2 | 5 | 28853 | 19 | ||||
129713 | 233950 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 204 Addison St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002636.1935 | 2097490.3386 | 37.739458205327 | -122.433430668315 | (37.739458205327, -122.433430668315) | 2 | 7 | 5 | 63 | 7 | |||
356 | 233580 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1317 Clayton St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5999035.80578 | 2105154.14715 | 37.7602962318988 | -122.44643038196 | (37.7602962318988, -122.44643038196) | 15 | 5 | 5 | 28862 | 12 | |||
429 | 259715 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 210 Gold Mine Dr | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000723 | 2098465 | 37.7420256658379 | -122.440115509428 | (37.7420256658379, -122.440115509428) | 2 | 7 | 5 | 63 | 7 | ||||
3135 | 65233 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4020 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/24/1989 12:00:00 AM | Permit Number 28024 | 6003001.20160757 | 2102438.8847262 | 37.7530664584471 | -122.432521998877 | (37.7530664584471, -122.432521998877) | 2 | 4 | 5 | 28862 | 22 | ||
7743 | 233523 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 288 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004756.81916 | 2101985.3622 | 37.7519205920806 | -122.426418438458 | (37.7519205920806, -122.426418438458) | 2 | 4 | 5 | 28862 | 22 | |||
10301 | 233590 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 303 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5999654.30846 | 2105211.96069 | 37.7604902804205 | -122.444295432814 | (37.7604902804205, -122.444295432814) | 15 | 5 | 5 | 28862 | 3 | |||
10524 | 18541 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 61X Quartz Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 5999058.055369 | 2099782.1056805 | 37.7455471938994 | -122.445967045704 | (37.7455471938994, -122.445967045704) | 2 | 7 | 5 | 63 | 22 | |||
13903 | 233957 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 15 Penny Ln | 1 | Back Yard : Yard | Tree | Private 2 | 5 | Width 2ft | 6002524.54294 | 2096295.78541 | 37.7361719027113 | -122.433731352142 | (37.7361719027113, -122.433731352142) | 2 | 7 | 5 | 63 | 7 | |||
16170 | 233531 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 242 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999670.17675 | 2099218.0015 | 37.7440332337389 | -122.443809911325 | (37.7440332337389, -122.443809911325) | 2 | 7 | 5 | 63 | 22 | |||
18749 | 227563 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4565 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | Permit Number 784780 | 6000806.39418 | 2104634.53115 | 37.7589704630323 | -122.440269497142 | (37.7589704630323, -122.440269497142) | 2 | 4 | 5 | 28862 | 38 | ||
20385 | 251602 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 44R Amber Dr | 1 | Back Yard : Yard | Tree | Private 2 | 5999509 | 2100035 | 37.7462673204657 | -122.444425925791 | (37.7462673204657, -122.444425925791) | 2 | 7 | 5 | 63 | 22 | |||||
21107 | 58677 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 142 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20288 | 6004283.38599027 | 2097405.52604754 | 37.7393186445117 | -122.427729355445 | (37.7393186445117, -122.427729355445) | 2 | 7 | 5 | 63 | 7 | ||
21422 | 233581 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 448 Alvarado St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003457.11059 | 2102748.48945 | 37.7539424029305 | -122.430967471992 | (37.7539424029305, -122.430967471992) | 2 | 4 | 5 | 28862 | 22 | |||
22333 | 1349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 248 Amber Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 5999719.4742299 | 2099231.8279857 | 37.7440740097154 | -122.443640445364 | (37.7440740097154, -122.443640445364) | 2 | 7 | 5 | 63 | 22 | |||
23058 | 233551 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4165 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002110.79471 | 2102342.32619 | 37.7527507985361 | -122.435594287848 | (37.7527507985361, -122.435594287848) | 2 | 4 | 5 | 28862 | 22 | |||
23097 | 60652 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 125 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20284 | 6004314.87851567 | 2097476.26675857 | 37.7395146637963 | -122.427625506935 | (37.7395146637963, -122.427625506935) | 2 | 7 | 5 | 63 | 7 | ||
24315 | 65352 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 252 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28187 | 6001484.29754015 | 2096470.76224415 | 37.736593266506 | -122.437340424735 | (37.736593266506, -122.437340424735) | 2 | 7 | 5 | 63 | 7 | ||
24731 | 3463 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 76 Cameo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 5999748.3728 | 2099465.41355 | 37.7447170278662 | -122.44355729713 | (37.7447170278662, -122.44355729713) | 2 | 7 | 5 | 63 | 22 | |||
24949 | 233586 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 4175 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002583.68203 | 2104117.56572 | 37.7576520299212 | -122.434085852276 | (37.7576520299212, -122.434085852276) | 2 | 4 | 5 | 28862 | 3 | |||
27708 | 62501 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 553 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1986 12:00:00 AM | Permit Number 22676 | 6001215.07825091 | 2103108.27650352 | 37.7548029979447 | -122.438746711531 | (37.7548029979447, -122.438746711531) | 2 | 4 | 5 | 28862 | 22 | ||
27918 | 233578 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 878 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6000785.56931 | 2102019.64805 | 37.7517894430431 | -122.440154008017 | (37.7517894430431, -122.440154008017) | 2 | 4 | 5 | 28862 | 22 | |||
28451 | 64133 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 610 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24904 | 6002610.61709759 | 2098908.05619778 | 37.7433494776015 | -122.433620394679 | (37.7433494776015, -122.433620394679) | 2 | 7 | 5 | 63 | 22 | ||
28918 | 5016 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 5319 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2 | 6001623.7265968 | 2098938.5095602 | 37.7433770497021 | -122.43703498209 | (37.7433770497021, -122.43703498209) | 2 | 7 | 5 | 63 | 22 | |||
31580 | 233584 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 347 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004048.93084 | 2103906.56169 | 37.7571557120869 | -122.429003379596 | (37.7571557120869, -122.429003379596) | 2 | 4 | 5 | 28862 | 3 | |||
31851 | 233577 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 829 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 6001011.85937 | 2101991.3944 | 37.7517247457985 | -122.439369443051 | (37.7517247457985, -122.439369443051) | 2 | 4 | 5 | 28862 | 22 | |||
33800 | 56191 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 261 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32887 | 6003447.98693949 | 2101534.97756971 | 37.7506098682705 | -122.430912424073 | (37.7506098682705, -122.430912424073) | 2 | 4 | 5 | 28862 | 22 | ||
34674 | 233585 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 343 Cumberland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003385.78389 | 2104458.12953 | 37.7586326264222 | -122.43133616794 | (37.7586326264222, -122.43133616794) | 2 | 4 | 5 | 28862 | 3 | |||
36225 | 22855 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 139 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 5999860.76134 | 2099112.81238 | 37.7437552784922 | -122.443143361677 | (37.7437552784922, -122.443143361677) | 2 | 7 | 5 | 63 | 22 | |||
36446 | 5031 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5310X Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001777 | 2098684 | 37.7426869370939 | -122.436486790385 | (37.7426869370939, -122.436486790385) | 2 | 7 | 5 | 63 | 7 | |||
38656 | 65308 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 64 Lapidge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1989 12:00:00 AM | Permit Number 28127 | 6005982.44079017 | 2105130.61413387 | 37.7606259299013 | -122.422403517998 | (37.7606259299013, -122.422403517998) | 2 | 4 | 5 | 28859 | 19 | ||
39199 | 65341 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 188 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1989 12:00:00 AM | Permit Number 28173 | 6001746.6239921 | 2095001.97603702 | 37.732575228117 | -122.436328365067 | (37.732575228117, -122.436328365067) | 9 | 7 | 5 | 63 | 40 | ||
39419 | 233571 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1457 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003319.27784 | 2099726.65625 | 37.7456373473043 | -122.431228448062 | (37.7456373473043, -122.431228448062) | 2 | 7 | 5 | 63 | 22 | |||
41371 | 62502 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 559 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/11/1986 12:00:00 AM | Permit Number 22677 | 6001216.54610272 | 2103082.94453689 | 37.754733525989 | -122.438739820196 | (37.754733525989, -122.438739820196) | 2 | 4 | 5 | 28862 | 22 | ||
41525 | 64413 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 125 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1988 12:00:00 AM | Permit Number 25260 | 6003685.70575404 | 2097659.19041399 | 37.7399813214783 | -122.429813955945 | (37.7399813214783, -122.429813955945) | 2 | 7 | 5 | 63 | 7 | ||
41626 | 233601 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 144 Moreland St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6002179.92831 | 2097515.63005 | 37.7395017532076 | -122.435010039698 | (37.7395017532076, -122.435010039698) | 2 | 7 | 5 | 63 | 7 | |||
41961 | 233532 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 31 Quartz Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999036.29821 | 2099791.08936 | 37.7455706185038 | -122.446042924359 | (37.7455706185038, -122.446042924359) | 2 | 7 | 5 | 63 | 22 | |||
42140 | 61736 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 221 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/29/1992 12:00:00 AM | Permit Number 21741 | 6003726.68800043 | 2100963.99534524 | 37.7490578720388 | -122.429907929601 | (37.7490578720388, -122.429907929601) | 2 | 4 | 5 | 28862 | 22 |
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) );