trees
150 rows where Police Districts = 4 and qLegalStatus_id = 6 sorted by Zip Codes
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes ▼ | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34658 | 104715 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3618 22nd St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.428325838726 | (37.7549616692716, -122.428325838726) | 2 | 4 | 5 | 28862 | 22 | ||||
36007 | 107047 | Significant Tree 6 | Tree(s) :: 17 | 1933 15TH ST | Front Yard : Yard | Tree | Private 2 | 6004592.7 | 2107127.1 | 37.7660293092823 | -122.427352228532 | (37.7660293092823, -122.427352228532) | 8 | 4 | 5 | 28862 | 3 | ||||||
37022 | 95985 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 577 Sanchez St | 1 | Front Yard : | Tree | Private 2 | 6003673 | 2104901 | 37.7598649162805 | -122.430374442168 | (37.7598649162805, -122.430374442168) | 2 | 4 | 5 | 28862 | 3 | |||||
37050 | 252828 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 3852 17th St | 7 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
40225 | 99859 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 12 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | ||||
43399 | 117435 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 98X CLIPPER ST | 1 | Back Yard : Yard | Tree | Private 2 | 6004559 | 2101087 | 37.7494427139243 | -122.427038546128 | (37.7494427139243, -122.427038546128) | 2 | 4 | 5 | 28862 | 22 | |||||
44457 | 252830 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 9 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
46691 | 258502 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 145 | 3321 16th St | 2 | Front Yard : Yard | Tree | Private 2 | 6004551.31558 | 2106568.33958 | 37.7644927464624 | -122.427455559127 | (37.7644927464624, -122.427455559127) | 8 | 4 | 5 | 28862 | 3 | |||||
46751 | 105555 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 410 Elizabeth St | 2 | Front Yard : Yard | Tree | Private 2 | Permit Number 772516 | 6003623.1 | 2102191.9 | 37.7524235434098 | -122.430353733326 | (37.7524235434098, -122.430353733326) | 2 | 4 | 5 | 28862 | 22 | ||||
48978 | 87197 | Significant Tree 6 | Cedrus deodara :: Deodar Cedar 109 | 617 Sanchez St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 50213 | 6003760 | 2104634 | 37.7591367256626 | -122.430054504807 | (37.7591367256626, -122.430054504807) | 2 | 4 | 5 | 28862 | 3 | ||||
52899 | 173663 | Significant Tree 6 | Pyrus kawakamii :: Evergreen Pear 83 | 3878 17th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6003109 | 2105964 | 37.7627516946294 | -122.432400964417 | (37.7627516946294, -122.432400964417) | 15 | 4 | 5 | 28862 | 3 | ||||
59089 | 116955 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 818 Douglass St | 1 | Front Yard : Cutout | Tree | Private 2 | 6 | 3x3 | 6001245 | 2101454 | 37.7502624545247 | -122.43852471352 | (37.7502624545247, -122.43852471352) | 2 | 4 | 5 | 28862 | 22 | |||
61475 | 187629 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 4283 23rd St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001353 | 2102279 | 37.7525338497288 | -122.438210337194 | (37.7525338497288, -122.438210337194) | 2 | 4 | 5 | 28862 | 22 | ||||
66345 | 100552 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 4 | Front Yard : Yard | Tree | Private 2 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | |||||
67906 | 223957 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 98 Seward St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 6000715.72405 | 2104622.00656 | 37.7589309108477 | -122.440582177927 | (37.7589309108477, -122.440582177927) | 2 | 4 | 5 | 28862 | 38 | |||
69345 | 252824 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 3 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
73609 | 252836 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 98 Prosper St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
76481 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 155 | 265 Dorland St | 1 | Back Yard : Yard | Tree | Private 2 | 6003831 | 2105693 | 37.7620485075454 | -122.429884491233 | (37.7620485075454, -122.429884491233) | 8 | 4 | 5 | 28862 | 3 | |||||
78991 | 252827 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 3852 17th St | 6 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
84261 | 251716 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3929 19th St | 1 | Front Yard : Yard | Tree | Private 2 | 6003450 | 2104734 | 37.7593937399337 | -122.431133769968 | (37.7593937399337, -122.431133769968) | 2 | 4 | 5 | 28862 | 3 | |||||
89841 | 253178 | Significant Tree 6 | Washingtonia filifera :: California Fan Palm 176 | 4450 24th St | 2 | Front Yard : Cutout | Tree | Private 2 | Width 0ft | Permit Number 780574 | 6000289.52403 | 2101701.02913 | 37.7508863393389 | -122.441846529398 | (37.7508863393389, -122.441846529398) | 2 | 4 | 5 | 28862 | 22 | |||
93094 | 106927 | Significant Tree 6 | Podocarpus gracilor :: Fern Pine 51 | 4150 24th St | Sidewalk: Property side : Cutout | Tree | Private 2 | 1.5X1.5 | Permit Number 772519 | 6002207.56819 | 2101805.30097 | 37.7512817512061 | -122.435221219626 | (37.7512817512061, -122.435221219626) | 2 | 4 | 5 | 28862 | 22 | ||||
94274 | 252822 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 3852 17th St | 1 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
103318 | 115673 | Significant Tree 6 | Acer japonicum :: Japanese Maple 124 | 86 Stanton St | Front Yard : Yard | Tree | Private 2 | 6000281.6 | 2103909.8 | 37.7569506357303 | -122.442032456595 | (37.7569506357303, -122.442032456595) | 2 | 4 | 5 | 28862 | 38 | ||||||
103792 | 104717 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3618 22nd St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.428325838726 | (37.7549616692716, -122.428325838726) | 2 | 4 | 5 | 28862 | 22 | ||||
106429 | 105497 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 41 | 3929 19TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 60 | 6003450.9 | 2104734.8 | 37.7593959875427 | -122.431130714429 | (37.7593959875427, -122.431130714429) | 2 | 4 | 5 | 28862 | 3 | ||||
107642 | 251173 | Significant Tree 6 | Washingtonia robusta :: Mexican Fan Palm 72 | 367 Jersey St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6002770.52649 | 2101500.01269 | 37.7504754543841 | -122.433252636724 | (37.7504754543841, -122.433252636724) | 2 | 4 | 5 | 28862 | 22 | ||||
108934 | 104726 | Significant Tree 6 | Syagrus romanzoffianum :: Queen Palm 85 | 1079 Church St | 1 | Front Yard : Yard | Tree | Private 2 | Permit Number 770313 | 6004474.7 | 2102638.1 | 37.7536969056436 | -122.427440543051 | (37.7536969056436, -122.427440543051) | 2 | 4 | 5 | 28862 | 22 | ||||
112541 | 255922 | Significant Tree 6 | Alnus rhombifolia :: White Alder 327 | 554 Clipper St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6001599 | 2100911 | 37.7487916364102 | -122.437261685392 | (37.7487916364102, -122.437261685392) | 2 | 4 | 5 | 28862 | 22 | ||||
113215 | 108560 | Significant Tree 6 | Pinus halepensis :: Allepo Pine 330 | 3790 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003155.9 | 2103640.4 | 37.7563743055091 | -122.432072816055 | (37.7563743055091, -122.432072816055) | 2 | 4 | 5 | 28862 | 3 | |||||
113217 | 255048 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 45 Eagle St | 3 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6000118.88808 | 2104341.86796 | 37.7581277146448 | -122.44262619575 | (37.7581277146448, -122.44262619575) | 2 | 4 | 5 | 28862 | 3 | ||||
113829 | 101236 | Significant Tree 6 | Tree(s) :: 17 | 895X Church St | 1 | Back Yard : Yard | Tree | Private 2 | 10/05/2012 12:00:00 AM | 13 | Permit Number 769299 | 6004383.5 | 2103691.7 | 37.7565846850157 | -122.427831000859 | (37.7565846850157, -122.427831000859) | 2 | 4 | 5 | 28862 | 3 | ||
121953 | 100550 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 2 | Front Yard : Yard | Tree | Private 2 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | |||||
136228 | 252825 | Significant Tree 6 | Ilex spp :: Holly Species 81 | 3852 17th St | 4 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
138982 | 104716 | Significant Tree 6 | Juniperus chinensis :: Juniper 113 | 3618 22nd St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 770676 | 6004228.3 | 2103103.8 | 37.7549616692716 | -122.428325838726 | (37.7549616692716, -122.428325838726) | 2 | 4 | 5 | 28862 | 22 | ||||
143770 | 110950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 342 HILL ST | Front Yard : Yard | Tree | Private 2 | 15 | 3x3 | Permit Number 778799 | 6004048 | 2103384 | 37.7557208285242 | -122.428969343229 | (37.7557208285242, -122.428969343229) | 2 | 4 | 5 | 28862 | 22 | |||
159259 | 104674 | Significant Tree 6 | Taxus baccata :: Irish Yew 86 | 3649-3651 17TH ST | 1 | Front Yard : Yard | Tree | Private 2 | 20 | Permit Number 770917 | 6004555.5 | 2105964.3 | 37.7628344347284 | -122.427398052716 | (37.7628344347284, -122.427398052716) | 8 | 4 | 5 | 28862 | 3 | |||
160817 | 252823 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 3852 17th St | 2 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
167295 | 223958 | Significant Tree 6 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 98 Seward St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6000714.90104 | 2104629.88079 | 37.7589524846915 | -122.440585589054 | (37.7589524846915, -122.440585589054) | 2 | 4 | 5 | 28862 | 38 | |||
171061 | 100551 | Significant Tree 6 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 143 | 4443 19th St | 3 | Front Yard : Yard | Tree | Private 2 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | |||||
171763 | 106405 | Significant Tree 6 | Pinus Spp :: Pine Spp 100 | 4849X 19th St | Front Yard : Yard | Tree | Private 2 | Permit Number 772769 | 5999644.57626 | 2104777.09851 | 37.7592957011711 | -122.444297841065 | (37.7592957011711, -122.444297841065) | 2 | 4 | 5 | 28862 | 3 | |||||
176722 | 253637 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 701 Noe St | 2 | Front Yard : Yard | Tree | Private 2 | Width 3ft | 6003144.80454 | 2104133.37104 | 37.7577272573137 | -122.432146391441 | (37.7577272573137, -122.432146391441) | 2 | 4 | 5 | 28862 | 3 | ||||
189569 | 252838 | Significant Tree 6 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 | 99 Pond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
189693 | 252829 | Significant Tree 6 | Palm (unknown Genus) :: Palm Spp 273 | 3852 17th St | 8 | Front Yard : Yard | Tree | Private 2 | 6003330 | 2106021 | 37.7629207320267 | -122.431640673814 | (37.7629207320267, -122.431640673814) | 15 | 4 | 5 | 28862 | 3 | |||||
1790 | 103256 | Significant Tree 6 | Maytenus boaria :: Mayten 58 | 4187 26th St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 3x3 | 6002700 | 2100625 | 37.7480688746475 | -122.433434000346 | (37.7480688746475, -122.433434000346) | 2 | 4 | 5 | 63 | 22 | |||
68284 | 253182 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 5157 Diamond Heights Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 6000788 | 2100195 | 37.7467795353698 | -122.440014780391 | (37.7467795353698, -122.440014780391) | 2 | 4 | 5 | 63 | 22 | |||||
69856 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000754 | 2103380 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | 2 | 4 | 5 | 63 | 38 | ||||
86615 | 253183 | Significant Tree 6 | Pinus pinea :: Italian Stone Pine 63 | 5159 Diamond Heights Blvd | 1 | Front Yard : Yard | Tree | Private 2 | 6000808 | 2099903 | 37.745978911495 | -122.439924689335 | (37.745978911495, -122.439924689335) | 2 | 4 | 5 | 63 | 22 | |||||
91521 | 255902 | Significant Tree 6 | Pittosporum undulatum :: Victorian Box 36 | 3943 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 6004266 | 2100418 | 37.7475892225894 | -122.428004081153 | (37.7475892225894, -122.428004081153) | 2 | 4 | 5 | 63 | 22 | |||||
159982 | 102589 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 5157 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6000788.8 | 2100195.2 | 37.7467801300642 | -122.440012028415 | (37.7467801300642, -122.440012028415) | 2 | 4 | 5 | 63 | 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) );