trees
215 rows where Neighborhoods (old) = 40 and qSpecies_id = 133 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 137146 | 65803 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2245 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28771 | 5991002.61160286 | 2100125.98772668 | 37.7460281288142 | -122.4738463283 | (37.7460281288142, -122.4738463283) | 1 | 8 | 4 | 29491 | 40 | ||
| 9241 | 65804 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2249 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28772 | 5991003.52349052 | 2100099.94265799 | 37.7459566686168 | -122.473841275381 | (37.7459566686168, -122.473841275381) | 1 | 8 | 4 | 29491 | 40 | ||
| 27614 | 65799 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28767 | 5991045.46087918 | 2100388.25805195 | 37.7467507369343 | -122.473717291816 | (37.7467507369343, -122.473717291816) | 1 | 8 | 4 | 29491 | 40 | ||
| 101256 | 206522 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2204 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991046.63721 | 2100321.91518 | 37.7465686447317 | -122.473708385358 | (37.7465686447317, -122.473708385358) | 1 | 8 | 4 | 29491 | 40 | |||
| 49813 | 206568 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2515 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991380.56657 | 2098286.24678 | 37.7409985569439 | -122.472405327055 | (37.7409985569439, -122.472405327055) | 1 | 8 | 4 | 29491 | 40 | |||
| 81847 | 206567 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2523 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991381.76089 | 2098233.80223 | 37.7408546267459 | -122.472397375252 | (37.7408546267459, -122.472397375252) | 1 | 8 | 4 | 29491 | 40 | |||
| 150332 | 31296 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 431 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 4 | Permit Number 34940 | 5991578.61319 | 2097704.4347 | 37.7394125098801 | -122.471678172112 | (37.7394125098801, -122.471678172112) | 1 | 8 | 4 | 29491 | 40 | |
| 138610 | 31913 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2281 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42222 | 5991689.25479737 | 2099914.99470572 | 37.7454885429424 | -122.471456657987 | (37.7454885429424, -122.471456657987) | 1 | 8 | 4 | 29491 | 40 | ||
| 13518 | 31915 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2287 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 4 | Permit Number 35339 | 5991692.93382 | 2099879.32999 | 37.745390829638 | -122.471441338374 | (37.745390829638, -122.471441338374) | 1 | 8 | 4 | 29491 | 40 | |
| 128259 | 206521 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991723.00262 | 2099864.63418 | 37.7453522181485 | -122.471336295754 | (37.7453522181485, -122.471336295754) | 1 | 8 | 4 | 29491 | 40 | |||
| 148811 | 206520 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2290 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991725.72943 | 2099875.90905 | 37.7453833337792 | -122.471327688331 | (37.7453833337792, -122.471327688331) | 1 | 8 | 4 | 29491 | 40 | |||
| 151946 | 65810 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2290 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28778 | 5991729.56779327 | 2099841.10556299 | 37.7452879943861 | -122.471311880679 | (37.7452879943861, -122.471311880679) | 1 | 8 | 4 | 29491 | 40 | ||
| 127094 | 31914 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2286 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 4 | Permit Number 42223 | 5991731.01436 | 2099907.3159 | 37.7454698746265 | -122.471311701978 | (37.7454698746265, -122.471311701978) | 1 | 8 | 4 | 29491 | 40 | |
| 190674 | 206519 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991734.05463 | 2099933.45812 | 37.7455418303067 | -122.471303093689 | (37.7455418303067, -122.471303093689) | 1 | 8 | 4 | 29491 | 40 | |||
| 32620 | 31228 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2651 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/04/1995 12:00:00 AM | 4 | Permit Number 34914 | 5991736.03785 | 2097377.43168 | 37.7385237494811 | -122.47111005511 | (37.7385237494811, -122.47111005511) | 1 | 8 | 4 | 29491 | 40 | |
| 150864 | 206565 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2679 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991740.00006 | 2097213.72231 | 37.7380744742606 | -122.471084432514 | (37.7380744742606, -122.471084432514) | 1 | 8 | 4 | 29491 | 40 | |||
| 25175 | 65811 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 2280 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/1990 12:00:00 AM | Permit Number 28799 | 5991740.53584922 | 2099906.37764585 | 37.7454678491967 | -122.471278710139 | (37.7454678491967, -122.471278710139) | 1 | 8 | 4 | 29491 | 40 | ||
| 104682 | 206566 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991741.26483 | 2097200.972 | 37.7380395382962 | -122.471079130991 | (37.7380395382962, -122.471079130991) | 1 | 8 | 4 | 29491 | 40 | |||
| 45301 | 206523 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2690 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5991790.63989 | 2097130.86053 | 37.737849885658 | -122.470903312649 | (37.737849885658, -122.470903312649) | 1 | 8 | 4 | 29491 | 40 | |||
| 38958 | 40752 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
| 64516 | 40751 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 54 Cerritos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/13/1999 12:00:00 AM | Permit Number 41722 | 5992568.54395141 | 2093000.42735623 | 37.72655370366 | -122.46791340088 | (37.72655370366, -122.46791340088) | 9 | 8 | 4 | 59 | 40 | ||
| 63519 | 206524 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992940.67499 | 2098878.9332 | 37.7427160965819 | -122.467054169341 | (37.7427160965819, -122.467054169341) | 1 | 8 | 4 | 59 | 40 | |||
| 152874 | 206525 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992946.5083 | 2098897.01812 | 37.7427660898953 | -122.46703531413 | (37.7427660898953, -122.46703531413) | 1 | 8 | 4 | 59 | 40 | |||
| 71121 | 206526 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 35 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992953.91132 | 2098913.47299 | 37.7428116981042 | -122.467010912843 | (37.7428116981042, -122.467010912843) | 1 | 8 | 4 | 59 | 40 | |||
| 125070 | 206527 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992983.90563 | 2098997.49136 | 37.7430441224891 | -122.466913308501 | (37.7430441224891, -122.466913308501) | 1 | 8 | 4 | 59 | 40 | |||
| 74614 | 206528 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992986.65204 | 2099006.05822 | 37.7430678034305 | -122.466904434898 | (37.7430678034305, -122.466904434898) | 1 | 8 | 4 | 59 | 40 | |||
| 70998 | 206529 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 13 Madrone Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5992989.73242 | 2099015.25675 | 37.7430932380525 | -122.466894452432 | (37.7430932380525, -122.466894452432) | 1 | 8 | 4 | 59 | 40 | |||
| 108499 | 218322 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 420 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 0ft | 5993190.15092 | 2099959.3697 | 37.7456970982494 | -122.466270063011 | (37.7456970982494, -122.466270063011) | 1 | 8 | 4 | 29491 | 40 | |||
| 114209 | 206572 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993215.16949 | 2099646.04946 | 37.7448382439064 | -122.466160788211 | (37.7448382439064, -122.466160788211) | 1 | 8 | 4 | 29491 | 40 | |||
| 37635 | 206573 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993216.90415 | 2099626.41246 | 37.7447844257663 | -122.466153363383 | (37.7447844257663, -122.466153363383) | 1 | 8 | 4 | 29491 | 40 | |||
| 159238 | 206571 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 51 Cortes Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993219.18082 | 2099666.63445 | 37.7448949964991 | -122.466148413523 | (37.7448949964991, -122.466148413523) | 1 | 8 | 4 | 29491 | 40 | |||
| 157044 | 206570 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 4 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993230.10677 | 2099675.67045 | 37.7449204374235 | -122.46611129043 | (37.7449204374235, -122.46611129043) | 1 | 8 | 4 | 29491 | 40 | |||
| 126946 | 206580 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993286.92729 | 2099684.15258 | 37.7449470052046 | -122.465915433344 | (37.7449470052046, -122.465915433344) | 1 | 8 | 4 | 29491 | 40 | |||
| 88461 | 206579 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993299.1056 | 2099684.88554 | 37.744949720257 | -122.465873376566 | (37.744949720257, -122.465873376566) | 1 | 8 | 4 | 29491 | 40 | |||
| 176132 | 206578 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 275 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993312.03833 | 2099686.0969 | 37.7449537923783 | -122.465828745912 | (37.7449537923783, -122.465828745912) | 1 | 8 | 4 | 29491 | 40 | |||
| 186101 | 206532 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 San Aleso Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5993345.96317 | 2094536.94274 | 37.730817459756 | -122.46533747775 | (37.730817459756, -122.46533747775) | 9 | 8 | 4 | 59 | 40 | |||
| 194155 | 206531 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5993348.57217 | 2094559.38972 | 37.7308792440863 | -122.465330088014 | (37.7308792440863, -122.465330088014) | 9 | 8 | 4 | 59 | 40 | |||
| 189913 | 206581 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 190 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993591.13879 | 2099773.66773 | 37.7452103357006 | -122.464870033553 | (37.7452103357006, -122.464870033553) | 1 | 8 | 4 | 29491 | 40 | |||
| 100325 | 33392 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 161 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1996 12:00:00 AM | Permit Number 37511 | 5993609.77804843 | 2093900.82209008 | 37.729086039701 | -122.464379267011 | (37.729086039701, -122.464379267011) | 9 | 8 | 4 | 59 | 40 | ||
| 81319 | 206582 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 190 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993610.53275 | 2099775.23813 | 37.745215765799 | -122.464803087101 | (37.745215765799, -122.464803087101) | 1 | 8 | 4 | 29491 | 40 | |||
| 106812 | 206577 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 215 Dorantes Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993636.26419 | 2099712.16168 | 37.7450440573323 | -122.464709533316 | (37.7450440573323, -122.464709533316) | 1 | 8 | 4 | 29491 | 40 | |||
| 133810 | 206583 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Dorantes Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993643.85712 | 2099778.24608 | 37.7452259461282 | -122.464688076401 | (37.7452259461282, -122.464688076401) | 1 | 8 | 4 | 29491 | 40 | |||
| 180178 | 206664 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 135 San Marcos Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5993646.4962 | 2100328.84926 | 37.7467379151376 | -122.464718926731 | (37.7467379151376, -122.464718926731) | 1 | 8 | 4 | 29491 | 40 | |||
| 103424 | 206620 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 2105 09th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993657.15968 | 2101227.85905 | 37.7492069822304 | -122.464747327347 | (37.7492069822304, -122.464747327347) | 1 | 8 | 4 | 29491 | 40 | |||
| 182208 | 206584 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 180 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5993659.8453 | 2099783.10112 | 37.7452401985713 | -122.464633144905 | (37.7452401985713, -122.464633144905) | 1 | 8 | 4 | 29491 | 40 | |||
| 172753 | 206576 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993684.51151 | 2099645.64672 | 37.7448642055102 | -122.464537875235 | (37.7448642055102, -122.464537875235) | 1 | 8 | 4 | 29491 | 40 | |||
| 186941 | 206575 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Montalvo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993692.18131 | 2099632.63233 | 37.744828913423 | -122.464510409921 | (37.744828913423, -122.464510409921) | 1 | 8 | 4 | 29491 | 40 | |||
| 152214 | 206574 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993698.09593 | 2099619.5133 | 37.7447932328356 | -122.464489006068 | (37.7447932328356, -122.464489006068) | 1 | 8 | 4 | 29491 | 40 | |||
| 35026 | 206591 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Montalvo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993709.62503 | 2099698.37793 | 37.7450104397813 | -122.464454865994 | (37.7450104397813, -122.464454865994) | 1 | 8 | 4 | 29491 | 40 | |||
| 157023 | 206592 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 101 Montalvo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5993721.8716 | 2099672.65516 | 37.744940517497 | -122.464410652624 | (37.744940517497, -122.464410652624) | 1 | 8 | 4 | 29491 | 40 | |||
| 140979 | 206548 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 160 Dorantes Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5993741.10567 | 2099827.07051 | 37.7453656117262 | -122.464355354239 | (37.7453656117262, -122.464355354239) | 1 | 8 | 4 | 29491 | 40 | |||
| 64571 | 206665 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 11 Santa Rita Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993870.76921 | 2100887.71242 | 37.7482853390143 | -122.463983980089 | (37.7482853390143, -122.463983980089) | 1 | 8 | 4 | 29491 | 40 | |||
| 50752 | 206547 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 120 Dorantes Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993889.30878 | 2099967.60077 | 37.7457600139093 | -122.463853094571 | (37.7457600139093, -122.463853094571) | 1 | 8 | 4 | 29491 | 40 | |||
| 161052 | 206555 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5993893.29504 | 2101174.89341 | 37.7490751632062 | -122.463926929805 | (37.7490751632062, -122.463926929805) | 1 | 8 | 4 | 29491 | 40 | |||
| 77345 | 206554 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 47 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 5993895.61602 | 2101166.11299 | 37.7490511881613 | -122.463918266634 | (37.7490511881613, -122.463918266634) | 1 | 8 | 4 | 29491 | 40 | |||
| 146225 | 206556 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 32 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5993935.86279 | 2101082.16601 | 37.7488230103837 | -122.463773001819 | (37.7488230103837, -122.463773001819) | 1 | 8 | 4 | 29491 | 40 | |||
| 59731 | 206585 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 368 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993961.34204 | 2099692.54098 | 37.745008919941 | -122.463584056983 | (37.745008919941, -122.463584056983) | 1 | 8 | 4 | 29491 | 40 | |||
| 184544 | 206666 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5993976.53914 | 2100938.08553 | 37.7484297458427 | -122.463621888759 | (37.7484297458427, -122.463621888759) | 1 | 8 | 4 | 29491 | 40 | |||
| 117873 | 206667 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993986.73582 | 2100929.3593 | 37.7484063733597 | -122.463585995905 | (37.7484063733597, -122.463585995905) | 1 | 8 | 4 | 29491 | 40 | |||
| 12800 | 206586 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 360 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993997.55659 | 2099722.78299 | 37.7450940434634 | -122.463461028807 | (37.7450940434634, -122.463461028807) | 1 | 8 | 4 | 29491 | 40 | |||
| 83405 | 206668 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993998.36893 | 2100916.34697 | 37.7483713150869 | -122.463544824955 | (37.7483713150869, -122.463544824955) | 1 | 8 | 4 | 29491 | 40 | |||
| 190886 | 47755 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 364St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2002 12:00:00 AM | Permit Number 45535 | 5994004.07072151 | 2099729.00956261 | 37.7451115153754 | -122.463438956035 | (37.7451115153754, -122.463438956035) | 1 | 8 | 4 | 29491 | 40 | |||
| 111783 | 206669 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994007.62455 | 2100906.4247 | 37.7483446043367 | -122.463512099503 | (37.7483446043367, -122.463512099503) | 1 | 8 | 4 | 29491 | 40 | |||
| 129133 | 206670 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 15 Sotelo Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994011.71818 | 2100897.82655 | 37.7483212318599 | -122.463497320046 | (37.7483212318599, -122.463497320046) | 1 | 8 | 4 | 29491 | 40 | |||
| 193008 | 218121 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5994024.91011 | 2100655.57636 | 37.7476568343048 | -122.463434125583 | (37.7476568343048, -122.463434125583) | 1 | 8 | 4 | 29491 | 40 | |||
| 151204 | 52741 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 409@ ALTON Pacheco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2006 12:00:00 AM | Permit Number 48790 | 5994026.96721275 | 2101530.61038788 | 37.7500595741159 | -122.463490505234 | (37.7500595741159, -122.463490505234) | 1 | 8 | 4 | 29491 | 40 | |||
| 92863 | 47756 | Permitted Site 7 | Crataegus laevigata :: English Hawthorn 133 | 360St. Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2002 12:00:00 AM | Permit Number 45536 | 5994029.42937676 | 2099753.03047002 | 37.7451789317369 | -122.463353013703 | (37.7451789317369, -122.463353013703) | 1 | 8 | 4 | 29491 | 40 | |||
| 114722 | 218122 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Lopez Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5994032.10421 | 2100668.86964 | 37.7476937487685 | -122.463410213512 | (37.7476937487685, -122.463410213512) | 1 | 8 | 4 | 29491 | 40 | |||
| 85200 | 206628 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 20 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994037.30563 | 2101977.91794 | 37.7512883623694 | -122.463487212563 | (37.7512883623694, -122.463487212563) | 1 | 8 | 4 | 29491 | 40 | |||
| 77503 | 206587 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 348 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994044.71238 | 2099771.06427 | 37.7452293284847 | -122.463301476481 | (37.7452293284847, -122.463301476481) | 1 | 8 | 4 | 29491 | 40 | |||
| 58588 | 206536 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 401 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994052.44062 | 2101520.15999 | 37.7500323476354 | -122.463401659183 | (37.7500323476354, -122.463401659183) | 1 | 8 | 4 | 29491 | 40 | |||
| 68821 | 206588 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 348 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994058.29292 | 2099782.40477 | 37.7452612490171 | -122.463255340382 | (37.7452612490171, -122.463255340382) | 1 | 8 | 4 | 29491 | 40 | |||
| 39404 | 206537 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 401 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994067.3294 | 2101503.80633 | 37.7499883024325 | -122.46334898679 | (37.7499883024325, -122.46334898679) | 1 | 8 | 4 | 29491 | 40 | |||
| 167005 | 206627 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994076.75455 | 2101874.65457 | 37.7510071002966 | -122.463343302157 | (37.7510071002966, -122.463343302157) | 1 | 8 | 4 | 29491 | 40 | |||
| 17056 | 206626 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 40 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994084.99265 | 2101862.22446 | 37.7509734449922 | -122.463313912312 | (37.7509734449922, -122.463313912312) | 1 | 8 | 4 | 29491 | 40 | |||
| 18421 | 122404 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5994085 | 2099826 | 37.7453824890774 | -122.46316615516 | (37.7453824890774, -122.46316615516) | 1 | 8 | 4 | 29491 | 40 | ||||
| 185629 | 122405 | Undocumented 4 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x6 | 5994085 | 2099826 | 37.7453824890774 | -122.46316615516 | (37.7453824890774, -122.46316615516) | 1 | 8 | 4 | 29491 | 40 | ||||
| 118462 | 206589 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5994086.71603 | 2099812.25652 | 37.7453448518007 | -122.463159224416 | (37.7453448518007, -122.463159224416) | 1 | 8 | 4 | 29491 | 40 | |||
| 74040 | 206590 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 340 Magellan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994099.18491 | 2099823.62069 | 37.745376773231 | -122.463116933812 | (37.745376773231, -122.463116933812) | 1 | 8 | 4 | 29491 | 40 | |||
| 140646 | 206538 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 399 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994103.27732 | 2101446.93652 | 37.7498342233673 | -122.463220551898 | (37.7498342233673, -122.463220551898) | 1 | 8 | 4 | 29491 | 40 | |||
| 16321 | 206539 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 393 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994118.07071 | 2101419.5251 | 37.749759810788 | -122.463167407365 | (37.749759810788, -122.463167407365) | 1 | 8 | 4 | 29491 | 40 | |||
| 68672 | 206540 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 387 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994134.95664 | 2101369.7507 | 37.7496241156629 | -122.463105404514 | (37.7496241156629, -122.463105404514) | 1 | 8 | 4 | 29491 | 40 | |||
| 158228 | 206541 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 375 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994147.31458 | 2101302.53521 | 37.7494402708691 | -122.463057794403 | (37.7494402708691, -122.463057794403) | 1 | 8 | 4 | 29491 | 40 | |||
| 98018 | 206657 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994149.03126 | 2101531.53277 | 37.7500691388799 | -122.463068471138 | (37.7500691388799, -122.463068471138) | 1 | 8 | 4 | 29491 | 40 | |||
| 161629 | 206542 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 351 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994154.36407 | 2101104.38684 | 37.7488966118001 | -122.46301904262 | (37.7488966118001, -122.46301904262) | 1 | 8 | 4 | 29491 | 40 | |||
| 103756 | 206658 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994157.02115 | 2101539.85513 | 37.7500924502117 | -122.463041445619 | (37.7500924502117, -122.463041445619) | 1 | 8 | 4 | 29491 | 40 | |||
| 62868 | 206543 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 347 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994159.12368 | 2101087.06957 | 37.7488493371331 | -122.463001327749 | (37.7488493371331, -122.463001327749) | 1 | 8 | 4 | 29491 | 40 | |||
| 27348 | 206661 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994161.93741 | 2101486.33597 | 37.7499457833913 | -122.463020562465 | (37.7499457833913, -122.463020562465) | 1 | 8 | 4 | 29491 | 40 | |||
| 158137 | 206662 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994173.63187 | 2101468.04914 | 37.7498962460271 | -122.462978796147 | (37.7498962460271, -122.462978796147) | 1 | 8 | 4 | 29491 | 40 | |||
| 155079 | 206544 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 337 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994178.74316 | 2101030.22278 | 37.7486943803622 | -122.462929360401 | (37.7486943803622, -122.462929360401) | 1 | 8 | 4 | 29491 | 40 | |||
| 170380 | 206663 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 390 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994181.82756 | 2101452.31219 | 37.7498535084399 | -122.462949313674 | (37.7498535084399, -122.462949313674) | 1 | 8 | 4 | 29491 | 40 | |||
| 40920 | 206659 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994198.61036 | 2101541.1054 | 37.750098278721 | -122.462897719553 | (37.750098278721, -122.462897719553) | 1 | 8 | 4 | 29491 | 40 | |||
| 133847 | 206553 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 352 Pacheco St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994206.92878 | 2101186.05332 | 37.74912387497 | -122.462843199074 | (37.74912387497, -122.462843199074) | 1 | 8 | 4 | 29491 | 40 | |||
| 48224 | 206660 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 41 Alton Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994227.71262 | 2101539.78712 | 37.7500963352778 | -122.462796987411 | (37.7500963352778, -122.462796987411) | 1 | 8 | 4 | 29491 | 40 | |||
| 149954 | 206654 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Alton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994247.90783 | 2101537.24109 | 37.7500905076701 | -122.462726967074 | (37.7500905076701, -122.462726967074) | 1 | 8 | 4 | 29491 | 40 | |||
| 61748 | 206655 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Alton Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994255.40167 | 2101538.85258 | 37.7500953640099 | -122.462701170033 | (37.7500953640099, -122.462701170033) | 1 | 8 | 4 | 29491 | 40 | |||
| 155431 | 206656 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 45 Alton Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994277.82387 | 2101540.85875 | 37.7501021637853 | -122.46262377888 | (37.7501021637853, -122.46262377888) | 1 | 8 | 4 | 29491 | 40 | |||
| 31183 | 206625 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994283.13326 | 2101793.571 | 37.7507963531822 | -122.46262374829 | (37.7507963531822, -122.46262374829) | 1 | 8 | 4 | 29491 | 40 | |||
| 44186 | 206624 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 80 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5994298.51296 | 2101800.25271 | 37.7508155851791 | -122.46257104893 | (37.7508155851791, -122.46257104893) | 1 | 8 | 4 | 29491 | 40 | |||
| 20290 | 206629 | DPW Maintained 1 | Crataegus laevigata :: English Hawthorn 133 | 81 Ventura Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994298.95446 | 2101835.26425 | 37.7509117433916 | -122.462572061571 | (37.7509117433916, -122.462572061571) | 1 | 8 | 4 | 29491 | 40 |
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) );