trees
8,659 rows where qSpecies_id = 11 sorted by Zip Codes 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 132657 | 1300 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 8 | Median : Cutout | Tree | DPW 1 | 25 | 10 | 5991824.50484 | 2087077.28239 | 37.7102472009077 | -122.470054391311 | (37.7102472009077, -122.470054391311) | 9 | 8 | 4 | 64 | 24 | |||
| 133005 | 330 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3494X 19th Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 133490 | 208350 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3580 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5990592.28285 | 2092905.19309 | 37.7261778941828 | -122.474738242173 | (37.7261778941828, -122.474738242173) | 9 | 8 | 4 | 64 | 40 | |||
| 135117 | 178294 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 3x6 | 5990067.81407 | 2088679.3925 | 37.7145444926031 | -122.476242754016 | (37.7145444926031, -122.476242754016) | 1 | 8 | 4 | 64 | 14 | |||
| 137763 | 1291 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3990 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/17/2017 01:08:00 PM | 3 | 3x3 | 5992151.4222 | 2087298.4709 | 37.7108734249293 | -122.468940594456 | (37.7108734249293, -122.468940594456) | 9 | 8 | 4 | 64 | 24 | ||
| 138032 | 104954 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 601 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 138364 | 322 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3982X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 2X2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 138888 | 114366 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 839 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5988367 | 2089770 | 37.7174402490935 | -122.482201236859 | (37.7174402490935, -122.482201236859) | 1 | 8 | 4 | 64 | 14 | ||||
| 140449 | 1226 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3600X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 15 | 3X5 | 5993524.0546702 | 2087589.4711722 | 37.7117516532039 | -122.464217607089 | (37.7117516532039, -122.464217607089) | 9 | 8 | 4 | 64 | 24 | ||
| 142435 | 177221 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | 5989179.19874 | 2089367.33922 | 37.7163818516244 | -122.479364431248 | (37.7163818516244, -122.479364431248) | 1 | 8 | 4 | 64 | 14 | ||||
| 143507 | 255347 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 28 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 143816 | 105996 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3990A ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/2014 12:00:00 AM | 3 | 3x3 | 5992123.9 | 2087300.1 | 37.7108763078665 | -122.469035835215 | (37.7108763078665, -122.469035835215) | 9 | 8 | 4 | 64 | 24 | ||
| 144588 | 208360 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4990 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990637.48412 | 2093619.08442 | 37.7281406798462 | -122.474634064727 | (37.7281406798462, -122.474634064727) | 9 | 8 | 4 | 64 | 40 | |||
| 144994 | 420 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3878 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2008 12:00:00 AM | 3 | 2X3 | 5990951.59904 | 2089989.44281 | 37.7181927813499 | -122.473283556398 | (37.7181927813499, -122.473283556398) | 9 | 8 | 4 | 64 | 40 | ||
| 145223 | 255360 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 41 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 145960 | 208367 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 56 | : | Tree | Private 2 | 3 | Width 0ft | 5991247.57131 | 2092431.18566 | 37.724914337716 | -122.472438427518 | (37.724914337716, -122.472438427518) | 9 | 8 | 4 | 64 | 40 | |||
| 149120 | 364 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2008 12:00:00 AM | 3 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 150188 | 208346 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3592 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990578.22351 | 2092670.11026 | 37.7255316008907 | -122.474769693278 | (37.7255316008907, -122.474769693278) | 9 | 8 | 4 | 64 | 40 | |||
| 151034 | 315 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3430X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 2 | 5990580.98006 | 2092524.42255 | 37.7251317386157 | -122.474749535596 | (37.7251317386157, -122.474749535596) | 9 | 8 | 4 | 64 | 40 | |||
| 151097 | 255352 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 33 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 153814 | 208328 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1 Elmhurst Dr | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5991213.15323 | 2094380.3449 | 37.7302642498839 | -122.47269945752 | (37.7302642498839, -122.47269945752) | 9 | 8 | 4 | 64 | 40 | |||
| 154559 | 208366 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 700 Junipero Serra Blvd | 54 | : | Tree | Private 2 | 2 | Width 0ft | 5991248.72719 | 2092445.90941 | 37.7249548323756 | -122.472435504713 | (37.7249548323756, -122.472435504713) | 9 | 8 | 4 | 64 | 40 | |||
| 156767 | 175105 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 3x6 | 5990422.48043 | 2088489.59506 | 37.7140439164585 | -122.475003050272 | (37.7140439164585, -122.475003050272) | 1 | 8 | 4 | 64 | 14 | |||
| 159454 | 208358 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4992 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5990634.34026 | 2093568.57876 | 37.7280018218284 | -122.474641248493 | (37.7280018218284, -122.474641248493) | 9 | 8 | 4 | 64 | 40 | |||
| 160969 | 255701 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x12 | 5990422.48043 | 2088489.59506 | 37.7140439164585 | -122.475003050272 | (37.7140439164585, -122.475003050272) | 1 | 8 | 4 | 64 | 14 | ||||
| 161119 | 208339 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3652 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5990553.88335 | 2092240.82908 | 37.724351491613 | -122.474822514967 | (37.724351491613, -122.474822514967) | 9 | 8 | 4 | 64 | 40 | |||
| 165074 | 1319 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4050X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 15 | TR | 5991740.4279021 | 2087082.0100679 | 37.7102553211792 | -122.470345319704 | (37.7102553211792, -122.470345319704) | 9 | 8 | 4 | 64 | 24 | ||
| 167976 | 276 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3250 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 2 | 5990658.15287 | 2093877.27418 | 37.7288508016084 | -122.4745814481 | (37.7288508016084, -122.4745814481) | 9 | 8 | 4 | 64 | 40 | |||
| 168106 | 208330 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3698 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990493.99716 | 2091321.13641 | 37.7218227742729 | -122.474962428782 | (37.7218227742729, -122.474962428782) | 9 | 8 | 4 | 64 | 40 | |||
| 168335 | 314 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 3438X 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1995 12:00:00 AM | 18 | 2 | 5990580.98006 | 2092524.42255 | 37.7251317386157 | -122.474749535596 | (37.7251317386157, -122.474749535596) | 9 | 8 | 4 | 64 | 40 | ||
| 169561 | 327 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3470X 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.42491 | 37.7250492609916 | -122.474754004974 | (37.7250492609916, -122.474754004974) | 9 | 8 | 4 | 64 | 40 | ||
| 170018 | 177222 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5989183.51797 | 2089355.54971 | 37.7163497314364 | -122.479348640047 | (37.7163497314364, -122.479348640047) | 1 | 8 | 4 | 64 | 14 | ||||
| 171711 | 177218 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3602 Alemany Blvd | 7 | : | Tree | Private 2 | 10 | Width 3ft | 5993301.35241 | 2087629.73492 | 37.7118493692142 | -122.464990243198 | (37.7118493692142, -122.464990243198) | 9 | 8 | 4 | 64 | 24 | |||
| 173035 | 208337 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3680 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5990515.64043 | 2091663.5574 | 37.7227642313656 | -122.474912596438 | (37.7227642313656, -122.474912596438) | 9 | 8 | 4 | 64 | 40 | |||
| 174968 | 104955 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 601 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||||
| 176017 | 104722 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 0 Garces Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 770294 | 5989426.46547 | 2089157.77848 | 37.7158208086468 | -122.478494450472 | (37.7158208086468, -122.478494450472) | 1 | 8 | 4 | 64 | 14 | |||
| 177253 | 255348 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 177411 | 255345 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 178333 | 365 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3690X 19th Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2006 12:00:00 AM | 3 | 2 | 5990489.74295 | 2091103.38095 | 37.7212246253626 | -122.474961247113 | (37.7212246253626, -122.474961247113) | 9 | 8 | 4 | 64 | 40 | ||
| 180185 | 1242 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3700X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X5 | 5993218.71389 | 2087629.40018 | 37.7118436847502 | -122.465275838287 | (37.7118436847502, -122.465275838287) | 9 | 8 | 4 | 64 | 24 | |||
| 180720 | 208359 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4992 19th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5990635.39919 | 2093594.76884 | 37.7280737945656 | -122.474639498428 | (37.7280737945656, -122.474639498428) | 9 | 8 | 4 | 64 | 40 | |||
| 182260 | 1304 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4000X Alemany Blvd | 12 | Median : Cutout | Tree | DPW 1 | 35 | 10 | 5991645.96929 | 2086939.81399 | 37.7098594231521 | -122.470661434599 | (37.7098594231521, -122.470661434599) | 9 | 8 | 4 | 64 | 24 | |||
| 183883 | 255361 | Undocumented 4 | Lophostemon confertus :: Brisbane Box 11 | 700 Brotherhood Way | 42 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x21 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
| 184851 | 208365 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 500 Junipero Serra Blvd | 40 | : | Tree | Private 2 | 4 | Width 0ft | 5991343.18171 | 2093534.72216 | 37.7279499075366 | -122.472188319753 | (37.7279499075366, -122.472188319753) | 9 | 8 | 4 | 64 | 40 | |||
| 185553 | 175109 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 3x6 | 5990038.21114 | 2088688.00297 | 37.7145664180874 | -122.476345701189 | (37.7145664180874, -122.476345701189) | 1 | 8 | 4 | 64 | 14 | |||
| 186931 | 175108 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 654 Brotherhood Way | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 3x6 | 5990046.17827 | 2088685.5531 | 37.7145601533898 | -122.476317985012 | (37.7145601533898, -122.476317985012) | 1 | 8 | 4 | 64 | 14 | |||
| 188807 | 1316 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4050X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 3 | TR | 5991740.4279021 | 2087082.0100679 | 37.7102553211792 | -122.470345319704 | (37.7102553211792, -122.470345319704) | 9 | 8 | 4 | 64 | 24 | ||
| 191972 | 208363 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 4986 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5990650.177 | 2093775.54023 | 37.7285710036319 | -122.47460159919 | (37.7285710036319, -122.47460159919) | 9 | 8 | 4 | 64 | 40 | |||
| 192837 | 208345 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 3594 19th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5990578.14128 | 2092637.23298 | 37.7254413233411 | -122.474767578959 | (37.7254413233411, -122.474767578959) | 9 | 8 | 4 | 64 | 40 | |||
| 194060 | 208352 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5000 19th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5990623.6066 | 2093323.81913 | 37.7273291513948 | -122.474660498502 | (37.7273291513948, -122.474660498502) | 9 | 8 | 4 | 64 | 40 | |||
| 547 | 228103 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004325 | 2096691 | 37.7373590721786 | -122.427534581259 | (37.7373590721786, -122.427534581259) | 2 | 7 | 5 | 63 | 7 | |||
| 1472 | 2091 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 943 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/1992 12:00:00 AM | 6 | 2X2 | 6001433.65825 | 2095553.49813 | 37.7340717929056 | -122.437449841319 | (37.7340717929056, -122.437449841319) | 9 | 7 | 5 | 63 | 40 | ||
| 1704 | 29288 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 9 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998060.68791 | 2099984.96724 | 37.7460471998142 | -122.449430386304 | (37.7460471998142, -122.449430386304) | 2 | 7 | 5 | 63 | 7 | ||
| 2202 | 29373 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 2 | Median : Cutout | Tree | DPW 1 | 07/06/2005 12:00:00 AM | 3 | 3X3 | Permit Number 772999 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |
| 3564 | 29260 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 4 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999192.47139 | 2100264.06623 | 37.7468782156517 | -122.445536908226 | (37.7468782156517, -122.445536908226) | 2 | 7 | 5 | 63 | 22 | ||
| 5896 | 68729 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 8 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1993 12:00:00 AM | Permit Number 32645 | 5998785.51386128 | 2099959.35584866 | 37.7460183133905 | -122.446922200801 | (37.7460183133905, -122.446922200801) | 2 | 7 | 5 | 63 | 7 | |||
| 5911 | 228080 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 890 Clipper Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999913.84424 | 2100703.76258 | 37.7481266725268 | -122.443074048252 | (37.7481266725268, -122.443074048252) | 2 | 4 | 5 | 63 | 22 | |||
| 6184 | 64799 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 450 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25798 | 6003587.23896685 | 2100132.28558533 | 37.7467662928737 | -122.430330814023 | (37.7467662928737, -122.430330814023) | 2 | 7 | 5 | 63 | 22 | ||
| 7573 | 64140 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 408 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24912 | 6003905.86029931 | 2098394.49493183 | 37.7420127636574 | -122.429105167098 | (37.7420127636574, -122.429105167098) | 2 | 7 | 5 | 63 | 22 | ||
| 8418 | 64139 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 523 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24910 | 6003239.38144538 | 2098311.93722578 | 37.7417483289476 | -122.431403744863 | (37.7417483289476, -122.431403744863) | 2 | 7 | 5 | 63 | 7 | ||
| 11164 | 64419 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 111 Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/11/1988 12:00:00 AM | Permit Number 25267 | 6003583.64860345 | 2097735.92139782 | 37.740186227283 | -122.430172299864 | (37.740186227283, -122.430172299864) | 2 | 7 | 5 | 63 | 7 | ||
| 11524 | 64282 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 411 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25086 | 6003895.1200055 | 2098341.81687307 | 37.7418675138214 | -122.429138548404 | (37.7418675138214, -122.429138548404) | 2 | 7 | 5 | 63 | 7 | ||
| 12177 | 228104 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 291 Whitney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004325 | 2096691 | 37.7373590721786 | -122.427534581259 | (37.7373590721786, -122.427534581259) | 2 | 7 | 5 | 63 | 7 | |||
| 14402 | 208305 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600x Bosworth St | 6 | Median : Yard | Tree | DPW 1 | 1 | Width 10ft | 6002233.89157 | 2095386.08451 | 37.7336575763338 | -122.434671221913 | (37.7336575763338, -122.434671221913) | 9 | 7 | 5 | 63 | 40 | |||
| 14466 | 187649 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 890x Clipper Ter | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999832 | 2100719 | 37.7481638439189 | -122.443358156196 | (37.7481638439189, -122.443358156196) | 2 | 4 | 5 | 63 | 22 | ||||
| 17005 | 101474 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 541 Congo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/04/2016 12:00:00 AM | Permit Number 775316 | 6000089 | 2095440.1 | 37.7336838892166 | -122.442090592963 | (37.7336838892166, -122.442090592963) | 9 | 7 | 4 | 63 | 40 | |||
| 18755 | 16138 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 370 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5999754.91061 | 2094714.13801 | 37.7316715225246 | -122.443193512388 | (37.7316715225246, -122.443193512388) | 9 | 7 | 4 | 63 | 40 | |||
| 20473 | 208314 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 931 Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001504.4065 | 2095542.47222 | 37.7340455402682 | -122.437204453845 | (37.7340455402682, -122.437204453845) | 9 | 7 | 5 | 63 | 40 | |||
| 21556 | 64289 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 357 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/18/1988 12:00:00 AM | Permit Number 25094 | 6004221.28750393 | 2098359.956664 | 37.7419357800281 | -122.428012059642 | (37.7419357800281, -122.428012059642) | 2 | 7 | 5 | 63 | 7 | ||
| 22103 | 64141 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 450 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/04/1993 12:00:00 AM | Permit Number 31503 | 6003668.99323589 | 2098381.3149539 | 37.7419631631413 | -122.429923237684 | (37.7419631631413, -122.429923237684) | 2 | 7 | 5 | 63 | 22 | ||
| 23070 | 29278 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 22 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998653.8721 | 2100156.73057 | 37.7465527348295 | -122.447391602559 | (37.7465527348295, -122.447391602559) | 2 | 7 | 5 | 63 | 7 | ||
| 23295 | 2152 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1109 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6000977.95547 | 2095707.30973 | 37.734468205445 | -122.439036363859 | (37.734468205445, -122.439036363859) | 9 | 7 | 5 | 63 | 40 | |||
| 24317 | 216490 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 800x Bosworth St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 6001788.93125 | 2095501.57158 | 37.7339494063362 | -122.436217839104 | (37.7339494063362, -122.436217839104) | 9 | 7 | 5 | 63 | 40 | |||
| 24457 | 29294 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 15 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997840.39461 | 2099954.53533 | 37.7459510371212 | -122.450189934828 | (37.7459510371212, -122.450189934828) | 2 | 7 | 5 | 63 | 7 | ||
| 24834 | 60616 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 152 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20240 | 6004848.50630576 | 2097410.92341249 | 37.7393654155838 | -122.425775803338 | (37.7393654155838, -122.425775803338) | 2 | 7 | 5 | 63 | 7 | ||
| 24883 | 4472 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1501 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004592.7498 | 2100104.29343 | 37.7467463372886 | -122.426851861342 | (37.7467463372886, -122.426851861342) | 2 | 7 | 5 | 63 | 22 | |||
| 25488 | 29296 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 17 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997789.65443 | 2099947.60504 | 37.7459291044398 | -122.450364887145 | (37.7459291044398, -122.450364887145) | 2 | 7 | 5 | 63 | 7 | ||
| 25588 | 64303 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 1617 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25114 | 6004013.37542651 | 2098859.53431589 | 37.743295740519 | -122.428766558424 | (37.743295740519, -122.428766558424) | 2 | 7 | 5 | 63 | 22 | ||
| 26548 | 47533 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 254 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45404 | 6004948.86039834 | 2098452.49541166 | 37.7422310063648 | -122.425502929799 | (37.7422310063648, -122.425502929799) | 2 | 7 | 5 | 63 | 22 | ||
| 27551 | 63945 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 264 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/1987 12:00:00 AM | Permit Number 24675 | 6004856.58665432 | 2099033.15113958 | 37.7438201403882 | -122.425863306487 | (37.7438201403882, -122.425863306487) | 2 | 7 | 5 | 63 | 22 | ||
| 27789 | 187645 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 880x Clipper Ter | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999931 | 2100716 | 37.7481612516949 | -122.443015603116 | (37.7481612516949, -122.443015603116) | 2 | 4 | 5 | 63 | 22 | ||||
| 27822 | 29295 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 16 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997814.38842 | 2099950.16176 | 37.7459375400967 | -122.450279545065 | (37.7459375400967, -122.450279545065) | 2 | 7 | 5 | 63 | 7 | ||
| 27863 | 2123 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1100X Bosworth St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/13/2014 11:05:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | |||
| 28258 | 4958 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5173 Diamond Heights Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/10/1997 12:00:00 AM | 6 | 3X3 | 6000768.969286 | 2099859.3929298 | 37.7458569549646 | -122.440056525632 | (37.7458569549646, -122.440056525632) | 2 | 4 | 5 | 63 | 22 | ||
| 28694 | 60656 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 159 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20290 | 6004348.70731442 | 2097373.30443411 | 37.7392338661268 | -122.427501208362 | (37.7392338661268, -122.427501208362) | 2 | 7 | 5 | 63 | 7 | ||
| 30558 | 29374 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 3 | Median : Cutout | Tree | DPW 1 | 07/06/2005 12:00:00 AM | 3 | 3X3 | Permit Number 772999 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | |
| 31222 | 2032 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 645 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6002168.04388 | 2095363.4286 | 37.7335916299421 | -122.434897256628 | (37.7335916299421, -122.434897256628) | 9 | 7 | 5 | 63 | 40 | |||
| 31922 | 228107 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 357 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6001296.21258 | 2096174.59578 | 37.7357693679469 | -122.437969506208 | (37.7357693679469, -122.437969506208) | 2 | 7 | 5 | 63 | 7 | |||
| 32107 | 16122 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 313 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/05/2012 12:00:00 AM | 3 | 3X3 | 5999967.48728 | 2094632.53487 | 37.7314595783841 | -122.442452738108 | (37.7314595783841, -122.442452738108) | 9 | 7 | 4 | 63 | 40 | ||
| 34263 | 2124 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1100X Bosworth St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/06/2005 12:00:00 AM | 3 | 6001043.628513 | 2095761.867481 | 37.7346217448773 | -122.438813219285 | (37.7346217448773, -122.438813219285) | 2 | 7 | 5 | 63 | 7 | |||
| 34563 | 29269 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 13 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998912.29808 | 2100220.6513 | 37.7467430097923 | -122.44650259483 | (37.7467430097923, -122.44650259483) | 2 | 7 | 5 | 63 | 22 | ||
| 35584 | 57475 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 462 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24911 | 6003596.18542051 | 2098377.26850411 | 37.7419479290274 | -122.430174695022 | (37.7419479290274, -122.430174695022) | 2 | 7 | 5 | 63 | 22 | ||
| 36480 | 60609 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 44 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1983 12:00:00 AM | Permit Number 20233 | 6004854.74181998 | 2098042.44150378 | 37.7410997733275 | -122.425799182451 | (37.7410997733275, -122.425799182451) | 2 | 7 | 5 | 63 | 7 | ||
| 36904 | 2156 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1127 Bosworth St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000906.70235 | 2095731.66253 | 37.734531018077 | -122.439284453792 | (37.734531018077, -122.439284453792) | 9 | 7 | 5 | 63 | 40 | |||
| 37297 | 229039 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1501 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6004589.2732 | 2100123.66014 | 37.7467993172358 | -122.42686526212 | (37.7467993172358, -122.42686526212) | 2 | 7 | 5 | 63 | 22 | |||
| 37564 | 29375 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600X Bosworth St | 4 | Median : Cutout | Tree | DPW 1 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6002398.10054 | 2095366.8333155 | 37.7336140379052 | -122.434102128474 | (37.7336140379052, -122.434102128474) | 2 | 7 | 5 | 63 | 7 | ||
| 38696 | 4963 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 5177 Diamond Heights Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/10/1997 12:00:00 AM | 6 | 3X3 | 6000767.9397481 | 2099833.0623434 | 37.7457845988343 | -122.440058197903 | (37.7457845988343, -122.440058197903) | 2 | 4 | 5 | 63 | 22 | ||
| 39541 | 16094 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 295 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/1989 12:00:00 AM | 12 | 3X3 | 6000142.45419 | 2094629.85248 | 37.7314621846134 | -122.44184765356 | (37.7314621846134, -122.44184765356) | 9 | 7 | 4 | 63 | 40 | ||
| 40341 | 29259 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 3 | Median : Cutout | Tree | DPW 1 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5999220.77002 | 2100268.25982 | 37.7468913457549 | -122.445439356037 | (37.7468913457549, -122.445439356037) | 2 | 7 | 5 | 63 | 22 | ||
| 40548 | 101065 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 380X Beacon St | 1 | Median : Cutout | Tree | DPW 1 | 3 | 3x3 | 6002433 | 2098186.8 | 37.7413589965156 | -122.434182997537 | (37.7413589965156, -122.434182997537) | 2 | 7 | 5 | 63 | 7 |
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) );