Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 | 2001 | 141165 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1901 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 1 | Width 0ft | 6002136.302999999 | 2113271.8343 | 37.7827619879541 | -122.436288194942 | (37.7827619879541, -122.436288194942) | ||
| 3074 | 3074 | 199930 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016497.9258 | 2092921.8231 | 37.727690668221506 | -122.385184171361 | (37.7276906682215, -122.385184171361) | ||
| 3082 | 3082 | 199927 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 5 | Width 0ft | 6016464.324 | 2092869.4925 | 37.7275451198245 | -122.385296689415 | (37.7275451198245, -122.385296689415) | ||
| 3105 | 3105 | 199929 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | ||
| 13374 | 13374 | 29405 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2901X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014656.2415 | 2090451.6586 | 37.7208060360431 | -122.391378344678 | (37.7208060360431, -122.391378344678) | ||
| 13454 | 13454 | 29437 | DPW Maintained 3 | Tristania conferta :: 79 | 2307X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015612.318 | 2091732.5629 | 37.72437616438229 | -122.388162796666 | (37.7243761643823, -122.388162796666) | ||
| 13492 | 13492 | 29408 | Permitted Site 1 | Tristania conferta :: 79 | 2715X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014970.0169 | 2090872.4668 | 37.7219789022018 | -122.39032309567 | (37.7219789022018, -122.39032309567) | ||
| 13508 | 13508 | 29427 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.38896553930401 | (37.7234697537221, -122.388965539304) | ||
| 13531 | 13531 | 29526 | DPW Maintained 3 | Tristania conferta :: 79 | 2200X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 4 | 2X3 | 6015798.6366 | 2092060.1318 | 37.725285925529 | -122.387541555629 | (37.725285925529, -122.387541555629) | ||
| 13552 | 13552 | 29439 | DPW Maintained 3 | Tristania conferta :: 79 | 2303X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015640.8979 | 2091772.6846 | 37.7244879141293 | -122.38806679762199 | (37.7244879141293, -122.388066797622) | ||
| 13617 | 13617 | 29430 | Permitted Site 1 | Tristania conferta :: 79 | 2401X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015434.0318 | 2091490.2952 | 37.7237010652846 | -122.388762207738 | (37.7237010652846, -122.388762207738) | ||
| 13658 | 13658 | 29560 | DPW Maintained 3 | Tristania conferta :: 79 | 3100X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 16 | 3X3 | 6014251.2078 | 2089975.3633 | 37.7194757354442 | -122.39274513029 | (37.7194757354442, -122.39274513029) | ||
| 13674 | 13674 | 29421 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6015238.3862 | 2091224.5002 | 37.7229603992916 | -122.389419974154 | (37.7229603992916, -122.389419974154) | ||
| 13756 | 13756 | 29432 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015452.0518 | 2091514.7509 | 37.7237692145382 | -122.38870162152 | (37.7237692145382, -122.38870162152) | ||
| 13783 | 13783 | 29532 | DPW Maintained 3 | Tristania conferta :: 79 | 2302X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015618.3638 | 2091811.707 | 37.7245938134403 | -122.388147417672 | (37.7245938134403, -122.388147417672) | ||
| 13890 | 13890 | 29426 | Permitted Site 1 | Tristania conferta :: 79 | 2501X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015353.5854 | 2091384.7495 | 37.723406798628 | -122.389032933904 | (37.723406798628, -122.389032933904) | ||
| 13919 | 13919 | 29521 | DPW Maintained 3 | Tristania conferta :: 79 | 2006X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016098.1753 | 2092465.4708 | 37.726415492982795 | -122.386534320443 | (37.7264154929828, -122.386534320443) | ||
| 13938 | 13938 | 29486 | Permitted Site 1 | Tristania conferta :: 79 | 1616 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016775.5724 | 2093362.9876 | 37.7289173744178 | -122.384255044958 | (37.7289173744178, -122.384255044958) | ||
| 13996 | 13996 | 29494 | DPW Maintained 3 | Tristania conferta :: 79 | 1700X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016622.9685 | 2093155.9340000001 | 37.7283404071211 | -122.384768194628 | (37.7283404071211, -122.384768194628) | ||
| 14024 | 14024 | 29547 | Permitted Site 1 | Tristania conferta :: 79 | 2920 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014582.5436 | 2090417.5505 | 37.720708291367 | -122.391630714392 | (37.720708291367, -122.391630714392) | ||
| 14044 | 14044 | 29531 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2300X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015628.2568 | 2091824.3481 | 37.7246290715339 | -122.38811410031201 | (37.7246290715339, -122.388114100312) | ||
| 14045 | 14045 | 29406 | Permitted Site 1 | Tristania conferta :: 79 | 2845X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6014746.9934 | 2090564.9462 | 37.7211221378179 | -122.39107255471599 | (37.7211221378179, -122.391072554716) | ||
| 14096 | 14096 | 29566 | Permitted Site 1 | Tristania conferta :: 79 | 3224 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6014068.4858 | 2089729.2978 | 37.718789938046605 | -122.39335952751999 | (37.7187899380466, -122.39335952752) | ||
| 14107 | 14107 | 29383 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014243.8989 | 2089896.7929 | 37.7192595907189 | -122.39276490097099 | (37.7192595907189, -122.392764900971) | ||
| 14365 | 14365 | 29425 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015328.4861 | 2091346.7788 | 37.7233011472419 | -122.389117048339 | (37.7233011472419, -122.389117048339) | ||
| 14449 | 14449 | 29495 | Permitted Site 1 | Tristania conferta :: 79 | 1700X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016616.3583 | 2093144.917 | 37.7283097910179 | -122.384790279442 | (37.7283097910179, -122.384790279442) | ||
| 14504 | 14504 | 29438 | DPW Maintained 3 | Tristania conferta :: 79 | 2305X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015624.4095 | 2091751.2497 | 37.72442814458989 | -122.388122301142 | (37.7244281445899, -122.388122301142) | ||
| 14553 | 14553 | 29440 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015660.6839 | 2091799.6156 | 37.7245629575419 | -122.38800027789101 | (37.7245629575419, -122.388000277891) | ||
| 14601 | 14601 | 29403 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2901X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014631.8786 | 2090416.3323 | 37.7207076848108 | -122.391460092084 | (37.7207076848108, -122.391460092084) | ||
| 14713 | 14713 | 29485 | Permitted Site 1 | Tristania conferta :: 79 | 1608 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016787.6638 | 2093383.8729 | 37.7289753898862 | -122.38421469762 | (37.7289753898862, -122.38421469762) | ||
| 14785 | 14785 | 29469 | Permitted Site 1 | Tristania conferta :: 79 | 1609 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016821.7398 | 2093350.8961 | 37.7288867261126 | -122.38409459771098 | (37.7288867261126, -122.384094597711) | ||
| 14830 | 14830 | 29396 | Permitted Site 1 | Tristania conferta :: 79 | 3001 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014489.3554 | 2090228.1287 | 37.720183003403704 | -122.39193960073999 | (37.7201830034037, -122.39193960074) | ||
| 14886 | 14886 | 29429 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015416.6554 | 2091465.8395 | 37.7236329516711 | -122.388820569012 | (37.7236329516711, -122.388820569012) | ||
| 14948 | 14948 | 29394 | Permitted Site 1 | Tristania conferta :: 79 | 3019 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 5 | 3x3 | 6014458.2927 | 2090182.4482 | 37.720055849211604 | -122.392043782138 | (37.7200558492116, -122.392043782138) | ||
| 15071 | 15071 | 29387 | DPW Maintained 3 | Tristania conferta :: 79 | 3103 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 10 | 3x3 | 6014285.3159 | 2089950.3913 | 37.7194090616104 | -122.392625484256 | (37.7194090616104, -122.392625484256) | ||
| 15085 | 15085 | 29384 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014251.8169 | 2089910.1925 | 37.7192968231465 | -122.39273846811199 | (37.7192968231465, -122.392738468112) | ||
| 15158 | 15158 | 29434 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015482.9432 | 2091559.1573 | 37.723892857778104 | -122.38859793246701 | (37.7238928577781, -122.388597932467) | ||
| 15436 | 15436 | 29533 | DPW Maintained 3 | Tristania conferta :: 79 | 2304X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015579.3413 | 2091755.0969999998 | 37.724436211393396 | -122.388278365495 | (37.7244362113934, -122.388278365495) | ||
| 15499 | 15499 | 29379 | Permitted Site 1 | Tristania conferta :: 79 | 3225 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 10 | 3x3 | 6014101.9849 | 2089704.3258 | 37.718723230996105 | -122.39324198712299 | (37.7187232309961, -122.393241987123) | ||
| 15503 | 15503 | 29385 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014260.3439 | 2089918.7195 | 37.7193207101956 | -122.39270958943999 | (37.7193207101956, -122.39270958944) | ||
| 15652 | 15652 | 29527 | DPW Maintained 3 | Tristania conferta :: 79 | 2220 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 2X3 | 6015766.2095 | 2092015.0636 | 37.7251603810099 | -122.387650511034 | (37.7251603810099, -122.387650511034) | ||
| 15670 | 15670 | 29518 | DPW Maintained 3 | Tristania conferta :: 79 | 2002X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6016118.5109 | 2092491.8522 | 37.7264890568376 | -122.38646585917401 | (37.7264890568376, -122.386465859174) | ||
| 15696 | 15696 | 29409 | Permitted Site 1 | Tristania conferta :: 79 | 2715X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014989.3241 | 2090898.8532 | 37.7220524249966 | -122.39025819753901 | (37.7220524249966, -122.390258197539) | ||
| 15709 | 15709 | 29381 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014224.4086 | 2089865.1211 | 37.7191715436771 | -122.392830057526 | (37.7191715436771, -122.392830057526) | ||
| 15822 | 15822 | 29431 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015465.5668 | 2091536.6323 | 37.7238300455694 | -122.388656428754 | (37.7238300455694, -122.388656428754) | ||
| 15923 | 15923 | 29386 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014271.9163 | 2089934.5554 | 37.719364835170396 | -122.392670694873 | (37.7193648351704, -122.392670694873) | ||
| 16048 | 16048 | 29395 | Permitted Site 1 | Tristania conferta :: 79 | 3001 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014475.9558 | 2090207.4202 | 37.7201253980359 | -122.39198447167699 | (37.7201253980359, -122.391984471677) | ||
| 16204 | 16204 | 29404 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2901X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6014642.8419 | 2090432.7773 | 37.7207534480251 | -122.391423344097 | (37.7207534480251, -122.391423344097) | ||
| 16346 | 16346 | 29504 | Permitted Site 1 | Tristania conferta :: 79 | 1800X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016442.8409 | 2092919.0689 | 37.7276800583286 | -122.38537441062401 | (37.7276800583286, -122.385374410624) | ||
| 16413 | 16413 | 29503 | Permitted Site 1 | Tristania conferta :: 79 | 1800X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016452.7561 | 2092931.7384 | 37.727715394829296 | -122.38534101579599 | (37.7277153948293, -122.385341015796) | ||
| 16447 | 16447 | 29423 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 5 | 3x3 | 6015296.9511 | 2091308.8081 | 37.7231951390157 | -122.38922340969101 | (37.7231951390157, -122.389223409691) | ||
| 16659 | 16659 | 29380 | DPW Maintained 3 | Tristania conferta :: 79 | 3231 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6014087.9762 | 2089684.2263 | 37.7186672634726 | -122.393289004191 | (37.7186672634726, -122.393289004191) | ||
| 16696 | 16696 | 29546 | DPW Maintained 3 | Tristania conferta :: 79 | 2900X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6014598.9886 | 2090439.4771 | 37.7207694102971 | -122.39157540084999 | (37.7207694102971, -122.39157540085) | ||
| 16740 | 16740 | 29382 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014237.1991 | 2089885.2205 | 37.7192274430768 | -122.39278725067498 | (37.7192274430768, -122.392787250675) | ||
| 16769 | 16769 | 29493 | Permitted Site 1 | Tristania conferta :: 79 | 1700X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016630.1295 | 2093166.4001 | 37.728369541019894 | -122.384744167276 | (37.7283695410199, -122.384744167276) | ||
| 16888 | 16888 | 18349 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 480 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6010310.27618 | 2106136.10948 | 37.763629979170496 | -122.40750631726101 | (37.7636299791705, -122.407506317261) | ||
| 17766 | 17766 | 18376 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 714 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6010377.02154 | 2104944.60362 | 37.760362109048295 | -122.40719146910801 | (37.7603621090483, -122.407191469108) | ||
| 37402 | 37402 | 29542 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2770X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014905.272030001 | 2090859.0916099998 | 37.7219385849654 | -122.39054597016501 | (37.7219385849654, -122.390545970165) | ||
| 77302 | 77302 | 29513 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1900X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 8 | 3x3 | 6016255.22712 | 2092677.23147 | 37.7270056390015 | -122.38600614922701 | (37.7270056390015, -122.386006149227) | ||
| 78382 | 78382 | 29501 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1750X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016558.40828 | 2093067.0921200002 | 37.7280928939915 | -122.384985197237 | (37.7280928939915, -122.384985197237) | ||
| 78716 | 78716 | 29462 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1735X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 2x3 | 6016586.67067 | 2093043.04223 | 37.728028420976 | -122.38488581749701 | (37.728028420976, -122.384885817497) | ||
| 79492 | 79492 | 29416 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2601X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6015100.6056699995 | 2091049.9556900002 | 37.722473494558294 | -122.389884070919 | (37.7224734945583, -122.389884070919) | ||
| 80931 | 80931 | 29508 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1850X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6016520.1701445 | 2092944.0657869 | 37.727752972771604 | -122.385108820711 | (37.7277529727716, -122.385108820711) | ||
| 81012 | 81012 | 29410 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2715X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014921.45084 | 2090812.1685799998 | 37.7218106411245 | -122.39048676658999 | (37.7218106411245, -122.39048676659) | ||
| 81674 | 81674 | 29490 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1628X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6016733.30759 | 2093304.25674 | 37.7287537740577 | -122.38439706997801 | (37.7287537740577, -122.384397069978) | ||
| 81754 | 81754 | 29428 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2501X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015363.4124582 | 2091390.373071 | 37.7234227845738 | -122.388999355726 | (37.7234227845738, -122.388999355726) | ||
| 82076 | 82076 | 29390 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3023X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014390.84887 | 2090096.2596 | 37.7198154476157 | -122.392270889515 | (37.7198154476157, -122.392270889515) | ||
| 83437 | 83437 | 29525 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2000X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6016159.1076981 | 2092541.4365656 | 37.726627452952705 | -122.386328971933 | (37.7266274529527, -122.386328971933) | ||
| 83506 | 83506 | 29444 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1935X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 2X4 | 6016311.3838732 | 2092663.1779623001 | 37.726970158575895 | -122.385811035359 | (37.7269701585759, -122.385811035359) | ||
| 85157 | 85157 | 29460 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1735X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 8 | 2X3 | 6016576.02227 | 2093028.2050299998 | 37.727987091974605 | -122.384921596442 | (37.7279870919746, -122.384921596442) | ||
| 85250 | 85250 | 29523 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2000X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6016159.1076981 | 2092541.4365656 | 37.726627452952705 | -122.386328971933 | (37.7266274529527, -122.386328971933) | ||
| 86492 | 86492 | 29497 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1700X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016597.15555 | 2093118.91165 | 37.728237323375104 | -122.384854853888 | (37.7282373233751, -122.384854853888) | ||
| 87748 | 87748 | 29455 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016520.1701445 | 2092944.0657869 | 37.727752972771604 | -122.385108820711 | (37.7277529727716, -122.385108820711) | ||
| 88255 | 88255 | 29451 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016488.0524002 | 2092900.9411781002 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | ||
| 88375 | 88375 | 29457 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1809X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016492.91829 | 2092912.51025 | 37.7276648199576 | -122.38520083393 | (37.7276648199576, -122.38520083393) | ||
| 89846 | 89846 | 29541 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2770X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014971.2257001 | 2090947.9242658 | 37.722186160549896 | -122.390324186532 | (37.7221861605499, -122.390324186532) | ||
| 90828 | 90828 | 29565 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3232 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014034.4176 | 2089682.92243 | 37.7186607076026 | -122.393474044809 | (37.7186607076026, -122.393474044809) | ||
| 91196 | 91196 | 29453 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016488.0524002 | 2092900.9411781002 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | ||
| 91283 | 91283 | 29524 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2000X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6016159.1076981 | 2092541.4365656 | 37.726627452952705 | -122.386328971933 | (37.7266274529527, -122.386328971933) | ||
| 93388 | 93388 | 29509 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1850X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016520.1701445 | 2092944.0657869 | 37.727752972771604 | -122.385108820711 | (37.7277529727716, -122.385108820711) | ||
| 95990 | 95990 | 29543 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2770X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6014851.5294699995 | 2090794.3298 | 37.721757780241 | -122.39072722268101 | (37.721757780241, -122.390727222681) | ||
| 96386 | 96386 | 29487 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1622 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016762.42122 | 2093342.90057 | 37.7288614922286 | -122.384299111574 | (37.7288614922286, -122.384299111574) | ||
| 96675 | 96675 | 29392 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3023X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014422.79908 | 2090141.91698 | 37.719942587808596 | -122.392163639387 | (37.7199425878086, -122.392163639387) | ||
| 97276 | 97276 | 29445 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1935X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 8 | 2X3 | 6016311.3838732 | 2092663.1779623001 | 37.726970158575895 | -122.385811035359 | (37.7269701585759, -122.385811035359) | ||
| 99231 | 99231 | 29475 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1425X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 8 | 3x3 | 6017067.120080001 | 2093685.37068 | 37.729818690875796 | -122.383269564776 | (37.7298186908758, -122.383269564776) | ||
| 99241 | 99241 | 29522 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 2000X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6016159.1076981 | 2092541.4365656 | 37.726627452952705 | -122.386328971933 | (37.7266274529527, -122.386328971933) | ||
| 100938 | 100938 | 29389 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3101 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 8 | 3x3 | 6014318.9543699995 | 2089998.4675 | 37.71954293749221 | -122.392512568678 | (37.7195429374922, -122.392512568678) | ||
| 102656 | 102656 | 29499 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1750X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016574.50953 | 2093089.8998 | 37.728156409987 | -122.384931122461 | (37.728156409987, -122.384931122461) | ||
| 102696 | 102696 | 29436 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2301X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015595.31207 | 2091713.40361 | 37.7243226144973 | -122.38822024781 | (37.7243226144973, -122.38822024781) | ||
| 103763 | 103763 | 29515 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1900X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 8 | 3x3 | 6016229.4754 | 2092640.83477 | 37.726904275623 | -122.386092637137 | (37.726904275623, -122.386092637137) | ||
| 105097 | 105097 | 29454 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1829X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016488.0524002 | 2092900.9411781002 | 37.7276327843847 | -122.385216849755 | (37.7276327843847, -122.385216849755) | ||
| 107114 | 107114 | 29496 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1700X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016605.23051 | 2093131.22612 | 37.728271583101794 | -122.384827795688 | (37.7282715831018, -122.384827795688) | ||
| 107811 | 107811 | 29466 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1625 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016829.0642387 | 2093358.8188683998 | 37.7289088854195 | -122.38406982785601 | (37.7289088854195, -122.384069827856) | ||
| 108274 | 108274 | 29559 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3100X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6014322.6162736 | 2090077.8318366 | 37.719761059626606 | -122.39250545916799 | (37.7197610596266, -122.392505459168) | ||
| 108993 | 108993 | 29420 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2601X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 5 | 3x3 | 6015142.633330001 | 2091104.26555 | 37.722624949354795 | -122.38974258111799 | (37.7226249493548, -122.389742581118) | ||
| 109367 | 109367 | 29467 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1629X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6016822.618545201 | 2093350.1642125999 | 37.7288847650771 | -122.384091508851 | (37.7288847650771, -122.384091508851) | ||
| 110392 | 110392 | 16772 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1901 O'Farrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 5999052.6011233 | 2112722.5070334 | 37.7810779855184 | -122.446916917115 | (37.7810779855184, -122.446916917115) | ||
| 110836 | 110836 | 29446 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1935X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 2X3 | 6016311.3838732 | 2092663.1779623001 | 37.726970158575895 | -122.385811035359 | (37.7269701585759, -122.385811035359) | ||
| 110926 | 110926 | 29514 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1900X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 8 | 3x3 | 6016246.75465 | 2092662.96108 | 37.7269659864266 | -122.38603444433399 | (37.7269659864266, -122.386034444334) | ||
| 110938 | 110938 | 29500 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1750X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016565.278030001 | 2093076.9327599998 | 37.7281202944361 | -122.384962133363 | (37.7281202944361, -122.384962133363) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");