trees

438 rows where qSpecies_id = 63 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
80305 111179 Significant Tree 6 Pinus pinea :: Italian Stone Pine 63 400 NORTH POINT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2016 12:00:00 AM 3 9x6   6008572 2121805 37.806555520543 -122.414627380808 (37.806555520543, -122.414627380808) 3 1 10 308 23
85334 256616 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1541X Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011315 2120446 37.8029777664724 -122.405038917948 (37.8029777664724, -122.405038917948) 3 1 10 308 23
90211 96976 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 390X Filbert St 1 Median : Yard Tree Rec/Park 5     28     6010951.1 2119992.4 37.8017119430502 -122.406266229116 (37.8017119430502, -122.406266229116) 3 1 10 308 23
108098 132177 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1048 Union St 1 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   6007888.26555 2119276.18895 37.7995736051877 -122.416814304957 (37.7995736051877, -122.416814304957) 5 1 1 308 32
113826 16372 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 5 Median : Cutout Tree DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
114548 132185 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 32 Median : Yard Tree DPW 1     31 Width 8ft   6011428.32338 2120121.70557 37.8020936674502 -122.404623915473 (37.8020936674502, -122.404623915473) 3 1 10 308 23
140100 132186 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 34 Median : Yard Tree DPW 1     20 Width 8ft   6011427.66353 2120140.51179 37.8021452678603 -122.404627523539 (37.8021452678603, -122.404627523539) 3 1 10 308 23
140332 16374 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 7 Median : Cutout Tree DPW 1     12 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
144960 16370 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1400X Montgomery St 3 Median : Cutout Tree DPW 1     18 8   6011455.2971485 2120087.0441833 37.8020000032358 -122.404528131508 (37.8020000032358, -122.404528131508) 3 1 10 308 23
146463 107487 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 12 Median : Cutout Tree DPW 1     23     6011454.1798 2119912.99001 37.801522030487 -122.40451973891 (37.801522030487, -122.40451973891) 3 1 10 308 23
164190 16364 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300X Montgomery St 17 Median : Cutout Tree DPW 1     12 8   6011500.9168661 2119743.0722499 37.8010580895294 -122.404346040012 (37.8010580895294, -122.404346040012) 3 1 10 308 23
190898 132183 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1306x Montgomery St 23 Median : Yard Tree DPW 1     26 Width 8ft   6011446.11989 2119998.19994 37.8017555457373 -122.404553631656 (37.8017555457373, -122.404553631656) 3 1 10 308 23
36162 110396 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1x ARLETA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x30   6011055 2087587 37.7127397354919 -122.403625353192 (37.7127397354919, -122.403625353192) 9 7 8 309 39
120938 110397 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 2200 BAY SHORE BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2       3x30   6011234 2087411 37.7122664722191 -122.40299429709 (37.7122664722191, -122.40299429709) 9 7 8 309 39
188305 178179 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 201 Yale St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   6007200.07685 2092715.80897 37.7266062646522 -122.417312460112 (37.7266062646522, -122.417312460112) 9 3 7 309 28
95203 141265 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 52 JORDAN AVE 2 Sidewalk: Curb side : Yard Tree Private 2     12 Width 0ft   5996227.2891 2114192.1724 37.7849514808139 -122.456797345759 (37.7849514808139, -122.456797345759) 11 6 1 54 31
163885 115556 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 3897 CLAY ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996199 2115222 37.7877774871206 -122.456969730492 (37.7877774871206, -122.456969730492) 11 6 1 54 31
192071 132173 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 91 Mayfair Dr 3 Sidewalk: Property side : Yard Tree Private 2     15 Width 6ft   5997717.35609 2114490.42899 37.7858558611085 -122.45166373929 (37.7858558611085, -122.45166373929) 15 6 1 54 31
60584 115235 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 58 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2016 12:00:00 AM 3 4x6 Permit Number 777338 5989295.30249 2114868.10873 37.7864069399285 -122.480829025898 (37.7864069399285, -122.480829025898) 11 6 1 55 33
77265 20512 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1211X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 60   5984783.6901595 2107169.3790132 37.7650051676015 -122.495869700491 (37.7650051676015, -122.495869700491) 11 6 2 55 8
97194 24742 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 50X Point Lobos Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 12x12   5982568.63637 2112600.93828 37.7797886774071 -122.503933218017 (37.7797886774071, -122.503933218017) 11 6 2 55 26
111313 20511 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1211X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 60   5984783.6901595 2107169.3790132 37.7650051676015 -122.495869700491 (37.7650051676015, -122.495869700491) 11 6 2 55 8
157105 54486 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 535 39th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/11/1972 12:00:00 AM 8   Permit Number 10278 5983764.83173 2112189.27219 37.7787286289905 -122.499764682948 (37.7787286289905, -122.499764682948) 11 6 2 55 26
181774 118274 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 801 37th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     31 Width 3ft   5984451.13428 2110349.39905 37.7737171157491 -122.497254676861 (37.7737171157491, -122.497254676861) 11 6 2 55 26
2394 184349 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1251 Sunset Blvd 13 Sidewalk: Property side : Yard Tree Private 2     28 Width 0ft   5984659.3559 2106454.1603 37.7630340956965 -122.496246960605 (37.7630340956965, -122.496246960605) 1 8 3 56 35
11326 186595 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 66 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984740.8383 2104479.6291 37.7576173573885 -122.49581948315 (37.7576173573885, -122.49581948315) 1 8 3 56 35
33872 186702 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 59 Sidewalk: Property side : Yard Tree Private 2     23 Width 0ft   5984718.4366 2105146.0279 37.7594457908807 -122.495946116181 (37.7594457908807, -122.495946116181) 1 8 3 56 35
34962 184744 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984688.1718 2106200.1767 37.7623384159342 -122.496128558374 (37.7623384159342, -122.496128558374) 1 8 3 56 35
41594 20767 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1692X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     24 60   5984807.4869191 2103677.7923597 37.7554196391607 -122.495529849669 (37.7554196391607, -122.495529849669) 1 8 3 56 35
45383 186433 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1601 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5984738.4307 2104031.9087 37.7563879005336 -122.495794783817 (37.7563879005336, -122.495794783817) 1 8 3 56 35
52616 184782 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 43 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984677.5396 2105882.9212 37.7614666984861 -122.496141923024 (37.7614666984861, -122.496141923024) 1 8 3 56 35
54785 186417 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1601 Sunset Blvd 5 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984727.1251 2104191.8612 37.7568264235859 -122.495845680799 (37.7568264235859, -122.495845680799) 1 8 3 56 35
63026 186711 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1300 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984852.6024 2106104.2938 37.762084778312 -122.495552790494 (37.762084778312, -122.495552790494) 1 8 3 56 35
68325 184784 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984713.613 2105863.1758 37.7614145960538 -122.496015705201 (37.7614145960538, -122.496015705201) 1 8 3 56 35
69152 184781 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 42 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984718.1696 2105899.6288 37.7615149526664 -122.496002635394 (37.7615149526664, -122.496002635394) 1 8 3 56 35
74337 211057 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 447 Lawton St 2 Sidewalk: Curb side : Pot Tree Private 2     9 Width 3ft   5992810.26786 2104540.37946 37.7582534434534 -122.467916772063 (37.7582534434534, -122.467916772063) 1 8 4 56 12
93032 186593 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984773.0801 2104494.2844 37.7576594849516 -122.495709060541 (37.7576594849516, -122.495709060541) 1 8 3 56 35
103634 186594 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984719.4834 2104488.841 37.7576414000341 -122.495894015518 (37.7576414000341, -122.495894015518) 1 8 3 56 35
106470 186343 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 Sunset Blvd 10 Sidewalk: Property side : Yard Tree Private 2     7 Width 0ft   5984811.8118 2102790.6052 37.7529839215525 -122.495449463877 (37.7529839215525, -122.495449463877) 1 8 3 56 35
118830 211056 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 17th Ave 2 Sidewalk: Property side : Yard Tree Private 2     20     5990908.64637 2104472.93122 37.7579582535812 -122.474488420401 (37.7579582535812, -122.474488420401) 1 8 4 56 12
121598 186348 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1801 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984789.3132 2102727.1271 37.7528083107787 -122.495522585708 (37.7528083107787, -122.495522585708) 1 8 3 56 35
125583 184742 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 8 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5984665.3886 2106227.5165 37.7624121488276 -122.496209373012 (37.7624121488276, -122.496209373012) 1 8 3 56 35
126322 186253 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 64 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984779.1353 2103090.988 37.7538067764424 -122.495584617514 (37.7538067764424, -122.495584617514) 1 8 3 56 35
132701 186592 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 63 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984742.0945 2104511.4521 37.757704808066 -122.495817486185 (37.757704808066, -122.495817486185) 1 8 3 56 35
152112 186248 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 12 Sidewalk: Property side : Yard Tree Private 2     11 Width 0ft   5984775.1177 2103139.467 37.7539396511246 -122.495602086568 (37.7539396511246, -122.495602086568) 1 8 3 56 35
162189 184737 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1301 Sunset Blvd 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984694.2473 2106265.1087 37.7625170568543 -122.496112336517 (37.7625170568543, -122.496112336517) 1 8 3 56 35
167835 184087 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 88 Sidewalk: Property side : Yard Tree Private 2     12 Width 0ft   5984947.9817 2104096.3091 37.7565769961358 -122.495074842554 (37.7565769961358, -122.495074842554) 1 8 3 56 35
170803 186254 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1701 Sunset Blvd 65 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984796.5449 2103072.2391 37.7537563165951 -122.495523029283 (37.7537563165951, -122.495523029283) 1 8 3 56 35
170849 186531 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1501 Sunset Blvd 2 unknown : Yard Tree Private 2     9 Width 0ft   5984751.3064 2104919.289 37.7588251541556 -122.495815712177 (37.7588251541556, -122.495815712177) 1 8 3 56 35
173494 181382 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1500 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5984896.9779 2104470.096 37.7576003251998 -122.49527879388 (37.7576003251998, -122.49527879388) 1 8 3 56 35
173903 184079 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1600 Sunset Blvd 80 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5984934.15 2104045.1938 37.7564358379272 -122.49511890768 (37.7564358379272, -122.49511890768) 1 8 3 56 35
178211 186688 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1401 Sunset Blvd 45 Sidewalk: Property side : Yard Tree Private 2     3 Width 0ft   5984691.4289 2105282.7412 37.7598195855983 -122.496049606755 (37.7598195855983, -122.496049606755) 1 8 3 56 35
179563 211058 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 447 Lawton St 3 Sidewalk: Curb side : Pot Tree Private 2     15 Width 3ft   5992805.57319 2104540.3462 37.7582530810297 -122.467933005722 (37.7582530810297, -122.467933005722) 1 8 4 56 12
97489 38524 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 3031 Steiner St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/15/1998 12:00:00 AM 4   Permit Number 40508 6001948.5977 2118592.4425 37.7973603403586 -122.437318675826 (37.7973603403586, -122.437318675826) 13 9 1 57 17
2009 201784 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 32 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015541.73553 2087974.13978 37.7140523566047 -122.388144625001 (37.7140523566047, -122.388144625001) 10 3 8 58 1
7554 201736 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 5 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015525.30693 2087693.56377 37.7132810386533 -122.38818183984 (37.7132810386533, -122.38818183984) 10 3 8 58 1
12042 201792 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 40 Sidewalk: Property side : Yard Tree Private 2     22 Width 8ft   6015451.0989 2088156.51994 37.7145481150837 -122.388470624731 (37.7145481150837, -122.388470624731) 10 3 8 58 1
14391 194472 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 5 Sidewalk: Property side : Yard Tree Private 2     16     6016745.33826 2095063.00852 37.7335836232886 -122.384477928938 (37.7335836232886, -122.384477928938) 10 3 8 58 1
17861 201752 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 4 Sidewalk: Property side : Yard Tree Private 2     25 Width 8ft   6015886.86298 2086978.1992 37.7113368105223 -122.386882306895 (37.7113368105223, -122.386882306895) 10 3 8 58 1
20635 201770 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 18 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015634.53236 2087578.56705 37.712971331023 -122.387796296857 (37.712971331023, -122.387796296857) 10 3 8 58 1
21065 201733 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015510.4184 2087766.77172 37.7134812286504 -122.388238406274 (37.7134812286504, -122.388238406274) 10 3 8 58 1
23165 201759 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015719.97269 2087309.22701 37.712236507578 -122.387482205949 (37.712236507578, -122.387482205949) 10 3 8 58 1
25472 201732 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015480.18133 2087865.40702 37.713750386735 -122.388349797223 (37.713750386735, -122.388349797223) 10 3 8 58 1
25951 201761 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 9 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015680.02756 2087378.65264 37.7124249245429 -122.387625110022 (37.7124249245429, -122.387625110022) 10 3 8 58 1
27135 194470 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 84 Whitney Young Cir 3 Sidewalk: Property side : Yard Tree Private 2     16     6016764.11928 2095038.85548 37.7335183423928 -122.384411315236 (37.7335183423928, -122.384411315236) 10 3 8 58 1
31995 201737 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015529.27451 2087676.75764 37.7132351120852 -122.38816695425 (37.7132351120852, -122.38816695425) 10 3 8 58 1
32167 201766 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 14 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015647.69731 2087483.94989 37.7127122597387 -122.387744196458 (37.7127122597387, -122.387744196458) 10 3 8 58 1
38128 201734 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 3 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015517.44938 2087731.03371 37.71338348853 -122.388211611887 (37.71338348853, -122.388211611887) 10 3 8 58 1
38402 194467 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 1901 Quint St 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6012416.6749 2095223.97206 37.7337852773717 -122.399454760738 (37.7337852773717, -122.399454760738) 10 3 8 58 1
39195 201740 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 9 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015542.0778 2087585.57887 37.7129854620959 -122.388116342205 (37.7129854620959, -122.388116342205) 10 3 8 58 1
43163 201735 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 4 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015522.2781 2087714.21053 37.7133375628641 -122.388193748644 (37.7133375628641, -122.388193748644) 10 3 8 58 1
48450 201773 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 21 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015629.12317 2087652.01307 37.7131727000372 -122.387820114508 (37.7131727000372, -122.387820114508) 10 3 8 58 1
57881 201744 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 13 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015567.574 2087419.0912 37.7125297315236 -122.388016607392 (37.7125297315236, -122.388016607392) 10 3 8 58 1
63112 201741 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 10 Sidewalk: Property side : Yard Tree Private 2     13 Width 8ft   6015551.73985 2087509.47398 37.7127770280164 -122.388077638997 (37.7127770280164, -122.388077638997) 10 3 8 58 1
65486 201795 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 43 Sidewalk: Property side : Yard Tree Private 2     24 Width 8ft   6015420.28917 2088209.03426 37.7146906018698 -122.388580780005 (37.7146906018698, -122.388580780005) 10 3 8 58 1
67122 201776 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 24 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015607.24672 2087763.10237 37.7134765179931 -122.387903474463 (37.7134765179931, -122.387903474463) 10 3 8 58 1
67974 201788 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 36 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015494.63123 2088072.87111 37.7143208438162 -122.388314323455 (37.7143208438162, -122.388314323455) 10 3 8 58 1
79660 201757 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 5 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015756.55363 2087265.17293 37.7121175695368 -122.38735269906 (37.7121175695368, -122.38735269906) 10 3 8 58 1
82734 201750 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     34 Width 8ft   6015853.10494 2087012.76113 37.7114298417752 -122.3870013933 (37.7114298417752, -122.3870013933) 10 3 8 58 1
84080 201783 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 31 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015549.05195 2087952.54872 37.7139934770858 -122.388117830599 (37.7139934770858, -122.388117830599) 10 3 8 58 1
87306 201794 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 42 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015439.96848 2088181.18977 37.7146152368657 -122.388510817234 (37.7146152368657, -122.388510817234) 10 3 8 58 1
90634 201790 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 38 Sidewalk: Property side : Yard Tree Private 2     18 Width 8ft   6015475.6761 2088115.28204 37.7144362457024 -122.388382798743 (37.7144362457024, -122.388382798743) 10 3 8 58 1
96403 201768 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 16 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015641.02933 2087537.69345 37.7128594598683 -122.387770990859 (37.7128594598683, -122.387770990859) 10 3 8 58 1
96989 201781 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 29 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015573.4977 2087883.43723 37.713805064638 -122.388028516222 (37.713805064638, -122.388028516222) 10 3 8 58 1
97073 194469 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 981 Le Conte Ave 1 Sidewalk: Curb side : Yard Tree Private 2     29     6013175.32991 2089516.24763 37.7181552814285 -122.396431907321 (37.7181552814285, -122.396431907321) 10 3 8 58 1
99536 201777 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 25 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015601.56547 2087780.3718 37.7135236217889 -122.387924315354 (37.7135236217889, -122.387924315354) 10 3 8 58 1
106034 255453 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 90 Kiska Rd 1 Front Yard : Yard Tree Private 2       3x3   6018381 2093938 37.7305848832053 -122.378744818809 (37.7305848832053, -122.378744818809) 10 3 8 58 1
106214 201767 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 15 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015642.29299 2087514.93769 37.7127970469199 -122.387765036445 (37.7127970469199, -122.387765036445) 10 3 8 58 1
106418 201754 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 2 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015794.33118 2087216.37677 37.7119856767735 -122.387218726159 (37.7119856767735, -122.387218726159) 10 3 8 58 1
107661 201748 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 17 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015601.73852 2087319.33199 37.7122577046069 -122.387891566548 (37.7122577046069, -122.387891566548) 10 3 8 58 1
110823 201753 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015806.16056 2087204.98759 37.7119550593549 -122.387177046177 (37.7119550593549, -122.387177046177) 10 3 8 58 1
113722 201749 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 491 Jamestown Ave 1 Sidewalk: Property side : Yard Tree Private 2     26 Width 8ft   6015821.03447 2087045.57383 37.7115181633057 -122.387114525336 (37.7115181633057, -122.387114525336) 10 3 8 58 1
114462 201769 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 17 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6015636.77799 2087561.79601 37.7129254053659 -122.387787365691 (37.7129254053659, -122.387787365691) 10 3 8 58 1
119044 201747 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 727 Jamestown Ave 16 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015587.35405 2087353.50341 37.7123507358797 -122.387943666966 (37.7123507358797, -122.387943666966) 10 3 8 58 1
122823 201764 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 12 Sidewalk: Property side : Yard Tree Private 2     14 Width 8ft   6015653.28128 2087440.52101 37.7125933216851 -122.387721868094 (37.7125933216851, -122.387721868094) 10 3 8 58 1
124322 201782 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 30 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6015559.74323 2087927.45907 37.713925178088 -122.388079127353 (37.713925178088, -122.388079127353) 10 3 8 58 1
131920 201760 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 8 Sidewalk: Property side : Yard Tree Private 2     10 Width 8ft   6015686.51796 2087358.79354 37.7123707547676 -122.387601292376 (37.7123707547676, -122.387601292376) 10 3 8 58 1
132708 201780 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 28 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015582.72471 2087849.79956 37.7137132132682 -122.387994278123 (37.7137132132682, -122.387994278123) 10 3 8 58 1
133258 201758 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015742.62341 2087279.17788 37.7121552529428 -122.387401822747 (37.7121552529428, -122.387401822747) 10 3 8 58 1
133522 201785 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 724 Jamestown Ave 33 Sidewalk: Property side : Yard Tree Private 2     17 Width 8ft   6015530.91454 2087992.79913 37.7141029920284 -122.388183328214 (37.7141029920284, -122.388183328214) 10 3 8 58 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);