trees
6,344 rows where qSpecies_id = 19 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22848 | 1398 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 47 Ardath Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/13/2004 12:00:00 AM | 3 | 3X4 | 6017352.5573683 | 2095370.395604 | 37.7344612068158 | -122.382399955055 | (37.7344612068158, -122.382399955055) | 10 | 3 | 8 | 58 | 1 | ||
23333 | 193069 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 28 | : | Tree | Private 2 | 2 | Width 4ft | 6015210.26637 | 2098805.13987 | 37.7437737433553 | -122.390046486977 | (37.7437737433553, -122.390046486977) | 10 | 3 | 8 | 58 | 1 | |||
23487 | 199865 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6016268.2217 | 2093791.063 | 37.7300647191695 | -122.386038837831 | (37.7300647191695, -122.386038837831) | 10 | 3 | 8 | 58 | 1 | |||
23682 | 40078 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 300 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 8 | Permit Number 41301 | 6013786.28999 | 2094199.42847 | 37.73104833461 | -122.394647835845 | (37.73104833461, -122.394647835845) | 10 | 3 | 8 | 58 | 1 | |
24154 | 17430 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1887 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6013360.18498 | 2096350.84555 | 37.7369319827098 | -122.396271694904 | (37.7369319827098, -122.396271694904) | 10 | 3 | 8 | 58 | 1 | |||
24187 | 29860 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1900X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014068.9121897 | 2099730.7814701 | 37.746251993267 | -122.394057835868 | (37.746251993267, -122.394057835868) | 10 | 3 | 8 | 58 | 1 | ||
24791 | 29820 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
25092 | 50848 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1636REVISED Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2004 12:00:00 AM | Permit Number 47364 | 6014694.26637327 | 2095422.25015862 | 37.7344563934175 | -122.391594241924 | (37.7344563934175, -122.391594241924) | 10 | 3 | 8 | 58 | 1 | |||
25931 | 193290 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Ardath Ct | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017463.55131 | 2095291.12818 | 37.734249684563 | -122.382010696451 | (37.734249684563, -122.382010696451) | 10 | 3 | 8 | 58 | 1 | |||
26200 | 29874 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1900X Evans Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014068.9121897 | 2099730.7814701 | 37.746251993267 | -122.394057835868 | (37.746251993267, -122.394057835868) | 10 | 3 | 8 | 58 | 1 | ||
26664 | 199882 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1131 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6017363.6575 | 2093361.8884 | 37.728946855007 | -122.382221895551 | (37.728946855007, -122.382221895551) | 10 | 3 | 8 | 58 | 1 | |||
26979 | 29831 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 29 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
27122 | 29840 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014944.2776 | 2099085.41213 | 37.7445285569526 | -122.390985805465 | (37.7445285569526, -122.390985805465) | 10 | 3 | 8 | 58 | 1 | ||
27503 | 199762 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1255 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016551.909 | 2092571.4831 | 37.726731689633 | -122.384973150968 | (37.726731689633, -122.384973150968) | 10 | 3 | 8 | 58 | 1 | |||
28003 | 53147 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1511@ LANE Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/2006 12:00:00 AM | 2 | Permit Number 49075 | 6015192.9639 | 2093582.5577 | 37.7294326375383 | -122.389741612555 | (37.7294326375383, -122.389741612555) | 10 | 3 | 8 | 58 | 1 | |
28528 | 200025 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1572 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015230.3375 | 2094325.3586 | 37.7314742920109 | -122.3896642664 | (37.7314742920109, -122.3896642664) | 10 | 3 | 8 | 58 | 1 | |||
29180 | 193062 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 12 | : | Tree | Private 2 | 1 | Width 4ft | 6014912.02528 | 2099027.76176 | 37.7443684713257 | -122.391093299634 | (37.7443684713257, -122.391093299634) | 10 | 3 | 8 | 58 | 1 | |||
29674 | 193022 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1675 Bay Shore Blvd | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6012164.65845 | 2090962.85285 | 37.7220710717127 | -122.400026921111 | (37.7220710717127, -122.400026921111) | 10 | 3 | 8 | 58 | 1 | |||
30796 | 193064 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 23 | : | Tree | Private 2 | 3 | Width 4ft | 6015121.07948 | 2098872.18165 | 37.7439528793244 | -122.390359559858 | (37.7439528793244, -122.390359559858) | 10 | 3 | 8 | 58 | 1 | |||
31443 | 193304 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1502 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016023.1071 | 2096881.43664 | 37.7385366952096 | -122.3871017028 | (37.7385366952096, -122.3871017028) | 10 | 3 | 8 | 58 | 1 | |||
31592 | 193294 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1013 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017423.21493 | 2093673.93611 | 37.729806966204 | -122.382037696797 | (37.729806966204, -122.382037696797) | 10 | 3 | 8 | 58 | 1 | |||
31612 | 29821 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
31649 | 177325 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 499 Lathrop Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012707.89529 | 2086680.32707 | 37.7103423833654 | -122.397848820678 | (37.7103423833654, -122.397848820678) | 10 | 3 | 8 | 309 | 1 | |||
31736 | 26607 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1485 Bay Shore Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6011745.1373 | 2092507.28125 | 37.7262883561197 | -122.401585605396 | (37.7262883561197, -122.401585605396) | 10 | 3 | 8 | 58 | 1 | ||
31872 | 193018 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 03rd St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6015871.31513 | 2098824.58498 | 37.743863776308 | -122.38776207318 | (37.743863776308, -122.38776207318) | 10 | 3 | 8 | 58 | 1 | |||
32025 | 193019 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 3600 03rd St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015859.74339 | 2098809.06176 | 37.7438205117227 | -122.387801003014 | (37.7438205117227, -122.387801003014) | 10 | 3 | 8 | 58 | 1 | |||
32879 | 85590 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1570 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015074.2477 | 2095138.5099 | 37.7336983845847 | -122.390260693216 | (37.7336983845847, -122.390260693216) | 10 | 3 | 8 | 58 | 1 | ||
33440 | 85582 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1486 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015517.7847 | 2094813.6891 | 37.7328310842891 | -122.388704574636 | (37.7328310842891, -122.388704574636) | 10 | 3 | 8 | 58 | 1 | ||
33916 | 29854 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1800X Evans Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014413.12367 | 2099481.40364 | 37.7455863790999 | -122.392850141433 | (37.7455863790999, -122.392850141433) | 10 | 3 | 8 | 58 | 1 | ||
34133 | 85609 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1551 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015130.3081 | 2095032.4348 | 37.7334102332415 | -122.390059466624 | (37.7334102332415, -122.390059466624) | 10 | 3 | 8 | 58 | 1 | ||
34576 | 193303 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 807 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6015505.86141 | 2097146.99817 | 37.739237216732 | -122.388908640419 | (37.739237216732, -122.388908640419) | 10 | 3 | 8 | 58 | 1 | |||
35159 | 6743 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1300X Fairfax Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016859.78768 | 2097310.83297 | 37.7397620268834 | -122.384238731741 | (37.7397620268834, -122.384238731741) | 10 | 3 | 8 | 58 | 1 | |||
35168 | 17406 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1788 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/28/1996 12:00:00 AM | 6 | 3x3 | 6013914.85019 | 2096007.19001 | 37.7360192239038 | -122.39432990213 | (37.7360192239038, -122.39432990213) | 10 | 3 | 8 | 58 | 1 | ||
35682 | 26609 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1485 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/14/2006 12:00:00 AM | 3 | 3X3 | 6011735.62232 | 2092555.25526 | 37.7264195519176 | -122.401621868778 | (37.7264195519176, -122.401621868778) | 10 | 3 | 8 | 58 | 1 | ||
36680 | 38607 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1560 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/2006 12:00:00 AM | 3 | Permit Number 49071 | 6015315.5274 | 2094264.9013 | 37.7313130118825 | -122.389365525835 | (37.7313130118825, -122.389365525835) | 10 | 3 | 8 | 58 | 1 | |
37013 | 193088 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1445 Fairfax Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6016353.82584 | 2097602.79871 | 37.7405357172446 | -122.386008496795 | (37.7405357172446, -122.386008496795) | 10 | 3 | 8 | 58 | 1 | |||
37553 | 193086 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 53 | : | Tree | Private 2 | 3 | Width 4ft | 6015572.85588 | 2098535.43446 | 37.7430532910692 | -122.388773903118 | (37.7430532910692, -122.388773903118) | 10 | 3 | 8 | 58 | 1 | |||
37674 | 193286 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1333 Hudson Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017977.93865 | 2094591.23202 | 37.7323563014062 | -122.380183654476 | (37.7323563014062, -122.380183654476) | 10 | 3 | 8 | 58 | 1 | |||
39517 | 85585 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1516 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015333.6646 | 2094945.596 | 37.733183067921 | -122.389350338061 | (37.733183067921, -122.389350338061) | 10 | 3 | 8 | 58 | 1 | ||
39797 | 193106 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 70 Reddy St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6013577.9178 | 2093886.35961 | 37.7301771244662 | -122.395346296097 | (37.7301771244662, -122.395346296097) | 10 | 3 | 8 | 58 | 1 | |||
40194 | 17471 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2050X Palou Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/1992 12:00:00 AM | 6 | 3X3 | 6012415.17187 | 2097121.80295 | 37.7389962397742 | -122.399593159205 | (37.7389962397742, -122.399593159205) | 10 | 3 | 8 | 58 | 1 | ||
40209 | 193100 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1224 Fairfax Ave | 2 | : | Tree | Private 2 | 1 | Width 4ft | 6017433.94384 | 2096880.5876 | 37.7386123884484 | -122.382223599248 | (37.7386123884484, -122.382223599248) | 10 | 3 | 8 | 58 | 1 | |||
40448 | 10840 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1139X Hudson Ave | 47 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/2008 12:00:00 AM | 3 | 3X4 | 6017999.90001 | 2094605.73201 | 37.7323973271712 | -122.380108735409 | (37.7323973271712, -122.380108735409) | 10 | 3 | 8 | 58 | 1 | ||
40594 | 193298 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1040 Palou Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6017507.81667 | 2093329.78992 | 37.7288666800305 | -122.38172129012 | (37.7288666800305, -122.38172129012) | 10 | 3 | 8 | 58 | 1 | |||
41122 | 22500 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6400 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6013113.36636 | 2090284.89866 | 37.7202623949849 | -122.396699945652 | (37.7202623949849, -122.396699945652) | 10 | 3 | 8 | 58 | 1 | |||
41327 | 193049 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 10 | : | Tree | Private 2 | 5 | Width 4ft | 6013830.70731 | 2099917.50727 | 37.7467514607167 | -122.394894600811 | (37.7467514607167, -122.394894600811) | 10 | 3 | 8 | 58 | 1 | |||
41367 | 29849 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1800X Evans Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014521.43542 | 2099403.82747 | 37.7453793866416 | -122.392470187744 | (37.7453793866416, -122.392470187744) | 10 | 3 | 8 | 58 | 1 | ||
41415 | 83660 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1588 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/01/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52296 | 6015346.3057 | 2094590.2717 | 37.7322081198817 | -122.389281830592 | (37.7322081198817, -122.389281830592) | 10 | 3 | 8 | 58 | 1 | |
41533 | 29838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1700X Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014986.46906 | 2099054.93467 | 37.7444472132656 | -122.39083778516 | (37.7444472132656, -122.39083778516) | 10 | 3 | 8 | 58 | 1 | ||
41584 | 29827 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
41932 | 29823 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
41960 | 193087 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 54 | : | Tree | Private 2 | 4 | Width 4ft | 6015589.76226 | 2098523.56065 | 37.7430216250434 | -122.38871461621 | (37.7430216250434, -122.38871461621) | 10 | 3 | 8 | 58 | 1 | |||
43054 | 26608 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1485 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011741.31334 | 2092529.41169 | 37.7263489083674 | -122.401600379453 | (37.7263489083674, -122.401600379453) | 10 | 3 | 8 | 58 | 1 | ||
43072 | 47243 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 874 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 1 | Permit Number 45192 | 6014744.2406 | 2089184.4725 | 37.7173314758058 | -122.390985635281 | (37.7173314758058, -122.390985635281) | 10 | 3 | 8 | 58 | 1 | |
43271 | 193072 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 37 | : | Tree | Private 2 | 3 | Width 4ft | 6015318.00876 | 2098725.46335 | 37.7435609430974 | -122.389668372422 | (37.7435609430974, -122.389668372422) | 10 | 3 | 8 | 58 | 1 | |||
43549 | 29790 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1985X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6013589.41889 | 2100022.1973941 | 37.7470254980848 | -122.395736292585 | (37.7470254980848, -122.395736292585) | 10 | 3 | 8 | 58 | 1 | ||
45640 | 201340 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1 Bitting Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6012714.10336 | 2092626.08619 | 37.7266685912663 | -122.398244248089 | (37.7266685912663, -122.398244248089) | 10 | 3 | 8 | 58 | 1 | ||||
45709 | 193052 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1998 Evans Ave | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6013779.11033 | 2099954.16592 | 37.7468492484883 | -122.395075586663 | (37.7468492484883, -122.395075586663) | 10 | 3 | 8 | 58 | 1 | |||
46884 | 199866 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1600 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016259.959 | 2093780.5969 | 37.7300355240413 | -122.386066673972 | (37.7300355240413, -122.386066673972) | 10 | 3 | 8 | 58 | 1 | |||
46898 | 17389 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1696 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6014412.72216 | 2095634.17289 | 37.7350226581581 | -122.392582460038 | (37.7350226581581, -122.392582460038) | 10 | 3 | 8 | 58 | 1 | |||
47220 | 85575 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1354 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6016198.73439 | 2094304.25494 | 37.7314699961365 | -122.386314831963 | (37.7314699961365, -122.386314831963) | 10 | 3 | 8 | 58 | 1 | ||
47975 | 17379 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1616 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6014755.80631 | 2095377.01944 | 37.7343356147903 | -122.391378315473 | (37.7343356147903, -122.391378315473) | 10 | 3 | 8 | 58 | 1 | |||
48269 | 29808 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
48390 | 193098 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1301 Fairfax Ave | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6017070.0677 | 2097067.7936 | 37.7391063141074 | -122.383494750497 | (37.7391063141074, -122.383494750497) | 10 | 3 | 8 | 58 | 1 | |||
48812 | 193038 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1925 Evans Ave | 6 | : | Tree | Private 2 | 3 | Width 4ft | 6013953.00674 | 2099743.1247 | 37.7462794425459 | -122.394459489924 | (37.7462794425459, -122.394459489924) | 10 | 3 | 8 | 58 | 1 | |||
49057 | 193306 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1499 Mendell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6015779.37833 | 2096310.48205 | 37.7369554703275 | -122.387904577927 | (37.7369554703275, -122.387904577927) | 10 | 3 | 8 | 58 | 1 | |||
49175 | 17407 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1798 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013883.27463 | 2096029.33044 | 37.7360782617048 | -122.394440622145 | (37.7360782617048, -122.394440622145) | 10 | 3 | 8 | 58 | 1 | |||
49287 | 193284 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 6404 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6013063.29248 | 2090204.76107 | 37.7200395661428 | -122.396867420218 | (37.7200395661428, -122.396867420218) | 10 | 3 | 8 | 58 | 1 | |||
49330 | 26604 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1485 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/14/2011 12:00:00 AM | 6 | 3X3 | Permit Number 768158 | 6011777.20808 | 2092336.0059 | 37.7258198587868 | -122.401462705844 | (37.7258198587868, -122.401462705844) | 10 | 3 | 8 | 58 | 1 | |
49675 | 22110 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 3600X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6015973.48399 | 2098973.66495 | 37.744278778308 | -122.387419191637 | (37.744278778308, -122.387419191637) | 10 | 3 | 8 | 58 | 1 | |||
50008 | 82714 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1434 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52468 | 6015808.2627 | 2093548.1385 | 37.7293722301295 | -122.387612046257 | (37.7293722301295, -122.387612046257) | 10 | 3 | 8 | 58 | 1 | |
50164 | 85608 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1481 Palou Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015511.739 | 2094744.9876 | 37.7326421087341 | -122.38872068208 | (37.7326421087341, -122.38872068208) | 10 | 3 | 8 | 58 | 1 | ||
50419 | 193058 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 6 | : | Tree | Private 2 | 3 | Width 4ft | 6014802.29213 | 2099111.00932 | 37.7445909618204 | -122.391478555688 | (37.7445909618204, -122.391478555688) | 10 | 3 | 8 | 58 | 1 | |||
50582 | 6838 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1475 Fairfax Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/14/2001 12:00:00 AM | 5 | 3X3 | 6016138.23461 | 2097761.58271 | 37.7409597718784 | -122.386765004722 | (37.7409597718784, -122.386765004722) | 10 | 3 | 8 | 58 | 1 | ||
52047 | 200719 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1530 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6015256.7189 | 2095000.5573 | 37.7333297142714 | -122.389620199661 | (37.7333297142714, -122.389620199661) | 10 | 3 | 8 | 58 | 1 | |||
52363 | 40040 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1358 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | Permit Number 41277 | 6016192.43464744 | 2094305.95322391 | 37.7314743105785 | -122.386336729935 | (37.7314743105785, -122.386336729935) | 10 | 3 | 8 | 58 | 1 | ||
52443 | 88472 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1525 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51425 | 6015767.14868 | 2096650.26303 | 37.7378877623999 | -122.387970564791 | (37.7378877623999, -122.387970564791) | 10 | 3 | 8 | 58 | 1 | |
52567 | 193041 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 2 | : | Tree | Private 2 | 5 | Width 4ft | 6013966.95235 | 2099815.66783 | 37.7464794059188 | -122.394416345849 | (37.7464794059188, -122.394416345849) | 10 | 3 | 8 | 58 | 1 | |||
53983 | 193042 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 3 | : | Tree | Private 2 | 5 | Width 4ft | 6013950.14435 | 2099829.5265 | 37.7465165245336 | -122.394475436714 | (37.7465165245336, -122.394475436714) | 10 | 3 | 8 | 58 | 1 | |||
54610 | 193006 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013524.80106 | 2097799.85374 | 37.7409198159039 | -122.395804042044 | (37.7409198159039, -122.395804042044) | 10 | 3 | 8 | 58 | 1 | |||
54653 | 6760 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1275 Fairfax Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3x3 | 6017216.38852 | 2096959.46054 | 37.7388169392625 | -122.382981296967 | (37.7388169392625, -122.382981296967) | 10 | 3 | 8 | 58 | 1 | ||
54907 | 39985 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 64 Flora St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/1999 12:00:00 AM | Permit Number 41243 | 6013841.23785102 | 2094410.9727181 | 37.7316322467041 | -122.394472677257 | (37.7316322467041, -122.394472677257) | 10 | 3 | 8 | 58 | 1 | ||
55234 | 85591 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1574 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015045.6678 | 2095162.1433 | 37.7337616917971 | -122.390361153846 | (37.7337616917971, -122.390361153846) | 10 | 3 | 8 | 58 | 1 | ||
55331 | 200216 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2524 Hawes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6015239.1246 | 2090204.9839 | 37.7201610490527 | -122.38934626171 | (37.7201610490527, -122.38934626171) | 10 | 3 | 8 | 58 | 1 | |||
55428 | 192998 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 901 Rankin St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6013640.58193 | 2097957.11926 | 37.74135807441 | -122.395414726402 | (37.74135807441, -122.395414726402) | 10 | 3 | 8 | 58 | 1 | |||
56423 | 29810 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
56556 | 6813 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1400X Fairfax Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12/15/1998 12:00:00 AM | 6 | 3X3 | 6016463.58165 | 2097607.01609 | 37.7405533709401 | -122.385629294058 | (37.7405533709401, -122.385629294058) | 10 | 3 | 8 | 58 | 1 | ||
57238 | 193050 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1940 Evans Ave | 11 | : | Tree | Private 2 | 5 | Width 4ft | 6013815.46024 | 2099929.58477 | 37.7467837751701 | -122.394948169817 | (37.7467837751701, -122.394948169817) | 10 | 3 | 8 | 58 | 1 | |||
57843 | 17404 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1783 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/1991 12:00:00 AM | 30 | 3X3 | 6013910.33363 | 2095939.87898 | 37.7358341506251 | -122.394340806408 | (37.7358341506251, -122.394340806408) | 10 | 3 | 8 | 58 | 1 | ||
58018 | 11386 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1435 Innes Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1994 12:00:00 AM | 6 | 3X4 | 6016388.35933 | 2096530.18404 | 37.7375924457244 | -122.385814348454 | (37.7375924457244, -122.385814348454) | 10 | 3 | 8 | 58 | 1 | ||
58677 | 193077 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 42 | : | Tree | Private 2 | 4 | Width 4ft | 6015396.678 | 2098666.74648 | 37.7434040806449 | -122.389392251751 | (37.7434040806449, -122.389392251751) | 10 | 3 | 8 | 58 | 1 | |||
58807 | 199698 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2098 Jennings St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6015533.013 | 2092802.5784 | 37.7273098206339 | -122.388511598483 | (37.7273098206339, -122.388511598483) | 10 | 3 | 8 | 58 | 1 | |||
59127 | 85564 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1180 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6017158.96801 | 2093588.13352 | 37.7295567721058 | -122.38294526831 | (37.7295567721058, -122.38294526831) | 10 | 3 | 8 | 58 | 1 | ||
59199 | 193071 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 36 | : | Tree | Private 2 | 2 | Width 4ft | 6015306.71167 | 2098734.27336 | 37.743584507126 | -122.389708050508 | (37.743584507126, -122.389708050508) | 10 | 3 | 8 | 58 | 1 | |||
60255 | 29807 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1695X Evans Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Purchasing Dept 18 | 09/11/2006 12:00:00 AM | 3 | 4x4 | 6015152.5117442 | 2098858.5096741 | 37.7439170824372 | -122.390249918369 | (37.7439170824372, -122.390249918369) | 10 | 3 | 8 | 58 | 1 | ||
61225 | 85588 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1548 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2007 12:00:00 AM | 3 | 3x3 | 6015180.3228 | 2095061.0146 | 37.7334914813832 | -122.389888545959 | (37.7334914813832, -122.389888545959) | 10 | 3 | 8 | 58 | 1 | ||
62347 | 38545 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 1553 Jennings St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | Permit Number 40517 | 6016422.80620482 | 2093917.0086828 | 37.7304190951777 | -122.385513188555 | (37.7304190951777, -122.385513188555) | 10 | 3 | 8 | 58 | 1 | ||
62392 | 200117 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1579 Wallace Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 6014870.5488 | 2092777.8609 | 37.7272052174491 | -122.390800027524 | (37.7272052174491, -122.390800027524) | 10 | 3 | 8 | 58 | 1 | |||
62492 | 29848 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1800X Evans Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/11/2006 12:00:00 AM | 3 | 4X4 | 6014537.29909 | 2099390.62466 | 37.745344015429 | -122.392414410014 | (37.745344015429, -122.392414410014) | 10 | 3 | 8 | 58 | 1 | ||
63403 | 193081 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 1601 Evans Ave | 46 | : | Tree | Private 2 | 2 | Width 4ft | 6015460.55021 | 2098619.62663 | 37.7432782402895 | -122.389168106536 | (37.7432782402895, -122.389168106536) | 10 | 3 | 8 | 58 | 1 |
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) );