trees
3,267 rows where qSpecies_id = 67 sorted by qSiteInfo descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 172398 | 200734 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1434 Oakdale Ave | 1 | unknown : Yard | Tree | Private 2 | 7 | Width 0ft | 6015941.8417 | 2094834.993 | 37.7329130736504 | -122.387239974213 | (37.7329130736504, -122.387239974213) | 10 | 3 | 8 | 58 | 1 | |||
| 49756 | 116671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 Esmeralda Ave | 7 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 8239 | 259577 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Public Park | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 4x4 | 5994278 | 2098760 | 37.7424666368704 | -122.462421492412 | (37.7424666368704, -122.462421492412) | 1 | 8 | 4 | 59 | 40 | ||||
| 12167 | 259578 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 5994424 | 2098888 | 37.7428264992104 | -122.461925951337 | (37.7428264992104, -122.461925951337) | 1 | 8 | 4 | 59 | 40 | ||||
| 18175 | 259579 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Public Park | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 3x3 | 5994369 | 2098919 | 37.7429084509163 | -122.462118372119 | (37.7429084509163, -122.462118372119) | 1 | 8 | 4 | 59 | 40 | ||||
| 40060 | 112793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 4 | Unaccepted Street : Cutout | Tree | Private 2 | 8 | 6010304.6147 | 2116218.08658 | 37.7913124139936 | -122.408237021841 | (37.7913124139936, -122.408237021841) | 5 | 1 | 10 | 28857 | 21 | ||||
| 78634 | 112789 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 8 | 3x3 | 6010300.14411 | 2116243.45137 | 37.7913818092657 | -122.408254279811 | (37.7913818092657, -122.408254279811) | 5 | 1 | 10 | 28857 | 21 | |||
| 100416 | 112791 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 7 | 6010302.18584 | 2116235.66689 | 37.7913605492861 | -122.408246666156 | (37.7913605492861, -122.408246666156) | 5 | 1 | 10 | 28857 | 21 | ||||
| 187045 | 112794 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21x JOICE ST | 5 | Unaccepted Street : Cutout | Tree | Private 2 | 6010276 | 2116206 | 37.7912776248382 | -122.408335175586 | (37.7912776248382, -122.408335175586) | 5 | 1 | 10 | 28857 | 21 | |||||
| 190625 | 112792 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 3 | Unaccepted Street : Cutout | Tree | Private 2 | 5 | 6010303.89255 | 2116225.84414 | 37.7913336739481 | -122.408240067851 | (37.7913336739481, -122.408240067851) | 5 | 1 | 10 | 28857 | 21 | ||||
| 5655 | 222285 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 490X Ogden Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6008298.67066 | 2096058.40427 | 37.7358460585503 | -122.413750978428 | (37.7358460585503, -122.413750978428) | 2 | 7 | 7 | 28859 | 2 | |||
| 6350 | 117651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5101 Anza St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5982808.62425 | 2111663.85148 | 37.77722982032 | -122.503033613638 | (37.77722982032, -122.503033613638) | 11 | 6 | 2 | 55 | 26 | |||
| 6802 | 188921 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012543.15348 | 2101838.55647 | 37.751954571155 | -122.399481710736 | (37.751954571155, -122.399481710736) | 10 | 3 | 8 | 28856 | 29 | |||
| 12669 | 222494 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 2ft | 6003368.61725 | 2097750.91511 | 37.7402152150692 | -122.430916860842 | (37.7402152150692, -122.430916860842) | 2 | 7 | 5 | 63 | 7 | |||
| 12851 | 188928 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6012639.77007 | 2101842.50365 | 37.7519707940373 | -122.39914787158 | (37.7519707940373, -122.39914787158) | 10 | 3 | 8 | 28856 | 29 | |||
| 14482 | 175650 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990453.87404 | 2090277.74723 | 37.7189555611377 | -122.475024995517 | (37.7189555611377, -122.475024995517) | 1 | 8 | 4 | 64 | 14 | |||
| 14824 | 188911 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6012384.77523 | 2101833.46813 | 37.751931770655 | -122.400029051595 | (37.751931770655, -122.400029051595) | 10 | 3 | 8 | 28856 | 29 | |||
| 18314 | 204568 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 61 Burnside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6001187.03477 | 2095752.39336 | 37.7346038888419 | -122.438316738047 | (37.7346038888419, -122.438316738047) | 2 | 7 | 5 | 63 | 7 | ||||
| 20480 | 222416 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Diamond St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 6001716.41483 | 2105639.1941 | 37.7617807931825 | -122.437194157484 | (37.7617807931825, -122.437194157484) | 15 | 4 | 5 | 28862 | 3 | |||
| 20911 | 188282 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Rosie Lee Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6018083.14168 | 2094370.92156 | 37.731757175754 | -122.379804637898 | (37.731757175754, -122.379804637898) | 10 | 3 | 8 | 58 | 1 | |||
| 21122 | 125778 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 20 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5997378.69619 | 2114327.82413 | 37.7853899906986 | -122.452823661499 | (37.7853899906986, -122.452823661499) | 15 | 6 | 1 | 54 | 31 | |||
| 21698 | 222228 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5735 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6000718.4413 | 2097027.59574 | 37.7380786327218 | -122.440028227017 | (37.7380786327218, -122.440028227017) | 2 | 7 | 5 | 63 | 7 | |||
| 22003 | 125776 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 25 Heather Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5997332.30363 | 2114303.61712 | 37.7853208661167 | -122.452982417028 | (37.7853208661167, -122.452982417028) | 15 | 6 | 1 | 54 | 31 | |||
| 22168 | 188924 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6012576.69697 | 2101839.95145 | 37.7519602710713 | -122.399365809709 | (37.7519602710713, -122.399365809709) | 10 | 3 | 8 | 28856 | 29 | |||
| 23213 | 188987 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 305 Bridgeview Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6012918.63111 | 2094968.59879 | 37.7331120403799 | -122.397701430785 | (37.7331120403799, -122.397701430785) | 10 | 3 | 8 | 58 | 1 | |||
| 25461 | 188931 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6012684.2362 | 2101844.79492 | 37.751979563304 | -122.398994261091 | (37.751979563304, -122.398994261091) | 10 | 3 | 8 | 28856 | 29 | |||
| 27241 | 121845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 518 19th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5990042.03941 | 2111801.50629 | 37.7780302806256 | -122.478021255234 | (37.7780302806256, -122.478021255234) | 11 | 6 | 2 | 55 | 26 | |||
| 28203 | 118808 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 894 46th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5981738.11732 | 2109674.1043 | 37.771703578835 | -122.50658917067 | (37.771703578835, -122.50658917067) | 11 | 6 | 2 | 55 | 26 | |||
| 28211 | 175688 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1849 Felton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6005530.78221 | 2092211.86243 | 37.7251284788867 | -122.423047355852 | (37.7251284788867, -122.423047355852) | 9 | 7 | 7 | 309 | 5 | |||
| 29150 | 175710 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Gaven St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6008896.74795 | 2094854.28773 | 37.7325733824383 | -122.411598132751 | (37.7325733824383, -122.411598132751) | 9 | 3 | 7 | 309 | 28 | |||
| 29574 | 125800 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6002016.97166 | 2121171.67387 | 37.8044461176676 | -122.437266859587 | (37.8044461176676, -122.437266859587) | 13 | 9 | 1 | 57 | 17 | |||
| 30696 | 175647 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 199 Shakespeare St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993520.37631 | 2086668.28967 | 37.7092220951912 | -122.464163488366 | (37.7092220951912, -122.464163488366) | 9 | 8 | 6 | 28861 | 25 | |||
| 33845 | 125798 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6002015.8097 | 2121180.08116 | 37.8044691358044 | -122.437271482998 | (37.8044691358044, -122.437271482998) | 13 | 9 | 1 | 57 | 17 | |||
| 33993 | 175658 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6002179.18447 | 2093938.15694 | 37.729678792135 | -122.434756854447 | (37.729678792135, -122.434756854447) | 9 | 7 | 6 | 28861 | 25 | |||
| 34165 | 125799 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6002016.65647 | 2121175.80568 | 37.8044574446054 | -122.437268246357 | (37.8044574446054, -122.437268246357) | 13 | 9 | 1 | 57 | 17 | |||
| 34694 | 188895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1050 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6012767.38997 | 2102598.59008 | 37.7540539548395 | -122.398759597378 | (37.7540539548395, -122.398759597378) | 10 | 3 | 8 | 28856 | 29 | |||
| 35134 | 188923 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012568.02494 | 2101839.32896 | 37.7519580785092 | -122.399395755332 | (37.7519580785092, -122.399395755332) | 10 | 3 | 8 | 28856 | 29 | |||
| 36517 | 188943 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Revere Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6011566.68451 | 2097067.81933 | 37.7388006794984 | -122.402523060487 | (37.7388006794984, -122.402523060487) | 10 | 3 | 8 | 58 | 1 | |||
| 37008 | 188941 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Revere Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6011606.7054 | 2097039.0351 | 37.738723878306 | -122.402382662836 | (37.738723878306, -122.402382662836) | 10 | 3 | 8 | 58 | 1 | |||
| 37241 | 204602 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 Judson Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 5998668.22296 | 2093529.87364 | 37.7283577869805 | -122.446865208659 | (37.7283577869805, -122.446865208659) | 9 | 7 | 4 | 28861 | 40 | |||
| 38176 | 222413 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Diamond St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6001716.61711 | 2105628.79373 | 37.7617522478015 | -122.437192713187 | (37.7617522478015, -122.437192713187) | 15 | 4 | 5 | 28862 | 3 | |||
| 38394 | 202114 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 5ft | 6011999.88588 | 2092811.04962 | 37.7271366533292 | -122.400726278018 | (37.7271366533292, -122.400726278018) | 10 | 3 | 8 | 58 | 1 | |||
| 39774 | 204585 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 132 Melrose Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999120.349 | 2095540.31074 | 37.7339037945118 | -122.445446694533 | (37.7339037945118, -122.445446694533) | 9 | 7 | 4 | 59 | 40 | |||
| 43029 | 204357 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 380 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5991985.99504 | 2091008.33716 | 37.7210502575511 | -122.469782262745 | (37.7210502575511, -122.469782262745) | 9 | 8 | 6 | 64 | 24 | |||
| 43539 | 175599 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 192 Dublin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 6004164.31837 | 2089345.24941 | 37.7171801843089 | -122.427566943762 | (37.7171801843089, -122.427566943762) | 9 | 7 | 6 | 28861 | 5 | |||
| 44453 | 204362 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 304 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5992231.07965 | 2089876.61874 | 37.7179569979942 | -122.468852772034 | (37.7179569979942, -122.468852772034) | 9 | 8 | 6 | 64 | 24 | |||
| 44988 | 188915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012439.14392 | 2101833.80139 | 37.7519357168614 | -122.39984105913 | (37.7519357168614, -122.39984105913) | 10 | 3 | 8 | 28856 | 29 | |||
| 45861 | 202030 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 Fitzgerald Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 7ft | 6013974.71046 | 2090993.7917 | 37.7222567763217 | -122.393772134473 | (37.7222567763217, -122.393772134473) | 10 | 3 | 8 | 58 | 1 | |||
| 47660 | 204502 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 429 Hazelwood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5995590.95327 | 2095806.74609 | 37.7344332461006 | -122.457668080921 | (37.7344332461006, -122.457668080921) | 9 | 7 | 4 | 59 | 40 | |||
| 49240 | 204363 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 304 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5992230.03339 | 2089899.44154 | 37.7180196034048 | -122.468858048362 | (37.7180196034048, -122.468858048362) | 9 | 8 | 6 | 64 | 24 | |||
| 50719 | 204389 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5991049.04584 | 2094416.57218 | 37.7303542198692 | -122.473269434337 | (37.7303542198692, -122.473269434337) | 9 | 8 | 4 | 64 | 40 | |||
| 50963 | 188920 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012536.08431 | 2101837.90146 | 37.7519523786127 | -122.399506111115 | (37.7519523786127, -122.399506111115) | 10 | 3 | 8 | 28856 | 29 | |||
| 56886 | 220986 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 724 27th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 6001794.57947 | 2100036.79591 | 37.7464023951692 | -122.43652281088 | (37.7464023951692, -122.43652281088) | 2 | 7 | 5 | 63 | 22 | |||
| 60200 | 205759 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 158 Stillings Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5999706.25726 | 2095793.86202 | 37.7346334171983 | -122.443439244924 | (37.7346334171983, -122.443439244924) | 9 | 7 | 4 | 63 | 40 | |||
| 63251 | 175693 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 787 Burrows St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6009201.76364 | 2092855.14224 | 37.7271012595966 | -122.410402506577 | (37.7271012595966, -122.410402506577) | 9 | 3 | 7 | 309 | 28 | |||
| 63962 | 222495 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 21 Harry St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6003377.38503 | 2097755.83349 | 37.7402292165951 | -122.430886896324 | (37.7402292165951, -122.430886896324) | 2 | 7 | 5 | 63 | 7 | |||
| 64279 | 118804 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 6940 Fulton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 3ft | 5981816.18929 | 2109660.54581 | 37.7716709477941 | -122.506318113931 | (37.7716709477941, -122.506318113931) | 11 | 6 | 2 | 55 | 26 | |||
| 65161 | 220783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 714 Dolores St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6004945.69428 | 2104158.54536 | 37.757898320067 | -122.425919960442 | (37.757898320067, -122.425919960442) | 2 | 4 | 5 | 28862 | 3 | |||
| 65817 | 204360 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 160 Ralston St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992214.92072 | 2088927.28507 | 37.7153494245261 | -122.46883958168 | (37.7153494245261, -122.46883958168) | 9 | 8 | 6 | 64 | 24 | |||
| 65909 | 204358 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 374 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 5991983.82483 | 2090975.49308 | 37.7209599503178 | -122.469787374484 | (37.7209599503178, -122.469787374484) | 9 | 8 | 6 | 64 | 24 | |||
| 67499 | 175713 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 637 Hamilton St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6009802.33788 | 2091425.99493 | 37.7232107699499 | -122.408225566251 | (37.7232107699499, -122.408225566251) | 10 | 3 | 7 | 309 | 28 | |||
| 68331 | 222182 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 27th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6003111.77565 | 2100072.30365 | 37.7465746530929 | -122.431970636045 | (37.7465746530929, -122.431970636045) | 2 | 7 | 5 | 63 | 22 | ||||
| 68658 | 222175 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4220 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6002470.36275 | 2100366.71232 | 37.7473466464472 | -122.434209614287 | (37.7473466464472, -122.434209614287) | 2 | 4 | 5 | 63 | 22 | |||
| 70387 | 205817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Marston Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5998664.62429 | 2093222.76421 | 37.7275143308076 | -122.446855559853 | (37.7275143308076, -122.446855559853) | 9 | 7 | 4 | 28861 | 40 | ||||
| 70562 | 204589 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 359 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5997724.27189 | 2095500.4152 | 37.7337144539423 | -122.450270459239 | (37.7337144539423, -122.450270459239) | 9 | 7 | 4 | 59 | 40 | |||
| 71124 | 205850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 438 Orizaba Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5994044.85216 | 2089294.81203 | 37.7164641180118 | -122.462541222916 | (37.7164641180118, -122.462541222916) | 9 | 8 | 6 | 28861 | 24 | |||
| 72258 | 175663 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 279 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6004167.57831 | 2091788.97254 | 37.7238902967841 | -122.427729693185 | (37.7238902967841, -122.427729693185) | 9 | 7 | 6 | 28861 | 5 | ||||
| 74033 | 205873 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 366 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5991723.73637 | 2090961.33397 | 37.7209060359618 | -122.470685383523 | (37.7209060359618, -122.470685383523) | 9 | 8 | 6 | 64 | 24 | |||
| 74151 | 125870 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 14 Joice St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 6010321.02235 | 2116231.3383 | 37.791349718756 | -122.408181186526 | (37.791349718756, -122.408181186526) | 5 | 1 | 10 | 28857 | 21 | |||
| 74914 | 184965 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2717 34th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5985820.5401 | 2096898.0233 | 37.7368634938723 | -122.491527432912 | (37.7368634938723, -122.491527432912) | 1 | 8 | 3 | 29491 | 35 | |||
| 75316 | 175649 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | 1 | 8 | 4 | 64 | 14 | |||
| 75704 | 202111 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6011984.90914 | 2092821.29658 | 37.7271639540293 | -122.400778772341 | (37.7271639540293, -122.400778772341) | 10 | 3 | 8 | 58 | 1 | |||
| 76256 | 205815 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Marston Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998671.29704 | 2093222.7898 | 37.7275147822741 | -122.446832494046 | (37.7275147822741, -122.446832494046) | 9 | 7 | 4 | 28861 | 40 | ||||
| 79479 | 125797 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3701 Fillmore St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002015.52454 | 2121185.67578 | 37.8044844809378 | -122.437272870653 | (37.8044844809378, -122.437272870653) | 13 | 9 | 1 | 57 | 17 | |||
| 81499 | 175695 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 787 Burrows St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6009257.80166 | 2092872.55757 | 37.7271522196858 | -122.410210012107 | (37.7271522196858, -122.410210012107) | 9 | 3 | 7 | 309 | 28 | |||
| 81657 | 188919 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012522.72897 | 2101837.16706 | 37.7519496176856 | -122.399552244535 | (37.7519496176856, -122.399552244535) | 10 | 3 | 8 | 28856 | 29 | |||
| 81922 | 121846 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 522 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5990030.00714 | 2111778.2648 | 37.7779657675377 | -122.478061179078 | (37.7779657675377, -122.478061179078) | 11 | 6 | 2 | 55 | 26 | |||
| 83524 | 204600 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 158 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 10ft | 5999447.02569 | 2093744.50206 | 37.7289915679835 | -122.44418827768 | (37.7289915679835, -122.44418827768) | 9 | 7 | 4 | 63 | 40 | |||
| 83710 | 125782 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999068.0918 | 2119447.80624 | 37.7995447675413 | -122.447347524977 | (37.7995447675413, -122.447347524977) | 13 | 9 | 1 | 57 | 17 | |||
| 85498 | 125856 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2843 Larkin St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6006461.58499 | 2121022.99007 | 37.804289527702 | -122.421875291912 | (37.804289527702, -122.421875291912) | 5 | 9 | 1 | 28858 | 32 | |||
| 88228 | 204590 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 298 Monterey Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6000146.34132 | 2094716.84444 | 37.7317012657846 | -122.441840456285 | (37.7317012657846, -122.441840456285) | 9 | 7 | 4 | 63 | 40 | |||
| 88343 | 204503 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 65 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5997816.26809 | 2095981.13788 | 37.7350396679466 | -122.449987037888 | (37.7350396679466, -122.449987037888) | 9 | 7 | 4 | 59 | 40 | |||
| 89605 | 222184 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 524 27th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6003104.12018 | 2100103.45101 | 37.7466597424625 | -122.431999331618 | (37.7466597424625, -122.431999331618) | 2 | 7 | 5 | 63 | 22 | ||||
| 92450 | 188925 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012587.76707 | 2101840.20592 | 37.7519615867766 | -122.399327545327 | (37.7519615867766, -122.399327545327) | 10 | 3 | 8 | 28856 | 29 | |||
| 92716 | 204504 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 756 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5998160.08776 | 2096120.7158 | 37.7354425831017 | -122.448808386412 | (37.7354425831017, -122.448808386412) | 9 | 7 | 4 | 59 | 40 | |||
| 94066 | 188942 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2250 Revere Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 8ft | 6011601.74393 | 2097042.7843 | 37.7387338958451 | -122.402400080905 | (37.7387338958451, -122.402400080905) | 10 | 3 | 8 | 58 | 1 | |||
| 95733 | 125869 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 14 Joice St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6010322.99586 | 2116220.1954 | 37.7913192335393 | -122.408173571972 | (37.7913192335393, -122.408173571972) | 5 | 1 | 10 | 28857 | 21 | |||
| 96100 | 125783 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3100 Lyon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999067.20465 | 2119454.38129 | 37.7995627701683 | -122.447351068322 | (37.7995627701683, -122.447351068322) | 13 | 9 | 1 | 57 | 17 | |||
| 96698 | 188927 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 6012620.56924 | 2101841.45288 | 37.7519668387962 | -122.399214197496 | (37.7519668387962, -122.399214197496) | 10 | 3 | 8 | 28856 | 29 | |||
| 96747 | 204578 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 382 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998890.78307 | 2095267.32053 | 37.7331411199533 | -122.446220740114 | (37.7331411199533, -122.446220740114) | 9 | 7 | 4 | 59 | 40 | |||
| 96899 | 220889 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4612 17th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5998837.5301 | 2105719.51666 | 37.7618372687888 | -122.447156811134 | (37.7618372687888, -122.447156811134) | 15 | 5 | 11 | 29492 | 9 | |||
| 97460 | 205849 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 438 Orizaba Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5994041.34174 | 2089295.54399 | 37.7164659256374 | -122.46255340963 | (37.7164659256374, -122.46255340963) | 9 | 8 | 6 | 28861 | 24 | |||
| 98827 | 175731 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 582 Sweeny St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6007923.44818 | 2094303.98034 | 37.7310077131179 | -122.414924140441 | (37.7310077131179, -122.414924140441) | 9 | 3 | 7 | 309 | 28 | ||||
| 99173 | 125780 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 75 Emerson St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 8ft | 5998681.19546 | 2113401.84982 | 37.7829220585575 | -122.448250722201 | (37.7829220585575, -122.448250722201) | 15 | 6 | 1 | 54 | 31 | |||
| 101063 | 202112 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1833 Egbert Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 6011990.44763 | 2092817.45551 | 37.7271537161593 | -122.400759355986 | (37.7271537161593, -122.400759355986) | 10 | 3 | 8 | 58 | 1 | |||
| 101575 | 125855 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2843 Larkin St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6006460.99405 | 2121028.21686 | 37.8043038458052 | -122.421877708416 | (37.8043038458052, -122.421877708416) | 5 | 9 | 1 | 28858 | 32 | |||
| 101658 | 204606 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 450 Circular Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 6ft | 5999593.89835 | 2093609.08304 | 37.7286281168878 | -122.443670805062 | (37.7286281168878, -122.443670805062) | 9 | 7 | 4 | 63 | 40 | |||
| 102502 | 204591 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 298 Monterey Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6000137.52565 | 2094717.93006 | 37.7317037443113 | -122.441871011631 | (37.7317037443113, -122.441871011631) | 9 | 7 | 4 | 63 | 40 | |||
| 102928 | 205790 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 212 Hearst Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6000031.69248 | 2094391.34609 | 37.7308009895781 | -122.442213461795 | (37.7308009895781, -122.442213461795) | 9 | 7 | 4 | 63 | 40 | ||||
| 103472 | 188930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2001 25th St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6012673.63731 | 2101844.052 | 37.7519769327872 | -122.399030861684 | (37.7519769327872, -122.399030861684) | 10 | 3 | 8 | 28856 | 29 |
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) );