trees
548 rows where qCaretaker_id = 1 and qSpecies_id = 53 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14802 | 11429 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 810X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6016007.44377 | 2096780.42114 | 37.7382584597776 | -122.387148815626 | (37.7382584597776, -122.387148815626) | 10 | 3 | 8 | 58 | 1 | |||
14874 | 6756 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017521.0990665 | 2096743.3718322 | 37.7382404347673 | -122.381912713319 | (37.7382404347673, -122.381912713319) | 10 | 3 | 8 | 58 | 1 | ||
28345 | 6727 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
39117 | 14994 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016235.7427248 | 2097702.9858463 | 37.7408042749191 | -122.38642376985 | (37.7408042749191, -122.38642376985) | 10 | 3 | 8 | 58 | 1 | |||
41806 | 6719 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
66362 | 6799 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1375 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x9 | 6016685.6205969 | 2097367.3215875 | 37.7399075017412 | -122.384844867735 | (37.7399075017412, -122.384844867735) | 10 | 3 | 8 | 58 | 1 | |||
72329 | 6726 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
74408 | 6773 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1355 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
78348 | 6705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
102193 | 6752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1215 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6017539.76894 | 2096719.16796 | 37.738175006759 | -122.381846478456 | (37.738175006759, -122.381846478456) | 10 | 3 | 8 | 58 | 1 | |||
110376 | 25995 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1781 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6014085.16035 | 2096167.03762 | 37.7364675981514 | -122.39375225191 | (37.7364675981514, -122.39375225191) | 10 | 3 | 8 | 58 | 1 | |||
122954 | 6709 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
142509 | 6722 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
149060 | 6808 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1395 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016583.3780675 | 2097443.6071151 | 37.7401113108781 | -122.385203697211 | (37.7401113108781, -122.385203697211) | 10 | 3 | 8 | 58 | 1 | |||
150567 | 25558 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 50X Industrial St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2001 12:00:00 AM | 8 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | 10 | 3 | 8 | 58 | 1 | ||
169622 | 6721 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
188021 | 6788 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | |||
280 | 8072 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005345.6576 | 2111619.4154 | 37.7784066780298 | -122.425067563729 | (37.7784066780298, -122.425067563729) | 7 | 9 | 11 | 28852 | 10 | |||
1142 | 260393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
7085 | 260395 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
9194 | 260391 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
10644 | 260392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
13855 | 260394 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
14128 | 16935 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 542 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004164.66828 | 2110140.85762 | 37.7742801386068 | -122.429047601533 | (37.7742801386068, -122.429047601533) | 7 | 9 | 11 | 28852 | 10 | |||
24683 | 16945 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 602 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004026.09211 | 2110141.24132 | 37.7742733469863 | -122.429526989132 | (37.7742733469863, -122.429526989132) | 7 | 9 | 11 | 29492 | 10 | |||
25241 | 8179 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1205X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002000.37874 | 2111170.93633 | 37.7769857283744 | -122.436608008152 | (37.7769857283744, -122.436608008152) | 15 | 5 | 11 | 29492 | 10 | |||
28315 | 6990 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 855 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003337.33996 | 2110322.66362 | 37.7747324668328 | -122.431922464006 | (37.7747324668328, -122.431922464006) | 15 | 9 | 11 | 29492 | 10 | |||
29407 | 16958 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 705 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x5 | 6003566.56897 | 2110004.67754 | 37.7738723476787 | -122.431106813505 | (37.7738723476787, -122.431106813505) | 15 | 9 | 11 | 29492 | 10 | |||
34775 | 14651 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | |||
35689 | 7151 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
38510 | 19240 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 8x6 | 6002037.68577 | 2110909.98609 | 37.7762713444054 | -122.436460270394 | (37.7762713444054, -122.436460270394) | 15 | 5 | 11 | 29492 | 10 | |||
39074 | 20124 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 924X Fell St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
40655 | 16939 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
43961 | 17044 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
45836 | 9661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006079.13931 | 2110176.88384 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | 7 | 9 | 11 | 28852 | 10 | |||
48721 | 9675 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 235 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1981 12:00:00 AM | 12 | 3X3 | 6005972.11971 | 2110519.21136 | 37.7754211527567 | -122.422822183014 | (37.7754211527567, -122.422822183014) | 7 | 9 | 11 | 28852 | 10 | ||
50094 | 253202 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800 Oak St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |||
50755 | 7185 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.431575227386 | (37.7773563593355, -122.431575227386) | 15 | 9 | 11 | 29492 | 10 | |||
51714 | 7156 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 712 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003631.55189 | 2110917.37527 | 37.7763820727629 | -122.430947178384 | (37.7763820727629, -122.430947178384) | 7 | 9 | 11 | 29492 | 10 | |||
54208 | 9683 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 298 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/1982 12:00:00 AM | 20 | 3X3 | 6006045.73768 | 2110624.99987 | 37.7757157759068 | -122.422575039685 | (37.7757157759068, -122.422575039685) | 7 | 9 | 11 | 28852 | 10 | ||
57513 | 12263 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004991.72568 | 2111198.95935 | 37.7772322091826 | -122.426262005109 | (37.7772322091826, -122.426262005109) | 7 | 9 | 11 | 28852 | 10 | |||
61171 | 16895 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 371 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005249.75731 | 2110166.87775 | 37.7744129459718 | -122.425295929281 | (37.7744129459718, -122.425295929281) | 7 | 9 | 11 | 28852 | 10 | |||
61483 | 17037 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001158.18128 | 2109720.4277 | 37.7729551007398 | -122.439417421896 | (37.7729551007398, -122.439417421896) | 15 | 5 | 11 | 29492 | 10 | |||
64713 | 7152 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
65399 | 7150 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003528.61787 | 2110726.18593 | 37.7758512811844 | -122.431289605258 | (37.7758512811844, -122.431289605258) | 15 | 9 | 11 | 29492 | 10 | |||
67556 | 9975 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003525.87553 | 2111110.58272 | 37.7769065842705 | -122.431326537326 | (37.7769065842705, -122.431326537326) | 7 | 9 | 11 | 29492 | 10 | |||
67817 | 16940 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 599X Oak St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004143.7777346 | 2110082.9014722 | 37.774119822678 | -122.429115732545 | (37.774119822678, -122.429115732545) | 7 | 9 | 11 | 28852 | 10 | |||
70605 | 7148 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 670X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6003788.041 | 2110084.01472 | 37.7741027355458 | -122.430346367315 | (37.7741027355458, -122.430346367315) | 7 | 9 | 11 | 29492 | 10 | |||
72584 | 16863 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 215 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005958.79101 | 2110336.37823 | 37.774918385113 | -122.422855293382 | (37.774918385113, -122.422855293382) | 7 | 9 | 11 | 28852 | 10 | |||
77397 | 16979 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6003018.00984 | 2109974.66323 | 37.7737588358485 | -122.43300222285 | (37.7737588358485, -122.43300222285) | 15 | 5 | 11 | 29492 | 10 | |||
80201 | 20122 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 924X Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002999.41967 | 2110319.25168 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | 15 | 5 | 11 | 29492 | 10 | |||
81976 | 7711 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 43 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006508.0978555 | 2110273.8315465 | 37.7747776257034 | -122.420950679235 | (37.7747776257034, -122.420950679235) | 7 | 9 | 11 | 28852 | 10 | |||
82016 | 16948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 617 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004030.19479 | 2110006.18975 | 37.7739027607756 | -122.429503163951 | (37.7739027607756, -122.429503163951) | 7 | 9 | 11 | 29492 | 10 | |||
83435 | 14655 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | |||
83704 | 10626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005955 | 2111106 | 37.7770313662769 | -122.422923117926 | (37.7770313662769, -122.422923117926) | 7 | 9 | 11 | 28852 | 10 | |||
83917 | 7189 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5X5 | 6003518.08132 | 2111313.80886 | 37.7774641511736 | -122.43136801056 | (37.7774641511736, -122.43136801056) | 7 | 9 | 11 | 29492 | 10 | |||
90207 | 6932 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | Permit Number 780762 | 6004980.8762 | 2110598.20876 | 37.7755820815859 | -122.426256755638 | (37.7755820815859, -122.426256755638) | 7 | 9 | 11 | 28852 | 10 | ||
93569 | 7144 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 685X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003730.75372 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | 7 | 9 | 11 | 29492 | 10 | |||
95502 | 16899 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005035.08833 | 2110252.02045 | 37.7746345969303 | -122.426044572686 | (37.7746345969303, -122.426044572686) | 7 | 9 | 11 | 28852 | 10 | |||
95868 | 19217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1103X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002080.8485 | 2110141.50629 | 37.7741637433971 | -122.436255949697 | (37.7741637433971, -122.436255949697) | 15 | 5 | 11 | 29492 | 10 | |||
103903 | 7712 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 47 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006492.59831 | 2110356.24747 | 37.7750030463236 | -122.421010148365 | (37.7750030463236, -122.421010148365) | 7 | 9 | 11 | 28852 | 10 | |||
109776 | 23705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004026.4448 | 2110044.61455 | 37.7740080535371 | -122.429518876644 | (37.7740080535371, -122.429518876644) | 7 | 9 | 11 | 29492 | 10 | |||
111324 | 7153 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6003550.62034 | 2110877.34065 | 37.7762675615733 | -122.431224284875 | (37.7762675615733, -122.431224284875) | 7 | 9 | 11 | 29492 | 10 | |||
113219 | 16946 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 609 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004030.19479 | 2110006.18975 | 37.7739027607756 | -122.429503163951 | (37.7739027607756, -122.429503163951) | 7 | 9 | 11 | 29492 | 10 | |||
117462 | 12246 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 501 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | 6004973.20209 | 2110637.42143 | 37.775689316239 | -122.426286094705 | (37.775689316239, -122.426286094705) | 7 | 9 | 11 | 28852 | 10 | ||
122936 | 16856 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 150 Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6006257.87931 | 2110498.54999 | 37.7753805408795 | -122.421832203671 | (37.7753805408795, -122.421832203671) | 7 | 9 | 11 | 28852 | 10 | |||
124076 | 7165 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 735 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003427.15007 | 2110890.32808 | 37.776296224072 | -122.431652329724 | (37.776296224072, -122.431652329724) | 15 | 9 | 11 | 29492 | 10 | |||
140971 | 16959 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 705 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003588.88104 | 2109980.45883 | 37.7738071133695 | -122.431027903554 | (37.7738071133695, -122.431027903554) | 15 | 9 | 11 | 29492 | 10 | |||
141441 | 26425 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005298.7673 | 2111637.29894 | 37.7784531329654 | -122.425231047872 | (37.7784531329654, -122.425231047872) | 7 | 9 | 11 | 28852 | 10 | |||
142032 | 16862 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 205 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 7x6 | 6005961.9803 | 2110311.49787 | 37.7748502496054 | -122.422842492323 | (37.7748502496054, -122.422842492323) | 7 | 9 | 11 | 28852 | 10 | |||
142334 | 12245 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 503 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/03/2015 03:15:00 PM | 3 | 5x5 | Permit Number 780762 | 6004995.5845 | 2110652.4736 | 37.7757319109571 | -122.426209740207 | (37.7757319109571, -122.426209740207) | 7 | 9 | 11 | 28852 | 10 | |
158220 | 9662 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6006086.53311 | 2110106.07673 | 37.7742932396102 | -122.422397038566 | (37.7742932396102, -122.422397038566) | 7 | 9 | 11 | 28852 | 10 | |||
160258 | 6989 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 848 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15x3.5 | 6003368.38608 | 2110385.91832 | 37.7749079085756 | -122.431819586637 | (37.7749079085756, -122.431819586637) | 15 | 9 | 11 | 29492 | 10 | |||
161897 | 253634 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830 Oak St | 1 | Sidewalk: Property side : Cutout | tree | DPW 1 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.432999691851 | (37.7737452502421, -122.432999691851) | 15 | 5 | 11 | 29492 | 10 | |||||
162520 | 10628 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 805 Hayes St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/02/1990 12:00:00 AM | 6 | 3X4 | 6003942.23141 | 2110755.32974 | 37.775954734286 | -122.429860889744 | (37.775954734286, -122.429860889744) | 7 | 9 | 11 | 29492 | 10 | ||
163768 | 9696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3X3 | 6005964.80411 | 2111186.62637 | 37.7772532999259 | -122.422894934036 | (37.7772532999259, -122.422894934036) | 7 | 9 | 11 | 28852 | 10 | |||
163968 | 16919 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 13x6 | 6004493.27484 | 2110185.04209 | 37.7744200538695 | -122.427914040239 | (37.7744200538695, -122.427914040239) | 7 | 9 | 11 | 28852 | 10 | |||
164782 | 26423 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005252.46633 | 2111627.39845 | 37.7784233328254 | -122.425390515771 | (37.7784233328254, -122.425390515771) | 7 | 9 | 11 | 28852 | 10 | |||
172277 | 10647 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 913 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6003471.55966 | 2110689.4075 | 37.775747062973 | -122.431484357932 | (37.775747062973, -122.431484357932) | 15 | 9 | 11 | 29492 | 10 | ||
173262 | 16934 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 534 Oak St | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004202.21217 | 2110156.57626 | 37.7743254232669 | -122.428918851232 | (37.7743254232669, -122.428918851232) | 7 | 9 | 11 | 28852 | 10 | |||
174129 | 16872 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 259 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6005773.57352 | 2110239.8238 | 37.7746428175577 | -122.423489134945 | (37.7746428175577, -122.423489134945) | 7 | 9 | 11 | 28852 | 10 | |||
182795 | 26424 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 555 Fulton St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005277.15037 | 2111634.16402 | 37.7784433040001 | -122.425305605903 | (37.7784433040001, -122.425305605903) | 7 | 9 | 11 | 28852 | 10 | |||
188552 | 17045 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.7729834911046 | -122.439151661694 | (37.7729834911046, -122.439151661694) | 15 | 5 | 11 | 29492 | 10 | |||
188563 | 10618 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 350 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6006025.52151 | 2110969.11138 | 37.7766594822933 | -122.422669431679 | (37.7766594822933, -122.422669431679) | 7 | 9 | 11 | 28852 | 10 | |||
191157 | 16897 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 385 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005198.99692 | 2110159.80887 | 37.7743906686767 | -122.425471016021 | (37.7743906686767, -122.425471016021) | 7 | 9 | 11 | 28852 | 10 | |||
191412 | 2431 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 490X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6004657.78302 | 2110211.29448 | 37.7745014417711 | -122.427346845616 | (37.7745014417711, -122.427346845616) | 7 | 9 | 11 | 28852 | 10 | |||
192852 | 16949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 625 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003989.24409 | 2110039.43116 | 37.7739917148646 | -122.429647190447 | (37.7739917148646, -122.429647190447) | 7 | 9 | 11 | 29492 | 10 | |||
97500 | 1685 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 452X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5994164.03145 | 2111506.7878 | 37.7774594509207 | -122.463740525584 | (37.7774594509207, -122.463740525584) | 11 | 6 | 2 | 54 | 11 | |||
112841 | 1679 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 350X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994545.07613 | 2111468.1594 | 37.7773753373943 | -122.462419573309 | (37.7773753373943, -122.462419573309) | 11 | 6 | 2 | 54 | 11 | |||
162441 | 26666 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1015 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 5992306.14573 | 2114757.6166 | 37.7862781034857 | -122.470404314824 | (37.7862781034857, -122.470404314824) | 11 | 6 | 2 | 54 | 11 | |||
20638 | 21644 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1657 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004676.7022509 | 2114666.9735246 | 37.7867367053745 | -122.427598912468 | (37.7867367053745, -122.427598912468) | 13 | 9 | 11 | 28858 | 13 | |||
40439 | 2452 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1805X Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6003959.520066 | 2114567.2690482 | 37.7864223498862 | -122.430073076908 | (37.7864223498862, -122.430073076908) | 13 | 9 | 11 | 29490 | 13 | |||
94054 | 21691 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1881 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6003627.3299403 | 2114521.0871369 | 37.7862767266181 | -122.431219072895 | (37.7862767266181, -122.431219072895) | 13 | 9 | 11 | 29490 | 13 | |||
100106 | 7244 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1700 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 4x4 | 6003093.09301 | 2114182.05294 | 37.785315535228 | -122.433043161197 | (37.785315535228, -122.433043161197) | 13 | 9 | 11 | 29490 | 13 | |||
104538 | 21643 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1653 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004694.8905536 | 2114669.5021072 | 37.786744676998 | -122.427536165445 | (37.786744676998, -122.427536165445) | 13 | 9 | 11 | 28858 | 13 | |||
106831 | 7272 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1761 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003036.70673 | 2114326.97944 | 37.78571026818 | -122.433248599687 | (37.78571026818, -122.433248599687) | 13 | 9 | 11 | 29490 | 13 | |||
112969 | 21752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1787X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002537.7996519 | 2114344.6571005 | 37.7857304915222 | -122.434975938446 | (37.7857304915222, -122.434975938446) | 13 | 9 | 11 | 29490 | 13 | |||
119793 | 7270 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1761 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 4X4 | 6003016.86176 | 2114375.85752 | 37.7858433492106 | -122.433320751484 | (37.7858433492106, -122.433320751484) | 13 | 9 | 11 | 29490 | 13 | |||
140240 | 7269 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1761 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003018.18645 | 2114357.73087 | 37.7857936531706 | -122.433314872696 | (37.7857936531706, -122.433314872696) | 13 | 9 | 11 | 29490 | 13 | |||
145803 | 7268 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1761 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003036.70673 | 2114326.97944 | 37.78571026818 | -122.433248599687 | (37.78571026818, -122.433248599687) | 13 | 9 | 11 | 29490 | 13 |
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) );