trees
3,587 rows where qSpecies_id = 28 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79 | 121399 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
100 | 255131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
1723 | 19755 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
1845 | 20002 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2 | |||||||||||||
2868 | 255125 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 3 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3319 | 255128 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 6 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
3449 | 19754 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY15 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | |||||||||||||
4083 | 19998 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40 | |||||||||||||
5059 | 255129 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 7 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5129 | 255126 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 4 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
5510 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1601X Portola Dr | 5 | Front Yard : Yard | Tree | Private 2 | |||||||||||||||
6473 | 48743 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
7374 | 48751 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
8604 | 48746 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
8612 | 255133 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 11 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
8893 | 50823 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
9839 | 48748 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
10173 | 48744 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
10238 | 255130 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 8 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
10360 | 30354 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/17/1956 12:00:00 AM | Permit Number 43 | ||||||||||||||
10635 | 255127 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
11935 | 50824 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | Permit Number 47344 | ||||||||||||||
12040 | 48742 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12785 | 48747 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
12883 | 255123 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
15071 | 48749 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
15641 | 48745 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
17595 | 255124 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
18540 | 48750 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 46023 | |||||||||||||||
19147 | 255132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 10 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
2152 | 33675 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/03/1996 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | 7 | 9 | 11 | 28852 | 10 | |
8782 | 22575 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006314.95978 | 2112814.99848 | 37.7817441651975 | -122.421799324385 | (37.7817441651975, -122.421799324385) | 7 | 9 | 11 | 28852 | 41 | |||
11636 | 249410 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 698 Polk St | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6007114.55441 | 2113257.76141 | 37.7830049436594 | -122.419064511231 | (37.7830049436594, -122.419064511231) | 7 | 9 | 9 | 28852 | 36 | |||
11714 | 24315 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006566.61253 | 2112551.64159 | 37.7810352395317 | -122.420910018978 | (37.7810352395317, -122.420910018978) | 7 | 9 | 11 | 28852 | 41 | |||
20912 | 24331 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
21249 | 112640 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 299X STOCKTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6x9 | 6010693 | 2115178 | 37.7884783251045 | -122.406819877074 | (37.7884783251045, -122.406819877074) | 5 | 1 | 10 | 28852 | 6 | |||
25658 | 7812 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006212.78826 | 2112695.72596 | 37.7814109097272 | -122.422144314234 | (37.7814109097272, -122.422144314234) | 7 | 9 | 11 | 28852 | 41 | |||
27004 | 141435 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 HAYES ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005366.2195 | 2110950.1956 | 37.776570325295 | -122.424948806725 | (37.776570325295, -122.424948806725) | 7 | 9 | 11 | 28852 | 10 | |||
28479 | 126251 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 100 Elm St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6007028.01622 | 2112773.92137 | 37.7816715629397 | -122.419329563908 | (37.7816715629397, -122.419329563908) | 7 | 9 | 9 | 28852 | 36 | |||
28914 | 24330 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
28970 | 7813 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006213.15076 | 2112713.37247 | 37.7814593831787 | -122.422144314209 | (37.7814593831787, -122.422144314209) | 7 | 9 | 11 | 28852 | 41 | |||
29063 | 22577 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006373.00538 | 2112825.19303 | 37.7817754301315 | -122.421599237822 | (37.7817754301315, -122.421599237822) | 7 | 9 | 11 | 28852 | 41 | |||
29506 | 33680 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 419 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 13 | Permit Number 37760 | 6005344.46198727 | 2111116.85391927 | 37.7770266994083 | -122.425035932953 | (37.7770266994083, -122.425035932953) | 7 | 9 | 11 | 28852 | 10 | ||
30511 | 103595 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
31160 | 7815 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006205.55902 | 2112775.31728 | 37.781629040289 | -122.422174980189 | (37.781629040289, -122.422174980189) | 7 | 9 | 11 | 28852 | 41 | |||
31425 | 103598 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
32098 | 23170 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 202X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006871.78386 | 2111296.65749 | 37.7776065535391 | -122.419765202716 | (37.7776065535391, -122.419765202716) | 7 | 9 | 9 | 28852 | 36 | |||
35935 | 24314 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006601.99404 | 2112547.97273 | 37.7810271600142 | -122.420787355977 | (37.7810271600142, -122.420787355977) | 7 | 9 | 11 | 28852 | 41 | |||
42257 | 115376 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6004637 | 2110246 | 37.7745955592359 | -122.427421211008 | (37.7745955592359, -122.427421211008) | 7 | 9 | 11 | 28852 | 10 | ||||
42309 | 24332 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/1999 12:00:00 AM | 9 | 6006393.27479 | 2112527.98365 | 37.7809605085733 | -122.421508000714 | (37.7809605085733, -122.421508000714) | 7 | 9 | 11 | 28852 | 41 | |||
42596 | 103592 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
44167 | 141431 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/2005 12:00:00 AM | 17 | Width 0ft | Permit Number 48304 | 6005404.7905 | 2110954.8993 | 37.7765854191309 | -122.424815713066 | (37.7765854191309, -122.424815713066) | 7 | 9 | 11 | 28852 | 10 | |
44305 | 126250 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 611 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006607.01339 | 2112503.55173 | 37.7809054736589 | -122.420766837016 | (37.7809054736589, -122.420766837016) | 7 | 9 | 11 | 28852 | 41 | |||
47322 | 248672 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 97 Hermann St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004845.3119 | 2108840.52494 | 37.7707482453776 | -122.426600516098 | (37.7707482453776, -122.426600516098) | 7 | 9 | 5 | 28852 | 10 | |||
47482 | 22584 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006566.74341 | 2112845.87169 | 37.7818431310978 | -122.420930462379 | (37.7818431310978, -122.420930462379) | 7 | 9 | 11 | 28852 | 41 | |||
50941 | 24317 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006479.1525 | 2112537.25416 | 37.7809908049215 | -122.421211565287 | (37.7809908049215, -122.421211565287) | 7 | 9 | 11 | 28852 | 41 | |||
54643 | 258523 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
54789 | 126249 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 611 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006560.14321 | 2112498.86101 | 37.7808899522457 | -122.420928651146 | (37.7808899522457, -122.420928651146) | 7 | 9 | 11 | 28852 | 41 | |||
55548 | 248673 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6005207.14412 | 2108888.77574 | 37.7709011795763 | -122.425352365033 | (37.7709011795763, -122.425352365033) | 7 | 9 | 5 | 28852 | 10 | |||
56021 | 24324 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006305.76929 | 2112511.39113 | 37.7809100152295 | -122.421809546989 | (37.7809100152295, -122.421809546989) | 7 | 9 | 11 | 28852 | 41 | |||
56140 | 248668 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 4ft | 6004619.27289 | 2110222.43512 | 37.7745298532048 | -122.427480853466 | (37.7745298532048, -122.427480853466) | 7 | 9 | 11 | 28852 | 10 | |||
57896 | 24322 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006352.81998 | 2112520.5015 | 37.7809376833117 | -122.421647422525 | (37.7809376833117, -122.421647422525) | 7 | 9 | 11 | 28852 | 41 | |||
60934 | 258521 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
62274 | 258513 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005031 | 2108842 | 37.7707627914543 | -122.425958322168 | (37.7707627914543, -122.425958322168) | 7 | 9 | 5 | 28852 | 10 | ||||
64623 | 141433 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6005339.4079 | 2110947.8437 | 37.7765623530515 | -122.425041388509 | (37.7765623530515, -122.425041388509) | 7 | 9 | 11 | 28852 | 10 | |||
65764 | 103594 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
70820 | 138840 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 451 IVY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6005172.3876 | 2111107.6921 | 37.7769918216657 | -122.425630539914 | (37.7769918216657, -122.425630539914) | 7 | 9 | 11 | 28852 | 10 | |||
71025 | 126240 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700 Van Ness Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 6006641.75911 | 2112973.79327 | 37.7821986007353 | -122.42068002636 | (37.7821986007353, -122.42068002636) | 7 | 9 | 9 | 28852 | 36 | |||
73622 | 24333 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
73970 | 23177 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Van Ness Ave | 2 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | |||
74481 | 66033 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 176 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/1990 12:00:00 AM | 18 | 5x5 | Permit Number 29070 | 6005715.54101004 | 2110005.55330132 | 37.7739962917294 | -122.423673221036 | (37.7739962917294, -122.423673221036) | 7 | 9 | 11 | 28852 | 10 |
78660 | 126245 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 679 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6006341.80281 | 2112471.00109 | 37.7808011460043 | -122.421682019523 | (37.7808011460043, -122.421682019523) | 7 | 9 | 11 | 28852 | 41 | |||
79926 | 52113 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 501 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2005 12:00:00 AM | 4x4 | Permit Number 48304 | 6005450.41519372 | 2110958.1148217 | 37.7765968250138 | -122.424658112662 | (37.7765968250138, -122.424658112662) | 7 | 9 | 11 | 28852 | 10 | |
81117 | 141436 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 HAYES ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6005378.4493 | 2110951.6067 | 37.7765748906289 | -122.424906600688 | (37.7765748906289, -122.424906600688) | 7 | 9 | 11 | 28852 | 10 | |||
82924 | 47042 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/2002 12:00:00 AM | 6x9 | Permit Number 45032 | 6004340.5553933 | 2108752.14114491 | 37.7704770161634 | -122.428340177957 | (37.7704770161634, -122.428340177957) | 7 | 9 | 11 | 28852 | 10 | |
83927 | 117355 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500 Hayes St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6005443.21862963 | 2111009.61442816 | 37.7767378239513 | -122.424686672119 | (37.7767378239513, -122.424686672119) | 7 | 9 | 11 | 28852 | 10 | |||
84823 | 33683 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Ivy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.4247810873 | (37.7772038638652, -122.4247810873) | 7 | 9 | 11 | 28852 | 10 | |||
87435 | 248671 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 50 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6004331.06987 | 2108798.07115 | 37.7706025920658 | -122.428376262559 | (37.7706025920658, -122.428376262559) | 7 | 9 | 11 | 28852 | 10 | |||
87538 | 103597 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 10X Hermann St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.425958137982 | (37.7707643495235, -122.425958137982) | 7 | 9 | 5 | 28852 | 10 | ||||
92796 | 244245 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 176 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005740.1233 | 2110010.337 | 37.7740108141999 | -122.423588526804 | (37.7740108141999, -122.423588526804) | 7 | 9 | 11 | 28852 | 10 | |||
93162 | 126243 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 679 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6006291.93692 | 2112463.21725 | 37.7807769614403 | -122.421853977089 | (37.7807769614403, -122.421853977089) | 7 | 9 | 11 | 28852 | 41 | |||
95244 | 22579 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006429.75961 | 2112830.68466 | 37.7817937088462 | -122.421403284548 | (37.7817937088462, -122.421403284548) | 7 | 9 | 11 | 28852 | 41 | |||
96227 | 22583 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006548.99233 | 2112844.76483 | 37.7818390913318 | -122.420991794355 | (37.7818390913318, -122.420991794355) | 7 | 9 | 11 | 28852 | 41 | |||
98369 | 7809 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006235.14399 | 2112561.39045 | 37.7810433181208 | -122.422057428004 | (37.7810433181208, -122.422057428004) | 7 | 9 | 11 | 28852 | 41 | |||
99804 | 141432 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 511 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6005324.8262 | 2110946.4325 | 37.7765576545373 | -122.425091730432 | (37.7765576545373, -122.425091730432) | 7 | 9 | 11 | 28852 | 10 | |||
100668 | 24327 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | |||
100689 | 126247 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 649 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6006451.94637 | 2112482.08949 | 37.7808378023715 | -122.421301766381 | (37.7808378023715, -122.421301766381) | 7 | 9 | 11 | 28852 | 41 | |||
107918 | 142012 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 749 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004871.6299 | 2111553.6762 | 37.7781993856574 | -122.426702721407 | (37.7781993856574, -122.426702721407) | 7 | 9 | 11 | 28852 | 10 | |||
107994 | 24335 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | 7 | 9 | 9 | 28852 | 36 | ||||
108047 | 57553 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 601 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1976 12:00:00 AM | 18 | 3x3 | Permit Number 16416 | 6004949.77312 | 2110889.41028 | 37.7763798917414 | -122.426385087108 | (37.7763798917414, -122.426385087108) | 7 | 9 | 11 | 28852 | 10 | |
108348 | 23178 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 300X Van Ness Ave | 3 | Median : Cutout | Tree | DPW 1 | 30 | 9 | 6006874.5373229 | 2111536.5864673 | 37.778265495762 | -122.419772706207 | (37.778265495762, -122.419772706207) | 7 | 9 | 9 | 28852 | 36 | |||
108400 | 24320 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 600X Golden Gate Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006433.20726 | 2112530.1062 | 37.7809685880643 | -122.421370005128 | (37.7809685880643, -122.421370005128) | 7 | 9 | 11 | 28852 | 41 | |||
111613 | 47011 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 190 Hermann St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2002 12:00:00 AM | Permit Number 45008 | 6004362.86360721 | 2108776.26099442 | 37.7705445057003 | -122.428264732992 | (37.7705445057003, -122.428264732992) | 7 | 9 | 11 | 28852 | 10 | |||
113345 | 33684 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 400 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | Permit Number 37762 | 6005419.42693285 | 2111179.83479418 | 37.7772038638652 | -122.4247810873 | (37.7772038638652, -122.4247810873) | 7 | 9 | 11 | 28852 | 10 | |||
113425 | 248674 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 95 Hermann St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6005037.30148 | 2108867.21091 | 37.7708323706535 | -122.425938320109 | (37.7708323706535, -122.425938320109) | 7 | 9 | 5 | 28852 | 10 | |||
118515 | 138823 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 628 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 33 | Width 0ft | 6004357.247 | 2111017.4097 | 37.7766978348647 | -122.428443926863 | (37.7766978348647, -122.428443926863) | 7 | 9 | 11 | 28852 | 10 | |||
119098 | 7810 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 700X Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006241.41357 | 2112578.91563 | 37.7810917915932 | -122.422036983727 | (37.7810917915932, -122.422036983727) | 7 | 9 | 11 | 28852 | 41 | |||
123044 | 22574 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006283.90302 | 2112813.42944 | 37.7817381055674 | -122.421906654863 | (37.7817381055674, -122.421906654863) | 7 | 9 | 11 | 28852 | 41 | |||
123437 | 7801 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 690X Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006253.103271 | 2112460.108328 | 37.7807662350176 | -122.421988100815 | (37.7807662350176, -122.421988100815) | 7 | 9 | 11 | 28852 | 41 | |||
124262 | 22582 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 799X Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4X4 | 6006498.64773 | 2112839.17836 | 37.7818209142342 | -122.421165566743 | (37.7818209142342, -122.421165566743) | 7 | 9 | 11 | 28852 | 41 |
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) );