194,517 rows sorted by XCoord descending

View and edit SQL

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)
121059 187765 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 91 Kiska Rd 7 Sidewalk: Property side : Yard Tree Private 2     26     6019429.17387 2093568.53818 37.7296281423191 -122.375095487273 (37.7296281423191, -122.375095487273) 10 3 8 58 1
30083 201521 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 869 Innes Ave 2 : Tree Private 2     2 Width 3ft   6019420.24762 2094273.01088 37.7315619976776 -122.375175152832 (37.7315619976776, -122.375175152832) 10 3 8 58 1
144674 187764 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 91 Kiska Rd 6 Sidewalk: Property side : Yard Tree Private 2     18     6019412.69298 2093581.83976 37.729663759061 -122.37515338563 (37.729663759061, -122.37515338563) 10 3 8 58 1
153844 39995 DPW Maintained 1 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 869 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2004 12:00:00 AM 6 3x3 Permit Number 47551 6019405.77873 2094282.05396 37.7315860320638 -122.375225801726 (37.7315860320638, -122.375225801726) 10 3 8 58 1
120267 39997 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 871 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 5   Permit Number 41255 6019390.138 2094293.55208 37.7316167430098 -122.375280672083 (37.7316167430098, -122.375280672083) 10 3 8 58 1
6527 40000 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 881 Innes Ave 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 14   Permit Number 41257 6019376.91864 2094304.02926 37.7316447838739 -122.375327100491 (37.7316447838739, -122.375327100491) 10 3 8 58 1
64188 40003 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 881 Innes Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 8   Permit Number 41257 6019368.47353 2094309.06128 37.7316581360927 -122.375356645916 (37.7316581360927, -122.375356645916) 10 3 8 58 1
74104 40001 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 881 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 12   Permit Number 41257 6019355.96693 2094318.55144 37.7316835059849 -122.375400541805 (37.7316835059849, -122.375400541805) 10 3 8 58 1
19403 197209 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 91 Kiska Rd 5 Sidewalk: Property side : Yard Tree Private 2     7     6019354.09765 2093629.33991 37.7297909609772 -122.375359249432 (37.7297909609772, -122.375359249432) 10 3 8 58 1
46103 39999 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 881 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 13   Permit Number 41257 6019347.79521 2094325.03679 37.7317008637943 -122.375429242788 (37.7317008637943, -122.375429242788) 10 3 8 58 1
20782 40002 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 881 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 8   Permit Number 41257 6019340.13593 2094332.72798 37.731721560802 -122.375456255711 (37.731721560802, -122.375456255711) 10 3 8 58 1
177133 197208 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 91 Kiska Rd 4 Sidewalk: Property side : Yard Tree Private 2     5     6019334.40687 2093641.64666 37.7298236693276 -122.375428176194 (37.7298236693276, -122.375428176194) 10 3 8 58 1
52308 197207 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 91 Kiska Rd 3 Sidewalk: Property side : Yard Tree Private 2     6     6019325.73842 2093646.8502 37.7298374801948 -122.375458504919 (37.7298374801948, -122.375458504919) 10 3 8 58 1
158903 88041 DPW Maintained 1 Maytenus boaria :: Mayten 58 895 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 2 3x3 Permit Number 51054 6019312.19901 2094352.00994 37.7317729678294 -122.375554176579 (37.7317729678294, -122.375554176579) 10 3 8 58 1
140467 197206 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 91 Kiska Rd 2 Sidewalk: Property side : Yard Tree Private 2     5     6019299.00025 2093665.65157 37.7298876336035 -122.375552245738 (37.7298876336035, -122.375552245738) 10 3 8 58 1
90188 88040 DPW Maintained 1 Maytenus boaria :: Mayten 58 895 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 2 3x3 Permit Number 51054 6019291.73542 2094366.52239 37.7318116899468 -122.375625929912 (37.7318116899468, -122.375625929912) 10 3 8 58 1
14235 84619 DPW Maintained 1 Maytenus boaria :: Mayten 58 895 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/2011 12:00:00 AM 3 3x3 Permit Number 767653 6019276.35845 2094378.98804 37.7318450718732 -122.375679955768 (37.7318450718732, -122.375679955768) 10 3 8 58 1
32883 197205 DPW Maintained 1 Quercus agrifolia :: Coast Live Oak 172 91 Kiska Rd 1 Sidewalk: Property side : Yard Tree Private 2     5     6019275.32859 2093678.30312 37.7299210694925 -122.375634959101 (37.7299210694925, -122.375634959101) 10 3 8 58 1
28707 50621 Permitted Site 7 Syagrus romanzoffianum :: Queen Palm 85 820 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/08/2003 12:00:00 AM     Permit Number 47218 6019242.65386152 2094476.11509562 37.7321099088197 -122.375803212343 (37.7321099088197, -122.375803212343) 10 3 8 58 1
60321 201520 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 501 Griffith St 3 Sidewalk: Curb side : Yard Tree Private 2     5 Width 6ft   6019241.77344 2094383.32833 37.7318550858427 -122.37579982552 (37.7318550858427, -122.37579982552) 10 3 8 58 1
95785 201519 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 501 Griffith St 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 6ft   6019223.74724 2094361.07733 37.7317929966527 -122.375860604396 (37.7317929966527, -122.375860604396) 10 3 8 58 1
161880 201518 DPW Maintained 1 Prunus cerasifera :: Cherry Plum 7 501 Griffith St 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6019207.67378 2094338.78719 37.7317309074526 -122.375914629362 (37.7317309074526, -122.375914629362) 10 3 8 58 1
152448 40005 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 911 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41258 6019178.20708985 2094459.30382263 37.7320602007089 -122.376024856319 (37.7320602007089, -122.376024856319) 10 3 8 58 1
157007 39993 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 860 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/27/1999 12:00:00 AM     Permit Number 41251 6019175.31340513 2094526.32452806 37.7322440672923 -122.376039506051 (37.7322440672923, -122.376039506051) 10 3 8 58 1
28806 97041 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
30618 97004 Property Tree 8 Callistemon viminalis :: Weeping Bottlebrush 60 195A Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
30764 97025 Property Tree 8 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
33597 97039 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
35599 97045 Property Tree 8 Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
40665 97022 Property Tree 8 Umbellularia californica :: California Bay 326 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
41028 97042 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
41321 97014 Property Tree 8 Prunus ilicifoia :: Holly-leaved Cherry 245 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
44692 97015 Property Tree 8 Prunus ilicifoia :: Holly-leaved Cherry 245 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
56664 97021 Property Tree 8 Quercus agrifolia :: Coast Live Oak 172 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
62691 97040 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
64109 97027 Property Tree 8 Myoporum laetum :: Myoporum 62 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
71527 97029 Property Tree 8 Rhamnus californica :: Coffeeberry Tree 320 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
91643 97034 Property Tree 8 :: 45 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
92080 97016 Property Tree 8 Prunus ilicifoia :: Holly-leaved Cherry 245 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
104074 97028 Property Tree 8 Morus alba :: White Mulberry 246 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
116957 97032 Property Tree 8 Griselinia lucida :: Griselinia 242 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
120723 97043 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
125967 96999 Property Tree 8 Callistemon viminalis :: Weeping Bottlebrush 60 195A Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
175126 97044 Property Tree 8 Heteromeles arbutifolia :: Toyon 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
175634 97037 Property Tree 8 Griselinia lucida :: Griselinia 242 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
176465 97038 Property Tree 8 Hakea suaveolens :: Sweet Hakea Tree 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
179653 97035 Property Tree 8 Casurina stricta :: Beefwood: Drooping She-Oak 173 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
189767 97036 Property Tree 8 Griselinia lucida :: Griselinia 242 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
192727 97026 Property Tree 8 Tilia cordata :: Littleleaf Linden 12 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
60249 39996 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 870 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41254 6019158.47829216 2094538.87688533 37.7322776068337 -122.376098579608 (37.7322776068337, -122.376098579608) 10 3 8 58 1
157065 39998 Permitted Site 7 Melaleuca nesophila :: Pink Melaleuca 304 880 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM     Permit Number 41256 6019141.64317919 2094551.4292426 37.7323111463453 -122.376157653218 (37.7323111463453, -122.376157653218) 10 3 8 58 1
39634 40006 DPW Maintained 1 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 930 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 12   Permit Number 41259 6019126.39744 2094573.62219 37.7323712445238 -122.376211900284 (37.7323712445238, -122.376211900284) 10 3 8 58 1
26709 201517 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 911 Innes Ave 3 Sidewalk: Property side : Yard Tree Private 2     2 Width 5ft   6019123.25931 2094488.31096 37.7321368236424 -122.376216835747 (37.7321368236424, -122.376216835747) 10 3 8 58 1
156260 40004 DPW Maintained 1 Jacaranda mimosifolia :: Jacaranda 50 911 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 2   Permit Number 41258 6019111.21169 2094496.3329 37.7321581870346 -122.376259043617 (37.7321581870346, -122.376259043617) 10 3 8 58 1
50589 188415 DPW Maintained 1 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 2 Jennings St 2 : Tree Private 2     1 Width 3ft   6019090.32903 2097590.47628 37.7406529492792 -122.37654576819 (37.7406529492792, -122.37654576819) 10 3 8 58 1
130172 201486 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 934 Innes Ave 1 : Tree Private 2     6 Width 3ft   6019032.21192 2094642.96183 37.7325564518085 -122.376542332772 (37.7325564518085, -122.376542332772) 10 3 8 58 1
86009 40007 DPW Maintained 1 Syagrus romanzoffianum :: Queen Palm 85 939 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 19   Permit Number 41260 6019022.80772 2094568.61704 37.7323517975898 -122.37656969105 (37.7323517975898, -122.37656969105) 10 3 8 58 1
38711 116976 Undocumented 4 Salix spp :: Willow 203 100x CARGO WAY 7 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
49681 116977 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 100x CARGO WAY 117 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
173000 116975 Undocumented 4 Salix spp :: Willow 203 100x CARGO WAY 6 Front Yard : Yard Tree PUC 8 DPW for City Agency         6019010 2097405 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394) 10 3 8 58 1
49463 201487 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 934 Innes Ave 2 : Tree Private 2     5 Width 3ft   6019005.82727 2094664.79095 37.732614937414 -122.376635065468 (37.732614937414, -122.376635065468) 10 3 8 58 1
141336 40008 DPW Maintained 1 Rhamnus alaternus :: Italian Buckthorn 29 950 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/03/1999 12:00:00 AM 8   Permit Number 41261 6018990.20826 2094681.67111 37.7326604269313 -122.376690235261 (37.7326604269313, -122.376690235261) 10 3 8 58 1
181903 195925 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 90 Kiska Rd 2 Sidewalk: Property side : Yard Tree Private 2     8     6018989.61551 2093779.26661 37.7301825662676 -122.376629714494 (37.7301825662676, -122.376629714494) 10 3 8 58 1
85459 201645 DPW Maintained 1 Eucalyptus viminalis :: Manna Gum 223 101 Hunters Point Blvd 8 Sidewalk: Property side : Yard Tree Private 2     12 Width 4ft   6018982.72037 2095633.61521 37.7352738675975 -122.376782133393 (37.7352738675975, -122.376782133393) 10 3 8 58 1
12701 3581 Permitted Site 7 Ceratonia siliqua :: Carob 5 100X Cargo Way 16 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
14274 3580 Permitted Site 7 Quercus ilex :: Holly Oak 305 100X Cargo Way 15 Sidewalk: Curb side : Cutout Tree Port 6     6 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
44203 3575 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 10 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
54162 3576 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 11 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3x3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
62632 3577 Permitted Site 7 Quercus suber :: Cork Oak 78 100X Cargo Way 12 Sidewalk: Curb side : Cutout Tree Port 6     3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
66260 3682 Permitted Site 7 Eucalyptus sideroxylon :: Red Ironbark 127 100X Cargo Way 118 Sidewalk: Curb side : Cutout Tree Port 6     18 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
90691 3567 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 2 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
94317 3573 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 8 Sidewalk: Curb side : Cutout Tree Port 6   04/10/2017 09:44:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
105856 3574 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 9 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
109278 3570 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 100X Cargo Way 5 Sidewalk: Curb side : Cutout Tree Port 6     12 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
127393 3578 Permitted Site 7 Quercus suber :: Cork Oak 78 100X Cargo Way 13 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
146341 3568 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 3 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
158492 3686 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 100X Cargo Way 1 Median : Cutout Tree Port 6     12 8   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
167396 3583 Permitted Site 7 Quercus ilex :: Holly Oak 305 100X Cargo Way 18 Sidewalk: Curb side : Cutout Tree Port 6   05/31/1996 12:00:00 AM 8 3x3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
174733 3572 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 100X Cargo Way 7 Sidewalk: Curb side : Cutout Tree Port 6   04/10/2017 09:42:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
178553 3571 Permitted Site 7 Olea europaea :: Olive Tree 9 100X Cargo Way 6 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
25790 11503 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 17 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
29472 11507 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 21 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
42740 11506 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 20 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
44850 11492 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 100 Jennings St 6 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2000 12:00:00 AM 3 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
57743 11504 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 100 Jennings St 18 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/1998 12:00:00 AM 3 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
72950 11491 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 100 Jennings St 5 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2000 12:00:00 AM 3 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
80987 11508 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 22 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
80994 11505 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 19 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
97265 11502 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 16 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
105875 11493 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 100 Jennings St 7 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
116033 11500 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
118138 11501 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 15 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
155270 11490 DPW Maintained 1 Melaleuca linariifolia :: Flaxleaf Paperbark 103 100 Jennings St 4 Sidewalk: Curb side : Cutout Tree DPW 1   02/20/2008 12:00:00 AM 3 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
155683 11510 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 24 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
175115 11509 DPW Maintained 1 Eucalyptus sideroxylon :: Red Ironbark 127 100 Jennings St 23 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
185466 11495 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 100 Jennings St 9 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2000 12:00:00 AM 3 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049) 10 3 8 58 1
22461 41041 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 100 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/20/1999 12:00:00 AM     Permit Number 41824 6018973.83890969 2097433.1098399 37.7402144368946 -122.376937636731 (37.7402144368946, -122.376937636731) 10 3 8 58 1
47283 41040 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 100 Jennings St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/20/1999 12:00:00 AM     Permit Number 41824 6018973.83890969 2097433.1098399 37.7402144368946 -122.376937636731 (37.7402144368946, -122.376937636731) 10 3 8 58 1
82809 41043 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 100 Jennings St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/20/1999 12:00:00 AM     Permit Number 41824 6018973.83890969 2097433.1098399 37.7402144368946 -122.376937636731 (37.7402144368946, -122.376937636731) 10 3 8 58 1
124103 41042 Permitted Site 7 Melaleuca quinquenervia :: Cajeput 10 100 Jennings St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/1999 12:00:00 AM     Permit Number 41824 6018973.83890969 2097433.1098399 37.7402144368946 -122.376937636731 (37.7402144368946, -122.376937636731) 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)
);