trees
3,267 rows where qSpecies_id = 67 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6657 | 142247 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 Laguna St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 0ft | 6004975.0608 | 2110846.6753 | 37.7762639813435 | -122.426294566563 | (37.7762639813435, -122.426294566563) | 7 | 9 | 11 | 28852 | 10 | |||
12381 | 65434 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/1999 12:00:00 AM | Permit Number 33170 | 6008638.12512872 | 2114173.69680574 | 37.785605560242 | -122.41385837708 | (37.785605560242, -122.41385837708) | 7 | 10 | 9 | 28852 | 36 | ||
15598 | 112413 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 469x IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005169 | 2110996 | 37.7766849510116 | -122.425634307332 | (37.7766849510116, -122.425634307332) | 7 | 9 | 11 | 28852 | 10 | ||||
37989 | 12255 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 525 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2X2 | 6004954.30777 | 2110851.12966 | 37.7762750388441 | -122.426366674266 | (37.7762750388441, -122.426366674266) | 7 | 9 | 11 | 28852 | 10 | |||
40684 | 245856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Laguna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6005110.9888 | 2110189.241 | 37.7744665092384 | -122.425777548205 | (37.7744665092384, -122.425777548205) | 7 | 9 | 11 | 28852 | 10 | |||
43279 | 139890 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 983 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004849.4324 | 2112263.6366 | 37.7801475072603 | -122.426830084895 | (37.7801475072603, -122.426830084895) | 7 | 9 | 11 | 28852 | 41 | |||
46215 | 12256 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 525 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2X2 | 6004954.30777 | 2110851.12966 | 37.7762750388441 | -122.426366674266 | (37.7762750388441, -122.426366674266) | 7 | 9 | 11 | 28852 | 10 | |||
50177 | 12316 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
54937 | 31347 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 517 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34958 | 6004983.34013269 | 2110750.23773381 | 37.7759996553204 | -122.426259058519 | (37.7759996553204, -122.426259058519) | 7 | 9 | 11 | 28852 | 10 | ||
58036 | 12254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 525 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6004954.30777 | 2110851.12966 | 37.7762750388441 | -122.426366674266 | (37.7762750388441, -122.426366674266) | 7 | 9 | 11 | 28852 | 10 | |||
60480 | 142245 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 535 Laguna St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 0ft | 6004969.8237 | 2110876.0836 | 37.776344433323 | -122.426314777435 | (37.776344433323, -122.426314777435) | 7 | 9 | 11 | 28852 | 10 | |||
67836 | 22598 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 835 Turk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005965.95079 | 2112761.85116 | 37.7815785478641 | -122.423002954524 | (37.7815785478641, -122.423002954524) | 7 | 9 | 11 | 28852 | 41 | |||
73494 | 33678 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 447 Ivy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1996 12:00:00 AM | 5 | Permit Number 37759 | 6005220.1458 | 2111114.8558 | 37.7770141899152 | -122.425465839355 | (37.7770141899152, -122.425465839355) | 7 | 9 | 11 | 28852 | 10 | ||
81628 | 12317 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
91480 | 12305 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 916 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004841.0657 | 2112154.2707 | 37.7798467423901 | -122.426851238143 | (37.7798467423901, -122.426851238143) | 7 | 9 | 11 | 28852 | 41 | |||
91527 | 12314 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
91611 | 65941 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/2000 12:00:00 AM | Permit Number 28962 | 6007255.62038472 | 2113291.4844342 | 37.7831054816789 | -122.418578871955 | (37.7831054816789, -122.418578871955) | 7 | 9 | 9 | 28852 | 36 | ||
94246 | 12313 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004927.25201 | 2112274.40172 | 37.7801814652814 | -122.426561638009 | (37.7801814652814, -122.426561638009) | 7 | 9 | 11 | 28852 | 41 | |||
95003 | 22599 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 835 Turk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6005992.6226 | 2112765.71653 | 37.7815906662302 | -122.422910957475 | (37.7815906662302, -122.422910957475) | 7 | 9 | 11 | 28852 | 41 | |||
99025 | 139893 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 977 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004903.219 | 2112271.4058 | 37.7801718805445 | -122.426644565829 | (37.7801718805445, -122.426644565829) | 7 | 9 | 11 | 28852 | 41 | |||
99956 | 139891 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 981 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6004864.9708 | 2112266.0271 | 37.7801549495211 | -122.426776500746 | (37.7801549495211, -122.426776500746) | 7 | 9 | 11 | 28852 | 41 | |||
100159 | 33604 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37717 | 6005085.63985065 | 2110091.4174032 | 37.7741964769258 | -122.42585827051 | (37.7741964769258, -122.42585827051) | 7 | 9 | 11 | 28852 | 10 | |||
104970 | 49862 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75@ LAGUNA Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/17/2004 12:00:00 AM | Permit Number 46631 | 6005455.52049644 | 2109220.32111529 | 37.7718255527878 | -122.424516811052 | (37.7718255527878, -122.424516811052) | 7 | 9 | 5 | 28852 | 10 | ||
112304 | 139894 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 975 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004921.7454 | 2112273.7963 | 37.7801794916425 | -122.42658064478 | (37.7801794916425, -122.42658064478) | 7 | 9 | 11 | 28852 | 41 | |||
116230 | 12306 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 916 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004837.4799 | 2112172.7972 | 37.7798974088486 | -122.426864962809 | (37.7798974088486, -122.426864962809) | 7 | 9 | 11 | 28852 | 41 | |||
134284 | 245853 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6005116.9518 | 2110112.3844 | 37.7742558166581 | -122.425751449474 | (37.7742558166581, -122.425751449474) | 7 | 9 | 11 | 28852 | 10 | |||
136339 | 246515 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 73 Waller St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6005379.43616 | 2109216.97454 | 37.7718120669155 | -122.424779754098 | (37.7718120669155, -122.424779754098) | 7 | 9 | 5 | 28852 | 10 | |||
152540 | 138846 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 451 IVY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005131.7932 | 2111102.9163 | 37.7769764146012 | -122.425770628572 | (37.7769764146012, -122.425770628572) | 7 | 9 | 11 | 28852 | 10 | |||
159423 | 142246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 525 Laguna St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 0ft | 6004972.6437 | 2110863.998 | 37.7763114086194 | -122.426304161599 | (37.7763114086194, -122.426304161599) | 7 | 9 | 11 | 28852 | 10 | |||
159951 | 43090 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 146 Leavenworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2000 12:00:00 AM | Permit Number 42926 | 6008611.57202226 | 2112975.23965235 | 37.7823133939911 | -122.413865436957 | (37.7823133939911, -122.413865436957) | 7 | 10 | 9 | 28852 | 36 | |||
160347 | 33603 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37717 | 6005085.63985065 | 2110091.4174032 | 37.7741964769258 | -122.42585827051 | (37.7741964769258, -122.42585827051) | 7 | 9 | 11 | 28852 | 10 | |||
170967 | 222452 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 202 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004685.92692 | 2109166.0286 | 37.7716329876088 | -122.42717502102 | (37.7716329876088, -122.42717502102) | 7 | 9 | 11 | 28852 | 10 | |||
189072 | 138842 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 451 IVY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6005140.3897 | 2111105.3042 | 37.7769834569711 | -122.425741060612 | (37.7769834569711, -122.425741060612) | 7 | 9 | 11 | 28852 | 10 | |||
336 | 189035 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010091.10409 | 2111787.20644 | 37.7791343146469 | -122.408663052281 | (37.7791343146469, -122.408663052281) | 14 | 2 | 9 | 28853 | 34 | |||
6660 | 189023 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010789.05197 | 2109573.65252 | 37.7730954749965 | -122.406092565024 | (37.7730954749965, -122.406092565024) | 14 | 2 | 9 | 28853 | 34 | ||
6771 | 43351 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 385 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1977 12:00:00 AM | 26 | 3x3 | Permit Number 43103 | 6010005.03169 | 2109964.91982 | 37.7741259209126 | -122.408832212936 | (37.7741259209126, -122.408832212936) | 8 | 2 | 9 | 28853 | 34 | |
8685 | 10038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 360 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005474.31982 | 2106984.12162 | 37.7656865461171 | -122.424292710045 | (37.7656865461171, -122.424292710045) | 8 | 4 | 5 | 28853 | 19 | |||
10766 | 189037 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010129.26407 | 2111748.29533 | 37.7790296110535 | -122.408528295169 | (37.7790296110535, -122.408528295169) | 14 | 2 | 9 | 28853 | 34 | |||
10778 | 189038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010137.33918 | 2111739.58339 | 37.7790061423445 | -122.408499745276 | (37.7790061423445, -122.408499745276) | 14 | 2 | 9 | 28853 | 34 | |||
10999 | 31902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 965 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 14 | Permit Number 35327 | 6008027.66279 | 2109898.08591 | 37.7738314549808 | -122.415667565898 | (37.7738314549808, -122.415667565898) | 8 | 2 | 9 | 28853 | 34 | |
12936 | 189036 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010111.83402 | 2111767.71706 | 37.7790819623998 | -122.408589963453 | (37.7790819623998, -122.408589963453) | 14 | 2 | 9 | 28853 | 34 | |||
16254 | 189034 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010058.78317 | 2111821.06751 | 37.7792254789148 | -122.408777253584 | (37.7792254789148, -122.408777253584) | 14 | 2 | 9 | 28853 | 34 | |||
16632 | 42238 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010497.26908 | 2112250.8624 | 37.7804301450699 | -122.407290649051 | (37.7804301450699, -122.407290649051) | 14 | 2 | 9 | 28853 | 34 | |
17030 | 220770 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 54 Pearl St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6005613.92059 | 2108688.47135 | 37.7703741651755 | -122.423931067487 | (37.7703741651755, -122.423931067487) | 8 | 2 | 5 | 28853 | 19 | |||
17297 | 189039 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Russ St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010144.76793 | 2111731.54232 | 37.7789844794824 | -122.408473478765 | (37.7789844794824, -122.408473478765) | 14 | 2 | 9 | 28853 | 34 | |||
17841 | 107624 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 467 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6011064.4697 | 2111919.17259 | 37.7795511306237 | -122.405305061079 | (37.7795511306237, -122.405305061079) | 14 | 2 | 9 | 28853 | 34 | |||
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 | ||||
26334 | 82890 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
29618 | 189028 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6009991.59212 | 2111891.52885 | 37.7794151855119 | -122.409014669189 | (37.7794151855119, -122.409014669189) | 14 | 2 | 9 | 28853 | 34 | |||
36164 | 220776 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Florida St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009138.53931 | 2107166.48847 | 37.7663935067762 | -122.411631809669 | (37.7663935067762, -122.411631809669) | 8 | 4 | 7 | 28853 | 19 | |||
41108 | 189025 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010814.25369 | 2109596.96764 | 37.7731609024948 | -122.406007031421 | (37.7731609024948, -122.406007031421) | 14 | 2 | 9 | 28853 | 34 | ||
43263 | 189033 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Russ St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010004.52225 | 2111908.19053 | 37.779461658872 | -122.408971114137 | (37.779461658872, -122.408971114137) | 14 | 2 | 9 | 28853 | 34 | |||
45547 | 189024 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010801.22197 | 2109583.73033 | 37.7731238270259 | -122.406051177336 | (37.7731238270259, -122.406051177336) | 14 | 2 | 9 | 28853 | 34 | ||
47135 | 189026 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 955 Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | Width 3ft | 6010848.73344 | 2109624.73915 | 37.7732390850389 | -122.405889717541 | (37.7732390850389, -122.405889717541) | 14 | 2 | 9 | 28853 | 34 | ||
49535 | 188849 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1112 Harrison St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6010631.69356 | 2110389.62029 | 37.7753271309641 | -122.406694404849 | (37.7753271309641, -122.406694404849) | 8 | 2 | 9 | 28853 | 34 | |||
58928 | 41287 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80X Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 771150 | 6005120.37250824 | 2107836.80061549 | 37.7680078062065 | -122.425577628833 | (37.7680078062065, -122.425577628833) | 8 | 4 | 5 | 28853 | 19 | ||
65108 | 220778 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Florida St | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009139.51861 | 2107122.54701 | 37.7662729085954 | -122.411625317449 | (37.7662729085954, -122.411625317449) | 8 | 4 | 7 | 28853 | 19 | |||
65906 | 83449 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
66369 | 188856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 355 11th St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6008743.51462 | 2108952.72037 | 37.7712759171908 | -122.413124449536 | (37.7712759171908, -122.413124449536) | 8 | 2 | 9 | 28853 | 34 | |||
67708 | 189044 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 12th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007758.60706 | 2109046.49036 | 37.7714780470117 | -122.416537939674 | (37.7714780470117, -122.416537939674) | 8 | 2 | 9 | 28853 | 19 | |||
69578 | 36092 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | 8 | 4 | 7 | 28853 | 19 | |||
73060 | 220799 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6005109.92864 | 2107867.40022 | 37.7680912352555 | -122.425615931155 | (37.7680912352555, -122.425615931155) | 8 | 4 | 5 | 28853 | 19 | |||
75499 | 189027 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010574.88593 | 2112325.7775 | 37.7806401880397 | -122.40702741658 | (37.7806401880397, -122.40702741658) | 14 | 2 | 9 | 28853 | 34 | |||
78230 | 83448 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
81383 | 10049 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 389 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2003 12:00:00 AM | 3 | 3X3 | 6005557.3779151 | 2106729.2709881 | 37.7649914764619 | -122.42398730533 | (37.7649914764619, -122.42398730533) | 8 | 4 | 5 | 28853 | 19 | ||
85199 | 188855 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Heron St | 3 | : | Tree | Private 2 | 11 | Width 2ft | 6010012.0343 | 2110035.42428 | 37.77431990198 | -122.408812964744 | (37.77431990198, -122.408812964744) | 8 | 2 | 9 | 28853 | 34 | |||
88517 | 36095 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | 8 | 4 | 7 | 28853 | 19 | |||
94346 | 188852 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 397 08th St | 2 | : | Tree | Private 2 | 22 | Width 3ft | 6010041.33013 | 2109925.85439 | 37.77402068943 | -122.408703893195 | (37.77402068943, -122.408703893195) | 8 | 2 | 9 | 28853 | 34 | |||
96914 | 83450 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
99179 | 82893 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52441 | 6008675.9193 | 2110180.49816 | 37.774643311661 | -122.413445110902 | (37.774643311661, -122.413445110902) | 8 | 2 | 9 | 28853 | 34 | |
107416 | 189041 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010127.95445 | 2111781.19498 | 37.7791198724184 | -122.408535147085 | (37.7791198724184, -122.408535147085) | 14 | 2 | 9 | 28853 | 34 | |||
108616 | 220780 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Florida St | 27 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6009142.9779 | 2107062.20163 | 37.7661074081421 | -122.411609088298 | (37.7661074081421, -122.411609088298) | 8 | 4 | 7 | 28853 | 19 | |||
109238 | 188851 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 397 08th St | 1 | : | Tree | Private 2 | 22 | Width 3ft | 6010057.61121 | 2109905.66708 | 37.7739661716411 | -122.408646149513 | (37.7739661716411, -122.408646149513) | 8 | 2 | 9 | 28853 | 34 | |||
109302 | 189032 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010018.15477 | 2111897.569 | 37.7794332582881 | -122.408923203654 | (37.7794332582881, -122.408923203654) | 14 | 2 | 9 | 28853 | 34 | |||
111556 | 189043 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 70 Moss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010322.24625 | 2111201.84362 | 37.7775399884207 | -122.407822145684 | (37.7775399884207, -122.407822145684) | 14 | 2 | 9 | 28853 | 34 | |||
112588 | 82741 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
115833 | 36093 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | 8 | 4 | 7 | 28853 | 19 | |||
118309 | 82892 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
119379 | 188857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Minna St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007556.32266 | 2109725.24267 | 37.7733303617494 | -122.417285761027 | (37.7733303617494, -122.417285761027) | 8 | 2 | 9 | 28853 | 19 | |||
119700 | 220777 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Florida St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009140.42638 | 2107144.02197 | 37.7663319248037 | -122.411623695092 | (37.7663319248037, -122.411623695092) | 8 | 4 | 7 | 28853 | 19 | |||
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 | |||
128587 | 189029 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 22 Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6010013.13639 | 2111867.58146 | 37.7793506384549 | -122.408938448056 | (37.7793506384549, -122.408938448056) | 14 | 2 | 9 | 28853 | 34 | |||
128802 | 82891 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3x3 | Permit Number 52441 | 6008634.678811 | 2110151.0598083 | 37.7745601652378 | -122.413585687931 | (37.7745601652378, -122.413585687931) | 8 | 2 | 9 | 28853 | 34 | ||
130914 | 220781 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Florida St | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009143.97471 | 2107042.08959 | 37.7660522410313 | -122.411604219381 | (37.7660522410313, -122.411604219381) | 8 | 4 | 7 | 28853 | 19 | |||
135264 | 42188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 975 Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42468 | 6010750.56133351 | 2109544.8068813 | 37.7730141185867 | -122.406223676993 | (37.7730141185867, -122.406223676993) | 14 | 2 | 9 | 28853 | 34 | ||
140025 | 220768 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Elgin Park | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6005807.87841 | 2108828.68491 | 37.7707701060921 | -122.423270135033 | (37.7707701060921, -122.423270135033) | 8 | 2 | 5 | 28853 | 19 | |||
142634 | 189042 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010077.81986 | 2111831.85617 | 37.7792561682811 | -122.408712158837 | (37.7792561682811, -122.408712158837) | 14 | 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 | |||
145880 | 220779 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Florida St | 26 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6009143.24348 | 2107098.17408 | 37.7662061950939 | -122.41161071156 | (37.7662061950939, -122.41161071156) | 8 | 4 | 7 | 28853 | 19 | |||
146417 | 188854 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Heron St | 2 | : | Tree | Private 2 | 9 | Width 2ft | 6010001.1667 | 2110025.48762 | 37.7742920095037 | -122.408849856745 | (37.7742920095037, -122.408849856745) | 8 | 2 | 9 | 28853 | 34 | |||
147630 | 36096 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | 8 | 4 | 7 | 28853 | 19 | |||
148480 | 220769 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Elgin Park | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6005807.61785 | 2108816.0076 | 37.7707352825335 | -122.423270135003 | (37.7707352825335, -122.423270135003) | 8 | 2 | 5 | 28853 | 19 | |||
148834 | 42235 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010547.8419 | 2112298.97398 | 37.7805650784617 | -122.407119085392 | (37.7805650784617, -122.407119085392) | 14 | 2 | 9 | 28853 | 34 | |
150453 | 82895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52441 | 6008648.23533 | 2110155.46088 | 37.7745730107591 | -122.413539104453 | (37.7745730107591, -122.413539104453) | 8 | 2 | 9 | 28853 | 34 | |
152636 | 36091 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | 8 | 4 | 7 | 28853 | 19 | |||
153789 | 189040 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 29 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6010153.15667 | 2111754.38254 | 37.7790476631438 | -122.408446070136 | (37.7790476631438, -122.408446070136) | 14 | 2 | 9 | 28853 | 34 | |||
154101 | 36097 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2500 16th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/29/1998 12:00:00 AM | Permit Number 39197 | 6009173.48990003 | 2106882.99462813 | 37.7656170584886 | -122.411490890744 | (37.7656170584886, -122.411490890744) | 8 | 4 | 7 | 28853 | 19 | |||
155201 | 82946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1325 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52441 | 6008626.20144 | 2110135.25412 | 37.7745162905198 | -122.41361389477 | (37.7745162905198, -122.41361389477) | 8 | 2 | 9 | 28853 | 34 |
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) );