trees
379 rows where qSpecies_id = 86 sorted by Police Districts 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
192763 | 215327 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1301 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992028.3413 | 2098343.65136 | 37.7411936459769 | -122.470169759049 | (37.7411936459769, -122.470169759049) | 1 | 8 | 4 | 59 | 40 | |||
4496 | 74361 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 299 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 6005755.65434 | 2092345.08491 | 37.7255069657486 | -122.422279456248 | (37.7255069657486, -122.422279456248) | 9 | 7 | 7 | 309 | 5 | |||
5600 | 241053 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Coso Ave | 3 | Side Yard : Yard | Tree | Private 2 | 11 | Width 5ft | 6007672.87316 | 2099533.13544 | 37.7453517387841 | -122.416160625529 | (37.7453517387841, -122.416160625529) | 2 | 7 | 7 | 28859 | 2 | |||
8931 | 215339 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 637 Detroit St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5999420.83111 | 2095184.41503 | 37.7329437376643 | -122.444382272244 | (37.7329437376643, -122.444382272244) | 9 | 7 | 4 | 59 | 40 | |||
9034 | 179812 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1349 Cayuga Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 5999375.14619 | 2089880.54718 | 37.71837793826 | -122.444159228684 | (37.71837793826, -122.444159228684) | 9 | 7 | 6 | 28861 | 25 | |||
12934 | 16022 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 123 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6001242.37794 | 2094603.69246 | 37.7314529692816 | -122.438043142671 | (37.7314529692816, -122.438043142671) | 9 | 7 | 4 | 63 | 40 | |||
14728 | 62484 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 81 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 10 | Permit Number 22655 | 6000565.24487 | 2092874.98588 | 37.7266678079605 | -122.440260189157 | (37.7266678079605, -122.440260189157) | 9 | 7 | 6 | 28861 | 25 | |
20054 | 179816 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 300 Ellington Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 1ft | 5998896.47943 | 2087985.98749 | 37.713148590116 | -122.445677603554 | (37.713148590116, -122.445677603554) | 9 | 7 | 6 | 28861 | 25 | |||
20747 | 215303 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 5997546.26853 | 2094964.87379 | 37.7322337966419 | -122.450847264584 | (37.7322337966419, -122.450847264584) | 9 | 7 | 4 | 59 | 40 | ||||
21045 | 179811 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1367 Cayuga Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 0ft | 5999338.15399 | 2089837.49101 | 37.7182576053899 | -122.444284002399 | (37.7182576053899, -122.444284002399) | 9 | 7 | 6 | 28861 | 25 | |||
23212 | 179853 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5998760.78346 | 2089904.78247 | 37.7184094145512 | -122.446284557804 | (37.7184094145512, -122.446284557804) | 9 | 7 | 6 | 28861 | 25 | |||
24655 | 215338 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998226.11251 | 2096380.78786 | 37.7361604543418 | -122.448598839867 | (37.7361604543418, -122.448598839867) | 9 | 7 | 4 | 59 | 40 | |||
27027 | 179833 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 2ft | 6002155.36157 | 2093545.08036 | 37.7285981406774 | -122.434811114144 | (37.7285981406774, -122.434811114144) | 9 | 7 | 6 | 28861 | 25 | |||
27598 | 179854 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 339 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998465.19432 | 2089720.01475 | 37.7178851988142 | -122.447292991002 | (37.7178851988142, -122.447292991002) | 9 | 7 | 6 | 28861 | 25 | ||||
29990 | 215341 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 6000114.95424 | 2094335.27384 | 37.7306517731413 | -122.441921590428 | (37.7306517731413, -122.441921590428) | 9 | 7 | 4 | 63 | 40 | |||
33262 | 116307 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | |||
34915 | 215298 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6000134.87473 | 2094332.54938 | 37.7306454275316 | -122.441852526992 | (37.7306454275316, -122.441852526992) | 9 | 7 | 4 | 63 | 40 | |||
34996 | 31114 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 5 | Permit Number 34839 | 5998792.19171 | 2094330.53052 | 37.7305632843566 | -122.44649422303 | (37.7305632843566, -122.44649422303) | 9 | 7 | 4 | 28861 | 40 | |
35059 | 116297 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
35581 | 179842 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002649.41519 | 2093884.99893 | 37.7295595177473 | -122.433127421409 | (37.7295595177473, -122.433127421409) | 9 | 7 | 6 | 28861 | 25 | |||
37032 | 215337 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998231.9169 | 2096387.51631 | 37.7361792609492 | -122.448579256245 | (37.7361792609492, -122.448579256245) | 9 | 7 | 4 | 59 | 40 | |||
37296 | 179836 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 201 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 2ft | 6002646.43295 | 2094204.87454 | 37.7304376544756 | -122.433160577611 | (37.7304376544756, -122.433160577611) | 9 | 7 | 5 | 28861 | 25 | |||
38090 | 949 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1468 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/06/1990 12:00:00 AM | 6 | 3X6 | 6002168.03285 | 2093561.19975 | 37.7286431202677 | -122.434768461095 | (37.7286431202677, -122.434768461095) | 9 | 7 | 6 | 28861 | 25 | ||
40383 | 105515 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6002668.24171 | 2089385.75875 | 37.7172066783264 | -122.432741059164 | (37.7172066783264, -122.432741059164) | 9 | 7 | 6 | 28861 | 5 | |||
40385 | 215342 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5999549.56796 | 2093580.96212 | 37.7285483748934 | -122.443822037778 | (37.7285483748934, -122.443822037778) | 9 | 7 | 4 | 63 | 40 | |||
42725 | 215295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Burnside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6001248.26665 | 2095899.59415 | 37.7350115506281 | -122.43811558039 | (37.7350115506281, -122.43811558039) | 2 | 7 | 5 | 63 | 7 | |||
44377 | 116296 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
44578 | 179805 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1475 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5998972.41815 | 2089460.57977 | 37.7172018201812 | -122.445521103537 | (37.7172018201812, -122.445521103537) | 9 | 7 | 6 | 28861 | 25 | |||
46050 | 215344 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999563.31377 | 2093588.13313 | 37.7285688488645 | -122.443775032896 | (37.7285688488645, -122.443775032896) | 9 | 7 | 4 | 63 | 40 | |||
46559 | 179844 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 19 Camellia Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6003286.16791 | 2094080.48748 | 37.7301323849801 | -122.430940049855 | (37.7301323849801, -122.430940049855) | 9 | 7 | 6 | 28861 | 25 | |||
46837 | 179803 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1481 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998958.13876 | 2089448.31197 | 37.7171673203931 | -122.445569578776 | (37.7171673203931, -122.445569578776) | 9 | 7 | 6 | 28861 | 25 | |||
47539 | 31120 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Edna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 9 | Permit Number 34839 | 5998792.22814 | 2094324.02861 | 37.7305454337211 | -122.446493629496 | (37.7305454337211, -122.446493629496) | 9 | 7 | 4 | 28861 | 40 | |
48837 | 241065 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1801 Castro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6002656.66446 | 2100292.18739 | 37.7471525907236 | -122.433560071737 | (37.7471525907236, -122.433560071737) | 2 | 7 | 5 | 63 | 22 | ||||
49026 | 179810 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1367 Cayuga Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 0ft | 5999324.75892 | 2089823.48937 | 37.7182183958423 | -122.444329297662 | (37.7182183958423, -122.444329297662) | 9 | 7 | 6 | 28861 | 25 | |||
49209 | 179799 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Foote Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5998244.59243 | 2088714.20474 | 37.7151108676608 | -122.447983134341 | (37.7151108676608, -122.447983134341) | 9 | 7 | 6 | 28861 | 25 | |||
51255 | 215297 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 615 Hearst Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5997404.12695 | 2094370.52949 | 37.7305937308948 | -122.45129582845 | (37.7305937308948, -122.45129582845) | 9 | 7 | 4 | 28861 | 40 | |||
51532 | 179818 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998665.00636 | 2087845.19043 | 37.7127487749191 | -122.446467526652 | (37.7127487749191, -122.446467526652) | 9 | 7 | 6 | 28861 | 25 | |||
54331 | 215340 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 637 Detroit St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5999417.92849 | 2095175.79644 | 37.7329199074284 | -122.444391688153 | (37.7329199074284, -122.444391688153) | 9 | 7 | 4 | 59 | 40 | |||
54533 | 215301 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 123 Monterey Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001252.93679 | 2094603.03258 | 37.7314517578791 | -122.438006591549 | (37.7314517578791, -122.438006591549) | 9 | 7 | 4 | 63 | 40 | |||
55838 | 179815 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 300 Ellington Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 1ft | 5998907.25749 | 2087996.54696 | 37.713178199383 | -122.445641109954 | (37.713178199383, -122.445641109954) | 9 | 7 | 6 | 28861 | 25 | |||
56720 | 116300 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
56948 | 179838 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6002614.6695 | 2093907.99697 | 37.7296206941164 | -122.433249183323 | (37.7296206941164, -122.433249183323) | 9 | 7 | 6 | 28861 | 25 | |||
57951 | 179814 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 522 Sunnydale Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | 6010066.66697 | 2086413.12079 | 37.7094612429124 | -122.406958677794 | (37.7094612429124, -122.406958677794) | 9 | 7 | 8 | 309 | 39 | ||||
59411 | 179908 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002616.49516 | 2086635.08435 | 37.7096509944651 | -122.432723539456 | (37.7096509944651, -122.432723539456) | 9 | 7 | 6 | 28861 | 5 | |||
63554 | 241060 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005928.78547 | 2095826.36488 | 37.7350755589952 | -122.421928139697 | (37.7350755589952, -122.421928139697) | 2 | 7 | 7 | 28859 | 2 | |||
63804 | 179827 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 701 Vienna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002666.48138 | 2089402.27505 | 37.7172519286027 | -122.432748322975 | (37.7172519286027, -122.432748322975) | 9 | 7 | 6 | 28861 | 5 | |||
65143 | 241059 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 5ft | 6005916.72603 | 2095826.92897 | 37.7350764277358 | -122.421969873622 | (37.7350764277358, -122.421969873622) | 2 | 7 | 7 | 28859 | 2 | |||
65645 | 179865 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 279 Moscow St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6004627.95191 | 2091486.48414 | 37.7230857614719 | -122.426116731211 | (37.7230857614719, -122.426116731211) | 9 | 7 | 6 | 28861 | 5 | |||
67559 | 179809 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 114 Niagara Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 5999497.59387 | 2089483.70241 | 37.7172952777295 | -122.443707485722 | (37.7172952777295, -122.443707485722) | 9 | 7 | 6 | 28861 | 25 | |||
68300 | 241061 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 5ft | 6005940.184 | 2095824.54912 | 37.7350712161596 | -122.421888601897 | (37.7350712161596, -122.421888601897) | 2 | 7 | 7 | 28859 | 2 | |||
70182 | 179871 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 9 Athens St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6005395.25697 | 2093256.97645 | 37.7279904840704 | -122.423590123686 | (37.7279904840704, -122.423590123686) | 9 | 7 | 6 | 28861 | 5 | ||||
70723 | 179829 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 700 France Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 6002680.04915 | 2089397.80932 | 37.7172404361776 | -122.432701106797 | (37.7172404361776, -122.432701106797) | 9 | 7 | 6 | 28861 | 5 | |||
79283 | 179800 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 228 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5998609.28877 | 2088802.95321 | 37.7153753906268 | -122.446728973961 | (37.7153753906268, -122.446728973961) | 9 | 7 | 6 | 28861 | 25 | |||
79418 | 179867 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 985 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005404.97601 | 2092232.73416 | 37.7251786880381 | -122.423483738408 | (37.7251786880381, -122.423483738408) | 9 | 7 | 6 | 309 | 5 | |||
80235 | 179835 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 134 Cotter St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6001963.44434 | 2093526.42722 | 37.7285360253961 | -122.435473248114 | (37.7285360253961, -122.435473248114) | 9 | 7 | 6 | 28861 | 25 | |||
87428 | 215300 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6000205.65358 | 2094331.35281 | 37.730646174877 | -122.441607748599 | (37.730646174877, -122.441607748599) | 9 | 7 | 4 | 63 | 40 | |||
87437 | 179846 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 29 Colonial Way | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 6000367.54069 | 2093586.66565 | 37.7286106583386 | -122.440994678056 | (37.7286106583386, -122.440994678056) | 9 | 7 | 6 | 28861 | 25 | |||
88824 | 179826 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 838 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001050.56087 | 2088944.05849 | 37.7159019895732 | -122.438300979212 | (37.7159019895732, -122.438300979212) | 9 | 7 | 6 | 28861 | 5 | |||
88955 | 215335 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998237.40059 | 2096398.28008 | 37.7362091292407 | -122.448561071933 | (37.7362091292407, -122.448561071933) | 9 | 7 | 4 | 59 | 40 | |||
91516 | 179860 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 243 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6004522.90502 | 2091823.63198 | 37.7240055575044 | -122.426503852472 | (37.7240055575044, -122.426503852472) | 9 | 7 | 6 | 28861 | 5 | |||
92456 | 215336 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998234.84844 | 2096392.28962 | 37.7361925349403 | -122.448569464424 | (37.7361925349403, -122.448569464424) | 9 | 7 | 4 | 59 | 40 | |||
98214 | 179796 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1795 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 1ft | 5997861.23879 | 2088411.17322 | 37.714256892113 | -122.449286343701 | (37.714256892113, -122.449286343701) | 9 | 7 | 6 | 28861 | 25 | |||
101151 | 179820 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5998698.87726 | 2087810.60096 | 37.712655734647 | -122.446347971688 | (37.712655734647, -122.446347971688) | 9 | 7 | 6 | 28861 | 25 | |||
102546 | 179863 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 274 Moscow St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 2ft | 6004588.75772 | 2091549.34292 | 37.7232561425447 | -122.426256690891 | (37.7232561425447, -122.426256690891) | 9 | 7 | 6 | 28861 | 5 | |||
103352 | 179813 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1349 Cayuga Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 0ft | 5999385.00434 | 2089890.92911 | 37.7184070070682 | -122.444125898896 | (37.7184070070682, -122.444125898896) | 9 | 7 | 6 | 28861 | 25 | |||
103524 | 179808 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1401 Cayuga Ave | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 5999197.61143 | 2089687.82893 | 37.7178386481083 | -122.444759045 | (37.7178386481083, -122.444759045) | 9 | 7 | 6 | 28861 | 25 | |||
104409 | 179798 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Foote Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5998239.51925 | 2088721.51535 | 37.7151306509273 | -122.448001195404 | (37.7151306509273, -122.448001195404) | 9 | 7 | 6 | 28861 | 25 | |||
104877 | 179837 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 285 Santa Rosa Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6000743.66321 | 2093585.989 | 37.728630215899 | -122.439694355537 | (37.728630215899, -122.439694355537) | 9 | 7 | 6 | 28861 | 25 | |||
105099 | 179861 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 243 Athens St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6004531.11595 | 2091836.46353 | 37.7240412542901 | -122.426476381783 | (37.7240412542901, -122.426476381783) | 9 | 7 | 6 | 28861 | 5 | |||
107311 | 179825 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1115 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6000416.25611 | 2090642.64667 | 37.7205298306712 | -122.440615189366 | (37.7205298306712, -122.440615189366) | 9 | 7 | 6 | 28861 | 25 | |||
107371 | 179874 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6007111.06937 | 2091808.8773 | 37.7241110173924 | -122.4175559066 | (37.7241110173924, -122.4175559066) | 9 | 7 | 7 | 309 | 28 | |||
108553 | 179909 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 316 Chicago Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6002595.51683 | 2086620.13725 | 37.7096087631907 | -122.432794977119 | (37.7096087631907, -122.432794977119) | 9 | 7 | 6 | 28861 | 5 | |||
112263 | 97298 | Permitted Site 7 | Taxus baccata :: Irish Yew 86 | 1051 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | 9 | 7 | 4 | 59 | 40 | |||||
112452 | 116298 | Undocumented 4 | Taxus baccata :: Irish Yew 86 | 699X DETROIT ST | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x20 | 5999400 | 2095202 | 37.7329908332996 | -122.444455553893 | (37.7329908332996, -122.444455553893) | 9 | 7 | 4 | 59 | 40 | ||||
113842 | 25295 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 7x3 | 6000605.77697 | 2091736.42859 | 37.7235438977056 | -122.440038466696 | (37.7235438977056, -122.440038466696) | 9 | 7 | 6 | 28861 | 25 | |||
114189 | 179855 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 950 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5998508.96783 | 2089424.10578 | 37.7170752019331 | -122.447120402108 | (37.7170752019331, -122.447120402108) | 9 | 7 | 6 | 28861 | 25 | |||
114841 | 179851 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5998773.25514 | 2089930.66617 | 37.718481197523 | -122.44624330948 | (37.718481197523, -122.44624330948) | 9 | 7 | 6 | 28861 | 25 | |||
121368 | 179807 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1441 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5999120.21959 | 2089604.47334 | 37.7176053558696 | -122.445020564272 | (37.7176053558696, -122.445020564272) | 9 | 7 | 6 | 28861 | 25 | |||
122170 | 179839 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 6002619.90718 | 2093903.00137 | 37.7296072744596 | -122.433230719323 | (37.7296072744596, -122.433230719323) | 9 | 7 | 6 | 28861 | 25 | |||
123638 | 179876 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 590 Cambridge St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6007115.03067 | 2091796.72343 | 37.7240778683719 | -122.41754135197 | (37.7240778683719, -122.41754135197) | 9 | 7 | 7 | 309 | 28 | |||
123804 | 179868 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 345 Congdon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 2ft | 6004732.69466 | 2093569.91681 | 37.7288123277178 | -122.425902888604 | (37.7288123277178, -122.425902888604) | 9 | 7 | 6 | 28861 | 5 | |||
124331 | 215343 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999604.29165 | 2093616.12751 | 37.7286480521422 | -122.443635380789 | (37.7286480521422, -122.443635380789) | 9 | 7 | 4 | 63 | 40 | |||
124748 | 179822 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 364 Ellington Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5998692.05829 | 2087780.21802 | 37.7125719205336 | -122.446369355756 | (37.7125719205336, -122.446369355756) | 9 | 7 | 6 | 28861 | 25 | |||
125001 | 179872 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 66 Madison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6005421.70819 | 2093230.42134 | 37.7279190626089 | -122.423496793843 | (37.7279190626089, -122.423496793843) | 9 | 7 | 6 | 28861 | 5 | |||
125098 | 179852 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 802 Delano Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5998768.26163 | 2089920.0752 | 37.7184518319668 | -122.446259808467 | (37.7184518319668, -122.446259808467) | 9 | 7 | 6 | 28861 | 25 | |||
125099 | 215304 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 681 Joost Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | 5997552.24164 | 2094964.50066 | 37.7322331140486 | -122.450826587399 | (37.7322331140486, -122.450826587399) | 9 | 7 | 4 | 59 | 40 | ||||
126756 | 179845 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 85 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6000550.17873 | 2092849.30944 | 37.7265964485477 | -122.44031043159 | (37.7265964485477, -122.44031043159) | 9 | 7 | 6 | 28861 | 25 | ||||
126944 | 241063 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005947.85615 | 2095824.2566 | 37.73507084564 | -122.421862055716 | (37.73507084564, -122.421862055716) | 2 | 7 | 7 | 28859 | 2 | |||
127564 | 179912 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 295 Rome St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5998434.10808 | 2088860.2602 | 37.7155227337561 | -122.447338595604 | (37.7155227337561, -122.447338595604) | 9 | 7 | 6 | 28861 | 25 | |||
128394 | 241062 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 112 Crescent Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 5ft | 6005944.68012 | 2095825.54843 | 37.7350742136048 | -122.421873128139 | (37.7350742136048, -122.421873128139) | 2 | 7 | 7 | 28859 | 2 | |||
133462 | 179834 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 134 Cotter St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6001971.52486 | 2093519.43437 | 37.7285172835473 | -122.435444813332 | (37.7285172835473, -122.435444813332) | 9 | 7 | 6 | 28861 | 25 | |||
133906 | 179882 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Pioche St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005924.81091 | 2093297.57145 | 37.7281318260086 | -122.421762319978 | (37.7281318260086, -122.421762319978) | 9 | 7 | 7 | 309 | 5 | |||
134958 | 215299 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Hearst Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 2ft | 6000184.62411 | 2094332.33386 | 37.730647670445 | -122.441680520847 | (37.730647670445, -122.441680520847) | 9 | 7 | 4 | 63 | 40 | |||
135830 | 179804 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1481 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5998957.13313 | 2089446.35886 | 37.717161900187 | -122.44557291438 | (37.717161900187, -122.44557291438) | 9 | 7 | 6 | 28861 | 25 | |||
137276 | 179819 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 25 Dichiera Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5998682.50802 | 2087825.81458 | 37.7126965728687 | -122.446405642516 | (37.7126965728687, -122.446405642516) | 9 | 7 | 6 | 28861 | 25 | |||
141539 | 179840 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 212 Silver Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 2ft | 6002632.59127 | 2093895.12097 | 37.7295863562117 | -122.433186306304 | (37.7295863562117, -122.433186306304) | 9 | 7 | 6 | 28861 | 25 | |||
141829 | 179801 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 185 Rome St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 1ft | 5998776.53885 | 2088955.27581 | 37.7158031864544 | -122.446161836306 | (37.7158031864544, -122.446161836306) | 9 | 7 | 6 | 28861 | 25 | |||
142858 | 179806 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1475 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5998976.19185 | 2089464.18471 | 37.7172119339604 | -122.445508318764 | (37.7172119339604, -122.445508318764) | 9 | 7 | 6 | 28861 | 25 | |||
142955 | 215334 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 800 Foerster St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998241.14099 | 2096403.03655 | 37.7362224032408 | -122.448548482343 | (37.7362224032408, -122.448548482343) | 9 | 7 | 4 | 59 | 40 | |||
145353 | 179859 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 71 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6004926.25969 | 2092979.13729 | 37.7272011149393 | -122.425191700232 | (37.7272011149393, -122.425191700232) | 9 | 7 | 6 | 28861 | 5 |
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) );