trees
3,267 rows where qSpecies_id = 67 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133675 | 31131 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 6 | Permit Number 34846 | 5997461.35333 | 2093947.48586 | 37.7294354301769 | -122.45106749418 | (37.7294354301769, -122.45106749418) | 9 | 7 | 4 | 28861 | 40 | |
146950 | 53727 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 14 | 3x3 | Permit Number 9406 | 6012545.27593 | 2095206.78524 | 37.7337452530338 | -122.399008939832 | (37.7337452530338, -122.399008939832) | 10 | 3 | 8 | 58 | 1 | |
44911 | 105550 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6017193.2263 | 2092868.7457 | 37.7275833669602 | -122.382776791229 | (37.7275833669602, -122.382776791229) | 10 | 3 | 8 | 58 | 1 | |||
168064 | 105549 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6017207.7562 | 2092857.3745 | 37.7275529466122 | -122.382725769768 | (37.7275529466122, -122.382725769768) | 10 | 3 | 8 | 58 | 1 | |||
1578 | 10783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
10973 | 10788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
35428 | 10789 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1200X Hudson Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x4 | 6017715.9911991 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | 10 | 3 | 8 | 58 | 1 | |||
24325 | 69162 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 6 | Permit Number 33199 | 5982705.2838 | 2106882.9636 | 37.7640968091015 | -122.503037064776 | (37.7640968091015, -122.503037064776) | 1 | 8 | 3 | 56 | 35 | |
176428 | 220993 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 Diamond St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 4ft | 6001989.83823 | 2100489.19033 | 37.7476556570997 | -122.435879993478 | (37.7476556570997, -122.435879993478) | 2 | 4 | 5 | 63 | 22 | |||
107964 | 103999 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6017169.9617 | 2092803.1151 | 37.727401872803 | -122.382852652572 | (37.727401872803, -122.382852652572) | 10 | 3 | 8 | 58 | 1 | |||
4862 | 113857 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 SAN BRUNO AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011184 | 2102716 | 37.7542879873687 | -122.40424363426 | (37.7542879873687, -122.40424363426) | 10 | 4 | 8 | 28859 | 19 | ||||
51668 | 113856 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011184 | 2102716 | 37.7542879873687 | -122.40424363426 | (37.7542879873687, -122.40424363426) | 10 | 4 | 8 | 28859 | 19 | ||||
71489 | 220792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011142.79 | 2102716.47867 | 37.7542869988688 | -122.404386183281 | (37.7542869988688, -122.404386183281) | 10 | 4 | 8 | 28859 | 19 | |||
134154 | 220791 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011142.88889 | 2102704.62469 | 37.7542544559807 | -122.404385006975 | (37.7542544559807, -122.404385006975) | 10 | 4 | 8 | 28859 | 19 | |||
58748 | 220868 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1203 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5997388.6326 | 2105850.76689 | 37.7621147564205 | -122.45217741766 | (37.7621147564205, -122.45217741766) | 15 | 5 | 11 | 29492 | 12 | |||
142156 | 67191 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1203 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30641 | 5997390.38850911 | 2105838.38169829 | 37.7620808504058 | -122.452170451006 | (37.7620808504058, -122.452170451006) | 15 | 5 | 11 | 29492 | 12 | ||
155826 | 202069 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Jamestown Ave | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6012889.60074 | 2090482.04244 | 37.7207912554832 | -122.397487253644 | (37.7207912554832, -122.397487253644) | 10 | 3 | 8 | 58 | 1 | |||
100530 | 199919 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6017156.1904 | 2092897.3103 | 37.7276597535169 | -122.382906813046 | (37.7276597535169, -122.382906813046) | 10 | 3 | 8 | 58 | 1 | |||
145586 | 199918 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1208 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6017172.7159 | 2092880.7849 | 37.7276152910588 | -122.382848534061 | (37.7276152910588, -122.382848534061) | 10 | 3 | 8 | 58 | 1 | |||
11637 | 220924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 121 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6009569.56061 | 2097892.28263 | 37.7409527796372 | -122.409486379805 | (37.7409527796372, -122.409486379805) | 10 | 7 | 7 | 28859 | 2 | |||
178960 | 62947 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 121 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/05/1986 12:00:00 AM | 15 | Permit Number 23329 | 6007211.24104465 | 2097034.38673891 | 37.7384647641833 | -122.417579811496 | (37.7384647641833, -122.417579811496) | 2 | 7 | 7 | 28859 | 2 | |
15502 | 78224 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009704.84764 | 2090538.93921 | 37.7207696402774 | -122.408500030351 | (37.7207696402774, -122.408500030351) | 9 | 3 | 7 | 309 | 28 | |||
151316 | 199946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1215 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6017105.5123 | 2092851.5899 | 37.7275314140336 | -122.383078828854 | (37.7275314140336, -122.383078828854) | 10 | 3 | 8 | 58 | 1 | |||
161750 | 202070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1216 Jamestown Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6012852.30909 | 2090513.27274 | 37.7208749311243 | -122.39761834962 | (37.7208749311243, -122.39761834962) | 10 | 3 | 8 | 58 | 1 | |||
22678 | 199908 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1216 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6017309.9205 | 2093127.3901 | 37.7283000004206 | -122.382391361643 | (37.7283000004206, -122.382391361643) | 10 | 3 | 8 | 58 | 1 | |||
181803 | 122801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1219 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 6017253.657 | 2093097.6354 | 37.7282151918398 | -122.382583799411 | (37.7282151918398, -122.382583799411) | 10 | 3 | 8 | 58 | 1 | |||
61914 | 205829 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 122 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995652.85009 | 2090722.80681 | 37.7204775260872 | -122.457086459674 | (37.7204775260872, -122.457086459674) | 9 | 8 | 6 | 28861 | 24 | |||
109189 | 205665 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 122 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5995342.85966 | 2107068.64678 | 37.7653413368515 | -122.459341114012 | (37.7653413368515, -122.459341114012) | 15 | 5 | 11 | 56 | 12 | |||
165489 | 217684 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 122 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5992791.476 | 2097696.8524 | 37.7394617884735 | -122.467484111143 | (37.7394617884735, -122.467484111143) | 1 | 8 | 4 | 59 | 40 | |||
168904 | 175631 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1220 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011388.92797 | 2089147.79242 | 37.7170440044489 | -122.402580872525 | (37.7170440044489, -122.402580872525) | 10 | 7 | 8 | 309 | 39 | |||
75121 | 199914 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1220 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6017119.8344 | 2092922.0985 | 37.7277258082427 | -122.38303422196 | (37.7277258082427, -122.38303422196) | 10 | 3 | 8 | 58 | 1 | |||
77427 | 10850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1220X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017356.4574634 | 2095156.0177673 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | 10 | 3 | 8 | 58 | 1 | |||
29201 | 199977 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1221 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016917.6728 | 2092649.1528 | 37.7269651801144 | -122.383714109339 | (37.7269651801144, -122.383714109339) | 10 | 3 | 8 | 58 | 1 | |||
130327 | 205666 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1223 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5994203.82762 | 2107154.72777 | 37.7655121387998 | -122.46328697674 | (37.7655121387998, -122.46328697674) | 11 | 5 | 11 | 56 | 12 | |||
111247 | 199955 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1226 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016917.6728 | 2092728.4751 | 37.7271829836155 | -122.383719629667 | (37.7271829836155, -122.383719629667) | 10 | 3 | 8 | 58 | 1 | |||
142165 | 220812 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1229 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6010069.32933 | 2101867.34774 | 37.7518954281472 | -122.4080386188 | (37.7518954281472, -122.4080386188) | 2 | 4 | 7 | 28859 | 19 | |||
108439 | 96863 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 123 Marietta Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 2x2 | 5998424 | 2098102 | 37.7408978035844 | -122.448038555069 | (37.7408978035844, -122.448038555069) | 9 | 7 | 4 | 59 | 40 | |||
93130 | 217694 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 123 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5992876.1027 | 2097668.8322 | 37.7393897375089 | -122.467189474797 | (37.7393897375089, -122.467189474797) | 1 | 8 | 4 | 59 | 40 | |||
95488 | 217695 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 123 West Portal Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5992894.2168 | 2097688.0784 | 37.7394436283489 | -122.46712824371 | (37.7394436283489, -122.46712824371) | 1 | 8 | 4 | 59 | 40 | |||
101547 | 55325 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1231 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 11 | Permit Number 11255 | 6011451.82111 | 2089071.07644 | 37.7168368689981 | -122.402358088854 | (37.7168368689981, -122.402358088854) | 10 | 7 | 8 | 309 | 39 | ||
190364 | 199949 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1234 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016872.5031 | 2092757.6701 | 37.7272606504521 | -122.383877814405 | (37.7272606504521, -122.383877814405) | 10 | 3 | 8 | 58 | 1 | |||
20306 | 121801 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6008572.2717 | 2110960.39862 | 37.7767789137416 | -122.413858829626 | (37.7767789137416, -122.413858829626) | 8 | 2 | 9 | 28853 | 34 | |||
20794 | 60190 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/1982 12:00:00 AM | 10 | Permit Number 19735 | 6008544.7327 | 2110936.08659 | 37.776710612043 | -122.413952375309 | (37.776710612043, -122.413952375309) | 8 | 2 | 9 | 28853 | 34 | ||
23301 | 121802 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 6008587.55783 | 2110975.09573 | 37.776820126979 | -122.413806990012 | (37.776820126979, -122.413806990012) | 8 | 2 | 9 | 28853 | 34 | ||||
102088 | 205667 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1237 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5994207.87238 | 2107098.58877 | 37.7653582288099 | -122.463268912939 | (37.7653582288099, -122.463268912939) | 11 | 5 | 11 | 56 | 12 | |||
85612 | 199956 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1238 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016851.5709 | 2092773.0939 | 37.7273018440116 | -122.38395125115 | (37.7273018440116, -122.38395125115) | 10 | 3 | 8 | 58 | 1 | |||
24921 | 62865 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 124 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23233 | 6008284.66656741 | 2098013.35376974 | 37.7412131353607 | -122.413937647032 | (37.7412131353607, -122.413937647032) | 2 | 7 | 7 | 28859 | 2 | ||
156553 | 222486 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 124 Moreland St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 2ft | 6002283.64402 | 2097512.32666 | 37.7394985713917 | -122.4346512003 | (37.7394985713917, -122.4346512003) | 2 | 7 | 5 | 63 | 7 | |||
177438 | 199973 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1241 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016820.1725 | 2092720.7632 | 37.7271564183257 | -122.384056153817 | (37.7271564183257, -122.384056153817) | 10 | 3 | 8 | 58 | 1 | |||
128663 | 66526 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1243 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29700 | 6001379.50731699 | 2100154.2235922 | 37.7467012284206 | -122.437966489528 | (37.7467012284206, -122.437966489528) | 2 | 4 | 5 | 63 | 22 | ||
192965 | 204418 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1245 Willard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5996733.53974 | 2107102.37962 | 37.7655138169466 | -122.454533540707 | (37.7655138169466, -122.454533540707) | 15 | 5 | 11 | 29492 | 12 | |||
15816 | 26895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1245X Lane St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4 | 6015870.9547371 | 2095407.1210845 | 37.7344800964063 | -122.387524951 | (37.7344800964063, -122.387524951) | 10 | 3 | 8 | 58 | 1 | |||
88170 | 59679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1246 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1981 12:00:00 AM | 7 | Permit Number 19105 | 6016818.5199 | 2092798.4329 | 37.7273695927226 | -122.384067273223 | (37.7273695927226, -122.384067273223) | 10 | 3 | 8 | 58 | 1 | ||
47761 | 183269 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1249 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983336.1919 | 2106636.3882 | 37.763456845523 | -122.500836736792 | (37.763456845523, -122.500836736792) | 1 | 8 | 3 | 56 | 35 | |||
192395 | 102739 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1249 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016779.4097 | 2092749.4074 | 37.7272328159816 | -122.384199065737 | (37.7272328159816, -122.384199065737) | 10 | 3 | 8 | 58 | 1 | |||
66511 | 43782 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43412 | 5989265.29398 | 2114516.23084 | 37.7854390383616 | -122.480907074228 | (37.7854390383616, -122.480907074228) | 11 | 6 | 2 | 55 | 26 | |
116438 | 205834 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Ashton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994133.07445 | 2090738.36189 | 37.7204328405763 | -122.462340925011 | (37.7204328405763, -122.462340925011) | 9 | 8 | 6 | 28861 | 24 | |||
1671 | 220925 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Bradford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6009567.35719 | 2097865.4077 | 37.7408788634607 | -122.409492102185 | (37.7408788634607, -122.409492102185) | 10 | 7 | 7 | 28859 | 2 | |||
85023 | 205680 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5991377.35775 | 2104442.29027 | 37.7579012671485 | -122.472865199883 | (37.7579012671485, -122.472865199883) | 1 | 8 | 4 | 56 | 12 | |||
58237 | 205819 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Marston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 1ft | 5998627.13383 | 2093189.37891 | 37.7274205207388 | -122.446982762652 | (37.7274205207388, -122.446982762652) | 9 | 7 | 4 | 28861 | 40 | |||
132609 | 205820 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Marston Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5998660.55096 | 2093188.98198 | 37.7274213400028 | -122.446867211476 | (37.7274213400028, -122.446867211476) | 9 | 7 | 4 | 28861 | 40 | |||
174519 | 205821 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Marston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5998698.45657 | 2093188.19334 | 37.7274213400151 | -122.446736115501 | (37.7274213400151, -122.446736115501) | 9 | 7 | 4 | 28861 | 40 | |||
154213 | 222299 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Precita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007220.48144 | 2100125.0109 | 37.7469514483655 | -122.417766871348 | (37.7469514483655, -122.417766871348) | 2 | 7 | 7 | 28859 | 2 | |||
70232 | 53729 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 125 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/1972 12:00:00 AM | 12 | Permit Number 9408 | 6012570.8653 | 2095236.57105 | 37.7338284646029 | -122.398922559042 | (37.7338284646029, -122.398922559042) | 10 | 3 | 8 | 58 | 1 | ||
61950 | 199932 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1250 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016791.5283 | 2092818.2635 | 37.7274225513541 | -122.384161964499 | (37.7274225513541, -122.384161964499) | 10 | 3 | 8 | 58 | 1 | |||
117486 | 183671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1251 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5984575.2383 | 2106662.4217 | 37.7636009951873 | -122.496553259461 | (37.7636009951873, -122.496553259461) | 1 | 8 | 3 | 56 | 35 | |||
78023 | 199931 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1254 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016771.1469 | 2092830.933 | 37.7274562124229 | -122.38423330569 | (37.7274562124229, -122.38423330569) | 10 | 3 | 8 | 58 | 1 | |||
40436 | 69156 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 7 | Permit Number 33192 | 5983336.7375 | 2106596.5609 | 37.7633475230998 | -122.5008319043 | (37.7633475230998, -122.5008319043) | 1 | 8 | 3 | 56 | 35 | |
98986 | 199916 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016905.5541 | 2092999.2174 | 37.7279257189991 | -122.383780366921 | (37.7279257189991, -122.383780366921) | 10 | 3 | 8 | 58 | 1 | |||
24630 | 199971 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016740.2994 | 2092779.7041 | 37.7273138422776 | -122.384336380249 | (37.7273138422776, -122.384336380249) | 10 | 3 | 8 | 58 | 1 | |||
71044 | 199926 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1258 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016753.5197 | 2092848.5602 | 37.7275036386073 | -122.384295470701 | (37.7275036386073, -122.384295470701) | 10 | 3 | 8 | 58 | 1 | |||
33832 | 62064 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1259 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1985 12:00:00 AM | 8 | Permit Number 22145 | 5983337.283 | 2106566.0084 | 37.7632636666362 | -122.500827758091 | (37.7632636666362, -122.500827758091) | 1 | 8 | 3 | 56 | 35 | ||
52153 | 205828 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 126 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995357.70352 | 2090747.56335 | 37.7205285473285 | -122.458108470822 | (37.7205285473285, -122.458108470822) | 9 | 8 | 6 | 28861 | 24 | |||
149850 | 205650 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1262 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990512.24955 | 2106802.73976 | 37.7643323101209 | -122.476029468985 | (37.7643323101209, -122.476029468985) | 11 | 8 | 3 | 56 | 12 | |||
182656 | 46678 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1262 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | Permit Number 44808 | 5990516.58000296 | 2106798.86325494 | 37.7643219173773 | -122.476014208181 | (37.7643219173773, -122.476014208181) | 11 | 8 | 3 | 56 | 12 | ||
158245 | 199924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1262 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016730.9349 | 2092862.3314 | 37.727540202809 | -122.384374505972 | (37.727540202809, -122.384374505972) | 10 | 3 | 8 | 58 | 1 | |||
123801 | 15228 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1263 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008515.33313 | 2110876.38716 | 37.7765450403581 | -122.414049853039 | (37.7765450403581, -122.414049853039) | 8 | 2 | 9 | 28853 | 34 | |||
144953 | 15230 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1263 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6008515.33313 | 2110876.38716 | 37.7765450403581 | -122.414049853039 | (37.7765450403581, -122.414049853039) | 8 | 2 | 9 | 28853 | 34 | |||
185189 | 15229 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1263 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6008515.33313 | 2110876.38716 | 37.7765450403581 | -122.414049853039 | (37.7765450403581, -122.414049853039) | 8 | 2 | 9 | 28853 | 34 | |||
132559 | 222185 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1266 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003207.46719 | 2100851.79186 | 37.7487203698443 | -122.431695388655 | (37.7487203698443, -122.431695388655) | 2 | 4 | 5 | 28862 | 22 | |||
119610 | 199922 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1266 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6016715.5112 | 2092875.0009 | 37.7275741378954 | -122.384428708392 | (37.7275741378954, -122.384428708392) | 10 | 3 | 8 | 58 | 1 | |||
34065 | 199954 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1269 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016683.5619 | 2092823.2211 | 37.7274301939891 | -122.384535553346 | (37.7274301939891, -122.384535553346) | 10 | 3 | 8 | 58 | 1 | |||
58331 | 199920 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016691.2738 | 2092889.8739 | 37.7276136359457 | -122.384513533626 | (37.7276136359457, -122.384513533626) | 10 | 3 | 8 | 58 | 1 | |||
54030 | 10885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/01/1997 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
58006 | 10893 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
147960 | 10892 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
148501 | 10886 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/16/1999 12:00:00 AM | 6 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | ||
184439 | 10891 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1270X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017265.0162454 | 2095327.7862917 | 37.734339374173 | -122.382699652574 | (37.734339374173, -122.382699652574) | 10 | 3 | 8 | 58 | 1 | |||
180398 | 175636 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1277 Brussels St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011793.26419 | 2088994.55488 | 37.7166458107269 | -122.401172506308 | (37.7166458107269, -122.401172506308) | 10 | 7 | 8 | 309 | 39 | |||
113288 | 199915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1278 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016654.3669 | 2092917.9672 | 37.7276887336226 | -122.384643078505 | (37.7276887336226, -122.384643078505) | 10 | 3 | 8 | 58 | 1 | |||
57295 | 205656 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1280 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5991461.94774 | 2106749.02205 | 37.7642398373174 | -122.472740844327 | (37.7642398373174, -122.472740844327) | 11 | 8 | 11 | 56 | 12 | |||
112898 | 205657 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1280 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5991461.36873 | 2106761.25883 | 37.7642734027321 | -122.472743739228 | (37.7642734027321, -122.472743739228) | 11 | 8 | 11 | 56 | 12 | |||
54321 | 199907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1280 Revere Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016798.1385 | 2093163.3704 | 37.7283705125696 | -122.38416313585 | (37.7283705125696, -122.38416313585) | 10 | 3 | 8 | 58 | 1 | |||
189890 | 199906 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1280 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6016815.2148 | 2093150.1501 | 37.728335156345 | -122.384103181463 | (37.728335156345, -122.384103181463) | 10 | 3 | 8 | 58 | 1 | |||
107773 | 31933 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1282 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 776912 | 5981529.52333604 | 2106358.00177396 | 37.76258623775 | -122.507064660839 | (37.76258623775, -122.507064660839) | 1 | 8 | 3 | 56 | 35 | |
190655 | 199913 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1282 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6016634.5363 | 2092932.8401 | 37.7277284749637 | -122.384712669452 | (37.7277284749637, -122.384712669452) | 10 | 3 | 8 | 58 | 1 | |||
159707 | 205668 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1283 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5994218.5756 | 2106834.27277 | 37.7646331027558 | -122.463212712506 | (37.7646331027558, -122.463212712506) | 11 | 5 | 11 | 56 | 12 | |||
54046 | 183288 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1285 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5982099.3385 | 2106416.2727 | 37.762779775667 | -122.505098228653 | (37.762779775667, -122.505098228653) | 1 | 8 | 3 | 56 | 35 | |||
162969 | 220790 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1285 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011161.83731 | 2102372.64264 | 37.7533439652741 | -122.404296113485 | (37.7533439652741, -122.404296113485) | 10 | 4 | 8 | 28859 | 19 | |||
131813 | 125852 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1294 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6006829.97271 | 2119121.43017 | 37.799089094537 | -122.420465395978 | (37.799089094537, -122.420465395978) | 5 | 1 | 1 | 28858 | 32 |
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) );