trees
183 rows where qSpecies_id = 119 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
561 | 19835 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
8381 | 19836 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
9086 | 19838 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
9550 | 20003 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY46 | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2 | |||||||||||||
11967 | 19792 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY19 | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
17879 | 19817 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 100ST | |||||||||||||
17991 | 19926 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY37 | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
47335 | 176276 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 62 Tomaso Ct | 7 | Front Yard : Yard | Tree | Private 2 | 12 | Width 8ft | 6009192.32266 | 2086308.36594 | 37.7091246419674 | -122.409973180132 | (37.7091246419674, -122.409973180132) | 9 | 7 | 8 | 309 | 39 | |||
151602 | 176282 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 35 Tomaso Ct | 8 | Side Yard : Yard | Tree | Private 2 | 3 | Width 3ft | 6009202.48899 | 2086331.05779 | 37.7091875189513 | -122.409939644414 | (37.7091875189513, -122.409939644414) | 9 | 7 | 8 | 309 | 39 | |||
50533 | 113121 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 1x TOMASO CT | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
174138 | 113120 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 1x TOMASO CT | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6009323 | 2086334 | 37.70920235104 | -122.40952334552 | (37.70920235104, -122.40952334552) | 9 | 7 | 8 | 309 | 39 | |||||
188172 | 176283 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 35 Tomaso Ct | 9 | Side Yard : Yard | Tree | Private 2 | 8 | Width 3ft | 6009206.42472 | 2086339.23376 | 37.7092101890802 | -122.40992661864 | (37.7092101890802, -122.40992661864) | 9 | 7 | 8 | 309 | 39 | |||
107967 | 176290 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 324 Naylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002773.32683 | 2086530.28935 | 37.7093721434675 | -122.432174023131 | (37.7093721434675, -122.432174023131) | 9 | 7 | 6 | 28861 | 5 | |||
175983 | 176285 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1 Santa Barbara Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5993431.64495 | 2086606.10767 | 37.7090462435678 | -122.464465643484 | (37.7090462435678, -122.464465643484) | 9 | 8 | 6 | 28861 | 25 | |||
148176 | 176275 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 23 Byron Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5999165.78727 | 2086612.07538 | 37.7093915094837 | -122.444648098339 | (37.7093915094837, -122.444648098339) | 9 | 7 | 6 | 28861 | 5 | |||
35709 | 176284 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 251 De Long St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 5993742.60383 | 2086796.45358 | 37.7095868089467 | -122.463404735741 | (37.7095868089467, -122.463404735741) | 9 | 8 | 6 | 28861 | 25 | |||
78353 | 176289 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 140 South Hill Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6003155.69301 | 2086832.03957 | 37.710222356236 | -122.430874024341 | (37.710222356236, -122.430874024341) | 9 | 7 | 6 | 28861 | 5 | |||
156568 | 176281 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 600 Blanken Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6013188.37125 | 2086854.32403 | 37.7108468913331 | -122.396200370571 | (37.7108468913331, -122.396200370571) | 10 | 3 | 8 | 309 | 1 | |||
96190 | 176280 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 600 Blanken Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6013180.81524 | 2086857.67381 | 37.7108556687339 | -122.396226720696 | (37.7108556687339, -122.396226720696) | 10 | 3 | 8 | 309 | 1 | |||
169656 | 57922 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 539 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/1977 12:00:00 AM | 5 | Permit Number 16880 | 5999313.15008 | 2086900.51859 | 37.7101919177852 | -122.444159502961 | (37.7101919177852, -122.444159502961) | 9 | 7 | 6 | 28861 | 5 | ||
63491 | 65002 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1628 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1989 12:00:00 AM | 7 | Permit Number 26041 | 6007789.57951 | 2087924.39296 | 37.7134831981768 | -122.414935588817 | (37.7134831981768, -122.414935588817) | 9 | 7 | 8 | 309 | 39 | ||
135280 | 187568 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 138 Alpha St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6010896.54149 | 2088103.23155 | 37.7141483502397 | -122.404209349584 | (37.7141483502397, -122.404209349584) | 9 | 7 | 8 | 309 | 39 | |||
14087 | 72881 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 130 Alpha St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010899.06821 | 2088108.56402 | 37.7141631333099 | -122.404200991296 | (37.7141631333099, -122.404200991296) | 9 | 7 | 8 | 309 | 39 | |||
87730 | 176277 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 190 Foote Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 8ft | 5998652.47444 | 2088356.09646 | 37.7141508908239 | -122.446547575323 | (37.7141508908239, -122.446547575323) | 9 | 7 | 6 | 28861 | 25 | |||
158858 | 207724 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 132 Ralston St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 5992208.61623 | 2088772.74591 | 37.7149247331539 | -122.46885013342 | (37.7149247331539, -122.46885013342) | 9 | 8 | 6 | 64 | 24 | |||
46121 | 176270 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 195 Rome St | 1 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 5998756.35201 | 2088943.21744 | 37.7157689240671 | -122.44623074418 | (37.7157689240671, -122.44623074418) | 9 | 7 | 6 | 28861 | 25 | |||
18236 | 176271 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 195 Rome St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | Width 0ft | 5998766.3474 | 2088951.76376 | 37.7157929611452 | -122.446196810045 | (37.7157929611452, -122.446196810045) | 9 | 7 | 6 | 28861 | 25 | |||
116467 | 207721 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 228 Montana St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 5994631.9391 | 2089350.3088 | 37.7166502911674 | -122.460515994629 | (37.7166502911674, -122.460515994629) | 9 | 8 | 6 | 28861 | 24 | ||||
17475 | 176274 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 775 London St | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6 | 6000713.86512 | 2089358.37648 | 37.7170204575094 | -122.439494437135 | (37.7170204575094, -122.439494437135) | 9 | 7 | 6 | 28861 | 5 | ||||
107585 | 191709 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 3535 Jennings St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6013020.36677 | 2089365.26266 | 37.7177320820479 | -122.39695697201 | (37.7177320820479, -122.39695697201) | 10 | 3 | 8 | 58 | 1 | ||||
122202 | 191708 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 979 Le Conte Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6013251.20953 | 2089459.918 | 37.7180048338374 | -122.396165676526 | (37.7180048338374, -122.396165676526) | 10 | 3 | 8 | 58 | 1 | ||||
146526 | 176286 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 901 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5998666.60141 | 2089601.12997 | 37.7175702751322 | -122.446588269645 | (37.7175702751322, -122.446588269645) | 9 | 7 | 6 | 28861 | 25 | |||
151725 | 176273 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 179 Niagara Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 0ft | 5999314.98259 | 2089602.87456 | 37.7176120801242 | -122.444347244552 | (37.7176120801242, -122.444347244552) | 9 | 7 | 6 | 28861 | 25 | |||
109212 | 176272 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 179 Niagara Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 0ft | 5999311.03211 | 2089604.94508 | 37.7176175399043 | -122.444361048235 | (37.7176175399043, -122.444361048235) | 9 | 7 | 6 | 28861 | 25 | |||
180879 | 207727 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 378 Victoria St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5993265.77465 | 2089711.08498 | 37.717562206406 | -122.465264296326 | (37.717562206406, -122.465264296326) | 9 | 8 | 6 | 64 | 24 | |||
132964 | 176278 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 87 Seneca Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 1ft | 6000216.84897 | 2089896.46956 | 37.7184696403425 | -122.441250964156 | (37.7184696403425, -122.441250964156) | 9 | 7 | 6 | 28861 | 25 | |||
84988 | 176279 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 671 London St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6001065.40936 | 2089903.80776 | 37.7185380904529 | -122.43831837391 | (37.7185380904529, -122.43831837391) | 9 | 7 | 6 | 28861 | 5 | ||||
180779 | 22498 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 6404 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/20/2003 12:00:00 AM | 3 | 3X3 | 6013069.4059 | 2090221.21293 | 37.7200850799347 | -122.396847440878 | (37.7200850799347, -122.396847440878) | 10 | 3 | 8 | 58 | 1 | ||
115439 | 207722 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 300 Louisburg St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997412.90563 | 2090249.05124 | 37.7192776245304 | -122.450968397868 | (37.7192776245304, -122.450968397868) | 9 | 8 | 6 | 28861 | 24 | |||
80989 | 200198 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 3125 Jennings St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 6013701.6232 | 2090281.2208 | 37.7202850194185 | -122.394666263771 | (37.7202850194185, -122.394666263771) | 10 | 3 | 8 | 58 | 1 | |||
9092 | 207725 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 380 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5992234.50872 | 2090438.58266 | 37.7195002121526 | -122.468881791362 | (37.7195002121526, -122.468881791362) | 9 | 8 | 6 | 64 | 24 | |||
153448 | 207728 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 3802 19th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 5990564.76109 | 2090542.95021 | 37.7196901687566 | -122.474661051582 | (37.7196901687566, -122.474661051582) | 9 | 8 | 4 | 64 | 40 | |||
165212 | 207723 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 301 Byxbee St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5991929.88427 | 2090544.15077 | 37.7197724720092 | -122.469942439216 | (37.7197724720092, -122.469942439216) | 9 | 8 | 6 | 64 | 24 | |||
122502 | 207720 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 750 Grafton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994515.75563 | 2090598.91337 | 37.7200719768186 | -122.461008027219 | (37.7200719768186, -122.461008027219) | 9 | 8 | 6 | 28861 | 24 | |||
95024 | 207726 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 416 Ralston St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 5992237.92359 | 2090619.01384 | 37.719995829436 | -122.468883110676 | (37.719995829436, -122.468883110676) | 9 | 8 | 6 | 64 | 24 | |||
58209 | 207718 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 315 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994723.84306 | 2090686.34608 | 37.7203240181088 | -122.46029507617 | (37.7203240181088, -122.46029507617) | 9 | 8 | 6 | 28861 | 24 | |||
116477 | 207719 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 126 Brighton Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 1ft | 5996251.42646 | 2090752.11635 | 37.7205923605284 | -122.455019501973 | (37.7205923605284, -122.455019501973) | 9 | 8 | 6 | 28861 | 24 | |||
143684 | 202013 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 7 Wheat St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6012149.42791 | 2091374.55614 | 37.7232006759464 | -122.400108468936 | (37.7232006759464, -122.400108468936) | 10 | 3 | 8 | 58 | 1 | |||
113035 | 176287 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1565 Bacon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6006970.59339 | 2091697.77071 | 37.723798037137 | -122.418033639041 | (37.723798037137, -122.418033639041) | 9 | 7 | 7 | 309 | 28 | |||
107253 | 207717 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1180 Plymouth Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995974.63238 | 2091762.70234 | 37.7233513070047 | -122.456049310222 | (37.7233513070047, -122.456049310222) | 9 | 8 | 4 | 28861 | 24 | |||
118144 | 201358 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 245 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 2ft | 6013008.61874 | 2092664.02794 | 37.7267891723748 | -122.39722877051 | (37.7267891723748, -122.39722877051) | 10 | 3 | 8 | 58 | 1 | |||
51320 | 191705 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700 Armstrong Ave | 3 | Side Yard : Yard | Tree | Private 2 | 6 | 6013900.77828 | 2092879.68746 | 37.7274309582526 | -122.394159667654 | (37.7274309582526, -122.394159667654) | 10 | 3 | 8 | 58 | 1 | ||||
135986 | 88782 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 166 Havelock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2008 12:00:00 AM | 9 | 3x3 | Permit Number 51699 | 5999327.15741 | 2092949.02389 | 37.7268005308142 | -122.444545520761 | (37.7268005308142, -122.444545520761) | 9 | 7 | 6 | 28861 | 25 | |
180433 | 109627 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 500 CIRCULAR AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5999334 | 2093430 | 37.728121569817 | -122.444556419888 | (37.728121569817, -122.444556419888) | 9 | 7 | 4 | 28861 | 40 | ||||
50569 | 109626 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 117 JUDSON AVE | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x12 | 5999286.5 | 2093444.4 | 37.7281583983457 | -122.444721663071 | (37.7281583983457, -122.444721663071) | 9 | 7 | 4 | 28861 | 40 | |||||
112712 | 207715 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 117 Judson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5999294.96193 | 2093458.56634 | 37.7281977787 | -122.444693427785 | (37.7281977787, -122.444693427785) | 9 | 7 | 4 | 28861 | 40 | ||||
34061 | 207716 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 115 Judson Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 5999335.92351 | 2093459.52729 | 37.7282027546376 | -122.444551891566 | (37.7282027546376, -122.444551891566) | 9 | 7 | 4 | 28861 | 40 | |||
53757 | 176288 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 51 Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007278.51632 | 2093753.93468 | 37.7294611462914 | -122.417114824212 | (37.7294611462914, -122.417114824212) | 9 | 3 | 7 | 309 | 28 | |||
97479 | 207714 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 298 Staples Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5998133.74364 | 2093826.5868 | 37.7291419427263 | -122.448734282271 | (37.7291419427263, -122.448734282271) | 9 | 7 | 4 | 28861 | 40 | ||||
138085 | 207713 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 171 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5999625.57301 | 2094046.65577 | 37.7298313962868 | -122.443592725033 | (37.7298313962868, -122.443592725033) | 9 | 7 | 4 | 63 | 40 | ||||
83068 | 207712 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 579 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997579.44084 | 2094367.86788 | 37.7305964594534 | -122.450689553205 | (37.7305964594534, -122.450689553205) | 9 | 7 | 4 | 28861 | 40 | ||||
12159 | 207734 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 301 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 10ft | 6000042.84201 | 2094939.48464 | 37.7323066857905 | -122.442214249597 | (37.7323066857905, -122.442214249597) | 9 | 7 | 4 | 63 | 40 | |||
167227 | 207733 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 500 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998757.70005 | 2094996.74516 | 37.7323905826432 | -122.446661380942 | (37.7323905826432, -122.446661380942) | 9 | 7 | 4 | 59 | 40 | ||||
109998 | 207732 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 400 Congo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 10ft | 6000124.6238 | 2095012.30469 | 37.7325112932663 | -122.441936736802 | (37.7325112932663, -122.441936736802) | 9 | 7 | 5 | 63 | 40 | |||
58793 | 18564 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700X Quesada Ave | 19 | Median : Cutout | Tree | DPW 1 | 30 | 19 | 6014511.59225 | 2095170.64304 | 37.7337553901961 | -122.392208220649 | (37.7337553901961, -122.392208220649) | 10 | 3 | 8 | 58 | 1 | |||
44756 | 191700 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1700x Quesada Ave | 39 | Median : Yard | Tree | DPW 1 | 3 | 6014384.30677 | 2095263.82729 | 37.7340041867507 | -122.392654804178 | (37.7340041867507, -122.392654804178) | 10 | 3 | 8 | 58 | 1 | ||||
8190 | 261370 | Planning Code 138.1 required 2 | Eriobotrya japonica :: Edible Loquat 119 | 102 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007140 | 2095356 | 37.7338522748733 | -122.417707198486 | (37.7338522748733, -122.417707198486) | 2 | 7 | 7 | 28859 | 2 | ||||
188891 | 111509 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 800x BOSWORTH ST | 4 | Front Yard : Yard | Tree | DPW 1 | 4 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
160265 | 54637 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1747 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 1 | Permit Number 10460 | 6012648.74415 | 2095666.17396 | 37.7350124040996 | -122.398683444593 | (37.7350124040996, -122.398683444593) | 10 | 3 | 8 | 58 | 1 | ||
38804 | 207730 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 740 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 5998158.00142 | 2095945.96511 | 37.7349626400957 | -122.44880301654 | (37.7349626400957, -122.44880301654) | 9 | 7 | 4 | 59 | 40 | |||
39476 | 191702 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1998 Revere Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | 6013024.54675 | 2095962.65305 | 37.7358474048249 | -122.397404937794 | (37.7358474048249, -122.397404937794) | 10 | 3 | 8 | 58 | 1 | ||||
74905 | 191701 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2025 Revere Ave | 1 | : | Tree | Private 2 | 1 | Width 2ft | 6012750.04967 | 2096000.36179 | 37.7359356579989 | -122.398356633674 | (37.7359356579989, -122.398356633674) | 10 | 3 | 8 | 58 | 1 | |||
59884 | 207731 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 32 Malta Dr | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5999573.25493 | 2096045.34694 | 37.7353163497697 | -122.443917140176 | (37.7353163497697, -122.443917140176) | 9 | 7 | 4 | 63 | 40 | |||
11577 | 224121 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 499X Ogden Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6008290.10508 | 2096093.22608 | 37.7359411906366 | -122.413783055452 | (37.7359411906366, -122.413783055452) | 2 | 7 | 7 | 28859 | 2 | |||
9830 | 224122 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 499X Ogden Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6008272.03754 | 2096094.48518 | 37.7359436331948 | -122.413845611379 | (37.7359436331948, -122.413845611379) | 2 | 7 | 7 | 28859 | 2 | |||
17085 | 73562 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1620 La Salle Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6015449.23036 | 2096256.56638 | 37.7367891335144 | -122.389042293172 | (37.7367891335144, -122.389042293172) | 10 | 3 | 8 | 58 | 1 | |||
2236 | 71359 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1620 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6015449.34332 | 2096256.73769 | 37.7367896101585 | -122.389041914574 | (37.7367896101585, -122.389041914574) | 10 | 3 | 8 | 58 | 1 | |||
8877 | 191703 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1501 Quint St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | Width 4ft | 6013259.66608 | 2096346.42133 | 37.7369142408999 | -122.396618925818 | (37.7369142408999, -122.396618925818) | 10 | 3 | 8 | 58 | 1 | |||
153174 | 191704 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1501 Quint St | 3 | Front Yard : Yard | Tree | Private 2 | 6 | Width 4ft | 6013263.69136 | 2096352.02038 | 37.7369298387513 | -122.396605400918 | (37.7369298387513, -122.396605400918) | 10 | 3 | 8 | 58 | 1 | |||
167876 | 207711 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 200x Terrace Dr | 31 | Median : Yard | Tree | DPW 1 | 12 | 5993844.07189 | 2096487.62875 | 37.7362022754996 | -122.463756979508 | (37.7362022754996, -122.463756979508) | 1 | 8 | 4 | 59 | 40 | ||||
71753 | 224115 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 71 | Front Yard : Yard | Tree | Private 2 | 8 | 6004680.7613 | 2096547.43611 | 37.7369849941684 | -122.426294330213 | (37.7369849941684, -122.426294330213) | 2 | 7 | 5 | 63 | 7 | ||||
37110 | 224114 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 6 | 6004687.50549 | 2096549.18122 | 37.736990167061 | -122.42627113673 | (37.736990167061, -122.42627113673) | 2 | 7 | 5 | 63 | 7 | ||||
84688 | 224113 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 69 | Front Yard : Yard | Tree | Private 2 | 4 | 6004690.02185 | 2096554.43933 | 37.7370047468799 | -122.426262810788 | (37.7370047468799, -122.426262810788) | 2 | 7 | 5 | 63 | 7 | ||||
71542 | 224112 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6004737.84332 | 2096628.18536 | 37.7372099397936 | -122.426102718871 | (37.7372099397936, -122.426102718871) | 2 | 7 | 5 | 63 | 7 | ||||
89861 | 224111 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1100 San Jose Ave | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6004733.53405 | 2096634.51546 | 37.7372270772601 | -122.426118068508 | (37.7372270772601, -122.426118068508) | 2 | 7 | 5 | 63 | 7 | ||||
122868 | 17442 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1944 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6013068.40824 | 2096637.61256 | 37.73770314508 | -122.397300607455 | (37.73770314508, -122.397300607455) | 10 | 3 | 8 | 58 | 1 | |||
25767 | 191706 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1499 Rankin St | 7 | Side Yard : Yard | Tree | Private 2 | 1 | Width 3ft | 6012685.03055 | 2096691.54362 | 37.7378298766422 | -122.398629920547 | (37.7378298766422, -122.398629920547) | 10 | 3 | 8 | 58 | 1 | |||
119543 | 191707 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2187 Revere Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6011937.92175 | 2096699.93433 | 37.7378112633764 | -122.401213644004 | (37.7378112633764, -122.401213644004) | 10 | 3 | 8 | 58 | 1 | ||||
93765 | 191710 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1427x Innes Ave | 28 | Median : Yard | Tree | DPW 1 | 3 | 6016141.21336 | 2096757.17707 | 37.7382020430791 | -122.386684681762 | (37.7382020430791, -122.386684681762) | 10 | 3 | 8 | 58 | 1 | ||||
56150 | 224116 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 400 Prospect Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6006205.79839 | 2097605.42741 | 37.7399760871276 | -122.421096686769 | (37.7399760871276, -122.421096686769) | 2 | 7 | 7 | 28859 | 2 | ||||
154126 | 183573 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2587 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5988295.3826 | 2097727.4025 | 37.7392850696685 | -122.483031684036 | (37.7392850696685, -122.483031684036) | 1 | 8 | 3 | 29491 | 35 | |||
19239 | 224123 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 601X Powhattan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008526.38321 | 2098121.40646 | 37.7415233967761 | -122.413109512687 | (37.7415233967761, -122.413109512687) | 10 | 7 | 7 | 28859 | 2 | ||||
9946 | 247879 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 388 Mayflower St | 8 | Side Yard : Yard | Tree | Private 2 | 3 | 6009924.14803 | 2098382.32436 | 37.7423181897436 | -122.408294896795 | (37.7423181897436, -122.408294896795) | 10 | 7 | 7 | 28859 | 2 | ||||
42159 | 181986 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 2475 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5985788.161 | 2098383.3055 | 37.7409397902725 | -122.491748687988 | (37.7409397902725, -122.491748687988) | 1 | 8 | 3 | 29491 | 35 | |||
120318 | 247873 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 388 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6009888.01932 | 2098399.59712 | 37.7423635938187 | -122.408421037503 | (37.7423635938187, -122.408421037503) | 10 | 7 | 7 | 28859 | 2 | ||||
158281 | 246774 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1850 Alabama St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6009457.96402 | 2098740.81971 | 37.7432764236648 | -122.409932126974 | (37.7432764236648, -122.409932126974) | 2 | 7 | 7 | 28859 | 2 | ||||
38491 | 246771 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1850 Alabama St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6009333.37029 | 2098874.50038 | 37.743636497837 | -122.410372378408 | (37.743636497837, -122.410372378408) | 2 | 7 | 7 | 28859 | 2 | ||||
187997 | 246764 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 70 Waltham St | 8 | Front Yard : Yard | Tree | Private 2 | 8 | 6009279.96949 | 2098891.64841 | 37.7436805888792 | -122.410558236772 | (37.7436805888792, -122.410558236772) | 2 | 7 | 7 | 28859 | 2 | ||||
126650 | 247967 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 16 Joy St | 3 | Front Yard : Yard | Tree | Private 2 | 4 | 6010333.49571 | 2098927.49611 | 37.7438380268983 | -122.40691790615 | (37.7438380268983, -122.40691790615) | 2 | 7 | 7 | 28859 | 2 | ||||
54915 | 246770 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 99 Waltham St | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 6009309.01668 | 2098932.20278 | 37.7437935707282 | -122.410460661231 | (37.7437935707282, -122.410460661231) | 2 | 7 | 7 | 28859 | 2 |
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) );